LCKB
[Release] PlayerCounter - Printable Version

+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Release Zone (https://lckb.dev/forum/forumdisplay.php?fid=190)
+---- Forum: Episode 1 Releases (https://lckb.dev/forum/forumdisplay.php?fid=191)
+----- Forum: Tools (https://lckb.dev/forum/forumdisplay.php?fid=163)
+----- Thread: [Release] PlayerCounter (/showthread.php?tid=204)



- fabi202cool - 10-03-2011


hey guys,

today i would like release my new tool.

It counts all online Players and displays her names and zone.

 

Screen:

 

The ODBC MySQL Driver is required, you can download it here: 2

 

Download: 2

 

Fabi




- Natzn - 10-08-2011


Hi Fabi,

 

I wanted to ask you, where in the DB the players "status" is saved, because I want to show up a Online-Players info in my own launcher.




- Sutz - 11-22-2011


Id like to know this also.

 

Never mind found a way.

 

$t_onlineusers = mysql_query("SELECT COUNT(1) FROM t_users WHERE a_zone_num -1");
$r_accounts = mysql_fetch_row($t_accounts);
$r_users = mysql_fetch_row($t_users);
$r_onlineusers = mysql_fetch_row($t_onlineusers);
$onlineusers = $r_onlineusers[0];

 

This works as if an account is offline the a_zone_num is -1 but when an account is online the a_zone_num is the chars zone.




- wowa296 - 03-11-2012

Nice Work