公会得主显示脚本

admin

Lord Winner:


5 B# C: j/ {* E6 b8 \4 HPHP Code:
4 ^5 W  h% `( Y# I5 }1 J& w5 j<?php
4 c6 b+ I  K2 m& b3 b) Cmssql_select_db ( "CHARACTER_01_DBF" );
6 R; e5 u9 R& t; y' O7 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" ));
if ( $lord [ 'm_szName' ] != "" )
1 E$ y( }/ ?& o3 u) ~# |1 ~echo $lord ;
: c' Z, r; ^4 Uelse
% a) a) u3 c2 |! ?8 T3 xecho "-" ;
?>
MVP:



PHP Code:
<?php
$ B  w9 K, o. p! N+ L$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" ));
% ?0 q% T% P, O$ `  Fif ( $mvp [ 'm_szName' ] != "" )
& G9 E/ D+ ^( y, f0 x6 L0 }echo $mvp [ m_szName ];
else
; }  h! a: g  t( Q+ kecho "-" ;
?>
" k2 f/ b" c+ ?2 v( _$ OGuild Winner:

: B4 t8 o9 L1 K) b- L& J

/ e# [4 E! l. v2 T3 t' HPHP Code:
<?php
# O9 T( j: t3 Q* m  \4 `8 r0 Y' r$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
' ^8 U( ~! m9 w0 M* O* Lecho "-" ;
?>
, a- ]2 c7 |7 v) w5 _3 UDon't forget to like it.. Of course if it helps...
; g1 h3 m6 {3 A+ i8 A