X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fguest%2Fwhat-confirm.php;h=fcbbddb482f44af4b7a450b87d5852839fcafa5e;hb=bd9c1581b892ef89831a67dc2c18b8e3362f005f;hp=dc271286bfa0667c53db25de1a80843f05493050;hpb=007b2f3f0bd478fa40afd2d3d3282edbbfddc345;p=mailer.git diff --git a/inc/modules/guest/what-confirm.php b/inc/modules/guest/what-confirm.php index dc271286bf..fcbbddb482 100644 --- a/inc/modules/guest/what-confirm.php +++ b/inc/modules/guest/what-confirm.php @@ -18,6 +18,7 @@ * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * + * Copyright (c) 2009, 2010 by Mailer Developer Team * * For more information visit: http://www.mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -46,48 +47,55 @@ addMenuDescription('guest', __FILE__); // Init content $content = array( - 'message' => getMessage('GUEST_CONFIRMED_FAILED'), + 'message' => '{--GUEST_CONFIRMED_FAILED--}', 'userid' => 0, ); -if (isGetRequestElementSet('hash')) { +if (isGetRequestParameterSet('hash')) { // Initialize the user id $userid = '0'; // Search for an unconfirmed or confirmed account - $result = SQL_QUERY_ESC("SELECT `userid`, `email`, `refid`,`gender` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `user_hash`='%s' AND (`status`='UNCONFIRMED' OR `status`='CONFIRMED') LIMIT 1", - array(getRequestElement('hash')), __FILE__, __LINE__); + $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($userid, $email, $rid, $gender) = SQL_FETCHROW($result); + list($userid, $email, $refid) = SQL_FETCHROW($result); // Fetch user data if (!fetchUserData($userid)) { // Not found, should not happen - debug_report_bug('User account ' . $userid . ' not found.'); + debug_report_bug(__FILE__, __LINE__, 'User account ' . $userid . ' not found.'); } // END - if // Load all data and add points $content = getUserDataArray(); - $content['gender'] = translateGender($content['gender']); - $content['points'] = getConfig('points_register'); // Unlock his account (but only when it is on UNCONFIRMED!) - 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(getRequestElement('hash')), __FILE__, __LINE__); + 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 - sendEmail($email, getMessage('GUEST_THANX_CONFIRM'), $message); + sendEmail($email, '{--GUEST_THANX_CONFIRM--}', $message); // Maybe he got "referaled"? - if (($rid > 0) && ($rid != $userid)) { + if (($refid > 0) && ($refid != $userid)) { // Select the referal userid - if (fetchUserData($rid)) { + if (fetchUserData($refid)) { // Update ref counter... - updateReferalCounter($rid); + updateReferalCounter($refid); // Shall I 'pay' the referal points imidiately? if (getConfig('ref_payout') == '0') { @@ -99,10 +107,10 @@ if (isGetRequestElementSet('hash')) { } // If version matches add ref bonus to refid's account - if ((getExtensionVersion('bonus') >= '0.4.4') && (getConfig('bonus_active') == 'Y')) { + if ((isExtensionInstalledAndNewer('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`+{?bonus_ref?} WHERE `userid`=%s LIMIT 1", - array(bigintval($rid)), __FILE__, __LINE__); + array(bigintval($refid)), __FILE__, __LINE__); // Subtract points from system handleBonusPoints(getConfig('bonus_ref')); @@ -111,7 +119,7 @@ if (isGetRequestElementSet('hash')) { // Add one-time referal bonus over referal system or directly // @TODO Try to rewrite the following unset() unset($GLOBALS['ref_level']); - addPointsThroughReferalSystem('referal_bonus', $rid, getConfig('points_ref'), true, bigintval($userid), $locked, getConfig('reg_points_mode')); + addPointsThroughReferalSystem('referal_bonus', $refid, getConfig('points_ref'), true, bigintval($userid), $locked, getConfig('reg_points_mode')); } // END - if } // END - if @@ -128,7 +136,7 @@ if (isGetRequestElementSet('hash')) { // Lead-Code mode enabled redirectToUrl('lead-confirm.php'); } else { - $content['message'] = getMessage('GUEST_CONFIRMED_DONE'); + $content['message'] = '{--GUEST_CONFIRMED_DONE--}'; $content['userid'] = bigintval($userid); } } elseif (isExtensionActive('lead')) { @@ -139,18 +147,18 @@ if (isGetRequestElementSet('hash')) { redirectToUrl('lead-confirm.php'); } else { // Nobody was found unter this hash key... or our new member want's to confirm twice? - $content['message'] = getMessage('GUEST_CONFIRMED_TWICE'); + $content['message'] = '{--GUEST_CONFIRMED_TWICE--}'; } } else { // Nobody was found unter this hash key... or our new member want's to confirm twice? - $content['message'] = getMessage('GUEST_CONFIRMED_TWICE'); + $content['message'] = '{--GUEST_CONFIRMED_TWICE--}'; } // Load template loadTemplate('admin_settings_saved', false, $content['message']); -} elseif ((isFormSent()) && (isPostRequestElementSet('email'))) { +} elseif ((isFormSent()) && (isPostRequestParameterSet('email'))) { // Confirmation link requested 0 1 2 - if (fetchUserData(postRequestElement('email'), 'email')) { + if (fetchUserData(postRequestParameter('email'), 'email')) { // Email address found $content = getUserDataArray(); @@ -161,23 +169,23 @@ if (isGetRequestElementSet('hash')) { $message = loadEmailTemplate('guest_request_confirm', array('hash' => $content['user_hash']), $content['userid']); // Send email - sendEmail(postRequestElement('email'), getMessage('REQUEST_CONFIRM_LINK_SUBJ'), $message); + sendEmail(postRequestParameter('email'), '{--REQUEST_CONFIRM_LINK_SUBJECT--}', $message); // And set message - $content['message'] = getMessage('CONFIRM_LINK_SENT'); + $content['message'] = '{--CONFIRM_LINK_SENT--}'; break; case 'CONFIRMED': // Account already confirmed - $content['message'] = getMessage('LOGIN_ID_CONFIRMED'); + $content['message'] = '{--LOGIN_ID_CONFIRMED--}'; break; case 'LOCKED': // Account is locked - $content['message'] = getMessage('LOGIN_ID_LOCKED'); + $content['message'] = '{--LOGIN_ID_LOCKED--}'; break; } // END - switch } else { // Email address not registered - $content['message'] = getMessage('EMAIL_404'); + $content['message'] = '{--EMAIL_404--}'; } // Load template