公会得主显示脚本

admin

Lord Winner:


! Z; U5 n( j( |3 G+ tPHP Code:
<?php
mssql_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' ] != "" )
echo $lord ;
9 `" I" |3 f; o) j  `' Zelse
echo "-" ;
?>
MVP:


* c# E* N2 t3 j8 N9 [. A. n' X
4 P- H3 A8 Q; [, w: xPHP Code:
/ X' A: |" \7 p& ~2 x  L. m<?php
' _6 N& c7 Q, e# c9 h' i% I$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" ));
1 V3 s/ u1 l# C, G8 E! {2 }if ( $mvp [ 'm_szName' ] != "" )
echo $mvp [ m_szName ];
2 \) z+ g1 s% oelse
4 J+ G1 t; o# x$ Zecho "-" ;
?>
$ p' s' F7 [* }9 f/ X5 r: S2 S2 MGuild Winner:

" `2 k& U  y' N

PHP Code:
<?php
  A% P( C- u8 B+ G9 ]$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" ));
& ]- i! w9 ?& @; b6 U) qif ( $crown [ 'm_szGuild' ] != "" )
echo $crown [ m_szGuild ];
$ b4 a2 i/ X! F' x5 T! d1 _else
echo "-" ;
' ^9 q' {& A  s?>
Don't forget to like it.. Of course if it helps...