X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fguest%2Fwhat-confirm.php;h=a41e757126850fdaed65ca66ab5bac97d209d71e;hb=c81e9ed85e01215e464d94446773bcd5e6699194;hp=1cb2a7b8e282d3eb87f23c2751bdf6a099aae589;hpb=75ad748a68473ace540251427a74fb781b1145e9;p=mailer.git diff --git a/inc/modules/guest/what-confirm.php b/inc/modules/guest/what-confirm.php index 1cb2a7b8e2..a41e757126 100644 --- a/inc/modules/guest/what-confirm.php +++ b/inc/modules/guest/what-confirm.php @@ -32,158 +32,140 @@ ************************************************************************/ // Some security stuff... -if (ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) -{ +if (!defined('__SECURITY')) { $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php"; require($INC); } + // Add description as navigation point -ADD_DESCR("guest", basename(__FILE__)); +ADD_DESCR("guest", __FILE__); -OPEN_TABLE("100%", "guest_content_align", ""); -if (!empty($_GET['hash'])) -{ +if (!empty($_GET['hash'])) { // Initialize the user ID $uid = 0; // 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($_GET['hash']), __FILE__, __LINE__); - if (SQL_NUMROWS($result) == 1) - { + $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($_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!) - $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET status='CONFIRMED', ref_payout='%s' WHERE user_hash='%s' AND status='UNCONFIRMED' LIMIT 1", - array($CONFIG['ref_payout'], $_GET['hash']), __FILE__, __LINE__); - if (SQL_AFFECTEDROWS($link, __FILE__, __LINE__) == 1) - { - $msg = LOAD_EMAIL_TEMPLATE("confirm-member", "", bigintval($uid)); + 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'), $_GET['hash']), __FILE__, __LINE__); + if (SQL_AFFECTEDROWS() == 1) { + $msg = LOAD_EMAIL_TEMPLATE("confirm-member", array('points' => getConfig('points_register')), bigintval($uid)); // And send him right away the confirmation mail - SEND_EMAIL($email, GUEST_THANX_CONFIRM, $msg); - - // Maybe he got "referraled"? - if (($rid > 0) && ($rid != $uid)) - { - // Select the referral userid - $result = SQL_QUERY_ESC("SELECT userid FROM "._MYSQL_PREFIX."_user_data WHERE userid=%d LIMIT 1", - array(bigintval($rid)), __FILE__, __LINE__); - if (SQL_NUMROWS($result) == 1) - { + SEND_EMAIL($email, getMessage('GUEST_THANX_CONFIRM'), $msg); + + // Maybe he got "referaled"? + 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__); + if (SQL_NUMROWS($result) == 1) { // Update ref counter... UPDATE_REF_COUNTER($rid); // Ok, write the ref-points to this user and his parent-ref - unset($DEPTH); + unset($GLOBALS['ref_level']); - // Shall I "pay" the referral points imidiately? - if ($CONFIG['ref_payout'] == "0") - { + // Shall I "pay" the referal points imidiately? + if (getConfig('ref_payout') == "0") { // Yes, "pay" it now $locked = false; - } - else - { + } else { // No, "pay" it later $locked = true; } // If version matches add ref bonus to refid's account - if ((GET_EXT_VERSION("bonus") >= "0.4.4") && ($CONFIG['bonus_active'] == "Y")) - { + if ((GET_EXT_VERSION("bonus") >= "0.4.4") && (getConfig('bonus_active') == "Y")) { // Add points (directly only!) - $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET bonus_ref=bonus_ref+%s WHERE userid=%d LIMIT 1", - array($CONFIG['bonus_ref'], bigintval($rid)), __FILE__, __LINE__); + 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__); // Subtract points from system - BONUS_POINTS_HANDLER($CONFIG['bonus_ref']); - } + BONUS_POINTS_HANDLER(getConfig('bonus_ref')); + } // END - if - // Add one-time referral bonus over referral system or directly - ADD_POINTS_REFSYSTEM($rid, $CONFIG['points_ref'], true, bigintval($uid), $locked, $CONFIG['reg_points_mode']); - } - } + // Add one-time referal bonus over referal system or directly + unset($GLOBALS['ref_level']); + ADD_POINTS_REFSYSTEM("referal_bonus", $rid, getConfig('points_ref'), true, bigintval($uid), $locked, getConfig('reg_points_mode')); + } // END - if + } // END - if if (EXT_IS_ACTIVE("rallye")) { // Add user to rallye (or not?) RALLYE_AUTOADD_USER(bigintval($uid)); - } + } // END - if // Account confirmed! if (defined('LEAD_CODE_ENABLED') && defined('LEAD_EXPIRY_TIME')) { // Set special lead cookie - setcookie("lead_uid", bigintval($uid), (time() + LEAD_EXPIRY_TIME), COOKIE_PATH); - $_COOKIE['lead_uid'] = bigintval($uid); + set_session('lead_uid', bigintval($uid)); // Lead-Code mode enabled - LOAD_URL(URL."/lead-confirm.php"); + LOAD_URL("lead-confirm.php"); } else { - define('__CONFIRM_MSG', GUEST_CONFIRMED_DONE); + define('__CONFIRM_MSG', getMessage('GUEST_CONFIRMED_DONE')); define('__UID', bigintval($uid)); LOAD_TEMPLATE("guest_confirm_table"); } } elseif (defined('LEAD_CODE_ENABLED') && defined('LEAD_EXPIRY_TIME')) { // Set special lead cookie - setcookie("lead_uid", bigintval($uid), (time() + LEAD_EXPIRY_TIME), COOKIE_PATH); - $_COOKIE['lead_uid'] = bigintval($uid); + set_session('lead_uid', bigintval($uid)); // Lead-Code mode enabled - LOAD_URL(URL."/lead-confirm.php"); + LOAD_URL("lead-confirm.php"); } else { // Nobody was found unter this hash key... or our new member want's to confirm twice? - define('__CONFIRM_MSG', GUEST_CONFIRMED_TWICE); + define('__CONFIRM_MSG', getMessage('GUEST_CONFIRMED_TWICE')); define('__UID', "0"); LOAD_TEMPLATE("guest_confirm_table"); } } else { // Nobody was found unter this hash key... or our new member want's to confirm twice? - define('__CONFIRM_MSG', GUEST_CONFIRMED_TWICE); + define('__CONFIRM_MSG', getMessage('GUEST_CONFIRMED_TWICE')); define('__UID', "0"); LOAD_TEMPLATE("guest_confirm_table"); } -} - elseif ((isset($_POST['ok'])) && (!empty($_POST['email']))) -{ +} elseif ((isset($_POST['ok'])) && (!empty($_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($_POST['email']), __FILE__, __LINE__); - if (SQL_NUMROWS($result) == 1) - { + $result = SQL_QUERY_ESC("SELECT userid, status, user_hash FROM `{!_MYSQL_PREFIX!}_user_data` WHERE email='%s' LIMIT 1", + array($_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", "", $DATA[0]); - SEND_EMAIL($_POST['email'], REQUEST_CONFIRM_LINK_SUBJ, $msg); - $content = CONFIRM_LINK_SENT; + $msg = LOAD_EMAIL_TEMPLATE("guest_request_confirm", array('hash' => $DATA[2]), $DATA[0]); + SEND_EMAIL($_POST['email'], getMessage('REQUEST_CONFIRM_LINK_SUBJ'), $msg); + $content = getMessage('CONFIRM_LINK_SENT'); break; case "CONFIRMED": // Account already confirmed - $content = LOGIN_ID_CONFIRMED; + $content = getMessage('LOGIN_ID_CONFIRMED'); break; case "LOCKED": // Account is locked - $content = LOGIN_ID_LOCKED; + $content = getMessage('LOGIN_ID_LOCKED'); break; } - } - else - { + } else { // Email address not registered - $content = EMAIL_ADDY_404; + $content = getMessage('EMAIL_ADDY_404'); } define('__CONFIRM_MSG', $content); LOAD_TEMPLATE("guest_confirm_table"); -} - else -{ +} else { // No hash found, the guest may want to enter his email address to re-get his confirmation link? LOAD_TEMPLATE("guest_confirm_link"); } -CLOSE_TABLE(); + // ?>