公会得主显示脚本

admin

Lord Winner:
) s  [- Y, I. k, }+ c& Z* U

& l  z9 Z1 H) b9 v- O5 |# I  x# DPHP Code:
<?php
( `, \1 m' j9 v' G. H3 t' a9 c0 ^; Fmssql_select_db ( "CHARACTER_01_DBF" );
5 b3 P( v9 f: e: }4 {$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 R6 }- E$ n& q) `1 }if ( $lord [ 'm_szName' ] != "" )
echo $lord ;
5 g( W. e% ]6 X% W( X! celse
echo "-" ;
?>
MVP:
. ~! O" D+ E' Y4 w' A$ y
: X, Y$ V( k5 u& d" h
4 T$ J& v9 S9 G8 i
PHP Code:
+ t- u7 H' l2 ]% j3 p* o<?php
0 g' p) O* f/ I' ?$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" ));
1 X! K% J5 Q! Y  J' N  l5 Mif ( $mvp [ 'm_szName' ] != "" )
- K0 ]( m( \, f0 f4 x& zecho $mvp [ m_szName ];
else
echo "-" ;
?>
8 V8 u3 ^" u: ~  t. @/ a# CGuild Winner:
/ `1 g& p/ J/ k( q# J6 I4 t

4 H9 U' h1 n$ }9 ?
" t; n2 z# ?& W7 }PHP Code:
% }7 d; ^  b! L( ^+ z# T/ P9 K<?php
1 p' k) @7 t- U3 b3 q$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' ] != "" )
; |) b3 n: @% ^5 Decho $crown [ m_szGuild ];
$ R' N  {# z7 p; Y5 belse
- k# J; e- b& @# P' H3 P1 d9 ?2 f% \5 Lecho "-" ;
?>
3 N8 V' s% e, v, F, b2 E! j* Z& k, {+ iDon't forget to like it.. Of course if it helps...