X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fonline_functions.php;h=47ac57f03fe85680e70505840017a0db6d0889b5;hb=af71686cb6c6e59eee9c206b36342f7dd7164c1f;hp=7d1eb61339e95b7faec89c03b4371c98c7a259c4;hpb=5071030af40e69ca4284642f44758964e18f5be8;p=mailer.git

diff --git a/inc/libs/online_functions.php b/inc/libs/online_functions.php
index 7d1eb61339..47ac57f03f 100644
--- a/inc/libs/online_functions.php
+++ b/inc/libs/online_functions.php
@@ -74,58 +74,60 @@ function FILTER_UPDATE_ONLINE_LIST () {
 	} // END - if
 
 	// Now search for the user
-	$result = SQL_QUERY_ESC("SELECT timestamp FROM `{!_MYSQL_PREFIX!}_online` WHERE sid='%s' LIMIT 1",
+	$result = SQL_QUERY_ESC("SELECT `timestamp` FROM `{!_MYSQL_PREFIX!}_online` WHERE sid='%s' LIMIT 1",
 	array(session_id()), __FUNCTION__, __LINE__);
 
 	// Entry found?
 	if (SQL_NUMROWS($result) == 1) {
 		// Then update it
-		SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_online` SET
-`module`='%s',
-`action`='%s',
-`what`='%s',
-userid=%s,
-refid=%s,
-is_member='%s',
-is_admin='%s',
-timestamp=UNIX_TIMESTAMP(),
-ip='%s'
-WHERE sid='%s' LIMIT 1",
+		SQL_QUERY_ESC("UPDATE
+	`{!_MYSQL_PREFIX!}_online`
+SET
+	`module`='%s',
+	`action`='%s',
+	`what`='%s',
+	`userid`=%s,
+	`refid`=%s,
+	`is_member`='%s',
+	`is_admin`='%s',
+	`timestamp`=UNIX_TIMESTAMP(),
+	`ip`='%s'
+WHERE 
+	sid`='%s'
+LIMIT 1",
 		array(
-		$GLOBALS['module'],
-		$GLOBALS['action'],
-		$GLOBALS['what'],
-		$uid,
-		$rid,
-		$MEM,
-		$ADMIN,
-		detectRemoteAddr(),
-		session_id()
-		), __FUNCTION__, __LINE__
-		);
+			getModule(),
+			getAction(),
+			getWhat(),
+			$uid,
+			$rid,
+			$MEM,
+			$ADMIN,
+			detectRemoteAddr(),
+			session_id()
+		), __FUNCTION__, __LINE__);
 	} else {
 		// No entry does exists so we simply add it!
-		SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_online` (module, action, what, userid, refid, is_member, is_admin, timestamp, sid, ip) VALUES ('%s','%s','%s', %s, %s, '%s','%s', UNIX_TIMESTAMP(), '%s','%s')",
-		array(
-		$GLOBALS['module'],
-		$GLOBALS['action'],
-		$GLOBALS['what'],
-		$uid,
-		$rid,
-		$MEM,
-		$ADMIN,
-		session_id(),
-		detectRemoteAddr()
-		), __FUNCTION__, __LINE__
-		);
+		SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_online` (`module`, `action`, `what`, `userid`, `refid`, `is_member`, `is_admin`, `timestamp`, `sid`, `ip`) VALUES ('%s','%s','%s', %s, %s, '%s','%s', UNIX_TIMESTAMP(), '%s','%s')",
+			array(
+				getModule(),
+				getAction(),
+				getWhat(),
+				$uid,
+				$rid,
+				$MEM,
+				$ADMIN,
+				session_id(),
+				detectRemoteAddr()
+			), __FUNCTION__, __LINE__);
 	}
 
 	// Free result
 	SQL_FREERESULT($result);
 
 	// Purge old entries
-	SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_online` WHERE timestamp <= (UNIX_TIMESTAMP() - %s)",
-	array(getConfig('online_timeout')), __FUNCTION__, __LINE__);
+	SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_online` WHERE `timestamp` <= (UNIX_TIMESTAMP() - %s)",
+		array(getConfig('online_timeout')), __FUNCTION__, __LINE__);
 }
 
 //