X-Git-Url: http://gitweb.pimeys.fr/?a=blobdiff_plain;f=bde%2Fold%2Fenlever_droits_invites.sh;fp=bde%2Fold%2Fenlever_droits_invites.sh;h=d2e4751e5de281277953706b73144af8c47e5dc8;hb=62bd5a01bbcc7b96c4b1dd098415253d14492517;hp=0000000000000000000000000000000000000000;hpb=7630720dd491fa53093743e683d4e05f22d03afd;p=scripts-20-100.git

diff --git a/bde/old/enlever_droits_invites.sh b/bde/old/enlever_droits_invites.sh
new file mode 100755
index 0000000..d2e4751
--- /dev/null
+++ b/bde/old/enlever_droits_invites.sh
@@ -0,0 +1,11 @@
+#!/bin/bash
+
+# Pour virer les droits invités en masse puisque plus personne ne devrait avoir ce droit.
+
+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;"
+echo -n "Delete ? [y/N] "
+read ans
+if [[ $ans = "y" ]]
+then
+    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);"
+fi