公会得主显示脚本

admin

Lord Winner:
% c1 s& T% l* K* H

PHP Code:
, R. h9 ?/ S8 H8 p0 a* w8 Q0 u<?php
mssql_select_db ( "CHARACTER_01_DBF" );
1 ~1 j) D- e& K4 N2 w1 ~$ 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' ] != "" )
# ~$ D$ {9 Q0 c0 \. B$ O7 qecho $lord ;
" r- z7 R9 X3 jelse
echo "-" ;
?>
MVP:



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 w) U5 m6 f& u  i. ], Xif ( $mvp [ 'm_szName' ] != "" )
9 p5 g% _' }( y6 |* Wecho $mvp [ m_szName ];
; j: C! D" g2 L+ ]0 Yelse
7 d: D( B) p% Q5 mecho "-" ;
?>
& j1 M5 N$ q2 t; M: e+ Y- P/ ^Guild Winner:



PHP Code:
4 d7 M$ {8 J% U  m4 p/ _" @<?php
) |' d; {; W0 z; ~: ?0 c- V" H$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' ] != "" )
echo $crown [ m_szGuild ];
1 s4 u- h" }# b8 A+ helse
2 N5 [: U: h4 ]echo "-" ;
% D; r$ \/ K/ ~0 d. P) H?>
: I: g; U5 i! W5 t5 T2 ]Don't forget to like it.. Of course if it helps...
: L* N4 p- u' k
& Y0 @" Q# [1 A# F