X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=show_bonus.php;h=130f7147c3fcfeeaf3301cc8adee3a2224f3afc9;hp=352ccf7e8ffd14b88f3543f1873ec07e6d272803;hb=489ff30298f6e63d6bf2f2f42e3fbfd2148f8778;hpb=e01fcf1ca8ddeb72af76465df3ef72301a1cdae7 diff --git a/show_bonus.php b/show_bonus.php index 352ccf7e8f..130f7147c3 100644 --- a/show_bonus.php +++ b/show_bonus.php @@ -10,10 +10,10 @@ * -------------------------------------------------------------------- * * Kurzbeschreibung : Rankliste fuer Turbo-Bonus anzeigen * * -------------------------------------------------------------------- * - * $Revision:: 856 $ * - * $Date:: 2009-03-06 20:24:32 +0100 (Fr, 06. March 2009) $ * + * $Revision:: $ * + * $Date:: $ * * $Tag:: 0.2.1-FINAL $ * - * $Author:: stelzi $ * + * $Author:: $ * * Needs to be in all Files and every File needs "svn propset * * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * @@ -36,113 +36,106 @@ * MA 02110-1301 USA * ************************************************************************/ -// Load security stuff here (Oh, I hope this is not unsecure? Am I paranoia??? ;-) ) -require("inc/libs/security_functions.php"); +// Load security stuff here +require('inc/libs/security_functions.php'); -// Init "action" and "what" +// Init start time $GLOBALS['startTime'] = microtime(true); -$GLOBALS['what'] = ""; -$GLOBALS['action'] = ""; // Set this because we have no module in URI -$GLOBALS['module'] = "show_bonus"; +$GLOBALS['module'] = 'show_bonus'; $GLOBALS['output_mode'] = 0; // Load the required file(s) -require("inc/config.php"); +require('inc/config-global.php'); -// Is the "bonus" extension active? -REDIRECT_ON_UNINSTALLED_EXTENSION("bonus"); +// Is the 'bonus' extension active? +redirectOnUninstalledExtension('bonus'); // List only rankings when script is installed -if (isInstalled()) { - // Include header - LOAD_INC("inc/header.php"); - - if ((REQUEST_GET('uid') > 0) && (REQUEST_GET('d') > 0) && (REQUEST_ISSET_GET(('t')))) { - // Set row name - $t = ""; - switch (REQUEST_GET('t')) { - case "bonusid": // Bonus mail - $t = "bonus_id"; - break; - - case "mailid": // Regular member mail - $t = "mail_id"; - break; - - default: // Invalid type - DEBUG_LOG(__FILE__, __LINE__, sprintf("Invalid type %s detected.", REQUEST_GET('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 +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')))) { + // Set row name + $t = ''; + switch (REQUEST_GET('t')) { + case 'bonusid': // Bonus mail + $t = 'bonus_id'; + break; + + case 'mailid': // Regular member mail + $t = 'mail_id'; + break; + + default: // Invalid type + DEBUG_LOG(__FILE__, __LINE__, sprintf("Invalid type %s detected.", REQUEST_GET('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 LIMIT 1", - array(bigintval(REQUEST_GET('uid')), $t, bigintval(REQUEST_GET('d'))), __FILE__, __LINE__); - - // Entry found? - if (SQL_NUMROWS($result) == 1) { - // Load data - $content = SQL_FETCHARRAY($result); - - // Prepare constants for the pre-template - define('__GENDER' , TRANSLATE_GENDER($content['gender'])); - define('__SNAME' , $content['surname']); - define('__FNAME' , $content['family']); - define('__RANK' , BIGINTVAL($content['level'])); - define('__POINTS' , TRANSLATE_COMMA($content['points'])); - define('__MAILID' , bigintval(REQUEST_GET('d'))); - define('__RANK_ROWS', BONUS_MAKE_RANK_ROWS(bigintval(REQUEST_GET('d')), $t, bigintval(REQUEST_GET('uid')))); - - // Constant created within previous function which contains informations for current user's ranking position: - // __YOUR_RANKING_LINE - - // Load pre-template - define('__BONUS_MSG', LOAD_TEMPLATE("show_bonus_msg", true)); - } else { - // No data found - define('__BONUS_MSG', "{--BONUS_SHOW_NO_DATA--}"); - } - - // Free memory - SQL_FREERESULT($result); + array(bigintval(REQUEST_GET('uid')), $t, bigintval(REQUEST_GET('d'))), __FILE__, __LINE__); + + // Entry found? + if (SQL_NUMROWS($result) == 1) { + // Load data + $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'))); + + // Constant created within previous function which contains informations for current user's ranking position: + // @TODO Rewrite this constant + // __YOUR_RANKING_LINE + + // Load pre-template + $content['msg'] = LOAD_TEMPLATE('show_bonus_msg', true, $content); } else { - // Wrong type entered - define('__BONUS_MSG', "{--BONUS_SHOW_WRONG_TYPE--}"); + // No data found + $content['msg'] = "{--BONUS_SHOW_NO_DATA--}"; } + + // Free memory + SQL_FREERESULT($result); } else { - // Wrong call! - define('__BONUS_MSG', "{--BONUS_SHOW_WRONG_CALL--}"); + // Wrong type entered + $content['msg'] = "{--BONUS_SHOW_WRONG_TYPE--}"; } +} else { + // Wrong call! + $content['msg'] = "{--BONUS_SHOW_WRONG_CALL--}"; +} - // Load send_bonus header template (for your banners, e.g.?) - define('__BONUS_HEADER', LOAD_TEMPLATE("show_bonus_header", true)); - - // Load show_bonus footer template (for your banners, e.g.?) - define('__BONUS_FOOTER', LOAD_TEMPLATE("show_bonus_footer", true)); +// Load send_bonus header template (for your banners, e.g.?) +$content['header'] = LOAD_TEMPLATE('show_bonus_header', true); - // Total ranks who can win - define('__BONUS_TOTAL_RANKS', getConfig('bonus_ranks')); +// Load show_bonus footer template (for your banners, e.g.?) +$content['footer'] = LOAD_TEMPLATE('show_bonus_footer', true); - // Load final template - LOAD_TEMPLATE("show_bonus"); +// Total ranks who can win +$content['total_ranks'] = getConfig('bonus_ranks'); - // Include footer - LOAD_INC("inc/footer.php"); -} else { - // You have to install first! - LOAD_URL("install.php"); -} +// Load final template +LOAD_TEMPLATE('show_bonus', false, $content); -// Really all done here... ;-) -shutdown(); +// Include footer +loadIncludeOnce('inc/footer.php'); -// +// [EOF] ?>