公会得主显示脚本

admin

Lord Winner:


, k  a' T1 j8 ?3 [PHP Code:
<?php
2 _* a( o& l. D/ Q; `* H; Pmssql_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 ;
. B# E- V" ^* V# ?0 M. O0 delse
* N, N. K4 i, c, }& K; @9 {, V0 Techo "-" ;
?>
# [% W" g" G  RMVP:

! c' x' H6 q1 M1 w

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" ));
) E3 J% S$ v7 m4 y7 F2 ^if ( $mvp [ 'm_szName' ] != "" )
echo $mvp [ m_szName ];
else
echo "-" ;
" K" t2 m7 \, y, S/ r?>
5 n; p) a* w% k+ _+ RGuild Winner:
: a  `' v% A0 W' t: Z" h. D

) v8 H+ H2 A! H1 m
3 J; g& W+ B. N) t' yPHP Code:
0 x+ n$ K  v. _' N- @$ @4 \<?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
/ T3 Q# r- b& ~- s& eecho "-" ;
' h$ b/ q  T& G?>
+ V- l1 e& {( rDon't forget to like it.. Of course if it helps...