公会得主显示脚本

admin

Lord Winner:
% U1 t5 p2 W# c/ U" d; H" G# A
  J0 l/ ~$ p9 W7 F1 w3 J
- U2 i( w1 f" K6 U- r+ FPHP Code:
<?php
mssql_select_db ( "CHARACTER_01_DBF" );
# ~. a; ~# m1 k- f7 |. ~, [! G/ j$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' ] != "" )
: P( I: q2 r; J7 J- A6 Q! Zecho $lord ;
/ t! j( M* j9 Q. X5 oelse
echo "-" ;
?>
1 ^* j- J# ^9 q- R( [4 F3 L" nMVP:
; s* I, [- l5 g5 s, y  M) ~9 E
/ `# R# V' y, S

# Q. M) T/ E/ o1 X( Q, I! ~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" ));
- J5 Q7 e/ {) ^. x" K: vif ( $mvp [ 'm_szName' ] != "" )
4 c. ]- i% ^5 g; b" x; g& Oecho $mvp [ m_szName ];
else
echo "-" ;
: d- z0 Z3 @4 b?>
/ D; X3 w$ y5 s- e; b. cGuild Winner:
9 ~( u* v  a2 H0 ?
+ \- ]& f7 m' H* A- a- u$ g' c
! C! `- j; R% }  ~, l
PHP Code:
5 e' c1 j3 o% Y. k  Q<?php
& r; G4 i7 a: n1 o7 e$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" ));
$ }# e& a. m4 p, a3 ]if ( $crown [ 'm_szGuild' ] != "" )
  l- ?* d4 @) L- }( a8 ~echo $crown [ m_szGuild ];
else
3 Z7 Z* I8 o6 `9 \: o2 z# w! Gecho "-" ;
. \6 ^3 X. T# {4 `* e- F?>
$ n$ g7 @5 P) M& w7 b3 O1 _, bDon't forget to like it.. Of course if it helps...
+ N  g% d& O. N# A