|
|
在过去,我已经看到了各种方法检查当前在线玩家人数,但我见过有一个致命的缺陷。根据服务器被关闭(或更确切地说,如果它崩溃)播放器的计数被搞砸了。下面是我在谈论一个:
- c, X8 f3 Q9 l# s$ l1 d+ J! `% L代码:1 y, t( Z" k+ K2 _! I
. N- j8 S9 m+ X! S# n% y+ c' B
$mssql = mssql_query("SELECT * FROM [ACCOUNT_DBF].dbo.[ACCOUNT_TBL] WHERE isuse='J'");
4 B; `* e0 L0 Q K# q! A* o8 decho mssql_num_rows($mssql);
5 ^3 J. x7 g; ^; T这里有一个更正确的代码,它会自动复位计数,每当世界上的服务器程序打开当前在线:, p% [6 X# Y; x% p
4 F% e8 x% F# {3 ~) K8 d1 ~/ z" ?: i
代码:% c% t f, I# P" [
$mssql = mssql_query("SELECT * FROM [CHARACTER_01_DBF].dbo.[CHARACTER_TBL] WHERE MultiServer!=0");
: {- {5 \" ^/ s' g; Mecho mssql_num_rows($mssql);Credits to Sedrika for changing MultiServer=1 to Multiserver!=0
1 {$ s" t' h# _4 d6 l/ q) F9 P3 z2 U+ `: g: N
Spikensbror的更快的方法:
' s+ s. g8 \& u9 |& p) V2 _6 I7 P1 \+ L邮编:
$ T' T8 F6 j7 d; `% z4 g% _, o& A. r! ]) V4 K# c+ M" D$ J
$query = mssql_query('SELECT COUNT(*) as [CCU] FROM [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] WHERE [MultiServer] != 0;');( p3 P1 l# d, [# v
$ccu = mssql_fetch_assoc($query);- a) H6 F( Q" _& n1 C/ p2 s
$ccu = $ccu['CCU'];) t( _. F/ H2 w1 {1 i9 Z
. M% J( {* A5 z& J V# m3 a& H1 {6 t: S2 c9 g* }
( [# f* Z5 U6 i Z# f4 c7 J* o
9 C" j- m9 M1 ^0 d$ S |
|