公会得主显示脚本

admin

Lord Winner:


PHP Code:
<?php
mssql_select_db ( "CHARACTER_01_DBF" );
1 q4 C! I, J- O/ U$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 ;
# ~7 F# B. H( Telse
% V; ?9 ^" ]! P. @, kecho "-" ;
0 z. G) Q: x6 E5 `?>
MVP:
: W5 R- i" J. y& u  `

4 N* v6 |; r: ]+ j
PHP Code:
# e; t9 o; [# K+ ^' ~9 a<?php
1 a& N# z2 z. G. e& J$ X$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 ];
3 D& w  p- R/ @/ k5 b$ Gelse
echo "-" ;
! X- b. w9 x7 J" ^0 x?>
: o  J0 L; P& u0 a- |Guild Winner:
& l# W1 g/ R/ s. h  l0 G# D3 P
/ B, K3 D9 z! |% M
# b( L  r/ g) y
PHP Code:
* V: {( j$ X: o. |<?php
% Q4 U3 T- a1 C# X  i' X$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" ));
3 F* R* W: v5 h  Nif ( $crown [ 'm_szGuild' ] != "" )
; ~; f# k6 J7 O/ B+ M6 J0 ^echo $crown [ m_szGuild ];
else
echo "-" ;
?>
. T: W& D  v  a3 `& b, j% bDon't forget to like it.. Of course if it helps...
& r  t  h7 A5 A4 ~+ J- V% J
9 P- a: ?$ a$ U. q