公会得主显示脚本

admin

Lord Winner:
. L' N8 }$ b- k2 T! o1 l# i

PHP Code:
- c+ h! l" _+ n  b8 T  o9 s<?php
* t( ?2 i7 L% W: Rmssql_select_db ( "CHARACTER_01_DBF" );
% @) f2 r( u2 T( P$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
3 C1 ?: {9 b1 q1 Q3 ~. iecho "-" ;
! u8 z# ?/ a. [, |9 {?>
4 u* |$ g3 E4 a0 o0 y3 s7 SMVP:

# y: a% Z' T# B4 s1 G9 W' Z
3 s% X" \4 n! N) |' y* B! r: E7 k
PHP Code:
<?php
0 [: R3 D# A9 t5 W; j' z6 u. g$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" ));
/ h  G; W% ]3 Y% S* Fif ( $mvp [ 'm_szName' ] != "" )
, W: J3 o5 H/ w$ N5 Z4 L2 r- s& V2 U) ~( m6 Becho $mvp [ m_szName ];
else
echo "-" ;
?>
8 G4 x4 M2 K9 h& Q( cGuild Winner:

" Q( ?" k! w7 G1 f$ c
1 f+ F& s1 f3 {5 c' K; R5 l
% S% g' k% t" f7 Y( M6 P5 [$ _PHP Code:
3 Q# P% l( {# U" b5 p# o<?php
6 m; ^! c- F# D$ A+ n" g$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" ));
( P6 o4 `) p: B! D( p8 Cif ( $crown [ 'm_szGuild' ] != "" )
echo $crown [ m_szGuild ];
. t9 {: t  g8 a* D# O# p5 yelse
echo "-" ;
9 h" v2 E" e  C9 }' e/ n?>
' |" c0 U6 w. Q( `0 _Don't forget to like it.. Of course if it helps...