Variable fixed
[mailer.git] / ref.php
diff --git a/ref.php b/ref.php
index 783aab194c3b04928a3627c62d6f3da17cb55d9b..ba76c41b6d5e4b589f08cbbcbdc32bd9ca00bfe6 100644 (file)
--- a/ref.php
+++ b/ref.php
@@ -6,7 +6,7 @@
  * -------------------------------------------------------------------- *
  * File              : ref.php                                          *
  * -------------------------------------------------------------------- *
- * Short description : Redirection for the referal link                *
+ * Short description : Redirection for the referal link                 *
  * -------------------------------------------------------------------- *
  * Kurzbeschreibung  : Weiterleitungsscript fuer die Referal-Links      *
  * -------------------------------------------------------------------- *
@@ -42,12 +42,12 @@ $GLOBALS['what'] = ""; $GLOBALS['action'] = "";
 $GLOBALS['module'] = "ref"; $CSS = -1;
 
 // Load the required file(s)
-require ("inc/config.php");
+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=";
@@ -64,10 +64,10 @@ if (isBooleanConstantAndTrue('mxchange_installed')) {
 
        if (!empty($ref)) {
                // Test if nickname or numeric id
-               if ($ref != "".bigintval($ref)."") {
+               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
-                       $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET ref_clicks=ref_clicks+1 WHERE userid=%s LIMIT 1",
+                       $result = 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 {