X-Git-Url: http://gitweb.pimeys.fr/?a=blobdiff_plain;f=bde%2Ftrouver.sh;h=920219f8ac206d507e3edce63357edaeb7d0c8ba;hb=e06766c11f294c4c3db3d90e855bc313e6165cee;hp=47dca069ad6ca34a0f3e982b7c50053b17aa29db;hpb=1d5629a85dda994499e6d053f024c16a9026cbbd;p=scripts-20-100.git

diff --git a/bde/trouver.sh b/bde/trouver.sh
index 47dca06..920219f 100755
--- a/bde/trouver.sh
+++ b/bde/trouver.sh
@@ -7,21 +7,21 @@ do
   if [ $i = "--no-mail" ]
     then nomail=1;
   fi;
-  if [ $i = "--numcbde" ]
-    then searchnumcbde=1;
+  if [ $i = "--idbde" ]
+    then searchidcbde=1;
   fi
 done
 
 # Si on n'a *pas* mis --no-mail (too many negations, I know)
 if [ -z "${nomail}" ]
 then
-  adding=" OR email ILIKE '%$1%'"
+  adding=" OR mail ILIKE '%$1%'"
 fi
-# Si on a mis --numcbde, il faut matcher numcbde de manière plus lâche
-if [ "${searchnumcbde}" = "1" ]
+# Si on a mis --idcbde, il faut matcher numcbde de manière plus lâche
+if [ "${searchidcbde}" = "1" ]
 then
   wild="%"
 fi
 
-psql bde -c "SELECT * FROM adherents WHERE pseudo ILIKE '%$1%' OR nom ILIKE '%$1%'
- OR prenom ILIKE '%$1%'${adding} OR CAST(numcbde AS varchar) LIKE '${wild}$1${wild}' ORDER BY nom;"
+psql note -c "SELECT * FROM comptes WHERE pseudo ILIKE '%$1%' OR nom ILIKE '%$1%'
+ OR prenom ILIKE '%$1%'${adding} OR CAST(idbde AS varchar) LIKE '${wild}$1${wild}' ORDER BY nom;"