[bde] Gros ménage : archivage de tous les scripts NK2012

[scripts-20-100.git] / bde / enlever_droits_invites.sh

diff --git a/bde/enlever_droits_invites.sh b/bde/enlever_droits_invites.sh
deleted file mode 100755 (executable)
index d2e4751..0000000
--- a/bde/enlever_droits_invites.sh
+++ /dev/null
@@ -1,11 +0,0 @@
-#!/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