公会得主显示脚本

admin

Lord Winner:
! W9 k9 R1 C: k2 j8 q
0 v  C3 b$ L& L6 E5 L, {
/ {! K# l2 ~& H5 HPHP Code:
<?php
. i" ]8 r) u+ D( x- Y( `, ?4 b( Ymssql_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' ] != "" )
echo $lord ;
else
% Z! P  h+ i7 R# z  o8 j0 }. mecho "-" ;
?>
# @0 V! y( Q* l2 c: f6 `  p& wMVP:


+ [+ @( ]6 ^& J5 @
PHP Code:
6 c1 w4 z. ^% i3 J2 |<?php
0 g) e  m% ~( ~: G$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' ] != "" )
1 m/ t* B; ~, [echo $mvp [ m_szName ];
4 G' s: l. v8 s1 L! w+ Belse
echo "-" ;
?>
: i: O8 p# Z/ A2 O" Z7 a8 g( `4 X9 \Guild Winner:
( d3 t" t! [! v. }) ]) _1 }


& p3 j( c" l* @% F. D0 mPHP Code:
- f# N$ ~9 P$ X$ L  y<?php
$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" ));
. z6 P' w1 R* A& ?: oif ( $crown [ 'm_szGuild' ] != "" )
echo $crown [ m_szGuild ];
% e7 i, S( ~2 j9 j4 selse
echo "-" ;
?>
Don't forget to like it.. Of course if it helps...
8 M4 D: ?; A' `$ D, G$ J* t
9 f; m( s' F( x* q1 F  Z5 L