Migration to PDO database abstraction layer

[mirrors/Kyberia-bloodline.git] / wwwroot / inc / eventz / verify.inc

diff --git a/wwwroot/inc/eventz/verify.inc b/wwwroot/inc/eventz/verify.inc
index 407e4807d27cdf07055376b9d739cf7bcd5d9d64..7eb9008f6050921d92f806635a527cf9a3678cc7 100644 (file)
--- a/wwwroot/inc/eventz/verify.inc
+++ b/wwwroot/inc/eventz/verify.inc
@@ -2,11 +2,13 @@
 function verify(){
 
 global $db;
-$uvercode=mysql_real_escape_string($_POST['vc']);
-$login=mysql_real_escape_string($_POST['login']);
+$uvercode=db_escape_string($_POST['vc']);
+$login=db_escape_string($_POST['login']);
 
-$kset=$db->query("select user_id from users where login='$login'");
-$kset->next();$userid=$kset->getString('user_id');
+$kset=$db->query("select user_id,guild_id from users where login='$login'");
+$kset->next();
+$userid=$kset->getString('user_id');
+$guild_id=$kset->getString('guild_id');
 
 $set=$db->query("select node_id from nodes where node_id='$userid' and node_parent=".UNVERIFIED_REGISTRATIONS_NODE);
 if($set->getNumRows()!=1) {
@@ -28,13 +30,10 @@ if($uvercode!=$vercode) {
 //  ouch!! this is gonna be dirty!!!!! will be revised later:-)
 // XXX hardcoded, rewrite
 
-$q="update nodes set node_parent=".REGISTRATION_REQUEST_NODE.", node_vector='000001010473807402091448$userid' where node_id='$userid'";
-$db->update($q);
-
+//$q="update nodes set node_parent=".REGISTRATION_REQUEST_NODE.", node_vector='000001010473807402091448$userid' where node_id='$userid'";
+//$db->update($q);
 
-//     $params['node_parent']=REGISTRATION_REQUEST_NODE;
-//     $params['node_id']=$userid;
-//     nodes::setParent($params);
+nodes::setParent($userid,REGISTRATION_REQUEST_NODE);
 
 
 $q="update nodes set node_children_count=node_children_count+1 where node_id=".REGISTRATION_REQUEST_NODE;
@@ -45,12 +44,14 @@ $q="update nodes set node_system_access='public' where node_id='$userid'";
 $db->update($q);
 $q="update node_access set node_user_subchild_count=node_user_subchild_count+1 where node_id=".REGISTRATION_REQUEST_NODE;
 $db->update($q);
-
+nodes::putNode($userid,$guild_id,false);
 
 // and now the happy news:-))
 echo "<center>Verification successfull.<br><h3>from now on your registration is in the hands of kyberians</h3></center>";
        die();
 }
 
+
+
 }
 ?>