公会得主显示脚本

admin

Lord Winner:

7 T. m7 m& {& J/ T; E3 q
! E5 L5 H( |# I+ h2 hPHP Code:
/ {0 n' t1 o; \  [" x; O2 p<?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' ] != "" )
echo $lord ;
else
9 O" R$ b  ?; f5 t8 Yecho "-" ;
?>
$ D+ X6 p: X3 R3 w9 ]; c& OMVP:



PHP Code:
+ D( h! W1 P% T7 G) s<?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" ));
if ( $mvp [ 'm_szName' ] != "" )
/ c" ^. `4 C. ^% j- y' ?echo $mvp [ m_szName ];
5 _) N4 ^& ?% T: N7 ]7 aelse
echo "-" ;
' V) z. ?  H( b* k?>
* o# ~' t; z: }& _' ^* yGuild Winner:


: f0 Z- J* S& B/ Q1 P$ o
PHP Code:
<?php
. i: V7 s8 k" T, ~! v# m0 f$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" ));
0 M1 M- b; H! z$ @5 y" o1 wif ( $crown [ 'm_szGuild' ] != "" )
7 ~# g$ T* ~2 w8 p$ X; }, necho $crown [ m_szGuild ];
else
echo "-" ;
* `" U9 G8 m) D; o, h?>
2 B5 m- |9 l; _1 g' K4 Q0 QDon't forget to like it.. Of course if it helps...
7 r6 o0 U6 b% `* @9 ^! t" R. H