Fix for ticket #86, thx 2 profi-concept :)

[mailer.git] / show_bonus.php

diff --git a/show_bonus.php b/show_bonus.php
index a71eee78e1637d77f3c725090f565327e48477a8..2987ae3f11fa6ff0250d3f660491ae6e15e20037 100644 (file)
--- a/show_bonus.php
+++ b/show_bonus.php
@@ -32,7 +32,7 @@
  ************************************************************************/
 
 // Load security stuff here (Oh, I hope this is not unsecure? Am I paranoia??? ;-) )
-require_once("inc/libs/security_functions.php");
+require("inc/libs/security_functions.php");
 
 // Init "action" and "what"
 global $what, $action, $startTime;
@@ -55,7 +55,7 @@ if (!EXT_IS_ACTIVE("bonus")) {
 // List only rankings when script is installed
 if (isBooleanConstantAndTrue('mxchange_installed')) {
        // Include header
-       require(PATH."inc/header.php");
+       LOAD_INC("inc/header.php");
 
        if (($_GET['uid'] > 0) && ($_GET['d'] > 0) && (!empty($_GET['t']))) {
                // Set row name
@@ -78,10 +78,10 @@ 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
+WHERE d.`status`='CONFIRMED' AND d.userid=%s AND b.%s=%s
 LIMIT 1",
                                array(bigintval($_GET['uid']), $t, bigintval($_GET['d'])), __FILE__, __LINE__);
 
@@ -133,7 +133,7 @@ LIMIT 1",
        LOAD_TEMPLATE("show_bonus");
 
        // Include footer
-       require(PATH."inc/footer.php");
+       LOAD_INC("inc/footer.php");
 } else {
        // You have to install first!
        LOAD_URL("install.php");