|
在过去,我已经看到了各种方法检查当前在线玩家人数,但我见过有一个致命的缺陷。根据服务器被关闭(或更确切地说,如果它崩溃)播放器的计数被搞砸了。下面是我在谈论一个: 4 Z; C( e) {% l2 i; L8 I
代码:$ x8 D( W! R5 [0 e% e7 A% S8 F8 y( b7 e
+ w/ p3 I+ }0 ~- F( O' n6 I8 c$mssql = mssql_query("SELECT * FROM [ACCOUNT_DBF].dbo.[ACCOUNT_TBL] WHERE isuse='J'");
' S# g& i: s; t) f4 {1 decho mssql_num_rows($mssql);
5 b1 c$ K+ L- I4 K这里有一个更正确的代码,它会自动复位计数,每当世界上的服务器程序打开当前在线:, q3 L0 k% y# X% @7 q6 n6 w
+ S9 j) o: D$ P: | f3 B
代码:
* V9 a6 ?/ }- `) H6 b$mssql = mssql_query("SELECT * FROM [CHARACTER_01_DBF].dbo.[CHARACTER_TBL] WHERE MultiServer!=0");
% ~6 c% C' X/ A6 j$ ?3 ~7 q4 H# U9 hecho mssql_num_rows($mssql);Credits to Sedrika for changing MultiServer=1 to Multiserver!=01 U7 [" H6 d0 H/ @9 a5 f# h0 s
1 T+ B) \1 I! J# K
Spikensbror的更快的方法: / g) d3 X7 ?0 m: ]
邮编:
% J$ K7 o; ^# O6 n" u( r: i! ^! b9 C5 v
$query = mssql_query('SELECT COUNT(*) as [CCU] FROM [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] WHERE [MultiServer] != 0;');5 Z H. s8 e9 Z: v3 e; E
$ccu = mssql_fetch_assoc($query);& }6 j5 V( n3 |# i: d
$ccu = $ccu['CCU'];
1 O9 ~! b4 K* a, V
' Y) l* x# A [7 [
& T5 q8 f- K$ l0 ~* A% }, o% B; h. w) y( f! K# t1 D
% M; d6 v4 p( t+ M! i
|
|