公会得主显示脚本

admin

Lord Winner:


2 d) F7 j: G8 {, q+ tPHP Code:
<?php
mssql_select_db ( "CHARACTER_01_DBF" );
+ m2 \! T) t9 R% w5 E$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
( Q7 g) U5 G7 u1 z5 b) x  B( necho "-" ;
?>
MVP:
; J1 m) u. I9 R7 n# a6 T- f, Z1 M

/ n1 d7 k& P6 \6 M
: X, U6 `5 C. s0 Z- pPHP Code:
<?php
, N* k; b8 `) o- v$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" ));
* o( ?" A1 j$ r( v) D+ Yif ( $mvp [ 'm_szName' ] != "" )
2 G: S3 F3 y4 |echo $mvp [ m_szName ];
else
echo "-" ;
  W& ~3 A# Y" b5 l! s" A?>
Guild Winner:



- O+ h  n# v7 v& U/ U( S. VPHP Code:
<?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 ];
3 X& Y! `- S. v/ O. Yelse
echo "-" ;
?>
, C8 W' Q% w9 r2 v: J  X3 W: [Don't forget to like it.. Of course if it helps...
# Y2 o+ J0 Z5 {/ d  }. ?! h