公会得主显示脚本

admin

Lord Winner:
5 \/ U. h+ [& a: x+ r

PHP Code:
<?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' ] != "" )
* c- a/ E2 v0 o0 t3 wecho $lord ;
+ K; s' m# S2 k& N( Xelse
% `9 C" V, q$ f0 i5 J1 M0 fecho "-" ;
% Q9 T0 S# G2 L+ b9 o. D# E, `?>
MVP:



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" ));
if ( $mvp [ 'm_szName' ] != "" )
echo $mvp [ m_szName ];
else
echo "-" ;
* N& V6 R' J# L, E( D3 N) K?>
Guild Winner:
7 ?  n2 G6 m) l+ X+ q

2 t7 Z: T9 B9 K$ l0 s
# s4 e; Y) ~5 `% W  u' oPHP Code:
7 L( F: m6 Y' {: f<?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' ] != "" )
echo $crown [ m_szGuild ];
* O$ }: Z; I' j! X7 kelse
echo "-" ;
?>
: L& v- n' _6 K: }4 h# NDon't forget to like it.. Of course if it helps...