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 61e8ce264adacd49e9992bea202fd7b667fbc612..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
 // 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
 
        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
                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",
 ON d.userid=b.userid
 WHERE d.status='CONFIRMED' AND d.userid=%s AND b.%s=%s
 LIMIT 1",


@@ -133,9 +133,9 @@ LIMIT 1",
        LOAD_TEMPLATE("show_bonus");
 
        // Include footer
        LOAD_TEMPLATE("show_bonus");
 
        // Include footer

-       include(PATH."inc/footer.php");
+       require(PATH."inc/footer.php");

 } else {
 } else {

-       // You have to configure first!
+       // You have to install first!

        LOAD_URL("install.php");
 }
 
        LOAD_URL("install.php");
 }