公会得主显示脚本

admin

Lord Winner:
. c  I! u% l% y4 _* a
% L" `8 \" m- o3 G/ U
1 l2 {9 R( m% A# d3 A! C$ g7 ?PHP Code:
& T$ i& {5 H; u+ F% x8 `# b) l<?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" ));
0 y  b- d* G) @# x' g% _if ( $lord [ 'm_szName' ] != "" )
, b4 v5 r: s& E% y% \echo $lord ;
else
echo "-" ;
?>
& M4 i2 W) Q% qMVP:



' A& D. g' Z" j( W  y/ JPHP Code:
<?php
2 T- q8 k: F) B2 I; E/ Z- L% s/ B2 s$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" ));
8 O. w$ p! U7 ^$ iif ( $mvp [ 'm_szName' ] != "" )
echo $mvp [ m_szName ];
else
echo "-" ;
3 j& S: u3 @4 F2 J' L8 `$ b?>
Guild Winner:

; h  z, g5 o( u( \

0 O5 \3 U9 W( \PHP Code:
<?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" ));
if ( $crown [ 'm_szGuild' ] != "" )
echo $crown [ m_szGuild ];
* }6 K& }7 X3 N: o, Z" O, L5 {  kelse
echo "-" ;
?>
Don't forget to like it.. Of course if it helps...
! a& Y7 p6 y  H) b# l