公会得主显示脚本

admin

Lord Winner:
) X& I: _" ~: L, G( [! _
! s) d, K$ ?0 Q4 f2 \; b
9 x5 v' x: d" _# Z, Q9 Z5 [) cPHP Code:
& T0 ^% O* U0 N<?php
5 C$ R2 d# Q0 m8 @& ^, I. Rmssql_select_db ( "CHARACTER_01_DBF" );
$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" ));
if ( $lord [ 'm_szName' ] != "" )
; ^; B4 y& @7 p7 d5 J! H' L# R" Techo $lord ;
: c( [0 ?: H. v/ |- |8 Selse
5 p2 m' L4 L: x% A4 V; Secho "-" ;
( ^. ?1 U3 m% N3 u, c?>
0 G/ b% ^* F$ L, _* qMVP:
) `4 }4 K+ }( F& Y' F2 ?' }; l
5 K( [1 W5 G7 |. h" i" y
* r9 l( p9 J7 T. `, U  z4 p
PHP Code:
<?php
$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" ));
if ( $mvp [ 'm_szName' ] != "" )
echo $mvp [ m_szName ];
4 Q8 G& \2 W0 R: T; felse
echo "-" ;
) a" n; a9 y, s: W?>
8 `0 X9 L/ ?0 L4 SGuild Winner:
  Z) V6 Y- Y- J7 C  T

+ W4 e0 O+ z' ~6 g( ?
PHP Code:
<?php
$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" ));
. P. p7 {5 X0 `: H8 U  z; cif ( $crown [ 'm_szGuild' ] != "" )
echo $crown [ m_szGuild ];
( n9 X4 K' v3 i2 K, |& celse
echo "-" ;
?>
& H, c6 K# _5 _# _: z9 |( h& gDon't forget to like it.. Of course if it helps...