X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=show_bonus.php;h=cf45a31fe1723037bf90ecb2ee90bebf753778c6;hp=6f2e4bffb65b77f40c473b58344c00ae9542368b;hb=26ea563a90454a2cde58f8cd134542a0d8f14780;hpb=0437f06b273f885db05736449a952c6eb72086ca diff --git a/show_bonus.php b/show_bonus.php index 6f2e4bffb6..cf45a31fe1 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 * @@ -39,10 +39,8 @@ // 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'; @@ -51,95 +49,94 @@ $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()) { - // 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 +// Include header +loadIncludeOnce('inc/header.php'); + +if ((getRequestElement('userid') > 0) && (getRequestElement('d') > 0) && (isGetRequestElementSet('t'))) { + // Set row name + $t = ''; + switch (getRequestElement('t')) { + case 'bonusid': // Bonus mail + $t = 'bonus_id'; + break; + + case 'mailid': // Regular member mail + $t = 'mail_id'; + break; + + default: // Invalid type + 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 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 - $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: - // __YOUR_RANKING_LINE - - // Load pre-template - $content['msg'] = LOAD_TEMPLATE('show_bonus_msg', true, $content); - } else { - // No data found - $content['msg'] = "{--BONUS_SHOW_NO_DATA--}"; - } - - // Free memory - SQL_FREERESULT($result); + array( + bigintval(getRequestElement('userid')), + $t, + bigintval(getRequestElement('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(getRequestElement('d')); + $content['rows'] = addBonusRanks(bigintval(getRequestElement('d')), $t, bigintval(getRequestElement('userid'))); + + // Get some prepared content + $content = merge_array($content, $GLOBALS['ranking_content']); + + // Load pre-template + $content['message'] = loadTemplate('show_bonus_msg', true, $content); } else { - // Wrong type entered - $content['msg'] = "{--BONUS_SHOW_WRONG_TYPE--}"; + // No data found + $content['message'] = "{--BONUS_SHOW_NO_DATA--}"; } + + // Free memory + SQL_FREERESULT($result); } else { - // Wrong call! - $content['msg'] = "{--BONUS_SHOW_WRONG_CALL--}"; + // Wrong type entered + $content['message'] = "{--BONUS_SHOW_WRONG_TYPE--}"; } +} else { + // 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); - - // 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'); +// Load send_bonus header template (for your banners, e.g.?) +$content['header'] = loadTemplate('show_bonus_header', true); - // Load final template - LOAD_TEMPLATE('show_bonus', false, $content); +// Load show_bonus footer template (for your banners, e.g.?) +$content['footer'] = loadTemplate('show_bonus_footer', true); - // Include footer - loadIncludeOnce('inc/footer.php'); -} else { - // You have to install first! - redirectToUrl('install.php'); -} +// Load final template +loadTemplate('show_bonus', false, $content); -// Really all done here... ;-) -shutdown(); +// Include footer +loadIncludeOnce('inc/footer.php'); -// +// [EOF] ?>