| 1 | <?php |
| 2 | function vycisti_registracky() { |
| 3 | global $db,$error; |
| 4 | |
| 5 | $q="select users.login as persona,users.email as email,k,node_id,node_creator,login from nodes |
| 6 | left join users on nodes.node_creator=users.user_id where node_name='request for access' and node_parent=2091448 and k<=4"; |
| 7 | |
| 8 | $set=$db->query($q); |
| 9 | while ($set->next()) { |
| 10 | $noda=$set->getString('node_id'); |
| 11 | echo "Uchadzac "; |
| 12 | echo $set->getString('login'); |
| 13 | echo "<br>Jeho noda:: "; |
| 14 | echo $set->getString('node_id'); |
| 15 | echo "<br>"; |
| 16 | echo " pocet hlasov:: "; |
| 17 | echo $set->getString('k'); |
| 18 | echo "<br>"; |
| 19 | $q="delete from users where user_id=$noda"; |
| 20 | echo $q; |
| 21 | $db->update($q); |
| 22 | echo "<br>"; |
| 23 | $q="delete from nodes where node_vector like '020914480$noda%'"; |
| 24 | echo $q; |
| 25 | $db->update($q); |
| 26 | echo "<br>"; |
| 27 | echo "<hr>"; |
| 28 | $mail=$set->getString('email'); |
| 29 | mail($mail,SYSTEM_URL. " registracia","Lutujem, vasa registracia bola zamietnuta"); |
| 30 | // echo $mail; |
| 31 | |
| 32 | |
| 33 | } |
| 34 | |
| 35 | return false; |
| 36 | } |
| 37 | ?> |