公会得主显示脚本

admin

Lord Winner:
  b2 ]. w, C8 c
) ~( U+ P, Q6 v7 X+ d; c
! t" o, ]0 N# @  IPHP Code:
<?php
" Q: ~$ v0 s+ Ymssql_select_db ( "CHARACTER_01_DBF" );
; i' c7 u' e; G8 U5 {7 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" ));
; b/ U. n9 u0 z  K& w" M1 Lif ( $lord [ 'm_szName' ] != "" )
echo $lord ;
: t. a3 a" ]3 ~! s3 Y* }6 _7 Kelse
echo "-" ;
7 [; ^) g( R! H- w?>
MVP:


. d3 x0 P4 c/ ]1 D- X; N: t: n
7 N  O. t' R  C/ }. a8 ~4 ?PHP Code:
7 W  |$ M; ^4 J; Q- I<?php
' N; [& W' q4 ~6 N$ L4 ?' g- ~2 p$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 ];
% @- o% o6 Y5 N& Relse
echo "-" ;
?>
! @1 Y, X3 Q7 ]' KGuild Winner:


$ V6 X' z6 M. B. t, g' @* R2 q
PHP Code:
<?php
) T! @1 f7 T2 P8 p0 ]$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" ));
: G" ?  [3 u4 z! W1 F. z! {if ( $crown [ 'm_szGuild' ] != "" )
! R7 N9 f) [1 `! mecho $crown [ m_szGuild ];
/ D8 R1 U6 t! `& e. L2 i2 E* y# ]else
echo "-" ;
7 j' _! i0 D& S2 E. W0 p?>
Don't forget to like it.. Of course if it helps...