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

[mailer.git] / ref.php

diff --git a/ref.php b/ref.php
index 7f9202725661bbfff87cdb14b4274b3950ca65e7..918e2ef68de13d86b8d7c92c00d8cdc4cd8d5d27 100644 (file)
--- a/ref.php
+++ b/ref.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;
@@ -67,7 +67,7 @@ if (isBooleanConstantAndTrue('mxchange_installed')) {
                if ($ref != "".($ref + 0)."") {
                        if (EXT_IS_ACTIVE("nickname")) {
                                // Nickname in URL, so load the ID
-                               $result = SQL_QUERY_ESC("SELECT userid FROM `"._MYSQL_PREFIX."_user_data` WHERE nickname='%s' LIMIT 1",
+                               $result = SQL_QUERY_ESC("SELECT userid FROM `{!_MYSQL_PREFIX!}_user_data` WHERE nickname='%s' LIMIT 1",
                                        array($ref), __FILE__, __LINE__);
 
                                // Load userid
@@ -93,7 +93,7 @@ if (isBooleanConstantAndTrue('mxchange_installed')) {
                // Is the refid valid?
                if ($ref > 0) {
                        // Update ref counter
-                       SQL_QUERY_ESC("UPDATE `"._MYSQL_PREFIX."_user_data` SET ref_clicks=ref_clicks+1 WHERE userid=%s LIMIT 1",
+                       SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_user_data` SET ref_clicks=ref_clicks+1 WHERE userid=%s LIMIT 1",
                                array(bigintval($ref)), __FILE__, __LINE__);
                } // END - if
        } else {
@@ -104,7 +104,7 @@ if (isBooleanConstantAndTrue('mxchange_installed')) {
        // Load the URL
        LOAD_URL($URL);
 } else {
-       // You have to configure first!
+       // You have to install first!
        LOAD_URL("install.php");
 }