X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=show_bonus.php;h=6ac941f49fd1da50b97a583c7b1cf4ef9ee209bc;hp=caafa19b66f3c0d1adbab71e918a775cdf524763;hb=cb30b8c591b92189065565d67063c7512b0eeb76;hpb=c7f21c9eb494d8466447c1a199ec5621440d7ac8 diff --git a/show_bonus.php b/show_bonus.php index caafa19b66..6ac941f49f 100644 --- a/show_bonus.php +++ b/show_bonus.php @@ -46,7 +46,7 @@ $GLOBALS['module'] = "show_bonus"; $CSS = 0; require ("inc/config.php"); // List only rankings when script is installed -if (defined('mxchange_installed') && (mxchange_installed)) +if (defined('mxchange_installed') && (isBooleanConstantAndTrue('mxchange_installed'))) { // Include header include(PATH."inc/header.php"); @@ -68,19 +68,19 @@ if (defined('mxchange_installed') && (mxchange_installed)) 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) { // 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); @@ -122,7 +122,7 @@ WHERE d.status='CONFIRMED' AND d.userid=%d 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', $_CONFIG['bonus_ranks']); // Load final template LOAD_TEMPLATE("show_bonus"); @@ -133,7 +133,7 @@ WHERE d.status='CONFIRMED' AND d.userid=%d AND b.".$t."='%s' LIMIT 1", else { // You have to configure first! - LOAD_URL(URL."/install.php"); + LOAD_URL("install.php"); } // Really all done here... ;-) ?>