X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=ref.php;h=12cf4cf7e43163a19e6137a55b1e8d1c8db7cf34;hb=d3c4fdd9bfab35389e1a5ff48f3952d527c7b4bb;hp=4a2129716d065158336bda6c623067d5abfadca2;hpb=2ec9007220186d54f84846871ed1f7638c29baf7;p=mailer.git

diff --git a/ref.php b/ref.php
index 4a2129716d..12cf4cf7e4 100644
--- a/ref.php
+++ b/ref.php
@@ -17,7 +17,7 @@
  * 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 *
@@ -46,11 +46,11 @@ $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')) {
@@ -61,29 +61,40 @@ 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');
+// Get referal id from ref or refid variable
+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 !
@@ -98,13 +109,10 @@ 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!)
-	$URL = 'index.php';
-}
+} // END - if
 
 // Load the URL
 redirectToUrl($URL);