Re: main menu users online count
I just added this to my game
<th style='border: 1px solid '><font color='Black'>[b]Users Online[/b]</font></th>
</tr>
<tr>
<td style='border: 1px solid '>";
$q = mysql_query("SELECT * FROM users WHERE laston>(unix_timestamp()-15*60) AND user_level=1 ORDER BY userid ASC",
$c);
while ($r = mysql_fetch_array($q))
{
$la = time() - $r['laston'];
$unit = "secs";
if ($la >= 60)
{
$la = (int)($la / 60);
$unit = "mins";
}
if ($la >= 60)
{
$la = (int)($la / 60);
$unit = "hours";
if ($la >= 24)
{
$la = (int)($la / 24);
$unit = "days";
}
}
print "[*][url='viewuser.php?u={$r[']<font color=black>{$r['username']}[/url] ($la $unit)";
}
}