Continue link added, contributed by profi-concept. Partly resolves #3

[mailer.git] / ref.php

diff --git a/ref.php b/ref.php
index 7adf9ae91a50a7b1339f868042277699a90cdd4e..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 {