公会得主显示脚本

admin

Lord Winner:
# e8 Q. S5 [4 H9 f( V

0 t" n( Y$ M+ X( F1 _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' ] != "" )
, n6 E3 ^* n9 h0 H% o3 e) M1 o# {echo $lord ;
else
echo "-" ;
?>
5 M: o) }0 j: o2 {3 eMVP:
! Y6 q) Y" ?& t

* L! j9 x) Z! d( s- x2 e6 N+ `0 N* K/ h
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" ));
if ( $mvp [ 'm_szName' ] != "" )
echo $mvp [ m_szName ];
# b" B- ^/ v3 m4 g: W0 N1 _+ }' lelse
echo "-" ;
?>
; c) _4 y9 I. F$ M: SGuild Winner:
7 e1 R! d/ w$ J# m/ G
7 i# X+ U$ l0 T

PHP Code:
<?php
+ g2 w' D2 t; D! N! v) i+ Z$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" ));
: y% V" b3 ^6 k& U3 Tif ( $crown [ 'm_szGuild' ] != "" )
! S6 j, F; `' x, u( Pecho $crown [ m_szGuild ];
else
echo "-" ;
?>
. G! o$ S! d: e* x! y8 [/ XDon't forget to like it.. Of course if it helps...