Should not be loadInclude() here, we need to rewrite EXT_LOAD_MODE and EXT_VER here

[mailer.git] / ref.php

diff --git a/ref.php b/ref.php
index 4a2129716d065158336bda6c623067d5abfadca2..08398c7efc55031c5db1a0cdd9769a4ac7c25f43 100644 (file)
--- a/ref.php
+++ b/ref.php
@@ -64,27 +64,25 @@ switch (getConfig('refid_target')) {
 }
 
 // Get referal ID from ref or refid variable
-if (REQUEST_ISSET_GET(('ref')))        $ref = REQUEST_GET('ref');
-elseif (REQUEST_ISSET_GET(('refid'))) $ref = REQUEST_GET('refid');
+if (REQUEST_ISSET_GET('ref'))        $ref = REQUEST_GET('ref');
+ elseif (REQUEST_ISSET_GET('refid')) $ref = REQUEST_GET('refid');
 
 if (!empty($ref)) {
        // Test if nickname or numeric id
-       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",
+       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",
                        array($ref), __FILE__, __LINE__);
 
-                       // Load userid
-                       list($ref) = SQL_FETCHROW($result);
+               // Load userid
+               list($ref) = SQL_FETCHROW($result);
 
-                       // Free result
-                       SQL_FREERESULT($result);
-               } else {
-                       // Invalid request!
-                       $ref = 0;
-               }
-       } // END - if
+               // Free result
+               SQL_FREERESULT($result);
+       } else {
+               // Invalid request!
+               $ref = 0;
+       }
 
        // Also edit this 0 !
        if (empty($ref)) $ref = 0;
@@ -98,8 +96,8 @@ if (!empty($ref)) {
        // 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",
-               array(bigintval($ref)), __FILE__, __LINE__);
+               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!)