公会得主显示脚本

admin

Lord Winner:

% d% X0 A* ?, x( Z0 r3 j$ J3 _2 {
PHP Code:
<?php
mssql_select_db ( "CHARACTER_01_DBF" );
7 s/ U/ Y  V8 t0 V$ I: W$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" ));
. q  u. m2 C: M5 Z/ rif ( $lord [ 'm_szName' ] != "" )
echo $lord ;
else
/ ?1 y) G/ G' D6 cecho "-" ;
?>
MVP:


4 u1 S: b7 l# K, L+ w8 z; W% n
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" ));
7 o. i% ?- G& Z4 e* vif ( $mvp [ 'm_szName' ] != "" )
echo $mvp [ m_szName ];
else
# I) o. B) M5 `- o- [; Necho "-" ;
?>
Guild Winner:

' t  _' P) I% m- T$ y$ i
6 ~" q' N* \4 C+ j* s( H2 u8 D5 I
PHP Code:
# g& w! U8 P$ M6 H<?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" ));
/ Q4 Q, A0 d. Z2 D1 yif ( $crown [ 'm_szGuild' ] != "" )
echo $crown [ m_szGuild ];
else
& q% G) p1 _2 \' R6 b1 _echo "-" ;
2 Q* ^; V: i/ @?>
! ?, U1 L% F4 z' E; s) I& j3 d8 wDon't forget to like it.. Of course if it helps...

: Z' r3 n' l$ r/ k9 z! J