From 36a31ecf3137283ddd5d7aad121bacf3df54e2e1 Mon Sep 17 00:00:00 2001
From: =?utf8?q?Roland=20H=C3=A4der?= <roland@mxchange.org>
Date: Sat, 27 Sep 2008 20:03:11 +0000
Subject: [PATCH 1/1] Now with refid.php

---
 inc/databases.php |  2 +-
 ref.php           | 21 +++++++++++++++------
 2 files changed, 16 insertions(+), 7 deletions(-)

diff --git a/inc/databases.php b/inc/databases.php
index 391cb43638..0507ac7fbf 100644
--- a/inc/databases.php
+++ b/inc/databases.php
@@ -113,7 +113,7 @@ define('USAGE_BASE', "usage");
 define('SERVER_URL', "http://www.mxchange.org");
 
 // This current patch level
-define('CURR_SVN_REVISION', "406");
+define('CURR_SVN_REVISION', "408");
 
 // Take a prime number which is long (if you know a longer one please try it out!)
 define('_PRIME', 591623);
diff --git a/ref.php b/ref.php
index 905abf7122..c9b37ece10 100644
--- a/ref.php
+++ b/ref.php
@@ -64,12 +64,21 @@ if (isBooleanConstantAndTrue('mxchange_installed')) {
 
 	if (!empty($ref)) {
 		// Test if nickname or numeric id
-		if ((EXT_IS_ACTIVE("nickname")) && ($ref != "".bigintval($ref)."")) {
-			// 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__);
-			list($ref) = SQL_FETCHROW($result);
-			SQL_FREERESULT($result);
+		if ($ref != "".bigintval($ref)."") {
+			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);
+
+				// Free result
+				SQL_FREERESULT($result);
+			} else {
+				// Invalid request!
+				$ref = 0;
+			}
 		} // END - if
 
 		// Also edit this 0 !
-- 
2.30.2