query(sprintf('select login from users where
login = "%s" or email = "%s" or xmpp = "%s"', $login, $email, $xmpp));
if ($set->getNumRows() > 0) {
$error = sprintf('No-no, user with this nick/email is already registered');
return false;
}
// registration clause // XXX hard coded, registration text
$qr_rc = $db->query('select node_content from nodes where node_id = '.REGISTRATION_TEXT_NODE);
$qr_rc->next();
$params['node_content'] = sprintf('%s
%s
E-mail address:: %s',
$qr_rc->getString('node_content'),
$content,
$email);
// XXX hard-coded
$params['node_parent'] = UNVERIFIED_REGISTRATIONS_NODE; // registrations_noverified forum
$params['node_name'] = 'request for access';
$params['node_creator']=UBIK_ID;
$params['flag'] = 'registration';
$user_id = nodes::addNode($params);
//puttin in the guild node is realized only after email verification
//nodes::putNode($user_id,$guild_id);
$q = sprintf('update nodes set node_system_access = "private",node_creator=%d where node_id = %d', $user_id,$user_id);
$db->update($q);
$pass = md5($pass);
$vercode = substr( md5( uniqid( rand() ) ), rand(0, 7), 23);
$q = sprintf('insert into users set password = "%s", user_id = %d,
header_id = 2091520, login = "%s", email = "%s",
hash = "%s", xmpp="%s", guild_id="%s"',
$pass, $user_id, $login, $email, $vercode, $xmpp, $guild_id);
$db->query($q); // XXX rewrite
$emailtext = sprintf(
'Vitaj %s! Prave som sa s radostou dozvedel, ze si vyplnil(a)
registracny formular na stranke '.SYSTEM_URL.' a chces sa stat
clenom tejto komunity.
Budem sa snazit urobit tento pokec trosku dlhsi,
lebo v povodnej kratkej forme ho pohlcuju spamfiltre, takze
ospravedln nasledujuce blabla a moj typicky atypicky zmysel
pre cierny humor, kedze sluzi ku dobrej veci :)
Pri registracii ti bol prideleny verifikacny kod.
Ten kod znie "%s" [bez uvodzoviek].
Ten musis zadat na adresu '.SYSTEM_URL.'/id/1976899/, kde
vyplnis formular s tvojim nickom a verifkacnym kodom.
Od tej chvile bude tvoja ziadost volne pristupna
uz zaregistrovanym clenom, ktori o nej budu hlasovat.
Pocet hlasov aby sa ziadosti vyhovelo je x.
Deadline na nazbieranie je 1 tyzden.
Takze fakticky dufam ze si o sebe napisal(a) nieco inteligentne :)
Prajem pekny zvysok dna',
$login, $vercode);
// edit by br
$headers = 'From: kyberia@'. SYSTEM_URL . "\r\n" . 'X-Mailer: PHP';
mail($email, SYSTEM_URL.' verification code', $emailtext, $headers);
$error = 'Request saved, verification code sent, please check your e-mail.';
return false;
}
?>