公会得主显示脚本

admin

Lord Winner:
( C, [9 d% T- n$ L) [5 i6 _' _
' x6 g/ Y1 t/ f" G3 `; n
PHP Code:
3 F, g2 r! W; H. J4 f, j4 Y" U6 F<?php
mssql_select_db ( "CHARACTER_01_DBF" );
- l( U! D* H( `! t3 K. G/ s! L, K$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" ));
7 s7 |7 j7 r$ \" H+ o1 I. nif ( $lord [ 'm_szName' ] != "" )
echo $lord ;
else
echo "-" ;
7 y7 K  a9 b: A. R: g; w?>
) G* t$ b0 y( C. c8 u, m) dMVP:
( B4 f  |+ z# B" ^
1 I" V# ~# g# p; B- h

PHP Code:
+ d0 r; j4 r+ ?% V$ ?3 f4 {<?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" ));
+ {" \8 K* E7 q' y  _7 i9 }if ( $mvp [ 'm_szName' ] != "" )
echo $mvp [ m_szName ];
else
# i" t( p0 u" [5 Q! iecho "-" ;
7 R* e; B; o7 O$ o: V1 \7 f?>
2 }) |6 M2 m! k( ]Guild Winner:



& a6 l+ _+ }3 K4 z2 RPHP Code:
3 V4 S$ B! x, j/ k/ K2 z<?php
% X( @5 I5 y4 U6 k- T% n$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' ] != "" )
echo $crown [ m_szGuild ];
9 X0 M3 ]: c- w; N( C" O' T* F  Qelse
2 c5 Z" j4 C9 u# hecho "-" ;
?>
Don't forget to like it.. Of course if it helps...
. K8 x; y& w5 V* a" n
' T/ d- w* _5 f) d1 K$ L) T$ E