psql db schema test
[mirrors/Kyberia-bloodline.git] / trash / reg / registruj_novych.inc
1 <?php
2
3 // XXX is this even used?
4
5 function registruj_novych() {
6 global $db,$error;
7
8 // XXX parametrize
9
10 $q="select users.login as persona,users.email as email,k,node_id,node_creator,login from nodes
11 left join users on nodes.node_creator=users.user_id where
12 node_name='request for access' and node_parent=2091448 and k>=5";
13
14 $set=$db->query($q);
15 while ($set->next()) {
16 $noda=$set->getString('node_id');
17 $login=$set->getString('login');
18 echo "User ";
19 echo $set->getString('login');
20 echo "<br>Jeho noda:: ";
21 echo $set->getString('node_id');
22 echo "<br>";
23 echo " pocet hlasov:: ";
24 echo $set->getString('k');
25 echo "<br>";
26 $q="update users set header_id=0 where user_id=$noda";
27 echo $q;
28 $db->update($q);
29 echo "<br>";
30 $q="update nodes set node_name='$login' where node_id=$noda";
31 echo $q;
32 $db->update($q);
33 echo "<br>";
34 $q="update nodes set external_link='db://user' where node_id=$noda";
35 echo $q;
36 $db->update($q);
37 echo "<br>";
38 $q="update nodes set template_id=7 where node_id=$noda";
39 echo $q;
40 $db->update($q);
41 echo "<br>";
42 $q="update nodes set node_parent=0 where node_id=$noda";
43 echo $q;
44 $db->update($q);
45 echo "<br>";
46 $q="update nodes set node_vector='0$noda' where node_id=$noda";
47 echo $q;
48 $db->update($q);
49 echo "<br>";
50 $q="select node_id from nodes where node_vector like '020914480$noda%'";
51 echo $q;
52 echo "<br>";
53 $subset=$db->query($q);
54 while ($subset->next()) {
55 $subnoda=$subset->getString('node_id');
56 $q="update nodes set node_vector='0$noda"."0$subnoda' where node_id=$subnoda";
57 echo "&nbsp;&nbsp;&nbsp;&nbsp;";echo $q;echo '<br>';
58 $db->update($q);
59
60 }
61
62
63 echo "<br>";
64 echo "<hr>";
65 $mail=$set->getString('email');
66 mail($mail,"kyberia gate is opened","Vitaj v kyberii");
67
68
69 $ubik['mail_to']=$noda;
70 $ubik['mail_text']="Ahoj, som UBIK. Momentalne som obycajnou polozkou v databaze, userom cislo 1 v tomto systeme.Bdiem nad systemom. Sledujem co robia slovicka v diskusnych forach, ako su pospajane a s cim. Postupom casu sa budem ucit, a o par rokov si urcite vsimnete moju prvu snahu o komunikaciu. Budem anjelom, diablom, matkou i dcerou.
71
72 Momentalne ti chcem povedat jedno hlasne VITAJ!. Vitaj v projekte ktory nikdy neskonci. Ak sem vchadzas so zlymi umyslami, prosim odid, nenajdes tu stastie. Ked vsak chces spoznat novych ludi na rovnakej vlne, ked chces svoj mozog zaplnit informaciami z nekonecnej siete, prosim, vstup.
73
74 Predtym ako vsak zacnes vnikat hlbsie do tajov systemu chcel by som ta odkazat na <a href='http://".SYSTEM_URL."/id/2111313/'>Newcommers forum</a> ktore ti ujasni niektore zakladne veci v systeme a tym ti v nom ulachci orientaciu.
75
76 peace & respect";
77
78 ubik::ubikMail($ubik);
79
80
81 }
82
83 return false;
84 }
85 ?>
This page took 0.309026 seconds and 4 git commands to generate.