公会得主显示脚本

admin

Lord Winner:


PHP Code:
( }( V; t7 g9 ^; A8 D<?php
2 ~: i  Z/ O; e9 T: Q3 wmssql_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" ));
# S, c9 c* [/ uif ( $lord [ 'm_szName' ] != "" )
, T% W0 s( T- A9 G6 m+ ?9 O" |( _echo $lord ;
1 Q' `# j, n6 qelse
0 s, c) \# U) p$ h; K8 Yecho "-" ;
* U; q* I: T, E& I8 \7 C) c. q. D?>
1 f* t$ F9 o( D' W- |MVP:



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" ));
4 ]6 y9 A8 d8 ^& Pif ( $mvp [ 'm_szName' ] != "" )
$ p& \9 ^' R. {& S# {; w# lecho $mvp [ m_szName ];
  s' R& [. J( W! [* \  X% b4 Melse
echo "-" ;
?>
Guild Winner:
. q; }6 h/ s* V. U5 A


PHP Code:
, V7 I1 l7 {: N" U7 f( x+ u. J2 ]% b. q<?php
& S9 {- r( ]; w: h) I$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" ));
; k$ |8 U  O/ O* M7 f# \if ( $crown [ 'm_szGuild' ] != "" )
5 f0 N8 r$ ?# ?7 p) @. i. Cecho $crown [ m_szGuild ];
1 [% ?# k1 B! r4 }( b5 v) Telse
echo "-" ;
?>
Don't forget to like it.. Of course if it helps...
/ N: e" H: M' o9 B) \' U! I
, r  _# I  H7 b% o