All database names are now 'back-ticked' and constant _MYSQL_PREFIX is wrapped. Partl...

[mailer.git] / show_bonus.php

diff --git a/show_bonus.php b/show_bonus.php
index 613fa13577ebe1f2676b03098a91e879902295b6..a71eee78e1637d77f3c725090f565327e48477a8 100644 (file)
--- a/show_bonus.php
+++ b/show_bonus.php
@@ -55,7 +55,7 @@ if (!EXT_IS_ACTIVE("bonus")) {
 // List only rankings when script is installed
 if (isBooleanConstantAndTrue('mxchange_installed')) {
        // Include header
-       include(PATH."inc/header.php");
+       require(PATH."inc/header.php");
 
        if (($_GET['uid'] > 0) && ($_GET['d'] > 0) && (!empty($_GET['t']))) {
                // Set row name
@@ -78,8 +78,8 @@ 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
-RIGHT JOIN "._MYSQL_PREFIX."_bonus_turbo AS b
+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",
@@ -127,15 +127,15 @@ 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");
 
        // Include footer
-       include(PATH."inc/footer.php");
+       require(PATH."inc/footer.php");
 } else {
-       // You have to configure first!
+       // You have to install first!
        LOAD_URL("install.php");
 }