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