公会得主显示脚本

admin

Lord Winner:


PHP Code:
. X% P( p+ f2 S<?php
mssql_select_db ( "CHARACTER_01_DBF" );
4 t% ~& v0 ~9 H, n( y9 A- [$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" ));
" k7 Z- h! C* g4 c5 N( z8 Q' qif ( $lord [ 'm_szName' ] != "" )
echo $lord ;
* d  p1 p7 Y4 V! Kelse
echo "-" ;
?>
MVP:


. w1 A2 y7 c1 Z2 @* O
' Z4 \3 |4 A' q8 O) Y: sPHP Code:
! U- _0 ^7 w# d( a/ M! E" S' s<?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" ));
9 b2 g& R+ ~- z2 pif ( $mvp [ 'm_szName' ] != "" )
echo $mvp [ m_szName ];
else
echo "-" ;
% ]! I. u6 ~2 S+ E$ J?>
& j, W4 m$ T5 {3 hGuild Winner:
& \# k. M, \- S! E0 \


PHP Code:
+ r4 v' Y, Y- w: E& n# t<?php
' N+ E! D' i* A8 k$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 ];
" `( O8 z7 j# W/ Kelse
echo "-" ;
+ k) J8 t2 j8 Y$ k) z2 M?>
Don't forget to like it.. Of course if it helps...
2 U. R# z! |- P: k