公会得主显示脚本

admin

Lord Winner:


" _' b* x( T' R: t5 T/ v! q# kPHP Code:
<?php
0 x9 a( t9 x( }3 e: |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" ));
  q3 N# ]) o! C. d7 {4 h' I6 Zif ( $lord [ 'm_szName' ] != "" )
9 ^& r* V: r, Mecho $lord ;
2 p8 c! z/ y) A3 _else
5 t' t4 k. f0 g' z7 Fecho "-" ;
?>
: ^1 l3 [; r/ L, k( EMVP:

2 v; }0 y0 O' N: }4 g5 g2 }

" @4 Z. z+ r1 W! @; I. lPHP Code:
, X4 l- ]: o1 ~+ I1 S<?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" ));
if ( $mvp [ 'm_szName' ] != "" )
: [; [4 |1 @. Z# ?echo $mvp [ m_szName ];
else
! ~2 ]) W$ x# }0 E; ^/ becho "-" ;
( J- t$ n1 A3 s; L?>
. C8 h  M' ^2 Q/ ~7 p) jGuild Winner:



3 k' ?, c# k, ZPHP Code:
<?php
! Z, l" X8 P  }% T7 Q; A4 }+ u. k' \3 p+ J$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" ));
* Y. ?9 d1 V; E7 K  Gif ( $crown [ 'm_szGuild' ] != "" )
' K& Q+ H& U/ N$ Secho $crown [ m_szGuild ];
else
echo "-" ;
?>
9 V5 K0 {. W5 u3 ]6 S$ i% t' MDon't forget to like it.. Of course if it helps...
  h9 l. p+ T& z5 r
& y" a0 y) J! ^* c8 W