X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Ffilter%2Fonline_filter.php;h=81bcb1f656f7ca06dec84285db39e2e60f7140f5;hb=0dd76819236495cb7cfe97d8152700b895261eea;hp=710e76d92137df2b57a122d9fa5e7873d19212ec;hpb=0f3a135204757cc8750262871c8e62c42300acb4;p=mailer.git

diff --git a/inc/filter/online_filter.php b/inc/filter/online_filter.php
index 710e76d921..81bcb1f656 100644
--- a/inc/filter/online_filter.php
+++ b/inc/filter/online_filter.php
@@ -16,8 +16,8 @@
  * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009 - 2011 by Mailer Developer Team                   *
- * For more information visit: http://www.mxchange.org                  *
+ * Copyright (c) 2009 - 2013 by Mailer Developer Team                   *
+ * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
  * it under the terms of the GNU General Public License as published by *
@@ -44,22 +44,23 @@ if (!defined('__SECURITY')) {
 function FILTER_UPDATE_ONLINE_LIST ($filterData) {
 	// Do not update online list when extension is deactivated
 	//* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Called!');
-	if (!isExtensionActive('online', true)) {
+	if (!isExtensionActive('online')) {
 		// Extension not active
-		return;
+		/* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Extension ext-online is not active.');
+		return $filterData;
 	} // END - if
 
 	// Empty session?
-	if (session_id() == '') {
+	if (!isValidSession()) {
 		// This is invalid here!
-		debug_report_bug(__FUNCTION__, __LINE__, 'Invalid session.');
+		reportBug(__FUNCTION__, __LINE__, 'Invalid session.');
 	} // END - if
 
 	// Initialize variables
 	$userid   = NULL;
 	$isMember = convertBooleanToYesNo(isMember());
 	$isAdmin  = convertBooleanToYesNo(isAdmin());
-	$action   = getActionFromModuleWhat(getModule(), getWhat());
+	$action   = getActionFromModuleWhat(getModule(), getWhat(FALSE));
 
 	// Valid userid?
 	if (isMember()) {
@@ -68,13 +69,13 @@ function FILTER_UPDATE_ONLINE_LIST ($filterData) {
 	} // END - if
 
 	// Now search for the user
-	$result = SQL_QUERY_ESC("SELECT `timestamp` FROM `{?_MYSQL_PREFIX?}_online` WHERE `sid`='%s' LIMIT 1",
+	$result = sqlQueryEscaped("SELECT `timestamp` FROM `{?_MYSQL_PREFIX?}_online` WHERE `sid`='%s' LIMIT 1",
 		array(session_id()), __FUNCTION__, __LINE__);
 
 	// Entry found?
-	if (SQL_NUMROWS($result) == 1) {
+	if (sqlNumRows($result) == 1) {
 		// Then update it
-		SQL_QUERY_ESC("UPDATE
+		sqlQueryEscaped("UPDATE
 	`{?_MYSQL_PREFIX?}_online`
 SET
 	`module`='%s',
@@ -86,15 +87,15 @@ SET
 	`is_admin`='%s',
 	`timestamp`=UNIX_TIMESTAMP(),
 	`ip`='%s'
-WHERE 
+WHERE
 	`sid`='%s'
 LIMIT 1",
 		array(
 			getModule(),
 			$action,
-			getWhat(),
-			makeZeroToNull($userid),
-			makeZeroToNull(determineReferalId()),
+			getWhat(FALSE),
+			convertZeroToNull($userid),
+			convertZeroToNull(determineReferralId()),
 			$isMember,
 			$isAdmin,
 			detectRemoteAddr(),
@@ -102,13 +103,13 @@ LIMIT 1",
 		), __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')",
+		sqlQueryEscaped("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(),
 				$action,
-				getWhat(),
-				makeZeroToNull($userid),
-				makeZeroToNull(determineReferalId()),
+				getWhat(FALSE),
+				convertZeroToNull($userid),
+				convertZeroToNull(determineReferralId()),
 				$isMember,
 				$isAdmin,
 				session_id(),
@@ -117,10 +118,10 @@ LIMIT 1",
 	}
 
 	// Free result
-	SQL_FREERESULT($result);
+	sqlFreeResult($result);
 
 	// Purge old entries
-	SQL_QUERY('DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_online` WHERE (UNIX_TIMESTAMP() - `timestamp`) >= {?online_timeout?}', __FUNCTION__, __LINE__);
+	sqlQuery('DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_online` WHERE (UNIX_TIMESTAMP() - `timestamp`) >= {?online_timeout?}', __FUNCTION__, __LINE__);
 
 	// Return data
 	//* DEBUG: */ logDebugMessage(__FUNCTION__, __LINE__, 'Done!');