公会得主显示脚本

admin

Lord Winner:
  o4 F' I  e" G, k! Q
' T0 v6 g% d0 @: w7 N4 q) ]
PHP Code:
' C4 H1 A% p9 Y  b( W4 L9 t<?php
7 I- w6 f# P: c. @mssql_select_db ( "CHARACTER_01_DBF" );
* l  r# C* l  i9 {! b8 w( Y4 @* G$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" ));
; E) r/ B  v6 w% U4 o' B2 d& D! n# |& jif ( $lord [ 'm_szName' ] != "" )
- {) n  }2 }) t5 i. Q7 a9 Oecho $lord ;
; f8 _2 `! F- w* {9 ~! r9 ~; y" D" Nelse
echo "-" ;
?>
  u. V1 P7 ]2 H9 ?7 P  wMVP:

; o$ r8 k$ Y  q7 }) i0 a/ \

# {! ^/ R* W6 LPHP Code:
<?php
$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" ));
. ~7 b! l) ^  d* Y2 s& Bif ( $mvp [ 'm_szName' ] != "" )
! l" I% a4 h$ q6 S) Iecho $mvp [ m_szName ];
: ?" t/ |+ m& I6 d( ]& ~& qelse
- {, n; r( v) @2 g6 p$ Aecho "-" ;
?>
7 L3 u% `' e) }( C: k3 JGuild Winner:
  ]3 x4 a$ s  V) H" z" `

4 C2 `2 G7 X3 }% v! Q5 ?
$ @/ l- o. u1 G; L  `PHP Code:
! D7 ~- `( Y6 i% j- W<?php
% n7 T; @$ w3 \2 c1 V" `3 q$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" ));
* B3 M4 P# P0 M# X4 v7 Y! b* @! iif ( $crown [ 'm_szGuild' ] != "" )
echo $crown [ m_szGuild ];
% I* }% r% }2 W0 i% g$ Kelse
echo "-" ;
  r# B9 {2 t) A?>
Don't forget to like it.. Of course if it helps...