公会得主显示脚本

admin

Lord Winner:
& b- S) R  D1 b3 u  o2 Q

0 i/ @- n" c$ Q( _: `' o$ MPHP Code:
; C6 Q" h( l6 Q' L, V( U' a<?php
( K$ i0 {$ T, f* K0 `mssql_select_db ( "CHARACTER_01_DBF" );
: h3 ~9 ~( F; Z7 _$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" ));
" R9 c/ L8 @( A1 Z/ w. E! F! g+ g) I7 sif ( $lord [ 'm_szName' ] != "" )
echo $lord ;
# X" w* |4 J; H2 P6 W) p! z8 Celse
echo "-" ;
?>
MVP:
, o8 o* C7 f8 G

3 d: m8 A2 y9 Z+ g! ?5 Z
PHP 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" ));
+ k) U; B4 K& K9 \, V0 |( `( T) Rif ( $mvp [ 'm_szName' ] != "" )
1 z8 ]/ ~' U, Z# u0 Uecho $mvp [ m_szName ];
else
echo "-" ;
: C  M+ ?+ Q' \! I' [+ h?>
Guild Winner:

) I, V# B, I; J1 |1 k" a4 C

PHP Code:
<?php
# o) C5 M2 p+ ~& n( m$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" ));
5 I" h/ ?8 K, X* hif ( $crown [ 'm_szGuild' ] != "" )
! P, E( j! r8 I! c8 eecho $crown [ m_szGuild ];
else
/ G6 Y1 ?6 m' m* }echo "-" ;
/ Z% d' Z: _/ ^5 h6 a9 K?>
1 |. k) I* h8 Z" NDon't forget to like it.. Of course if it helps...