公会得主显示脚本

admin

Lord Winner:
$ y" K$ m# w( _, T7 u
, Q- Z$ ~7 r- n! a7 F! j  G
: b. l- v/ I  w* Y: n5 @. w% pPHP Code:
<?php
5 a, E# H' G4 @7 T% m: C0 umssql_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" ));
if ( $lord [ 'm_szName' ] != "" )
) C9 H! m# \+ l1 eecho $lord ;
% T6 c3 l- W9 Q' p! O& ]else
$ @' }. Q5 _- _8 g7 F8 ~6 Zecho "-" ;
?>
3 _! o% ?- V/ Z3 rMVP:

& t/ ]3 i( {5 [% ^& O& Z

; ~2 Y+ t5 M4 @PHP Code:
& f$ N  l: q9 h" P<?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" ));
+ A  U* g, Q/ X3 Yif ( $mvp [ 'm_szName' ] != "" )
) n$ F  b" `; x9 D- Z2 Z( r1 j2 M9 A3 @+ Pecho $mvp [ m_szName ];
else
- r+ u5 G  n3 s1 ]3 Becho "-" ;
?>
3 T' N# c$ o' M; n+ @2 QGuild Winner:



7 ^1 Y! p4 {2 j. tPHP Code:
<?php
. E/ ]9 c8 H) N5 w' b  K4 q/ f$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" ));
" U! U* x' A3 b! \& pif ( $crown [ 'm_szGuild' ] != "" )
2 o8 U# i( F9 Oecho $crown [ m_szGuild ];
else
. `( t* d# Y6 Y* h) g2 Jecho "-" ;
?>
Don't forget to like it.. Of course if it helps...
; F& z5 H: h, U' N/ D& h
/ M$ {% T/ t2 E. ?7 Z( J9 g. k$ e& I