公会得主显示脚本

admin

Lord Winner:

& d' T! u8 m: b1 }4 v. q
PHP Code:
0 y' S2 s! Q: ]. h) R) `" v<?php
+ T9 o1 U6 b. A) I5 h1 hmssql_select_db ( "CHARACTER_01_DBF" );
- f/ c4 }$ L/ x3 P, _4 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" ));
if ( $lord [ 'm_szName' ] != "" )
, B+ l7 ^) E8 }1 Qecho $lord ;
* ^& [( e! g8 v& I3 a9 {8 Uelse
2 P: G: W; \& i6 Z" k  iecho "-" ;
4 Y- S  B. }% f  m8 L?>
MVP:

! ]' ~+ t4 s$ r% u* J
# c' K8 X. f( o4 T
; s# f! F3 J8 ~( ]& [- B  APHP Code:
<?php
3 N/ X* q9 J' _7 @5 w$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" ));
0 t6 g6 s) T& o! [: l- ]3 M, h- |if ( $mvp [ 'm_szName' ] != "" )
echo $mvp [ m_szName ];
else
echo "-" ;
+ e9 I( P" m, D% J?>
: A, j  v% r2 A* U' \Guild Winner:
; T( H$ z" |! @' i8 b' ^8 B
+ W" E* j+ j' P; Q- n" s/ K3 u. s

7 d  B, V" w. g. G8 a. oPHP Code:
<?php
, N+ J) z4 v* P* A$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' ] != "" )
# H) Q2 O' F: R, yecho $crown [ m_szGuild ];
else
echo "-" ;
6 P" ~: ~/ |, }# C?>
$ _/ d2 S  B% t) oDon't forget to like it.. Of course if it helps...

% U4 B7 q# o$ G: u5 t