|
|
在过去,我已经看到了各种方法检查当前在线玩家人数,但我见过有一个致命的缺陷。根据服务器被关闭(或更确切地说,如果它崩溃)播放器的计数被搞砸了。下面是我在谈论一个: & D. V. R0 a$ ^4 j
代码:0 X& ^5 s9 g8 {0 O
% R4 u" r7 F( N x0 N
$mssql = mssql_query("SELECT * FROM [ACCOUNT_DBF].dbo.[ACCOUNT_TBL] WHERE isuse='J'");
% A+ l" i; C- m* U8 Q5 F' q5 eecho mssql_num_rows($mssql);
+ G3 J( X. A0 B这里有一个更正确的代码,它会自动复位计数,每当世界上的服务器程序打开当前在线:
3 x3 K. A# ?& a' M n8 h$ v {2 W& I8 |& N1 N+ E- ~
代码:
1 u. Q' T0 P; l$mssql = mssql_query("SELECT * FROM [CHARACTER_01_DBF].dbo.[CHARACTER_TBL] WHERE MultiServer!=0");1 F3 }+ I+ M* z2 ~1 I
echo mssql_num_rows($mssql);Credits to Sedrika for changing MultiServer=1 to Multiserver!=03 @2 d& r4 T( n9 o+ F$ a
, j4 f! p( l/ F7 q$ U4 [$ g, \
Spikensbror的更快的方法: 9 t5 y6 c- Q H7 I
邮编:5 R9 t5 Q# F4 R+ f) T" Q- O+ j
1 G' g7 k# q5 d) R- r h7 I
$query = mssql_query('SELECT COUNT(*) as [CCU] FROM [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] WHERE [MultiServer] != 0;');. J4 W c# V% z* z7 f/ {. h
$ccu = mssql_fetch_assoc($query);
$ c9 Z! z5 e7 r* H+ V- _: M$ccu = $ccu['CCU'];
1 Q8 s& A! l: X; A
3 ]2 m' C' g! _
1 _1 z- N3 Q* Q. X2 u, [, F7 _0 B* J$ @8 z" O
; r2 c4 I% V3 b z |
|