5 $uvercode=mysql_real_escape_string($_POST['vc']);
6 $login=mysql_real_escape_string($_POST['login']);
8 $kset=$db->query("select user_id from users where login='$login'");
9 $kset->next();$userid=$kset->getString('user_id');
11 $set=$db->query("select * from nodes where node_id='$userid' and node_parent=1836516");
12 if($set->getNumRows()!=1) {
14 $error="User already verificated or invalid.";
19 $kset=$db->query("select hash from users where login='$login'");
20 $kset->next();$vercode=$kset->getString('hash');
22 if($uvercode!=$vercode) {
24 $error="Wrong verification code or username";
29 // ouch!! this is gonna be dirty!!!!! will be revised later:-)
30 $q="update nodes set node_parent=2091448, node_vector='00876611020914480$userid' where node_id='$userid'";
32 $q="update nodes set node_children_count=node_children_count+1 where node_id=2091448";
34 $q="update nodes set node_created=NOW() where node_id='$userid'";
36 $q="update nodes set node_system_access='public' where node_id='$userid'";
38 $q="update node_access set node_user_subchild_count=node_user_subchild_count+1 where node_id=2091448";
42 // and now the happy news:-))
45 echo "<center>Verification successfull.<br><h3>from now on your registration is in the hands of kyberians</h3></center>";