wwwroot/inc/eventz/uprav_zaregistrovanych.inc

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