飞飞世界论坛
标题:
公会得主显示脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:23
标题:
公会得主显示脚本
Lord Winner:
( r4 Z5 U, w, V$ I
7 P1 E/ F4 ^7 k1 w
2 m6 U) _3 y. Q
PHP Code:
) U$ [8 P# Q- S5 C: u
<?php
0 v6 F9 T. B, B% P1 X
mssql_select_db ( "CHARACTER_01_DBF" );
+ N& A% h" a& ?/ H% N) D: Q: s3 Z
$lord = mssql_fetch_array ( mssql_query ( "SELECT TOP 1 m_szName FROM tblLord a LEFT JOIN CHARACTER_TBL b ON RIGHT('0000000' + CONVERT(VARCHAR(7),a.idLord),7)= b.m_idPlayer ORDER BY s_date DESC" ));
/ o2 r* M( J d' @* ~5 }
if ( $lord [ 'm_szName' ] != "" )
1 a7 K9 T+ C9 i
echo $lord ;
- }+ Q, E$ D$ O; `# V: o0 P
else
6 k, Z% |* F( r0 V1 s
echo "-" ;
, s' Y+ I- ~. O* ^$ a( @
?>
8 u4 `6 @- r% ~
MVP:
. z% P; C) ?4 |3 _
$ I8 t9 Z! f5 t" k4 r8 r1 Y1 n
/ v: H& e2 @0 o' ~9 e% Y; r i. N `
- L& F* z) ]' F5 O
PHP Code:
0 t7 }3 o+ O# t" I- }3 F# b p
<?php
) ~9 P+ y$ K/ f: j K
$mvp = mssql_fetch_array ( mssql_query ( "SELECT TOP 1 m_szName FROM tblCombatJoinPlayer JP LEFT JOIN tblCombatInfo CI ON JP.CombatID = CI.CombatID LEFT JOIN CHARACTER_TBL C ON JP.PlayerID = C.m_idPlayer WHERE CI.[Status] = '30' ORDER BY JP.CombatID DESC, Point DESC" ));
$ b4 J* d6 @" p( _4 _
if ( $mvp [ 'm_szName' ] != "" )
8 B0 W0 j8 m; w' v7 X+ f7 L& o; H" D
echo $mvp [ m_szName ];
: i( `; j9 Z; Y( U/ S' w" V) g' B
else
* ]" E7 G3 }' w
echo "-" ;
) J/ L' P: O7 Y% M3 M' F( d+ o& l+ k
?>
5 x% O; G1 s' b: j8 s
Guild Winner:
2 j/ X7 f0 I1 C+ M2 m* e; [
, R* d1 w6 Z6 p: t- x; y
8 O/ v' i3 f y2 `7 Y
" Q, N* s; _$ t( {" B9 F
PHP Code:
+ [* p6 E% t( w/ k, i8 K0 Z
<?php
0 z l$ u d& q) o! }! f
$crown = mssql_fetch_array ( mssql_query ( "SELECT TOP 1 m_szGuild FROM tblCombatJoinGuild JG LEFT JOIN tblCombatInfo CI ON JG.CombatID = CI.CombatID LEFT JOIN GUILD_TBL G ON JG.GuildID = G.m_idGuild WHERE CI.[Status] = '30' ORDER BY JG.CombatID DESC, Point DESC" ));
0 N) g5 b0 o1 M! ?8 d7 f
if ( $crown [ 'm_szGuild' ] != "" )
9 c% Q" Z2 _# R+ b/ I
echo $crown [ m_szGuild ];
2 G) Q+ X0 l+ ]# w
else
" d* D, r8 G$ s* c6 A
echo "-" ;
$ r: s" i3 z1 V [% A/ s
?>
) n: q$ Y$ u" x5 F
Don't forget to like it.. Of course if it helps...
$ F* G2 d* Z8 `+ q
4 y1 Q( r q) |2 V( o8 ]* x8 M7 B0 I" A
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2