公会得主显示脚本

admin

Lord Winner:


5 a' R1 g8 z) G& G* K6 QPHP Code:
7 h  o, O7 u3 V<?php
mssql_select_db ( "CHARACTER_01_DBF" );
* C5 y8 E: P4 }- m/ O2 L9 S* M8 ?$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' ] != "" )
* a- [; S' t* Zecho $lord ;
# t2 k7 b& }3 H8 i& y7 Gelse
echo "-" ;
% ?8 ^1 c1 j; H* B) ~?>
3 N2 f/ U  U# }MVP:

. @% e4 g1 G% ^! N5 p* l7 ~. D

- X2 Z. s. @+ G# T( ^5 V6 ~' sPHP 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" ));
/ }. Y) H" h4 s1 C! x4 pif ( $mvp [ 'm_szName' ] != "" )
4 Q8 T( b) X' |7 q: M2 Hecho $mvp [ m_szName ];
else
) A& b& N* i- ?5 q8 {- i/ J, f5 lecho "-" ;
1 S1 b9 g- b, f?>
( Y8 Y6 O) k& g, ]- V. eGuild Winner:
9 b0 t5 c5 Z: ]1 z/ O. r
6 A; f* E3 C. |# d( Z  I

PHP Code:
<?php
& t9 m8 w* s7 N0 |$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' ] != "" )
7 j  \$ Q1 e8 Necho $crown [ m_szGuild ];
" e* n8 ^3 c1 u1 e! telse
echo "-" ;
?>
Don't forget to like it.. Of course if it helps...
) R  V) a1 _) |# x