All pastes #615391 Raw Edit

Anonymous

public php v1 · immutable
·published 2007-07-12 03:13 UTC
rendered paste body
<?	echo("<p>");	$offline = 1800; //5 minutes	$current = time(); //gets the current time	$offline = ($current-$offline); //the cutoff time for being considered online	$guests = mysql_query("select * from `guests` where online >= '$offline'");	$getusers = mysql_query("SELECT username, page from users where online >= '$offline' and hidden = '0'");	if(mysql_num_rows($guests) >=1)	{		print mysql_num_rows($guests);		print " Guests";		if(mysql_num_rows($getusers) >= 1)		{			echo(", ");		}	}	$getusers = mysql_query("SELECT username, page from users where online >= '$offline' and hidden = '0'");	$num_u = mysql_num_rows($getusers);	$n = "1";	while ($users = mysql_fetch_array($getusers))	{		if($users[username] == "Naresh")		{			$title = "Hidden! :P";		}else{			$title = "Last seen on $users[page]";		}		if($users[page] == "/")		{			$title = "Homepage";		}				echo ("<a href=\"$settings[url]/profile/$users[username]\" title=\"$title\" style=\"color:#fefefe;\">$users[username]</a>");		if($n != $num_u)		{			echo(", ");		}		$n++;	} ?>