X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=ref.php;h=4b34282a65e9fbc606c9057b698d6618fd81e609;hp=c9b37ece10ba3cb8f43d4730814a1b7d4fa28966;hb=27f65d023a3388a8bd85be8ee5991f776f541847;hpb=36a31ecf3137283ddd5d7aad121bacf3df54e2e1

diff --git a/ref.php b/ref.php
index c9b37ece10..4b34282a65 100644
--- a/ref.php
+++ b/ref.php
@@ -6,9 +6,9 @@
  * -------------------------------------------------------------------- *
  * File              : ref.php                                          *
  * -------------------------------------------------------------------- *
- * Short description : Redirection for the referral link                *
+ * Short description : Redirection for the referal link                 *
  * -------------------------------------------------------------------- *
- * Kurzbeschreibung  : Weiterleitungsscript fuer die Referral-Links     *
+ * Kurzbeschreibung  : Weiterleitungsscript fuer die Referal-Links      *
  * -------------------------------------------------------------------- *
  *                                                                      *
  * -------------------------------------------------------------------- *
@@ -42,12 +42,12 @@ $GLOBALS['what'] = ""; $GLOBALS['action'] = "";
 $GLOBALS['module'] = "ref"; $CSS = -1;
 
 // Load the required file(s)
-require ("inc/config.php");
+require("inc/config.php");
 
 // Redirect only to registration page when this script is installed
 if (isBooleanConstantAndTrue('mxchange_installed')) {
 	// Base URL for redirection
-	switch ($_CONFIG['refid_target'])
+	switch (getConfig('refid_target'))
 	{
 	case "register":
 		$URL = URL."/modules.php?module=index&what=register&refid=";
@@ -58,16 +58,16 @@ if (isBooleanConstantAndTrue('mxchange_installed')) {
 		break;
 	}
 
-	// Get referral ID from ref or refid variable
+	// Get referal ID from ref or refid variable
 	if (!empty($_GET['ref']))        $ref = secureString($_GET['ref']);
 	 elseif (!empty($_GET['refid'])) $ref = secureString($_GET['refid']);
 
 	if (!empty($ref)) {
 		// Test if nickname or numeric id
-		if ($ref != "".bigintval($ref)."") {
+		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",
+				$result = SQL_QUERY_ESC("SELECT userid FROM `"._MYSQL_PREFIX."_user_data` WHERE nickname='%s' LIMIT 1",
 					array($ref), __FILE__, __LINE__);
 
 				// Load userid
@@ -93,7 +93,7 @@ if (isBooleanConstantAndTrue('mxchange_installed')) {
 		// Is the refid valid?
 		if ($ref > 0) {
 			// Update ref counter
-			$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET ref_clicks=ref_clicks+1 WHERE userid=%s LIMIT 1",
+			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 {