X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=show_bonus.php;h=5773cf1b7de7f05cee4e5cd6fb904d93ec65a81c;hp=6ac941f49fd1da50b97a583c7b1cf4ef9ee209bc;hb=8b3b0fae36adfa1ef72f436d107d11404b326ec5;hpb=f01652b7b8efac92d97889e312402c4a845c2f14 diff --git a/show_bonus.php b/show_bonus.php index 6ac941f49f..5773cf1b7d 100644 --- a/show_bonus.php +++ b/show_bonus.php @@ -32,87 +32,89 @@ ************************************************************************/ // Load security stuff here (Oh, I hope this is not unsecure? Am I paranoia??? ;-) ) -require_once("inc/libs/security_functions.php"); +require("inc/libs/security_functions.php"); // Init "action" and "what" -global $what, $action, $startTime; $GLOBALS['startTime'] = microtime(true); -$GLOBALS['what'] = ""; $GLOBALS['action'] = ""; +$GLOBALS['what'] = ""; +$GLOBALS['action'] = ""; // Set this because we have no module in URI -$GLOBALS['module'] = "show_bonus"; $CSS = 0; +$GLOBALS['module'] = "show_bonus"; +$GLOBALS['output_mode'] = 0; // Load the required file(s) -require ("inc/config.php"); +require("inc/config.php"); + +// Is the "bonus" extension active? +REDIRECT_ON_UNINSTALLED_EXTENSION("bonus"); // List only rankings when script is installed -if (defined('mxchange_installed') && (isBooleanConstantAndTrue('mxchange_installed'))) -{ +if (isBooleanConstantAndTrue('mxchange_installed')) { // Include header - include(PATH."inc/header.php"); + LOAD_INC("inc/header.php"); - if (($_GET['uid'] > 0) && ($_GET['d'] > 0) && (!empty($_GET['t']))) - { + if ((REQUEST_GET('uid') > 0) && (REQUEST_GET('d') > 0) && (REQUEST_ISSET_GET(('t')))) { // Set row name $t = ""; - switch ($_GET['t']) - { - case "bonusid": - $t = "bonus_id"; - break; - - case "mailid": - $t = "mail_id"; - break; - } - if (!empty($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 +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.".$t."='%s' LIMIT 1", - array(bigintval($_GET['uid']), bigintval($_GET['d'])), __FILE__, __LINE__); - if (SQL_NUMROWS($result) == 1) - { +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 - list($gender, $sname, $fname, $level, $points) = SQL_FETCHROW($result); + $content = SQL_FETCHARRAY($result); // Prepare constants for the pre-template - define('__GENDER' , TRANSLATE_GENDER($gender)); - define('__SNAME' , $sname); - define('__FNAME' , $fname); - define('__RANK' , $level); - define('__POINTS' , $points); - define('__MAILID' , $_GET['d']); - define('__RANK_ROWS', BONUS_MAKE_RANK_ROWS(bigintval($_GET['d']), $t, bigintval($_GET['uid']))); + 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 - { + } else { // No data found - define('__BONUS_MSG', "".BONUS_SHOW_NO_DATA.""); + define('__BONUS_MSG', "{--BONUS_SHOW_NO_DATA--}"); } // Free memory SQL_FREERESULT($result); - } - else - { + } else { // Wrong type entered - define('__BONUS_MSG', "".BONUS_SHOW_WRONG_TYPE.""); + define('__BONUS_MSG', "{--BONUS_SHOW_WRONG_TYPE--}"); } - } - else - { + } else { // Wrong call! - define('__BONUS_MSG', "".BONUS_SHOW_WRONG_CALL.""); + define('__BONUS_MSG', "{--BONUS_SHOW_WRONG_CALL--}"); } // Load send_bonus header template (for your banners, e.g.?) @@ -122,18 +124,17 @@ WHERE d.status='CONFIRMED' AND d.userid=%s AND b.".$t."='%s' LIMIT 1", define('__BONUS_FOOTER', LOAD_TEMPLATE("show_bonus_footer", true)); // Total ranks who can win - define('__BONUS_TOTAL_RANKS', $_CONFIG['bonus_ranks']); + define('__BONUS_TOTAL_RANKS', getConfig('bonus_ranks')); // Load final template LOAD_TEMPLATE("show_bonus"); // Include footer - include(PATH."inc/footer.php"); -} - else -{ - // You have to configure first! + LOAD_INC("inc/footer.php"); +} else { + // You have to install first! LOAD_URL("install.php"); } + // Really all done here... ;-) ?>