公会得主显示脚本

admin

Lord Winner:

! H: ]) l3 \* l5 ?. j" m2 {
PHP Code:
<?php
6 S2 n9 |& \, d' O9 dmssql_select_db ( "CHARACTER_01_DBF" );
8 M* ?2 F' V" E7 `9 T$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" ));
  T' [4 s, L, R+ E& _, zif ( $lord [ 'm_szName' ] != "" )
echo $lord ;
$ V2 N" \. @2 v- ?+ U* |else
echo "-" ;
?>
% G$ |. P8 i% t, EMVP:
! w3 L/ F# I6 Q2 K; K# ]2 d


PHP 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" ));
3 Y. H- b$ H* E3 N1 \if ( $mvp [ 'm_szName' ] != "" )
( t8 }2 @# _* E* I3 F& h( @* vecho $mvp [ m_szName ];
; ~6 H+ V) {. o, ielse
* E9 K6 O0 ]( Iecho "-" ;
?>
: Z, U/ g. Y) k# \  B0 cGuild Winner:
! \, U/ F; T* k, U% W% A


PHP 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
9 I6 v/ ?! Z% i1 P0 u6 T7 w+ Vecho "-" ;
* k" |3 k5 m% Z! m  k0 z?>
# M6 F6 Z% P) A4 jDon't forget to like it.. Of course if it helps...
; q! z6 L+ ]5 C
5 F2 m) @$ F- b