|
|
在过去,我已经看到了各种方法检查当前在线玩家人数,但我见过有一个致命的缺陷。根据服务器被关闭(或更确切地说,如果它崩溃)播放器的计数被搞砸了。下面是我在谈论一个: \( W1 Z9 x6 _; U) f7 Y
代码:* D9 B0 v* n* t3 M( K6 [/ I
1 \/ j3 r9 N5 L T# r
$mssql = mssql_query("SELECT * FROM [ACCOUNT_DBF].dbo.[ACCOUNT_TBL] WHERE isuse='J'");$ z8 Y# {! i" g$ D$ t6 I0 O+ g- Y
echo mssql_num_rows($mssql);- f" [! A+ } l1 Q
这里有一个更正确的代码,它会自动复位计数,每当世界上的服务器程序打开当前在线:
0 l" m- v2 \# S; k9 b5 U. z5 Z! @# |9 f% d: i
代码:
8 L9 W) F) v1 c$mssql = mssql_query("SELECT * FROM [CHARACTER_01_DBF].dbo.[CHARACTER_TBL] WHERE MultiServer!=0");
' f+ N$ a7 U' _$ U/ j9 Gecho mssql_num_rows($mssql);Credits to Sedrika for changing MultiServer=1 to Multiserver!=0
# g, H0 Q6 i( c x- a
+ X7 p' M8 ~- p5 T, |; JSpikensbror的更快的方法:
( r2 |. o! c+ Y% @' r. W邮编:
. P: C0 B; {9 c7 c4 Q. p- Q7 E- g" @2 I1 Y$ P
$query = mssql_query('SELECT COUNT(*) as [CCU] FROM [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] WHERE [MultiServer] != 0;');
0 H9 F5 U3 ~0 z$ _ Q3 X9 A: S3 A$ccu = mssql_fetch_assoc($query);
" L' N6 c" r$ n2 {3 x) ^$ccu = $ccu['CCU'];7 R S+ u+ Y4 `2 k' c
4 X5 |- _, M' L4 G2 I) @& y; |9 i8 W" i& t! Y% |. @4 ^
' f0 Z, w' l" c; g/ N' b- I6 N. B1 {
|
|