X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=show_bonus.php;h=d23e3d25466b8c492eaa3ee5bfadb304b44d2569;hp=c41dc5b5cd2bd73602232b0d9d2db76dcb24955b;hb=56bd95001d8285c062a52e7917dbe74f45fc7677;hpb=a090e351c49fe021fb3064325694da03402332e0 diff --git a/show_bonus.php b/show_bonus.php index c41dc5b5cd..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 * @@ -36,113 +36,107 @@ * 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; +$GLOBALS['output_mode'] = '0'; // Load the required file(s) -require('inc/config.php'); +require('inc/config-global.php'); + +// Set content type +setContentType('text/html'); // Is the 'bonus' extension active? -REDIRECT_ON_UNINSTALLED_EXTENSION('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 -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 +redirectOnUninstalledExtension('bonus'); + +// 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 - 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(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 - define('__BONUS_MSG', "{--BONUS_SHOW_WRONG_TYPE--}"); + // No data found + $content['message'] = "{--BONUS_SHOW_NO_DATA--}"; } + + // Free memory + SQL_FREERESULT($result); } else { - // Wrong call! - define('__BONUS_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.?) - 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)); - - // Total ranks who can win - define('__BONUS_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'); +// Load show_bonus footer template (for your banners, e.g.?) +$content['footer'] = loadTemplate('show_bonus_footer', true); - // Include footer - LOAD_INC('inc/footer.php'); -} else { - // You have to install first! - LOAD_URL('install.php'); -} +// Load final template +loadTemplate('show_bonus', false, $content); -// Really all done here... ;-) -shutdown(); +// Include footer +loadIncludeOnce('inc/footer.php'); -// +// [EOF] ?>