]>
gitweb.pimeys.fr Git - scripts-20-100.git/blob - bde/trouver.sh
3 # Pour trouver quelqu'un dans la base de données
7 if [ $i = "--no-mail" ]
15 if [ $i = "--all" ] ||
[ $i = "-a" ]
21 # Si on n'a *pas* mis --no-mail (too many negations, I know)
24 adding
=" OR mail ILIKE '%$1%'"
26 # Si on a mis --idbde, il faut matcher l'idbde de manière plus lâche
27 if [ "${searchidcbde}" = "1" ]
32 psql note
-c "SELECT * FROM comptes WHERE pseudo ILIKE '%$1%' OR nom ILIKE '%$1%'
33 OR prenom ILIKE '%$1%'${adding} OR CAST(idbde AS varchar) LIKE '${wild}$1${wild}' ORDER BY nom;"
34 if [ -n "${searchall}" ]
36 psql note
-c "SELECT a.*, c.* FROM aliases AS a, comptes AS c WHERE a.idbde = c.idbde AND a.alias ILIKE '%$1%' ORDER BY a.alias;"
37 psql note
-c "SELECT h.*, c.* FROM historique AS h, comptes AS c WHERE h.idbde = c.idbde AND h.avant ILIKE '%$1%' ORDER BY h.avant;"