X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fguest%2Fwhat-confirm.php;h=569f4d4e0a607d94636e3fec610d61b57a4f7345;hb=0f9bc55be42f9851cc87a06f3971c853a83425a7;hp=3b34f5197aefa229f9d1281e633fc4666d702426;hpb=b5912168d72ae511eb623c3d92540c82d31b93c5;p=mailer.git diff --git a/inc/modules/guest/what-confirm.php b/inc/modules/guest/what-confirm.php index 3b34f5197a..569f4d4e0a 100644 --- a/inc/modules/guest/what-confirm.php +++ b/inc/modules/guest/what-confirm.php @@ -1,7 +1,7 @@ '{--GUEST_CONFIRMED_FAILED--}', + 'userid' => 0, +); + +if (isGetRequestParameterSet('hash')) { + // Initialize the user id + $userid = '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(getRequestParameter('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); + list($userid, $email, $refid) = SQL_FETCHROW($result); + + // Fetch user data + if (!fetchUserData($userid)) { + // Not found, should not happen + debug_report_bug(__FILE__, __LINE__, 'User account ' . $userid . ' not found.'); + } // END - if + + // Load all data and add points + $content = getUserDataArray(); // 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`={?ref_payout?}, + `user_hash`=NULL +WHERE + `user_hash`='%s' AND + `status`='UNCONFIRMED' +LIMIT 1", + array(getRequestParameter('hash')), __FILE__, __LINE__); + if (SQL_AFFECTEDROWS() == 1) { + // Send email if updated + $message = loadEmailTemplate('confirm-member', $content, bigintval($userid)); // 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) - { - // Update ref counter... - UPDATE_REF_COUNTER($rid); + sendEmail($email, '{--GUEST_THANX_CONFIRM--}', $message); - // Ok, write the ref-points to this user and his parent-ref - unset($DEPTH); + // Maybe he got "referaled"? + if (($refid > 0) && ($refid != $userid)) { + // Select the referal userid + if (fetchUserData($refid)) { + // Update ref counter... + updateReferalCounter($refid); - // Shall I "pay" the referral points imidiately? - if ($_CONFIG['ref_payout'] == "0") - { - // Yes, "pay" it now + // Shall I 'pay' the referal points imidiately? + if (getConfig('ref_payout') == '0') { + // Yes, 'pay' it now $locked = false; - } - else - { - // No, "pay" it later + } 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 ((isExtensionInstalledAndNewer('bonus', '0.4.4')) && (isBonusRallyeActive())) { // 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`+{?bonus_ref?} WHERE `userid`=%s LIMIT 1", + array(bigintval($refid)), __FILE__, __LINE__); // Subtract points from system - BONUS_POINTS_HANDLER($_CONFIG['bonus_ref']); - } + handleBonusPoints(getConfig('bonus_ref')); + } // END - if - // Add one-time referral bonus over referral system or directly - $DEPTH = 0; - 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 + // @TODO Try to rewrite the following unset() + unset($GLOBALS['ref_level']); + addPointsThroughReferalSystem('referal_bonus', $refid, getPointsRef(), true, bigintval($userid), $locked, getConfig('reg_points_mode')); + } // END - if + } // END - if - if (EXT_IS_ACTIVE("rallye")) { + if (isExtensionActive('rallye')) { // Add user to rallye (or not?) - RALLYE_AUTOADD_USER(bigintval($uid)); - } + addUserToReferalRallye(bigintval($userid)); + } // END - if // Account confirmed! - if (defined('LEAD_CODE_ENABLED') && defined('LEAD_EXPIRY_TIME')) { + if (isExtensionActive('lead')) { // Set special lead cookie - set_session("lead_uid", bigintval($uid), (time() + LEAD_EXPIRY_TIME), COOKIE_PATH); - $_SESSION['lead_uid'] = bigintval($uid); + setSession('lead_userid', bigintval($userid)); // Lead-Code mode enabled - LOAD_URL("lead-confirm.php"); + redirectToUrl('lead-confirm.php'); } else { - define('__CONFIRM_MSG', GUEST_CONFIRMED_DONE); - define('__UID', bigintval($uid)); - LOAD_TEMPLATE("guest_confirm_table"); + $content['message'] = '{--GUEST_CONFIRMED_DONE--}'; + $content['userid'] = bigintval($userid); } - } elseif (defined('LEAD_CODE_ENABLED') && defined('LEAD_EXPIRY_TIME')) { + } elseif (isExtensionActive('lead')) { // Set special lead cookie - set_session("lead_uid", bigintval($uid), (time() + LEAD_EXPIRY_TIME), COOKIE_PATH); - $_SESSION['lead_uid'] = bigintval($uid); + setSession('lead_userid', bigintval($userid)); // Lead-Code mode enabled - LOAD_URL("lead-confirm.php"); + redirectToUrl('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('__UID', "0"); - LOAD_TEMPLATE("guest_confirm_table"); + $content['message'] = '{--GUEST_CONFIRMED_TWICE--}'; } } else { // Nobody was found unter this hash key... or our new member want's to confirm twice? - define('__CONFIRM_MSG', GUEST_CONFIRMED_TWICE); - define('__UID', "0"); - LOAD_TEMPLATE("guest_confirm_table"); + $content['message'] = '{--GUEST_CONFIRMED_TWICE--}'; } -} - 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) - { + + // Load template + loadTemplate('admin_settings_saved', false, $content['message']); +} elseif ((isFormSent()) && (isPostRequestParameterSet('email'))) { + // Confirmation link requested 0 1 2 + if (fetchUserData(postRequestParameter('email'), 'email')) { // 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; - break; - - case "CONFIRMED": // Account already confirmed - $content = LOGIN_ID_CONFIRMED; - break; - - case "LOCKED": // Account is locked - $content = LOGIN_ID_LOCKED; - break; - } - } - else - { + $content = getUserDataArray(); + + // Detect status + switch ($content['status']) { + case 'UNCONFIRMED': // Account not confirmed + // Load email template + $message = loadEmailTemplate('guest_request_confirm', array('hash' => $content['user_hash']), $content['userid']); + + // Send email + sendEmail(postRequestParameter('email'), '{--REQUEST_CONFIRM_LINK_SUBJECT--}', $message); + + // And set message + $content['message'] = '{--CONFIRM_LINK_SENT--}'; + break; + + case 'CONFIRMED': // Account already confirmed + $content['message'] = '{--LOGIN_ID_CONFIRMED--}'; + break; + + case 'LOCKED': // Account is locked + $content['message'] = '{--LOGIN_ID_LOCKED--}'; + break; + } // END - switch + } else { // Email address not registered - $content = EMAIL_ADDY_404; + $content['message'] = '{--EMAIL_404--}'; } - define('__CONFIRM_MSG', $content); - LOAD_TEMPLATE("guest_confirm_table"); -} - else -{ + // Load template + loadTemplate('admin_settings_saved', false, $content['message']); +} else { // No hash found, the guest may want to enter his email address to re-get his confirmation link? - LOAD_TEMPLATE("guest_confirm_link"); + loadTemplate('guest_confirm_link'); } -CLOSE_TABLE(); -// + +// [EOF] ?>