公会得主显示脚本

admin

Lord Winner:

4 x1 I' m* _8 {" l+ Y
PHP Code:
<?php
; z7 S4 v3 x  z2 ~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" ));
  d9 v3 u  y5 p) |# cif ( $lord [ 'm_szName' ] != "" )
8 T. `  g% @% N& s4 B2 d' t' Zecho $lord ;
else
9 B; X$ R& u& {# Cecho "-" ;
, U# D! X' a6 }. ^?>
6 ^! b* I6 w  {+ tMVP:
2 U/ L7 T! o4 ?1 z3 O- |; |3 [! T


& _5 [1 D2 G* q! U& L, O# e+ u1 _5 mPHP Code:
0 O" w5 J$ ?( k  f1 W<?php
8 O$ R% E- I% f; a; x3 G, y  b$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 ];
' ]4 s" N* g9 v3 Eelse
) c5 U& g' s1 H9 Q, decho "-" ;
+ D: M  G: X1 L* s) \?>
- F. O4 S4 z6 V7 v1 o5 U( z9 K, lGuild Winner:

4 c6 C6 Z" B6 t+ N9 t5 p0 [

PHP Code:
6 T. [# O3 S1 ]7 `4 Q<?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" ));
7 o4 t* a; \; L; Y3 x/ ]5 [' @if ( $crown [ 'm_szGuild' ] != "" )
echo $crown [ m_szGuild ];
5 V$ D+ d% I3 u& d& velse
6 L3 V* W8 i2 f' c/ U9 a- @echo "-" ;
; A  I7 J8 Q; a, |- G?>
7 Q5 Y+ C* W3 O+ [. rDon't forget to like it.. Of course if it helps...