X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fguest%2Fwhat-login.php;h=6035504fb80e6f0470f99f945b1965d267384e95;hb=001e43c93664d89ffc23aa4452aac8520279086d;hp=94a981ce74da2faf4cdd1cd45251bd013aa750e6;hpb=9d4126c3e4920a19b3a6120ffb739a8efed32537;p=mailer.git

diff --git a/inc/modules/guest/what-login.php b/inc/modules/guest/what-login.php
index 94a981ce74..6035504fb8 100644
--- a/inc/modules/guest/what-login.php
+++ b/inc/modules/guest/what-login.php
@@ -91,13 +91,13 @@ if (IS_MEMBER()) {
 	$password = ""; $uid2 = ""; $dmy = "";
 	if ($probe_nickname === true) {
 		// Nickname entered
-		$result = SQL_QUERY_ESC("SELECT userid, password, last_online".$LAST." FROM "._MYSQL_PREFIX."_user_data WHERE nickname='%s' AND status='CONFIRMED' LIMIT 1",
+		$result = SQL_QUERY_ESC("SELECT userid, password, last_online".$LAST." FROM `"._MYSQL_PREFIX."_user_data` WHERE nickname='%s' AND status='CONFIRMED' LIMIT 1",
 			array($uid), __FILE__, __LINE__);
 		list($uid2, $password, $online, $login) = SQL_FETCHROW($result);
 		if (!empty($uid2)) $uid = bigintval($uid2);
 	} else {
 		// Direct userid entered
-		$result = SQL_QUERY_ESC("SELECT userid, password, last_online".$LAST." FROM "._MYSQL_PREFIX."_user_data WHERE userid=%s AND status='CONFIRMED' LIMIT 1",
+		$result = SQL_QUERY_ESC("SELECT userid, password, last_online".$LAST." FROM `"._MYSQL_PREFIX."_user_data` WHERE userid=%s AND status='CONFIRMED' LIMIT 1",
 			array($uid, $hash), __FILE__, __LINE__);
 		list($uid2, $password, $online, $login) = SQL_FETCHROW($result);
 	}
@@ -124,7 +124,7 @@ if (IS_MEMBER()) {
 			$hash = generateHash($_POST['password']);
 
 			// ... and update database
-			SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET password='%s' WHERE userid=%s AND status='CONFIRMED' LIMIT 1",
+			SQL_QUERY_ESC("UPDATE `"._MYSQL_PREFIX."_user_data` SET password='%s' WHERE userid=%s AND status='CONFIRMED' LIMIT 1",
 				array($hash, $uid), __FILE__, __LINE__);
 
 			// No login bonus by default
@@ -133,15 +133,15 @@ if (IS_MEMBER()) {
 			// Probe for last online timemark
 			$probe = time() -  $online;
 			if (!empty($login)) $probe = time() - $login;
-			if ((GET_EXT_VERSION("bonus") >= "0.2.2") && ($probe >= $_CONFIG['login_timeout'])) {
+			if ((GET_EXT_VERSION("bonus") >= "0.2.2") && ($probe >= getConfig('login_timeout'))) {
 				// Add login bonus to user's account
 				$ADD = sprintf(", login_bonus=login_bonus+%s",
-					(float)$_CONFIG['login_bonus']
+					(float)getConfig('login_bonus')
 				);
 				$BONUS = true;
 
 				// Subtract login bonus from userid's account or jackpot
-				if ((GET_EXT_VERSION("bonus") >= "0.3.5") && ($_CONFIG['bonus_mode'] != "ADD")) BONUS_POINTS_HANDLER('login_bonus');
+				if ((GET_EXT_VERSION("bonus") >= "0.3.5") && (getConfig('bonus_mode') != "ADD")) BONUS_POINTS_HANDLER('login_bonus');
 			} // END - if
 
 			// Init variables
@@ -173,7 +173,7 @@ if (IS_MEMBER()) {
 
 			if ($login) {
 				// Update database records
-				$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET total_logins=total_logins+1".$ADD." WHERE userid=%s LIMIT 1",
+				$result = SQL_QUERY_ESC("UPDATE `"._MYSQL_PREFIX."_user_data` SET total_logins=total_logins+1".$ADD." WHERE userid=%s LIMIT 1",
 					array($uid), __FILE__, __LINE__);
 				if (SQL_AFFECTEDROWS() == 1) {
 					// Procedure to checking for login data
@@ -194,7 +194,7 @@ if (IS_MEMBER()) {
 			}
 		} elseif (GET_EXT_VERSION("sql_patches") >= "0.4.7") {
 			// Update failture counter
-			SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET login_failtures=login_failtures+1,last_failture=NOW() WHERE userid=%s LIMIT 1",
+			SQL_QUERY_ESC("UPDATE `"._MYSQL_PREFIX."_user_data` SET login_failtures=login_failtures+1,last_failture=NOW() WHERE userid=%s LIMIT 1",
 				array($uid), __FILE__, __LINE__);
 
 			// Wrong password!
@@ -202,7 +202,7 @@ if (IS_MEMBER()) {
 		}
 	} elseif ((($probe_nickname) && (!empty($uid2))) || ($uid2 == $uid)) {
 		// Other account status?
-		$result = SQL_QUERY_ESC("SELECT status FROM "._MYSQL_PREFIX."_user_data WHERE userid=%s LIMIT 1",
+		$result = SQL_QUERY_ESC("SELECT status FROM `"._MYSQL_PREFIX."_user_data` WHERE userid=%s LIMIT 1",
 			array($uid), __FILE__, __LINE__);
 
 		// Entry found?
@@ -245,11 +245,11 @@ if (IS_MEMBER()) {
 	$probe_nickname = ((EXT_IS_ACTIVE("nickname")) && (("".round($_POST['id'])."") != $_POST['id']));
 	if ($probe_nickname) {
 		// Nickname entered
-		$result = SQL_QUERY_ESC("SELECT userid, status FROM "._MYSQL_PREFIX."_user_data WHERE nickname='%s' OR email='%s' LIMIT 1",
+		$result = SQL_QUERY_ESC("SELECT userid, status FROM `"._MYSQL_PREFIX."_user_data` WHERE nickname='%s' OR email='%s' LIMIT 1",
 			array($uid, $_POST['email']), __FILE__, __LINE__);
 	} else {
 		// Direct userid entered
-		$result = SQL_QUERY_ESC("SELECT userid, status FROM "._MYSQL_PREFIX."_user_data WHERE userid=%s OR email='%s' LIMIT 1",
+		$result = SQL_QUERY_ESC("SELECT userid, status FROM `"._MYSQL_PREFIX."_user_data` WHERE userid=%s OR email='%s' LIMIT 1",
 			array(bigintval($uid), $_POST['email']), __FILE__, __LINE__);
 	}
 
@@ -261,7 +261,7 @@ if (IS_MEMBER()) {
 		if ($status == "CONFIRMED") {
 			// Ooppps, this was missing! ;-) We should update the database...
 			$NEW_PASS = GEN_PASS();
-			$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_user_data SET password='%s' WHERE userid=%s LIMIT 1",
+			$result = SQL_QUERY_ESC("UPDATE `"._MYSQL_PREFIX."_user_data` SET password='%s' WHERE userid=%s LIMIT 1",
 				array(generateHash($NEW_PASS), $uid), __FILE__, __LINE__);
 
 			// Prepare data and message for email