公会得主显示脚本

admin

Lord Winner:

2 {- g: f- Y8 [) o/ Z
/ v( m4 J( _: Q  C5 x# d  ~  BPHP Code:
1 j) Y" t$ N; [  d9 _<?php
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" ));
if ( $lord [ 'm_szName' ] != "" )
  D; O- O/ H' f+ Qecho $lord ;
else
: O/ p! i. Y6 ?0 @/ l6 d4 o0 K0 fecho "-" ;
?>
7 x4 o$ c7 a8 H$ E3 S, fMVP:
/ x/ S1 @$ `' b7 {* C* g- Y


PHP Code:
  ~- x' ]4 z6 D2 T8 M6 d4 x0 Q- u<?php
6 H+ E# s7 c  v/ t$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 ];
# k* Y0 M! r* t8 M% N6 \: ^: nelse
echo "-" ;
: c# l8 q( a/ @$ I9 v0 Q# h) `/ u- ]2 d?>
Guild Winner:

7 G" b9 k+ j: M% _9 O: w2 `
$ Y/ s' m# }5 J! f- D+ Y
1 C9 R8 f3 o5 r! dPHP Code:
0 z: X0 m- z& L* n<?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 ];
( i/ W( F/ P  s5 A& o4 U; d) ]else
7 X, i! A1 i4 I6 `0 }" _: w( J2 w$ Eecho "-" ;
?>
8 f/ z6 G2 H4 c) d, Q  p) IDon't forget to like it.. Of course if it helps...

8 V" z0 y, l  R5 v