.
*/
require_once 'lib/include.php';
start_session ('no');
getvars ('hash');
postvars ('Confirm,Decline');
$layout = '';
$message = '';
if (!empty ($hash))
{
$db = new Database ();
/* delete unused, expired entries */
$db->query ("DELETE LOW_PRIORITY FROM registration WHERE rdate < DATE_SUB(UTC_TIMESTAMP(), INTERVAL 2 DAY)");
$db->query ("SELECT email, pass, openid_identity ".
"FROM registration WHERE hash='".$db->escape ($hash)."'");
if ($db->next_record ())
{
$email = $db->f ('email');
$pass = $db->f ('pass');
$openid_identity = $db->f ('openid_identity');
$db->query ("SELECT email FROM user WHERE email='".$email."'");
if ($db->next_record ()) {
$message = _('Account already exists.');
}
else {
if ($Confirm) {
$db->query ("INSERT INTO user SET email='".$email."', pass='".$pass."'");
$db->query ("SELECT LAST_INSERT_ID() as last_id FROM user");
if ($db->next_record ()) {
$last_id = $db->f ('last_id');
}
if (!empty ($openid_identity)) {
$db->query ("INSERT INTO openid SET userid='".$last_id.
"', identity='".$openid_identity."'");
}
$db->query ("DELETE FROM registration WHERE hash='".$db->escape ($hash)."'");
$session->id = $last_id;
$session->email = $email;
$session->pass = $pass;
$session->lang = 'null';
$session->status['afterlogged'] = 'yes';
$session->status['iflogged'] = 'yes';
$_SESSION['session'] = $session;
redirect ($CONF['secureProto'].'://'.$CONF['site'].'/rd');
}
else if ($Decline) {
$db->query ("DELETE FROM registration WHERE hash='".$db->escape ($hash)."'");
$message = _('Done, rejected.');
}
else
$layout = 'confirm';
}
}
else if (!empty ($hash))
$message = _('Your confirmation period or invitation has expired.');
}
?>
Cheetah News
Cheetah: ('; echo _('account'); ?> )