X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=ref.php;h=700491851a4bff59c4f262a928dfac4165e3463c;hp=b308c84198ac346f0e8c761192c84e442634d31f;hb=0e269568bd666186509e98594e83bac199ac26da;hpb=01894fd8602147cf872979a523d5da9b5b147a53

diff --git a/ref.php b/ref.php
index b308c84198..700491851a 100644
--- a/ref.php
+++ b/ref.php
@@ -49,68 +49,47 @@ require('inc/config-global.php');
 // No refid by default
 $URL = 'index.php';
 
-// Invalid request by default
-$ref = 0;
-
-// Base URL for redirection
-switch (getConfig('refid_target')) {
-	case 'register':
-		$URL = 'modules.php?module=index&what=register&refid=';
-		break;
-
-	case 'index':
-		$URL = 'index.php?refid=';
-		break;
-} // END - switch
-
-// Get referal ID from ref or refid variable
-if (isGetRequestElementSet('ref'))        $ref = getRequestElement('ref');
- elseif (isGetRequestElementSet('refid')) $ref = getRequestElement('refid');
-
-if (!empty($ref)) {
+if (determineReferalId() > 0) {
 	// Test if nickname or numeric id
 	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__);
+		// Nickname in URL, so load the id
+		fetchUserData(determineReferalId(), 'nickname');
 
 		// Do we have an entry?
-		if (SQL_NUMROWS($result) == 1) {
+		if (isUserDataValid()) {
 			// Load userid
-			list($ref) = SQL_FETCHROW($result);
+			$GLOBALS['refid'] = getUserData('userid');
 		} 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__);
+			fetchUserData(determineReferalId());
 
 			// Do we have an entry?
-			if (SQL_NUMROWS($result2) == 0) {
+			if (!isUserDataValid()) {
 				// No entry, so no referal id
-				$ref = 0;
+				$GLOBALS['refid'] = getConfig('def_refid');
 			} // END - if
-
-			// Free result
-			SQL_FREERESULT($result2);
 		}
-
-		// Free result
-		SQL_FREERESULT($result);
 	} // END - if
 
-	// Also edit this 0 !
-	if (empty($ref)) $ref = 0;
-
 	// Update session
-	setSession('refid', $ref);
-
-	// We have an refid here. So we simply add it
-	$URL .= bigintval($ref);
+	setSession('refid', determineReferalId());
 
 	// Is the refid valid?
-	if ($ref > 0) {
+	if (determineReferalId() > 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__);
+			array(determineReferalId()), __FILE__, __LINE__);
+
+		// Base URL for redirection
+		switch (getConfig('refid_target')) {
+			case 'register':
+				$URL = 'modules.php?module=index&what=register';
+				break;
+
+			case 'index':
+				$URL = 'index.php';
+				break;
+		} // END - switch
 	} // END - if
 } // END - if