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 7ef2fa027e34d4425e28c6221c01ca19982d9cb9..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",
@@ -133,7 +133,7 @@ LIMIT 1",
        LOAD_TEMPLATE("show_bonus");
 
        // Include footer
-       include(PATH."inc/footer.php");
+       require(PATH."inc/footer.php");
 } else {
        // You have to install first!
        LOAD_URL("install.php");