X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=show_bonus.php;h=0a633f1e771482e37a88064e8e6d86a1f325888c;hp=0d5c910e7f7427bc6fc5be0679077f999acdad35;hb=c6bd3b9962b4398407e7f6c3c1c62e9869cf04ec;hpb=58b29a924c48e7c1ce38c435c92e541b53984c56 diff --git a/show_bonus.php b/show_bonus.php index 0d5c910e7f..0a633f1e77 100644 --- a/show_bonus.php +++ b/show_bonus.php @@ -1,7 +1,7 @@ 0) && ($_GET['d'] > 0) && (!empty($_GET['t']))) - { - // Set row name - $t = ""; - switch ($_GET['t']) - { - case "bonusid": - $t = "bonus_id"; +require('inc/config-global.php'); + +// Set content type +setContentType('text/html'); + +// Is the 'bonus' extension active? +redirectOnUninstalledExtension('bonus'); + +// Include header +loadIncludeOnce('inc/header.php'); + +if ((getRequestParameter('userid') > 0) && (getRequestParameter('d') > 0) && (isGetRequestParameterSet('t'))) { + // Set row name + $t = ''; + switch (getRequestParameter('t')) { + case 'bonusid': // Bonus mail + $t = 'bonus_id'; break; - case "mailid": - $t = "mail_id"; + case 'mailid': // Regular member mail + $t = 'mail_id'; break; + + default: // Invalid type + logDebugMessage(__FILE__, __LINE__, sprintf("Invalid type %s detected.", getRequestParameter('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(getRequestParameter('userid')), + $t, + bigintval(getRequestParameter('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(getRequestParameter('d')); + $content['rows'] = addBonusRanks(bigintval(getRequestParameter('d')), $t, bigintval(getRequestParameter('userid'))); + + // Get some prepared content + $content = merge_array($content, $GLOBALS['ranking_content']); + + // Load pre-template + $content['message'] = loadTemplate('show_bonus_msg', true, $content); + } else { + // No data found + $content['message'] = '{--BONUS_SHOW_NO_DATA--}'; } - if (!empty($t)) - { - // Check for data - $result = SQL_QUERY_ESC("SELECT DISTINCT d.sex, 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=%d AND b.".$t."='%s' LIMIT 1", - array(bigintval($_GET['uid']), bigintval($_GET['d'])), __FILE__, __LINE__); - if (SQL_NUMROWS($result) == 1) - { - // Load data - list($sex, $sname, $fname, $level, $points) = SQL_FETCHROW($result); - - // Prepare constants for the pre-template - define('__SALUT' , TRANSLATE_SEX($sex)); - 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']))); - - // 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); - } - else - { - // Wrong type entered - define('__BONUS_MSG', "".BONUS_SHOW_WRONG_TYPE.""); - } - } - else - { - // Wrong call! - define('__BONUS_MSG', "".BONUS_SHOW_WRONG_CALL.""); + + // Free memory + SQL_FREERESULT($result); + } else { + // 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 send_bonus header template (for your banners, e.g.?) +$content['header'] = loadTemplate('show_bonus_header', true); - // Load show_bonus footer template (for your banners, e.g.?) - define('__BONUS_FOOTER', LOAD_TEMPLATE("show_bonus_footer", true)); +// Load show_bonus footer template (for your banners, e.g.?) +$content['footer'] = loadTemplate('show_bonus_footer', true); - // Total ranks who can win - define('__BONUS_TOTAL_RANKS', $_CONFIG['bonus_ranks']); +// Load final template +loadTemplate('show_bonus', false, $content); - // Load final template - LOAD_TEMPLATE("show_bonus"); +// Include footer +loadIncludeOnce('inc/footer.php'); - // Include footer - include(PATH."inc/footer.php"); -} - else -{ - // You have to configure first! - LOAD_URL("install.php"); -} -// Really all done here... ;-) +// [EOF] ?>