|
在过去,我已经看到了各种方法检查当前在线玩家人数,但我见过有一个致命的缺陷。根据服务器被关闭(或更确切地说,如果它崩溃)播放器的计数被搞砸了。下面是我在谈论一个: # ~8 a3 ]( ^3 |( g' V
代码:: K" [% a1 Z5 J" @7 G
' X* _! i, d8 H/ Y4 j ^$mssql = mssql_query("SELECT * FROM [ACCOUNT_DBF].dbo.[ACCOUNT_TBL] WHERE isuse='J'");" A& @" ?' S# k7 r: s
echo mssql_num_rows($mssql);2 M# L' Z6 x% g c# Z( {
这里有一个更正确的代码,它会自动复位计数,每当世界上的服务器程序打开当前在线:5 T2 B3 r" ^2 }
1 N3 X! o. j- M1 {! w( [
代码:
$ |- {; @0 ~$ F/ [; Q; o$mssql = mssql_query("SELECT * FROM [CHARACTER_01_DBF].dbo.[CHARACTER_TBL] WHERE MultiServer!=0");% q" {9 f- ]2 y( ^7 D5 u
echo mssql_num_rows($mssql);Credits to Sedrika for changing MultiServer=1 to Multiserver!=0
2 S# a$ W- i) r0 z" n1 G/ _# h( }( o* `: n9 z
Spikensbror的更快的方法:
7 `- r! O' D% e- {. j! s5 I邮编:
% A+ k# Y! H8 ^- g6 G
# ~! g( d- Y/ y4 S' T0 D$query = mssql_query('SELECT COUNT(*) as [CCU] FROM [CHARACTER_01_DBF].[dbo].[CHARACTER_TBL] WHERE [MultiServer] != 0;');
( I+ _% {1 o5 u0 U( U$ccu = mssql_fetch_assoc($query);
. b3 |- H) k3 F3 l! V) o1 e" @$ccu = $ccu['CCU'];! `% P/ b# P& C8 n
8 @, ^* Y0 N( m" e. l9 e
9 r3 ~, C& }( |# s$ U3 T
4 x+ ^8 R: T8 F* z
' E# d9 l; r' h |
|