公会得主显示脚本

admin

Lord Winner:


% d7 Z, Q4 C; p9 TPHP Code:
# k$ [1 e7 s! a! X3 s<?php
mssql_select_db ( "CHARACTER_01_DBF" );
2 H3 {) p0 [1 F9 R8 r$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 v4 I7 h+ _: V- ~4 Pelse
echo "-" ;
2 b, H  M& ?# j; E, y7 v?>
0 Q, R1 v5 M+ ~2 N6 P. j7 oMVP:
/ R' g  N4 ?7 v+ m9 G9 S) m- u


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' ] != "" )
: M2 f3 ?' ?5 F% |echo $mvp [ m_szName ];
7 i$ Q; H0 g& e8 V: j8 a( l9 xelse
echo "-" ;
, v  V( H" C2 m- q?>
Guild Winner:
! V4 ^/ i3 B+ a: W
  a3 O5 W6 i1 f2 j. |  U
" ?. {5 j- [5 p- ~" Q
PHP Code:
<?php
7 R8 w7 w9 W2 |+ m; ~$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' ] != "" )
9 H  Z( u1 K3 w) |$ x# techo $crown [ m_szGuild ];
else
echo "-" ;
?>
6 e/ \1 g1 z8 R/ q# Z1 I& \) m. S7 a: [Don't forget to like it.. Of course if it helps...

/ P! \6 e: S9 ^  k; e$ v! u$ z" G