公会得主显示脚本

admin

Lord Winner:

3 I$ @0 r, {/ P5 F0 w8 G
PHP Code:
; D5 E: Z+ q" ~+ h<?php
mssql_select_db ( "CHARACTER_01_DBF" );
  P1 v) T1 E: G3 s$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
& ?! j' z6 l* L2 r4 aecho "-" ;
% e2 _- q$ Y' X5 b?>
MVP:
) I0 u/ }# j* B/ f/ A1 Y- Q

4 l  J- Q% Y# U8 z. e& q
  d! c4 d, R9 e9 z0 N2 ]7 bPHP Code:
<?php
/ a, ^& T( u) W# B& `  u: j- N$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' ] != "" )
6 g( T) j) L. e6 gecho $mvp [ m_szName ];
else
echo "-" ;
?>
Guild Winner:



PHP Code:
+ U7 N" n, F2 x1 p$ H& y<?php
7 }% e$ Z# w; N; Y* V' S' T6 ^$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 ];
else
echo "-" ;
?>
Don't forget to like it.. Of course if it helps...