公会得主显示脚本

admin

Lord Winner:

( V7 q3 }+ _, N! o) W# H2 w
1 a$ `6 l7 ~( c3 n0 B. y9 `PHP Code:
' ?& R' U# `% M. {! w. C<?php
* r& b' Y1 ~  S) g! V" hmssql_select_db ( "CHARACTER_01_DBF" );
' Z$ m  i3 I  j+ ^. Q& _* a$ @+ r+ ?$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' ] != "" )
- x- Z7 Y) ?7 {# `7 Decho $lord ;
9 S* ~  A& d0 ^5 X: n; yelse
echo "-" ;
?>
) t2 \; O% p- A+ GMVP:
" s+ j6 T4 x7 y! v- Q- A) F
5 x4 b* }' M! K
2 y$ \- c) ^8 S& F' `/ v
0 I6 H! j- D! zPHP Code:
8 y/ R, v$ ~# G<?php
0 _' \5 V1 H/ |9 y+ K  m$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" ));
2 D" I3 B5 ^' \if ( $mvp [ 'm_szName' ] != "" )
echo $mvp [ m_szName ];
7 K! g, ?" [1 D1 {" }else
echo "-" ;
& b8 E6 \, P9 k7 Q4 @6 R1 }?>
Guild Winner:
! [. [0 h* z4 L  m7 L8 e( ]3 o
0 s4 W  |5 W% X6 d% _; m# |* ?
5 W! }* S2 L+ Z3 x- G
5 y6 e- K+ G1 p  B8 i6 q7 MPHP Code:
<?php
0 g2 V; A  y5 S$ F% c$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' ] != "" )
$ R9 @0 Q6 b( fecho $crown [ m_szGuild ];
else
echo "-" ;
- w5 s: X( B" m" q# ?: \& E?>
Don't forget to like it.. Of course if it helps...