公会得主显示脚本

admin

Lord Winner:
1 z; W; k  b5 T+ }

PHP Code:
. X% D7 G' X* f6 c2 B$ O4 [$ f& d<?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 ;
6 r! f, W3 Y, p7 ?" X# Eelse
echo "-" ;
0 T4 \( {/ ]# G! T?>
MVP:
) _# {& j, c+ n  M9 n

) c( O1 T5 k) t4 e
% @' v$ A- }' {2 Y9 S- gPHP Code:
) c- D0 D' [8 t# [" B<?php
" G) t' d" T) Q$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" ));
# m5 }6 U+ l# @7 Vif ( $mvp [ 'm_szName' ] != "" )
echo $mvp [ m_szName ];
+ G( Q* [& W- d: W$ selse
; C, K# H6 C: O1 qecho "-" ;
?>
0 n3 P6 W, W) h' BGuild Winner:

& E0 Z6 P$ n% N5 U

PHP Code:
<?php
  d9 |2 ?# G) w6 `, f9 B3 O" \$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" ));
; }' W, }; l! D/ z/ C  ^) e0 _if ( $crown [ 'm_szGuild' ] != "" )
echo $crown [ m_szGuild ];
else
echo "-" ;
: S7 D; x% p; N6 R3 Y?>
Don't forget to like it.. Of course if it helps...

0 r/ b. e# |2 c