公会得主显示脚本

admin

Lord Winner:


PHP Code:
( v* u5 t: z' V4 F. K* p7 C+ s<?php
' a1 W4 ]+ g3 t9 Q, ~& j. Emssql_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" ));
3 a( g, q# C, R# N- C+ K0 lif ( $lord [ 'm_szName' ] != "" )
echo $lord ;
. c( x( V# O, R; M1 W: gelse
echo "-" ;
+ r2 j7 F, r7 ^% G! e; g?>
MVP:
: |/ i* i" U4 h  |( L

3 i6 z9 Z  h9 V5 k: A/ O
+ f8 d  C$ d7 f$ J% E4 U. vPHP Code:
<?php
( T$ ]- \8 \/ Q7 N& Q+ q$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' ] != "" )
2 B1 W' {) K9 d, n$ Iecho $mvp [ m_szName ];
else
$ F( [* `+ f, Z/ uecho "-" ;
. O# U# ^6 L+ S& U2 H1 A?>
Guild Winner:
! T. D1 r% M& B  Y

- \0 X) d% y0 c4 c5 M  g
2 S3 I3 e! M2 T5 nPHP Code:
& r2 d- K' x% j) ~& n+ h3 m<?php
+ s" d, a( _" Z, b4 ^6 n; b: _' F) y' _$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' ] != "" )
echo $crown [ m_szGuild ];
else
, I6 l/ W5 d+ i  b' {. N' |echo "-" ;
?>
Don't forget to like it.. Of course if it helps...