[Release] Accounts Online Statistic

[zybex]

I'm write Accounts online statistic for WebPage.
Simply add sql query, attached in message to GunzDB. It's create new table "UsersOnline" and update Stored Procedures "spUpdateAccountLastLogoutTime" and "spUpdateLastConnDate".
In php script paste something like this:

$query = mssql_query("SELECT UserID FROM UsersOnline ORDER by UserID");
$UsersOnline="";
while($row = mssql_fetch_assoc($query)) {
    $UsersOnline.=$row[UserID]."<BR>";
}
echo $UsersOnline; 

One thing: when server restart you need clear table "UsersOnline".

[MentaL]

[Kingston]

Very Very Nice.

[Psylithium]

Nice one.

[Kreain]

umm way too easy and its better to use a timestamp style thing

[umegliu]

how to install? :scratch:

[bounty-hunter]

Im working on a custom GunZ site, how do i use it >.> (i suck at sql =[)