X-Git-Url: http://git.harvie.cz/?a=blobdiff_plain;ds=inline;f=wwwroot%2Finc%2Feventz%2Fuprav_zaregistrovanych.inc;fp=wwwroot%2Finc%2Feventz%2Fuprav_zaregistrovanych.inc;h=02d97d752c2ddc7b50bd73b9ab157b164b2e3e51;hb=51ff32267c4949bad6a8dddc502cbc01ed56edc8;hp=0000000000000000000000000000000000000000;hpb=dcee763368a1e3f380d07320a5254d91a09304e6;p=mirrors%2FKyberia-bloodline.git
diff --git a/wwwroot/inc/eventz/uprav_zaregistrovanych.inc b/wwwroot/inc/eventz/uprav_zaregistrovanych.inc
new file mode 100644
index 0000000..02d97d7
--- /dev/null
+++ b/wwwroot/inc/eventz/uprav_zaregistrovanych.inc
@@ -0,0 +1,57 @@
+> debug user
+
+$q="select users.login as persona,users.email as email,k,node_id,node_creator,login from nodes
+left join users on nodes.node_creator=users.user_id where node_name!='request for access' and node_parent=2091448 and
+k>=3";
+
+/*
+$q="select users.login as persona,users.email as email,k,node_id,node_creator,login from nodes
+left join users on nodes.node_creator=users.user_id where node_name!='request for access' and node_parent=2091448 and
+k>=3 and user_id=2110364";
+*/
+
+$set=$db->query($q);
+while ($set->next()) {
+$noda=$set->getString('node_id');
+echo "User ";
+echo $set->getString('login');
+echo "
Jeho noda:: ";
+echo $set->getString('node_id');
+echo "
";
+echo " pocet hlasov:: ";
+echo $set->getString('k');
+echo "
";
+$q="update nodes set external_link='db://user' where node_id=$noda";
+echo $q;
+ $db->update($q);
+echo "
";
+$q="update nodes set template_id=7 where node_id=$noda";
+echo $q;
+ $db->update($q);
+echo "
";
+$q="update nodes set node_parent=0 where node_id=$noda";
+echo $q;
+ $db->update($q);
+echo "
";
+$q="update nodes set node_vector='0$noda' where node_id=$noda";
+echo $q;
+ $db->update($q);
+
+$q="update users set user_mail=0 where user_id=$noda";
+echo $q;
+ $db->update($q);
+
+echo "
";
+echo "