|
在过去,我已经看到了各种方法检查当前在线玩家人数,但我见过有一个致命的缺陷。根据服务器被关闭(或更确切地说,如果它崩溃)播放器的计数被搞砸了。下面是我在谈论一个:
7 E/ d# K9 m1 r代码:
* U7 y( s* ?+ b4 i& U x0 {+ @/ b6 b2 z0 x6 A- Z; [
$mssql = mssql_query("SELECT * FROM [ACCOUNT_DBF].dbo.[ACCOUNT_TBL] WHERE isuse='J'");
, v$ g% h' G x" ^2 y, f) k# Decho mssql_num_rows($mssql);% N8 L% R `) T! R& b4 a$ T; [
这里有一个更正确的代码,它会自动复位计数,每当世界上的服务器程序打开当前在线:2 T" ]5 ~2 `' H
$ l. P5 e" _% P e: z/ Y, A) s
代码:
) h( y i O' r% S- }5 ]$mssql = mssql_query("SELECT * FROM [CHARACTER_01_DBF].dbo.[CHARACTER_TBL] WHERE MultiServer!=0");
: k1 x0 H& I6 h) E6 @: ]echo mssql_num_rows($mssql);Credits to Sedrika for changing MultiServer=1 to Multiserver!=0
! p% o4 G7 k/ l' t0 R
7 |! B; b7 z0 uSpikensbror的更快的方法: " v. r6 G3 C# n: Q- l1 y. w( D
邮编:
" G2 Y% e l4 o
/ P: ]- ^1 y k& }. g4 ^9 z, p$query = mssql_query('SELECT COUNT(*) as [CCU] FROM [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] WHERE [MultiServer] != 0;');
7 M9 t. D$ P% i; p, I$ccu = mssql_fetch_assoc($query);% |: b" O$ @* @& a5 p: p; H5 g }
$ccu = $ccu['CCU'];6 d* l# @( c8 C9 R; W; p. m% B
( S, A! C* u6 l1 E* h* z4 o u6 K0 N* m7 r o7 j
: Y! g$ T) R5 f n+ d' G/ P: v5 i* u" c4 W, c$ Y
|
|