|
在过去,我已经看到了各种方法检查当前在线玩家人数,但我见过有一个致命的缺陷。根据服务器被关闭(或更确切地说,如果它崩溃)播放器的计数被搞砸了。下面是我在谈论一个: # t* l, B5 V2 j$ P
代码:9 [8 P( e, x# \& w
- V/ W7 M( T {* s# f% X T4 T/ e
$mssql = mssql_query("SELECT * FROM [ACCOUNT_DBF].dbo.[ACCOUNT_TBL] WHERE isuse='J'");/ k) L7 D3 a4 m+ ^+ s4 c$ x1 R
echo mssql_num_rows($mssql);
9 s8 \: B; m I( q: @! R7 ~- v这里有一个更正确的代码,它会自动复位计数,每当世界上的服务器程序打开当前在线:
/ }: J+ }+ a9 Z: r/ U
$ ^, o, n6 ^( n% v- L4 [代码:
% Y" S: n1 U( K$mssql = mssql_query("SELECT * FROM [CHARACTER_01_DBF].dbo.[CHARACTER_TBL] WHERE MultiServer!=0");" \. O2 ]4 V$ o6 @" ~2 h
echo mssql_num_rows($mssql);Credits to Sedrika for changing MultiServer=1 to Multiserver!=0
9 z; d9 T2 X' x6 R0 O7 h+ U- ?
; R' Z4 |) H$ {0 h, P+ ]! ]Spikensbror的更快的方法:
6 t. M v' x0 v2 Z) ^9 J邮编:
; _' O7 h7 [ B" \2 P
# |$ \, B; e T% c' O u$query = mssql_query('SELECT COUNT(*) as [CCU] FROM [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] WHERE [MultiServer] != 0;');. N2 f( h8 d' M N1 l; i
$ccu = mssql_fetch_assoc($query);
+ c. B0 d& f- `6 G& R$ccu = $ccu['CCU'];$ }' I$ V6 T6 i" t2 h
0 t# m" D2 ]( T _% v/ |( V
3 `+ y; |0 G, g. o$ k2 }3 Z: U7 E& l H r0 N3 U8 D
, c: [! A4 n2 o# `9 Z |
|