X-Git-Url: http://git.harvie.cz/?a=blobdiff_plain;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 @@
+<?php
+function uprav_zaregistrovanych() {
+global $db,$error;
+// 2110364 >> 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 "<br>Jeho noda:: ";
+echo $set->getString('node_id');
+echo "<br>";
+echo " pocet hlasov:: ";
+echo $set->getString('k');
+echo "<br>";
+$q="update nodes set external_link='db://user' where node_id=$noda";
+echo $q;
+      $db->update($q);
+echo "<br>";
+$q="update nodes set template_id=7 where node_id=$noda";
+echo $q;
+      $db->update($q);
+echo "<br>";
+$q="update nodes set node_parent=0 where node_id=$noda";
+echo $q;
+      $db->update($q);
+echo "<br>";
+$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 "<br>";
+echo "<hr>";
+
+
+
+
+}
+
+return false;
+}
+?>
\ No newline at end of file