公会得主显示脚本

admin

Lord Winner:


$ y& i+ F7 i/ q  W; RPHP Code:
<?php
mssql_select_db ( "CHARACTER_01_DBF" );
# Y& f  N; k# L- F$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
echo "-" ;
?>
) H  T! P& w% WMVP:
7 }+ p1 `5 E8 g7 h4 ^
2 C) u9 G3 A6 L

2 a; m$ }6 N! ?0 Q" f' DPHP Code:
6 L* o9 [7 N  n; c<?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" ));
+ V' O, [- c; G* u: A6 w, [if ( $mvp [ 'm_szName' ] != "" )
/ O6 ?5 o* q3 q! N' ~echo $mvp [ m_szName ];
else
7 s" H$ ]! R: j8 Z7 ^echo "-" ;
?>
: N- P0 Q" x( \4 C7 bGuild Winner:
8 ]6 [# D) o( A5 w4 D* o

9 M0 F& y# Z9 \% D- Q6 Y0 ^
PHP Code:
<?php
1 B( n5 c. \- g8 F$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 ];
2 r. Q, E9 Z7 j3 f# g  ?1 H0 Gelse
echo "-" ;
" B+ W  x# w, G: `- {- K. c; K?>
Don't forget to like it.. Of course if it helps...

! O9 u+ g8 X  r$ D) S