X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=show_bonus.php;h=61e8ce264adacd49e9992bea202fd7b667fbc612;hp=613fa13577ebe1f2676b03098a91e879902295b6;hb=4bd12d7c844163f67cca3489aa0b6c9af61d8adb;hpb=c5a4b89497cf1430b387b43e0c7808ef6dac0acd diff --git a/show_bonus.php b/show_bonus.php index 613fa13577..61e8ce264a 100644 --- a/show_bonus.php +++ b/show_bonus.php @@ -78,7 +78,7 @@ if (isBooleanConstantAndTrue('mxchange_installed')) { 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 +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 @@ -127,7 +127,7 @@ 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");