X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=show_bonus.php;h=7ef2fa027e34d4425e28c6221c01ca19982d9cb9;hp=613fa13577ebe1f2676b03098a91e879902295b6;hb=701f5ac005404813e0e546102b5821f2ba2af522;hpb=c5a4b89497cf1430b387b43e0c7808ef6dac0acd diff --git a/show_bonus.php b/show_bonus.php index 613fa13577..7ef2fa027e 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"); @@ -135,7 +135,7 @@ LIMIT 1", // Include footer include(PATH."inc/footer.php"); } else { - // You have to configure first! + // You have to install first! LOAD_URL("install.php"); }