公会得主显示脚本

admin

Lord Winner:
, {  m/ a' m( c9 R8 ], n2 G1 q

PHP Code:
' d5 U6 m" K' ~! z; j4 K<?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' ] != "" )
& x5 ]$ A( o2 k, H) O9 A2 s5 zecho $lord ;
else
# r1 n9 a& F& ^! r( _) [echo "-" ;
0 C( Z7 U1 Z9 D' G5 q?>
/ r5 e# E/ M$ {* y8 A2 oMVP:

5 `# g4 m/ @3 ]) x! X
* H0 h) M+ o+ R* `1 n4 H+ z
% g+ u/ E% X+ @  t# \( kPHP Code:
1 z9 D2 _4 B! U4 k<?php
- {# B8 v5 P, n: I$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 "-" ;
- D0 u9 q! k, M?>
+ S. `5 W" ^" v2 {5 L2 vGuild Winner:



PHP Code:
( S2 y0 n' d9 ^$ b+ T5 B<?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" ));
! Z0 l4 w3 p8 d/ jif ( $crown [ 'm_szGuild' ] != "" )
( @1 m6 @, z- C5 l( N2 H; Uecho $crown [ m_szGuild ];
else
/ z( J5 T) G6 ^( }5 e- t0 y0 eecho "-" ;
?>
Don't forget to like it.. Of course if it helps...

) ]  f8 ?8 G' A) K+ t6 ?, P! ~