* Needs to be in all Files and every File needs "svn propset *
* svn:keywords Date Revision" (autoprobset!) at least!!!!!! *
* -------------------------------------------------------------------- *
- * Copyright (c) 2003 - 2008 by Roland Haeder *
+ * Copyright (c) 2003 - 2009 by Roland Haeder *
* For more information visit: http://www.mxchange.org *
* *
* This program is free software; you can redistribute it and/or modify *
// 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;
// Load the required file(s)
require('inc/config-global.php');
-// Redirect only to registration page when this script is installed
-if (!isInstalled()) {
- // You have to install first!
- redirectToUrl('install.php');
-} // END - if
+// No refid by default
+$URL = 'index.php';
+
+// Invalid request by default
+$ref = 0;
// Base URL for redirection
switch (getConfig('refid_target')) {
case 'index':
$URL = 'index.php?refid=';
break;
-}
+} // END - switch
// 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 (isGetRequestElementSet('ref')) $ref = getRequestElement('ref');
+ elseif (isGetRequestElementSet('refid')) $ref = getRequestElement('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 (isExtensionActive('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__);
+ // Do we have an entry?
+ if (SQL_NUMROWS($result) == 1) {
// Load userid
list($ref) = SQL_FETCHROW($result);
+ } else {
+ // So do we have a userid?
+ $result2 = SQL_QUERY_ESC("SELECT `userid` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `userid`='%s' LIMIT 1",
+ array($ref), __FILE__, __LINE__);
+
+ // Do we have an entry?
+ if (SQL_NUMROWS($result2) == 0) {
+ // No entry, so no referal id
+ $ref = 0;
+ } // END - if
// Free result
- SQL_FREERESULT($result);
- } else {
- // Invalid request!
- $ref = 0;
+ SQL_FREERESULT($result2);
}
+
+ // Free result
+ SQL_FREERESULT($result);
} // END - if
// Also edit this 0 !
// 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!)
- $URL = 'index.php';
-}
+} // END - if
// Load the URL
redirectToUrl($URL);