phpwcms Support Forum

Code: Select all

<?php
// AUTHOR: Jens Zetterström
// USAGE: {VTS_USERS_ONLINE}

// Define how long the maximum amount of time (in minutes) the session can be inactive.
define("MAX_IDLE_TIME", 3);

// get users online by looking at vts database tables
function vts_GetUsersOnline()
{
	$count = 0;
		
	$sql = sprintf(
							"SELECT COUNT(DISTINCT(accesslog.accesslog_id)) AS num_visitors_online
							FROM 	%s accesslog,
									%s visitors
							WHERE visitors.client_id    = '%d'
							AND visitors.accesslog_id = accesslog.accesslog_id
							AND accesslog.timestamp   >= '%d'",
							DB_PREPEND . "pot_accesslog",
							DB_PREPEND . "pot_visitors",
							1,
							time() - (MAX_IDLE_TIME * 60)
						);
		  
	$result = mysql_query($sql, $GLOBALS["db"]);
				
	if(mysql_num_rows($result) > 0)
	{
		$row = mysql_fetch_assoc($result);
		$count = intval($row['num_visitors_online']);
	}
	
	if($count == 0)
	{
		$count = 1;
	}

	return $count;
}

// {VTS_USERS_ONLINE}
// most article sorted by popularity
if( ! ( strpos($content["all"],'{VTS_USERS_ONLINE}')===false ) ) 
{
   $content["all"] = preg_replace('/\{VTS_USERS_ONLINE\}/e','vts_GetUsersOnline();', $content["all"]);
}
?>