公会得主显示脚本

admin

Lord Winner:

; l0 `8 Q- o  y0 x
PHP Code:
* |' @$ w+ a  R# Y% T( K7 T<?php
4 t4 O1 R7 a+ ]" L% f: emssql_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" ));
) N% }" g6 x7 z/ ~& c; F( f! ~if ( $lord [ 'm_szName' ] != "" )
9 o  [& m* E1 ]6 recho $lord ;
0 t; i2 X) {: |! C! E, Y5 Delse
7 p7 ]: t0 R7 S9 G. jecho "-" ;
0 A: F8 E1 |7 K  l?>
MVP:


8 s3 c  L' l3 W$ w# |
0 i4 g+ H$ ~5 k; Z. m) H+ rPHP Code:
<?php
; ^+ l: ^# c2 r  a7 {$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' ] != "" )
+ d& P* p- P' u% D* q1 L  Q  aecho $mvp [ m_szName ];
; Z% E! }3 ^$ z- Y9 w* u$ Xelse
! x7 |; H3 [5 g5 ?! N; i4 B  pecho "-" ;
) g9 ]2 S, w. b?>
Guild Winner:
! j0 H: \; S1 m' X5 w
" B! V8 s) L6 k2 j+ S
: a4 ]* Y, d  i; \8 b: k
3 I& J, [: T2 LPHP Code:
8 ~. x) U4 h: ^$ j7 z3 n; ]$ _<?php
5 Q; \4 I2 t* \& n/ l+ Y$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" ));
! y2 ]3 f1 t+ u4 O9 jif ( $crown [ 'm_szGuild' ] != "" )
9 I4 Q2 r! B4 r- _echo $crown [ m_szGuild ];
  x9 y- K& o, S  G, Eelse
echo "-" ;
! W7 D* O' b9 D' ~* a  _?>
; Q( m* U& z" N/ a9 \+ e/ hDon't forget to like it.. Of course if it helps...

4 q0 o) I2 N! G  I% |  t4 r