query("select user_id from users where login='$login'"); $kset->next();$userid=$kset->getString('user_id'); $set=$db->query("select node_id from nodes where node_id='$userid' and node_parent=".UNVERIFIED_REGISTRATIONS_NODE); if($set->getNumRows()!=1) { global $error; $error="User already verificated or invalid."; return false; } $kset=$db->query("select hash from users where login='$login'"); $kset->next();$vercode=$kset->getString('hash'); if($uvercode!=$vercode) { global $error; $error="Wrong verification code or username"; return false; } else { // ouch!! this is gonna be dirty!!!!! will be revised later:-) // XXX hardcoded, rewrite $q="update nodes set node_parent=".REGISTRATION_REQUEST_NODE.", node_vector='00000101020914480$userid' where node_id='$userid'"; $db->update($q); $q="update nodes set node_children_count=node_children_count+1 where node_id=".REGISTRATION_REQUEST_NODE; $db->update($q); $q="update nodes set node_created=NOW() where node_id='$userid'"; $db->update($q); $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); // and now the happy news:-)) echo "Verification successfull.

from now on your registration is in the hands of kyberians

"; die(); } } ?>