公会得主显示脚本

admin

Lord Winner:
* f  j: k3 Y! K. M

0 L4 S7 h3 Q3 z5 V+ C( wPHP Code:
! U( f7 H$ H$ l- Z<?php
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" ));
if ( $lord [ 'm_szName' ] != "" )
echo $lord ;
else
echo "-" ;
& h+ |8 l! U. Q?>
MVP:

- E& h) _0 a6 x2 o5 J7 \$ T
9 J% Z' Z1 A5 X9 ^, F: N
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" ));
8 c! z/ F4 ^, ^+ J: |, ?if ( $mvp [ 'm_szName' ] != "" )
4 z! W8 ?3 T0 E/ _  p5 yecho $mvp [ m_szName ];
else
' k! k8 D4 w0 @8 K: U( l" Yecho "-" ;
9 X3 w( b6 g6 O1 S+ F7 O/ y?>
. h6 F9 i9 Z4 q3 h5 ]4 {7 r) OGuild Winner:
4 L' Y0 t3 R0 @: M. D2 t% ?/ _


' W3 P% B, W' ^9 a0 a) WPHP Code:
3 E& [) H) f/ a4 E# F" {2 A+ a<?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" ));
if ( $crown [ 'm_szGuild' ] != "" )
0 n! ]" S% H+ Gecho $crown [ m_szGuild ];
: ^  w* }$ T) e! n$ w) `8 e9 Qelse
echo "-" ;
?>
Don't forget to like it.. Of course if it helps...