公会得主显示脚本

admin

Lord Winner:
" D; ?  H/ h6 c: c5 a9 q9 ~( u
( m9 z4 h( T! M2 @7 W3 \: p
. q0 V6 p/ [: L2 m2 @PHP Code:
<?php
" Z$ c, G( n  n% L7 Z0 Nmssql_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
echo "-" ;
?>
+ ^, E+ `& ^  z, G3 X4 R1 lMVP:
, h9 X$ S0 A) c) ?* ~0 D  o3 O

( _5 M8 g: E5 X4 N8 f0 N: D
5 _9 ^! O6 d* F( ^/ {' iPHP Code:
8 r# b6 y; B# A; F6 o<?php
! [! W# ]# P$ }9 D& i! G7 }$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" ));
5 [: p! ^% t1 ?if ( $mvp [ 'm_szName' ] != "" )
% _; C+ m1 P/ w& s: t2 J8 i: l: ^+ hecho $mvp [ m_szName ];
else
echo "-" ;
1 I* q8 J- C& j, a9 t) g$ o?>
7 v8 K' J* o. d+ i$ |Guild Winner:
# z- b/ O6 E, s  ^7 J* J% U
- x6 }) c; W) S* `5 L

PHP Code:
<?php
7 F' I4 r$ N+ K$ p: h) _) 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 ];
else
echo "-" ;
! z) c& u$ D6 z  n( i?>
Don't forget to like it.. Of course if it helps...
) H4 L" s. y/ A! L1 j: l2 {