公会得主显示脚本

admin

Lord Winner:
: M% v' F! N) _1 V- N7 K+ z7 U# B

( P5 ]( \* d5 a7 a9 o' ePHP Code:
: ~; `5 ~  z" V5 T$ M<?php
' X9 y. G* g9 C$ t0 m& Wmssql_select_db ( "CHARACTER_01_DBF" );
: `0 g( @1 a$ j# l/ S4 U  t0 e! E$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" ));
" {0 E  i- A' V6 rif ( $lord [ 'm_szName' ] != "" )
! [" w5 r2 U- d$ ~6 ^echo $lord ;
else
echo "-" ;
?>
MVP:
/ h1 K8 x3 H7 a
" f; H* o# y+ a8 ^
' E+ J8 l9 Y# i9 ?+ O! r, s% P) L
PHP Code:
, u2 X. v% m" e5 `' S<?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 ];
else
8 v9 B; b5 M7 z0 C  V/ mecho "-" ;
  B+ {- O% |7 \  q0 ?/ Q+ m. o5 Z?>
Guild Winner:
0 s- b1 o7 W5 ?, u% f* `4 w& V
* w! y' W5 T! S& Q2 r- Q4 N0 R9 c# E

PHP Code:
<?php
$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' ] != "" )
echo $crown [ m_szGuild ];
else
; L2 f+ }1 a' S( w8 U3 Xecho "-" ;
?>
Don't forget to like it.. Of course if it helps...
  w$ L7 x3 n' j/ Y8 h/ `4 h  D
. ?) ~2 b% G  H# }8 e2 U; Z- {) g