公会得主显示脚本

admin

Lord Winner:

6 s$ S. D4 \% z
7 f9 m- o  x4 P5 a9 G% ePHP Code:
+ g( J* U4 O) `, l# p<?php
1 d, t) D, L4 \/ x9 A6 R6 ~  ~5 kmssql_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" ));
% T: N3 z& X6 h% B7 l1 C: C1 eif ( $lord [ 'm_szName' ] != "" )
echo $lord ;
: p6 Z& C9 M" b4 X. e: Aelse
; \" k" R& T: }& qecho "-" ;
?>
4 a: B. a* C" i; i0 `. w7 kMVP:

& d1 F! u4 F2 P6 S
2 z- ^# ~0 Q% @+ J* ?7 ^, M1 W
PHP Code:
<?php
, v$ O# Q( ?0 e8 u8 X( f# M$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" ));
# L. l/ A! I; C# R7 x4 Jif ( $mvp [ 'm_szName' ] != "" )
- D7 ?7 S3 v! x2 ]echo $mvp [ m_szName ];
else
8 N8 x3 V# G8 J: G8 K) Z& k: x  j# Kecho "-" ;
+ Q& w' i" Z& u?>
, ?/ s! m$ j  x. W) `Guild Winner:



PHP Code:
4 t# @! c4 J& \<?php
' k+ V6 t* ]+ C0 o9 i7 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" ));
: [  @. l6 X; m+ u" @if ( $crown [ 'm_szGuild' ] != "" )
& T- z2 I; f- Cecho $crown [ m_szGuild ];
else
echo "-" ;
6 l+ e+ e. P$ J2 x7 O8 I?>
! q1 c; W! Q" d0 `Don't forget to like it.. Of course if it helps...

9 k& {5 `) C: n3 l