X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=birthday_confirm.php;h=333e5b03b757e5a3e829e5bbeac7187c9a6382db;hp=003c93fbd186e359dbf95f9e477f5d7720b250ff;hb=51079dd70c124f02f72bd573f7f6661e3078ea9f;hpb=0fd6858b423d41e7eee9ffa3d5138d318e08cc1c diff --git a/birthday_confirm.php b/birthday_confirm.php index 003c93fbd1..333e5b03b7 100644 --- a/birthday_confirm.php +++ b/birthday_confirm.php @@ -1,7 +1,7 @@ \n"; +$result = SQL_QUERY_ESC("SELECT + b.`points`, d.`userid`, d.`gender`, d.`surname`, d.`family`, d.`status`, d.`ref_payout` +FROM + `{?_MYSQL_PREFIX?}_user_birthday` AS b +INNER JOIN + `{?_MYSQL_PREFIX?}_user_data` AS d +ON + b.`userid`=d.`userid` +WHERE + b.`userid`=%s AND + b.`chk_value`='%s' +LIMIT 1", + array( + $userid, + $chk + ), __FILE__, __LINE__); +//* DEBUG: */ debugOutput("userid=".$userid.",chk=".$chk." (".strlen($chk).'/'.strlen(getRequestElement('check')).'/'.SQL_NUMROWS($result) . ')'); // Prepare content $content = array(); @@ -84,37 +89,23 @@ if (SQL_NUMROWS($result) == 1) { // Is the account confirmed? if ($data['status'] == 'CONFIRMED') { - // Set mode depending on how many mails the member has to confirm - $locked = false; - if (($data['ref_payout'] > 0) && (getConfig('allow_direct_pay') != 'Y')) $locked = true; - // Add points to account - unset($GLOBALS['ref_level']); - ADD_POINTS_REFSYSTEM('birthday_confirm', $uid, $data['points'], false, '0', $locked, strtolower(getConfig('birthday_mode'))); - - // Update mediadata if version is 0.0.4 or newer - if (GET_EXT_VERSION('mediadata') >= '0.0.4') { - // Update database - MEDIA_UPDATE_ENTRY(array('total_points'), 'add', $data['points']); - } // END - if + initReferralSystem(); + addPointsThroughReferralSystem('birthday_confirm', $userid, $data['points']); // Remove entry from table - SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_user_birthday` WHERE userid=%s AND chk_value='%s' LIMIT 1", - array($uid, $chk), __FILE__, __LINE__); - - // "Translate" some data - $data['gender'] = translateGender($data['gender']); - $data['points'] = translateComma($data['points']); + SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_birthday` WHERE `userid`=%s AND `chk_value`='%s' LIMIT 1", + array($userid, $chk), __FILE__, __LINE__); // Load message from template - $content['msg'] = LOAD_TEMPLATE('birthday_msg', true, $data); + $content['message'] = loadTemplate('birthday_msg', true, $data); } else { // Unconfirmed / locked accounts cannot get points - $content['msg'] = sprintf(getMessage('BIRTHDAY_CANNOT_STATUS'), translateUserStatus($data['status'])); + $content['message'] = '{%message,MEMBER_BIRTHDAY_CANNOT_STATUS=' . $data['status'] . '%}'; } } else { // Cannot load data! - $content['msg'] = getMessage('BIRTHDAY_CANNOT_LOAD_DATA'); + $content['message'] = '{--MEMBER_BIRTHDAY_CANNOT_LOAD_DATA--}'; } // Free memory @@ -127,13 +118,13 @@ $GLOBALS['module'] = 'birthday_confirm'; loadIncludeOnce('inc/header.php'); // Load birthday header template (for your banners, e.g.?) -$content['header'] = LOAD_TEMPLATE('birthday_header', true); +$content['header'] = loadTemplate('birthday_header', true); // Load birthday footer template (for your banners, e.g.?) -$content['footer'] = LOAD_TEMPLATE('birthday_footer', true); +$content['footer'] = loadTemplate('birthday_footer', true); // Load final template and output it -LOAD_TEMPLATE('birthday_confirm', false, $content); +loadTemplate('birthday_confirm', false, $content); // Include footer loadIncludeOnce('inc/footer.php');