公会得主显示脚本

admin

Lord Winner:


PHP Code:
<?php
mssql_select_db ( "CHARACTER_01_DBF" );
6 r' u  T. Z4 y  p9 N5 V0 C$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' ] != "" )
echo $lord ;
else
+ y& l; h4 T4 U2 j* Decho "-" ;
?>
7 V+ A  l% ^- l* Q6 E; `1 [MVP:



PHP Code:
0 d4 U. J: Z' `<?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" ));
. V% k$ ^2 Q0 t; }3 ]1 Qif ( $mvp [ 'm_szName' ] != "" )
echo $mvp [ m_szName ];
' E2 x$ g8 x5 k) Z4 X4 b" r5 Qelse
echo "-" ;
8 D6 J4 X8 q2 m( L' {3 z?>
8 |8 I: `3 Y; q' e3 [Guild Winner:
: V& q% d/ x& [1 D) j$ ~
' G2 I6 H) m: k; ^! t  d

0 Y& i0 {2 \! X. bPHP Code:
/ A  |3 Q6 e- ?7 _<?php
, `, w) s+ q; v3 [3 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" ));
if ( $crown [ 'm_szGuild' ] != "" )
' V$ d: r$ u% S. b4 Uecho $crown [ m_szGuild ];
' I# R6 B  F1 _! [7 e) x# Telse
2 _/ @. w0 b# p% z+ v$ [1 s" uecho "-" ;
/ R9 S) f+ I1 w% B?>
. ^% W) L5 z- Q0 {0 QDon't forget to like it.. Of course if it helps...
6 n' m) q' b4 m; G  @
1 m' Z7 ^9 n0 j8 c, T# W) n