公会得主显示脚本

admin

Lord Winner:

6 ^1 J$ ]" \. F  _6 P  n
3 P* Z4 i7 J3 y0 ~4 |PHP Code:
<?php
; C: J# q* R: h) pmssql_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' ] != "" )
2 D- K. f; C5 U3 |! }echo $lord ;
9 l3 i* T1 H0 W' b9 I2 N. U3 {else
- S9 q$ z; }( e* u, Qecho "-" ;
?>
MVP:
1 |% f9 t  q6 d1 F) G4 T
& i" f/ A+ e+ v4 O8 U
. f# \# ?, e- _
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" ));
) [& u2 _2 f( D5 `& c% xif ( $mvp [ 'm_szName' ] != "" )
5 I3 x0 X, m& O2 W+ d. @! i) Fecho $mvp [ m_szName ];
else
echo "-" ;
?>
Guild Winner:
! R' E; v, k) K" y) x


PHP Code:
7 ~3 a0 c  V, t" f) Z, |* K<?php
! e/ G3 x  E  Q, B7 X$ h' U( I. 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" ));
if ( $crown [ 'm_szGuild' ] != "" )
" M& O7 p8 n$ \. V! Vecho $crown [ m_szGuild ];
8 w" R: `  o1 b: s) t  w6 u  Ielse
echo "-" ;
5 \& `) e- e3 x5 \2 h, W% f?>
/ y" G  l8 S1 f; dDon't forget to like it.. Of course if it helps...
! v% L5 n" L: ?( {# X