|
In the past I've seen various ways of checking the current number of online players, but all that I've seen have a fatal flaw. Depending on how the server was turned off (or more specifically, if it crashes) the player count gets messed up. Here's the one I'm talking about:: W: B/ B0 W( `" a$ _+ Y9 u) I9 U! B' q
Code:
! y- W& T h+ J6 A/ ?8 M$mssql = mssql_query("SELECT * FROM [ACCOUNT_DBF].dbo.[ACCOUNT_TBL] WHERE isuse='J'");* Q' }, b: U, W9 v% N7 D2 w
echo mssql_num_rows($mssql);Here's a more proper code, which will automatically reset the current online count whenever the world server program is opened:- _! _, Y( c* p, U
Code:
) S& k9 n. I) ?$mssql = mssql_query("SELECT * FROM [CHARACTER_01_DBF].dbo.[CHARACTER_TBL] WHERE MultiServer='1'");, _: U2 L8 \6 L" ?! P
echo mssql_num_rows($mssql);9 t( [* s9 \, ~: L/ |' [
) z1 Y2 B: e/ |4 u4 k |
|