公会得主显示脚本

admin

Lord Winner:
  u! u, i: H0 q
% g+ j$ G+ v7 m9 ]# E' b/ l) `
PHP Code:
4 ~- m0 o+ M! @9 }! r% V<?php
mssql_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" ));
9 @6 O6 ^5 ]8 R' E5 z& Fif ( $lord [ 'm_szName' ] != "" )
echo $lord ;
9 @" A4 G5 K+ E: M5 Z+ Lelse
  s" }0 M0 Q; |, h( yecho "-" ;
" u' p9 j" j) N9 m0 ~# U$ e3 B4 `?>
: v0 P$ E1 c+ K; k) PMVP:
4 J2 R5 K0 M; T6 b% c# o
# I7 k- V+ @+ a: w* P5 s: g! ]% i

PHP Code:
1 S# |- R# ~- o: m5 M5 U<?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" ));
% t; L/ Q+ O1 m) @0 p( {if ( $mvp [ 'm_szName' ] != "" )
0 `' r! v  U- D/ }: W+ ]9 z% iecho $mvp [ m_szName ];
else
echo "-" ;
+ W+ {6 r7 o7 Q$ @4 _" D?>
! ?# \/ `3 B3 ~: G' JGuild Winner:
5 A4 |0 B& v/ B$ j" U
/ J0 r# A2 a, ^- W. k# M
: `3 J9 t6 j2 e# W  U+ e3 f
# B' K( N0 u3 L# L- {PHP Code:
<?php
& [5 h* k' ?$ O" P! i7 j( z/ k$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" ));
' M% k! U& Z) b2 D) `8 \' Fif ( $crown [ 'm_szGuild' ] != "" )
* _7 S( @: C, Qecho $crown [ m_szGuild ];
else
echo "-" ;
?>
9 O' t+ P3 i0 {5 j4 jDon't forget to like it.. Of course if it helps...
1 {3 Y6 S: n/ {1 ?