X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=show_bonus.php;h=525d5b498055f406e6e07f0efa126355d0cc366d;hp=5daf345ce89efd1b7874aa4431ec8681adc3645b;hb=4fbb69b66564237c51d4eaf8c82d0d8cdfcf84a0;hpb=0fd6858b423d41e7eee9ffa3d5138d318e08cc1c diff --git a/show_bonus.php b/show_bonus.php index 5daf345ce8..525d5b4980 100644 --- a/show_bonus.php +++ b/show_bonus.php @@ -1,7 +1,7 @@ 0) && (REQUEST_GET('d') > 0) && (REQUEST_ISSET_GET(('t')))) { +if ((isValidUserId(getRequestElement('userid'))) && (getRequestElement('d') > 0) && (isGetRequestElementSet('t'))) { // Set row name $t = ''; - switch (REQUEST_GET('t')) { + switch (getRequestElement('t')) { case 'bonusid': // Bonus mail $t = 'bonus_id'; break; @@ -76,20 +70,31 @@ if ((REQUEST_GET('uid') > 0) && (REQUEST_GET('d') > 0) && (REQUEST_ISSET_GET(('t break; default: // Invalid type - DEBUG_LOG(__FILE__, __LINE__, sprintf("Invalid type %s detected.", REQUEST_GET('t'))); + logDebugMessage(__FILE__, __LINE__, sprintf("Invalid type %s detected.", getRequestElement('t'))); break; } // END - switch // Valid type? if (!empty($t)) { // Check for data - $result = SQL_QUERY_ESC("SELECT DISTINCT d.gender, d.surname, d.family, b.level, b.points -FROM `{!_MYSQL_PREFIX!}_user_data` AS d -RIGHT JOIN `{!_MYSQL_PREFIX!}_bonus_turbo` AS b -ON d.userid=b.userid -WHERE d.`status`='CONFIRMED' AND d.userid=%s AND b.%s=%s + $result = SQL_QUERY_ESC("SELECT + d.`userid`, b.`level`, b.`points` +FROM + `{?_MYSQL_PREFIX?}_user_data` AS d +INNER JOIN + `{?_MYSQL_PREFIX?}_bonus_turbo` AS b +ON + d.`userid`=b.`userid` +WHERE + d.`status`='CONFIRMED' AND + d.`userid`=%s AND + b.`%s`=%s LIMIT 1", - array(bigintval(REQUEST_GET('uid')), $t, bigintval(REQUEST_GET('d'))), __FILE__, __LINE__); + array( + bigintval(getRequestElement('userid')), + $t, + bigintval(getRequestElement('d')) + ), __FILE__, __LINE__); // Entry found? if (SQL_NUMROWS($result) == 1) { @@ -97,44 +102,38 @@ LIMIT 1", $content = SQL_FETCHARRAY($result); // Prepare constants for the pre-template - $content['gender'] = translateGender($content['gender']); - $content['points'] = translateComma($content['points']); - $content['mailid'] = bigintval(REQUEST_GET('d')); - $content['rows'] = BONUS_MAKE_RANK_ROWS(bigintval(REQUEST_GET('d')), $t, bigintval(REQUEST_GET('uid'))); + $content['mailid'] = bigintval(getRequestElement('d')); + $content['rows'] = addBonusRanks(bigintval(getRequestElement('d')), $t, bigintval(getRequestElement('userid'))); - // Constant created within previous function which contains informations for current user's ranking position: - // @TODO Rewrite this constant - // __YOUR_RANKING_LINE + // Get some prepared content + $content = merge_array($content, $GLOBALS['ranking_content']); // Load pre-template - $content['msg'] = LOAD_TEMPLATE('show_bonus_msg', true, $content); + $content['message'] = loadTemplate('show_bonus_msg', true, $content); } else { // No data found - $content['msg'] = "{--BONUS_SHOW_NO_DATA--}"; + $content['message'] = '{--BONUS_SHOW_NO_DATA--}'; } // Free memory SQL_FREERESULT($result); } else { // Wrong type entered - $content['msg'] = "{--BONUS_SHOW_WRONG_TYPE--}"; + $content['message'] = '{--BONUS_SHOW_WRONG_TYPE--}'; } } else { // Wrong call! - $content['msg'] = "{--BONUS_SHOW_WRONG_CALL--}"; + $content['message'] = '{--BONUS_SHOW_WRONG_CALL--}'; } // Load send_bonus header template (for your banners, e.g.?) -$content['header'] = LOAD_TEMPLATE('show_bonus_header', true); +$content['header'] = loadTemplate('show_bonus_header', true); // Load show_bonus footer template (for your banners, e.g.?) -$content['footer'] = LOAD_TEMPLATE('show_bonus_footer', true); - -// Total ranks who can win -$content['total_ranks'] = getConfig('bonus_ranks'); +$content['footer'] = loadTemplate('show_bonus_footer', true); // Load final template -LOAD_TEMPLATE('show_bonus', false, $content); +loadTemplate('show_bonus', false, $content); // Include footer loadIncludeOnce('inc/footer.php');