All database names are now 'back-ticked' and constant _MYSQL_PREFIX is wrapped. Partl...

[mailer.git] / ref.php

diff --git a/ref.php b/ref.php
index 3d62586d555d0d82f972bfd92bb408f992c5a25c..5b46f1778aeb065d08d5eca7235af786bbc83f77 100644 (file)
--- a/ref.php
+++ b/ref.php
@@ -47,14 +47,14 @@ require("inc/config.php");
 // Redirect only to registration page when this script is installed
 if (isBooleanConstantAndTrue('mxchange_installed')) {
        // Base URL for redirection
-       switch ($_CONFIG['refid_target'])
+       switch (getConfig('refid_target'))
        {
        case "register":
-               $URL = URL."/modules.php?module=index&what=register&refid=";
+               $URL = "modules.php?module=index&what=register&refid=";
                break;
 
        case "index":
-               $URL = URL."/index.php?refid=";
+               $URL = "index.php?refid=";
                break;
        }
 
@@ -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,18 +93,18 @@ if (isBooleanConstantAndTrue('mxchange_installed')) {
                // Is the refid valid?
                if ($ref > 0) {
                        // Update ref counter
-                       $result = 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 {
                // No refid and we add our refid (don't forget to set $def_refid!)
-               $URL = URL."/index.php";
+               $URL = "index.php";
        }
 
        // Load the URL
        LOAD_URL($URL);
 } else {
-       // You have to configure first!
+       // You have to install first!
        LOAD_URL("install.php");
 }