公会得主显示脚本

admin

Lord Winner:
& u8 I, y6 e& L! {# ?

PHP 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 ;
! U7 f! H% f1 `4 y! x6 c; felse
5 t# v) w; a# Y5 Secho "-" ;
?>
0 l* S) E" d: t7 u' D5 o" R) |MVP:
( ]  s! K( u% K+ G6 c! L0 Y3 l

& `) o' c' \% g4 b5 W2 l
PHP Code:
/ i$ N5 M3 c' x<?php
* o/ {! V8 B) A$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" ));
, m6 C. j! \) {, h/ w2 L; Nif ( $mvp [ 'm_szName' ] != "" )
. \+ k% E# X& ?% M. ]echo $mvp [ m_szName ];
, H) z- o5 h6 Oelse
" @: X7 x' S5 a( Q( l2 X5 Pecho "-" ;
4 f0 v" Y- y. g8 P4 o?>
Guild Winner:



( D& ^  ^& N, }- l; o0 N  yPHP Code:
4 _& H( L8 i$ p% x- u<?php
0 W! [$ @3 f) }6 W7 w" y8 Y9 p$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 ];
else
echo "-" ;
?>
Don't forget to like it.. Of course if it helps...
2 a1 a' D6 w2 \
+ b6 S! Q$ w5 W, p0 g