inc/eventz/uprav_zaregistrovanych.inc

   1 <?php
   2 function uprav_zaregistrovanych() {
   3 global $db,$error;
   4 // 2110364 >> debug user
   5
   6 $q="select users.login as persona,users.email as email,k,node_id,node_creator,login from nodes
   7 left join users on nodes.node_creator=users.user_id where node_name!='request for access' and node_parent=2091448 and
   8 k>=3";
   9
  10 /*
  11 $q="select users.login as persona,users.email as email,k,node_id,node_creator,login from nodes
  12 left join users on nodes.node_creator=users.user_id where node_name!='request for access' and node_parent=2091448 and
  13 k>=3 and user_id=2110364";
  14 */
  15
  16 $set=$db->query($q);
  17 while ($set->next()) {
  18 $noda=$set->getString('node_id');
  19 echo "User ";
  20 echo $set->getString('login');
  21 echo "<br>Jeho noda:: ";
  22 echo $set->getString('node_id');
  23 echo "<br>";
  24 echo " pocet hlasov:: ";
  25 echo $set->getString('k');
  26 echo "<br>";
  27 $q="update nodes set external_link='db://user' where node_id=$noda";
  28 echo $q;
  29       $db->update($q);
  30 echo "<br>";
  31 $q="update nodes set template_id=7 where node_id=$noda";
  32 echo $q;
  33       $db->update($q);
  34 echo "<br>";
  35 $q="update nodes set node_parent=0 where node_id=$noda";
  36 echo $q;
  37       $db->update($q);
  38 echo "<br>";
  39 $q="update nodes set node_vector='0$noda' where node_id=$noda";
  40 echo $q;
  41       $db->update($q);
  42
  43 $q="update users set user_mail=0 where user_id=$noda";
  44 echo $q;
  45       $db->update($q);
  46
  47 echo "<br>";
  48 echo "<hr>";
  49
  50
  51
  52
  53 }
  54
  55 return false;
  56 }
  57 ?>