X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=show_bonus.php;h=130f7147c3fcfeeaf3301cc8adee3a2224f3afc9;hp=c41dc5b5cd2bd73602232b0d9d2db76dcb24955b;hb=e1d636846bafc8ae71855595a2a2843463025e26;hpb=a090e351c49fe021fb3064325694da03402332e0 diff --git a/show_bonus.php b/show_bonus.php index c41dc5b5cd..130f7147c3 100644 --- a/show_bonus.php +++ b/show_bonus.php @@ -36,113 +36,106 @@ * MA 02110-1301 USA * ************************************************************************/ -// Load security stuff here (Oh, I hope this is not unsecure? Am I paranoia??? ;-) ) +// 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['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'); +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] ?>