|
在过去,我已经看到了各种方法检查当前在线玩家人数,但我见过有一个致命的缺陷。根据服务器被关闭(或更确切地说,如果它崩溃)播放器的计数被搞砸了。下面是我在谈论一个: - \# X |. f( U. G
代码:
* |, `6 P3 Q6 I+ U- ~
( N, x8 H+ Y# I' ?) Y9 P9 I1 A) ]$mssql = mssql_query("SELECT * FROM [ACCOUNT_DBF].dbo.[ACCOUNT_TBL] WHERE isuse='J'");
4 u) ^( s5 W0 decho mssql_num_rows($mssql);
. l8 k9 _/ o& \- b ~0 P这里有一个更正确的代码,它会自动复位计数,每当世界上的服务器程序打开当前在线:
# d" q- g9 m0 \7 s# z3 ], k- u3 H" d7 q8 Q3 k
代码: n- D' V- |+ Z) E4 R& T7 T" y& g
$mssql = mssql_query("SELECT * FROM [CHARACTER_01_DBF].dbo.[CHARACTER_TBL] WHERE MultiServer!=0");( n* l! v+ @1 t' `3 U r8 N# j
echo mssql_num_rows($mssql);Credits to Sedrika for changing MultiServer=1 to Multiserver!=0
1 j; h" @$ m9 K3 z& F9 i7 s3 K8 H* V5 e" e
Spikensbror的更快的方法:
F, q& @* B- n: X$ D7 _邮编:4 O/ m& F2 z4 |+ f( D
. ?2 z7 j' Q- J3 [" x6 k$query = mssql_query('SELECT COUNT(*) as [CCU] FROM [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] WHERE [MultiServer] != 0;');# `5 b/ [( Z* G+ O8 Q: ~4 c/ F
$ccu = mssql_fetch_assoc($query);
' [6 N, ]( A& q2 B$ccu = $ccu['CCU'];8 A2 P' e K/ o' b+ |, X) M
3 V# }; Z' T7 m2 h R' y! \
0 B$ Q( n) H! K3 H* L
( H+ u2 ?/ k3 _: e) G* K5 `- L! \5 C6 `8 a L4 e) p
|
|