|
在过去,我已经看到了各种方法检查当前在线玩家人数,但我见过有一个致命的缺陷。根据服务器被关闭(或更确切地说,如果它崩溃)播放器的计数被搞砸了。下面是我在谈论一个: 5 J+ l2 U/ X% \" c' v
代码:
" o& c. K. D# w0 l+ f, o0 ]
" w" S0 u7 u4 ]8 a) N$mssql = mssql_query("SELECT * FROM [ACCOUNT_DBF].dbo.[ACCOUNT_TBL] WHERE isuse='J'");
% y) Q) K! I6 g' Q5 ]7 secho mssql_num_rows($mssql);, N, }6 E8 t6 v# c
这里有一个更正确的代码,它会自动复位计数,每当世界上的服务器程序打开当前在线:3 i1 l4 S7 S3 T, e2 Y3 O0 {
) B' N! G% L' \
代码:7 J! i0 Z E7 R- p1 z2 `8 |
$mssql = mssql_query("SELECT * FROM [CHARACTER_01_DBF].dbo.[CHARACTER_TBL] WHERE MultiServer!=0");8 ?$ q8 o" T1 s0 n T( V: d; R
echo mssql_num_rows($mssql);Credits to Sedrika for changing MultiServer=1 to Multiserver!=0
' y: n- m5 O% b4 L4 u( N/ o; W1 n: g" @6 n
Spikensbror的更快的方法:
& J/ q3 @1 H. r( {" i4 l% l2 y, {- m邮编:- ?0 |: r8 L# R6 ]- k
( B0 f! a) m0 K
$query = mssql_query('SELECT COUNT(*) as [CCU] FROM [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] WHERE [MultiServer] != 0;');
' ?" c% ^& A- k( R1 }6 u! e8 H$ccu = mssql_fetch_assoc($query);- D/ B i% H& d" v! n6 M& r
$ccu = $ccu['CCU'];
6 e m9 p; Z+ r4 o
0 s3 \ \6 \3 m; P) p: \1 ^. J5 I, B0 }6 G! D
# ?5 n* a- g; @
" k3 g; g3 }4 F, ~
|
|