X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=show_bonus.php;h=d23e3d25466b8c492eaa3ee5bfadb304b44d2569;hp=130f7147c3fcfeeaf3301cc8adee3a2224f3afc9;hb=3e2db2082694ee086a26408080dd9eee5f39b81a;hpb=2ec9007220186d54f84846871ed1f7638c29baf7 diff --git a/show_bonus.php b/show_bonus.php index 130f7147c3..d23e3d2546 100644 --- a/show_bonus.php +++ b/show_bonus.php @@ -17,7 +17,7 @@ * Needs to be in all Files and every File needs "svn propset * * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * - * Copyright (c) 2003 - 2008 by Roland Haeder * + * Copyright (c) 2003 - 2009 by Roland Haeder * * For more information visit: http://www.mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -44,27 +44,24 @@ $GLOBALS['startTime'] = microtime(true); // Set this because we have no module in URI $GLOBALS['module'] = 'show_bonus'; -$GLOBALS['output_mode'] = 0; +$GLOBALS['output_mode'] = '0'; // Load the required file(s) require('inc/config-global.php'); +// Set content type +setContentType('text/html'); + // Is the 'bonus' extension active? redirectOnUninstalledExtension('bonus'); -// List only rankings when script is installed -if (!isInstalled()) { - // You have to install first! - redirectToUrl('install.php'); -} // END - if - // Include header loadIncludeOnce('inc/header.php'); -if ((REQUEST_GET('uid') > 0) && (REQUEST_GET('d') > 0) && (REQUEST_ISSET_GET(('t')))) { +if ((getRequestElement('userid') > 0) && (getRequestElement('d') > 0) && (isGetRequestElementSet('t'))) { // Set row name $t = ''; - switch (REQUEST_GET('t')) { + switch (getRequestElement('t')) { case 'bonusid': // Bonus mail $t = 'bonus_id'; break; @@ -74,20 +71,28 @@ 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.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 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,42 +102,38 @@ LIMIT 1", // 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');