公会得主显示脚本

admin

Lord Winner:
6 K% V5 q' e5 k1 Y1 X9 r

  ^( c/ i& W% v5 c+ ]PHP Code:
8 o( ?* q0 x/ E8 Z<?php
7 R4 F! \1 F  n& zmssql_select_db ( "CHARACTER_01_DBF" );
" q1 h$ F/ n9 U3 b5 w* u$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" ));
  ^8 O. t/ `. g6 Y9 T% R9 p( iif ( $lord [ 'm_szName' ] != "" )
echo $lord ;
. y8 r- f8 b! n/ {" |/ h- |; gelse
$ j, b& E' _+ \/ y' X3 g& iecho "-" ;
?>
1 [0 J" O4 }9 [MVP:
" K8 f# {. \% ^! w* d8 x1 c; J

$ `6 ]& e$ s8 D: ]& c1 V
PHP Code:
/ F1 }+ ]9 J3 G* G<?php
/ b5 ^+ J) b, T! C2 }$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 ];
else
echo "-" ;
?>
Guild Winner:
5 ]9 d( @3 s9 o( o6 \$ l2 m! _


/ C( C( E8 x$ w0 a# X  [5 ]3 `- uPHP 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 ];
else
; c& d( M0 d. ^; B+ _echo "-" ;
- u" i$ r: s- X: r4 A- B' h?>
9 y5 T7 T/ i6 L( S9 s: f! r2 ?/ F7 WDon't forget to like it.. Of course if it helps...
3 r4 G- l" q9 D' D$ `; U