公会得主显示脚本

admin

Lord Winner:
+ o$ a- r( U* E! b4 x) j( g
2 n9 N4 z$ j7 L% |
/ [' G6 i7 C1 i# ^# sPHP Code:
<?php
8 a( s- v! h4 F7 |& U9 s; t" N7 cmssql_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" ));
4 X/ g+ y6 l+ J& Y- }9 Y& M* |* Xif ( $lord [ 'm_szName' ] != "" )
- d' A, h; _+ L8 m: d" H$ kecho $lord ;
, }9 B) V) z& K- x$ ^: F2 melse
echo "-" ;
?>
! }- f( o' j) X0 [MVP:
0 _. _) e7 n/ E0 G2 c$ x9 @# k5 {


/ ?2 W  l3 y3 sPHP Code:
<?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" ));
* }' X+ p: t0 c1 d2 ^if ( $mvp [ 'm_szName' ] != "" )
- t5 y# a+ g, ]; T) B' @echo $mvp [ m_szName ];
; F( y# N0 d5 `7 U( `else
echo "-" ;
  [4 R. t: c7 ^?>
. m+ q  E, s3 uGuild Winner:

+ n% f" V2 x5 y3 x$ m- F. u
; M& q: ~4 p) k" c
2 Y4 d0 E9 V% u& D8 k: r4 f# LPHP 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" ));
* L. A$ D) D3 O1 uif ( $crown [ 'm_szGuild' ] != "" )
echo $crown [ m_szGuild ];
else
echo "-" ;
- O0 X$ c' a; a?>
Don't forget to like it.. Of course if it helps...

' m5 f7 m5 {1 y* U( L