// Search for an unconfirmed or confirmed account
$result = SQL_QUERY_ESC("SELECT userid, email, refid FROM `{!_MYSQL_PREFIX!}_user_data` WHERE user_hash='%s' AND (`status`='UNCONFIRMED' OR `status`='CONFIRMED') LIMIT 1",
- array(REQUEST_GET('hash')), __FILE__, __LINE__);
+ array(REQUEST_GET('hash')), __FILE__, __LINE__);
if (SQL_NUMROWS($result) == 1) {
// Ok, he want's to confirm now so we load some data
list ($uid, $email, $rid) = SQL_FETCHROW($result);
// Unlock his account (but only when it is on UNCONFIRMED!)
SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET `status`='CONFIRMED', ref_payout=%s, user_hash=NULL WHERE user_hash='%s' AND `status`='UNCONFIRMED' LIMIT 1",
- array(getConfig('ref_payout'), REQUEST_GET('hash')), __FILE__, __LINE__);
+ array(getConfig('ref_payout'), REQUEST_GET('hash')), __FILE__, __LINE__);
if (SQL_AFFECTEDROWS() == 1) {
$msg = LOAD_EMAIL_TEMPLATE("confirm-member", array('points' => getConfig('points_register')), bigintval($uid));
if (($rid > 0) && ($rid != $uid)) {
// Select the referal userid
$result = SQL_QUERY_ESC("SELECT userid FROM `{!_MYSQL_PREFIX!}_user_data` WHERE userid=%s LIMIT 1",
- array(bigintval($rid)), __FILE__, __LINE__);
+ array(bigintval($rid)), __FILE__, __LINE__);
if (SQL_NUMROWS($result) == 1) {
// Update ref counter...
updateReferalCounter($rid);
if ((GET_EXT_VERSION('bonus') >= '0.4.4') && (getConfig('bonus_active') == 'Y')) {
// Add points (directly only!)
SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET bonus_ref=bonus_ref+%s WHERE userid=%s LIMIT 1",
- array(getConfig('bonus_ref'), bigintval($rid)), __FILE__, __LINE__);
+ array(getConfig('bonus_ref'), bigintval($rid)), __FILE__, __LINE__);
// Subtract points from system
BONUS_POINTS_HANDLER(getConfig('bonus_ref'));
} elseif ((IS_FORM_SENT()) && (REQUEST_ISSET_POST(('email')))) {
// Confirmation link requested 0 1 2
$result = SQL_QUERY_ESC("SELECT userid, status, user_hash FROM `{!_MYSQL_PREFIX!}_user_data` WHERE email='%s' LIMIT 1",
- array(REQUEST_POST('email')), __FILE__, __LINE__);
+ array(REQUEST_POST('email')), __FILE__, __LINE__);
if (SQL_NUMROWS($result) == 1) {
// Email address found
$DATA = SQL_FETCHROW($result);
switch ($DATA[1])
{
- case "UNCONFIRMED": // Account not confirmed
- $msg = LOAD_EMAIL_TEMPLATE("guest_request_confirm", array('hash' => $DATA[2]), $DATA[0]);
- sendEmail(REQUEST_POST('email'), getMessage('REQUEST_CONFIRM_LINK_SUBJ'), $msg);
- $content = getMessage('CONFIRM_LINK_SENT');
- break;
-
- case 'CONFIRMED': // Account already confirmed
- $content = getMessage('LOGIN_ID_CONFIRMED');
- break;
-
- case "LOCKED": // Account is locked
- $content = getMessage('LOGIN_ID_LOCKED');
- break;
+ case "UNCONFIRMED": // Account not confirmed
+ $msg = LOAD_EMAIL_TEMPLATE("guest_request_confirm", array('hash' => $DATA[2]), $DATA[0]);
+ sendEmail(REQUEST_POST('email'), getMessage('REQUEST_CONFIRM_LINK_SUBJ'), $msg);
+ $content = getMessage('CONFIRM_LINK_SENT');
+ break;
+
+ case 'CONFIRMED': // Account already confirmed
+ $content = getMessage('LOGIN_ID_CONFIRMED');
+ break;
+
+ case "LOCKED": // Account is locked
+ $content = getMessage('LOGIN_ID_LOCKED');
+ break;
}
} else {
// Email address not registered