X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=show_bonus.php;h=0953786b2cc935e6d350ce58fba281a5ef1c9fc0;hp=7ebf85b15940cf085d5ba6e091cba73281b42745;hb=d798a412acb8c1263933bd7f7a0fd9aa251495a7;hpb=60494e212a67fe360bfbb481eb4928480a6f379b diff --git a/show_bonus.php b/show_bonus.php index 7ebf85b159..0953786b2c 100644 --- a/show_bonus.php +++ b/show_bonus.php @@ -43,16 +43,20 @@ $GLOBALS['what'] = ""; $GLOBALS['action'] = ""; $GLOBALS['module'] = "show_bonus"; $CSS = 0; // Load the required file(s) -require ("inc/config.php"); +require("inc/config.php"); + +// Is the "bonus" extension active? +if (!EXT_IS_ACTIVE("bonus")) { + // Redirect to index + LOAD_URL("modules.php?module=index&msg=".CODE_EXTENSION_PROBLEM."&ext=bonus"); +} // END - if // List only rankings when script is installed -if (defined('mxchange_installed') && (mxchange_installed)) -{ +if (isBooleanConstantAndTrue('mxchange_installed')) { // Include header include(PATH."inc/header.php"); - if (($_GET['uid'] > 0) && ($_GET['d'] > 0) && (!empty($_GET['t']))) - { + if (($_GET['uid'] > 0) && ($_GET['d'] > 0) && (!empty($_GET['t']))) { // Set row name $t = ""; switch ($_GET['t']) @@ -65,22 +69,22 @@ if (defined('mxchange_installed') && (mxchange_installed)) $t = "mail_id"; break; } - if (!empty($t)) - { + + // Valid type? + if (!empty($t)) { // Check for data - $result = SQL_QUERY_ESC("SELECT DISTINCT d.sex, d.surname, d.family, b.level, b.points + $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=%d AND b.".$t."='%s' LIMIT 1", +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) - { + if (SQL_NUMROWS($result) == 1) { // Load data - list($sex, $sname, $fname, $level, $points) = SQL_FETCHROW($result); + list($gender, $sname, $fname, $level, $points) = SQL_FETCHROW($result); // Prepare constants for the pre-template - define('__SALUT' , TRANSLATE_SEX($sex)); + define('__GENDER' , TRANSLATE_GENDER($gender)); define('__SNAME' , $sname); define('__FNAME' , $fname); define('__RANK' , $level); @@ -93,24 +97,18 @@ WHERE d.status='CONFIRMED' AND d.userid=%d AND b.".$t."='%s' LIMIT 1", // Load pre-template define('__BONUS_MSG', LOAD_TEMPLATE("show_bonus_msg", true)); - } - else - { + } else { // No data found define('__BONUS_MSG', "".BONUS_SHOW_NO_DATA.""); } // Free memory SQL_FREERESULT($result); - } - else - { + } else { // Wrong type entered define('__BONUS_MSG', "".BONUS_SHOW_WRONG_TYPE.""); } - } - else - { + } else { // Wrong call! define('__BONUS_MSG', "".BONUS_SHOW_WRONG_CALL.""); } @@ -129,11 +127,10 @@ WHERE d.status='CONFIRMED' AND d.userid=%d AND b.".$t."='%s' LIMIT 1", // Include footer include(PATH."inc/footer.php"); -} - else -{ +} else { // You have to configure first! LOAD_URL("install.php"); } + // Really all done here... ;-) ?>