Function loadLanguageFile() does now support extensions

[mailer.git] / ref.php

diff --git a/ref.php b/ref.php
index 527d4e9ffc59a7dd6f313dfcbb533b9bde24cce1..730799b089100b6473261d2ae044cf01d839155f 100644 (file)
--- a/ref.php
+++ b/ref.php
@@ -39,10 +39,6 @@
 // Load security stuff here
 require('inc/libs/security_functions.php');
 
-// Init "action" and "what"
-$GLOBALS['what'] = '';
-$GLOBALS['action'] = '';
-
 // Set module
 $GLOBALS['module'] = 'ref';
 $GLOBALS['output_mode'] = -1;
@@ -68,16 +64,16 @@ 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",
-                       array($ref), __FILE__, __LINE__);
+                       $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);
@@ -102,8 +98,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!)