bde/enlever_droits_invites.sh

   1 #!/bin/bash
   2
   3 # Pour virer les droits invités en masse puisque plus personne ne devrait avoir ce droit.
   4
   5 psql bde -c "SELECT * FROM (SELECT numcbde, pseudo, droits, surdroits, droits-(droits&128) AS apres FROM adherents WHERE NOT supreme AND numcbde>0) AS plouf WHERE NOT droits=apres;"
   6 echo -n "Delete ? [y/N] "
   7 read ans
   8 if [[ $ans = "y" ]]
   9 then
  10     psql bde -c "UPDATE adherents SET droits=droits-(droits&128) WHERE numcbde in (SELECT numcbde FROM (SELECT numcbde, pseudo, droits, surdroits, droits-(droits&128) AS apres FROM adherents WHERE NOT supreme AND numcbde>0) AS plouf WHERE NOT droits=apres);"
  11 fi