公会得主显示脚本

admin

Lord Winner:
9 ?: `, ^9 o7 j  M/ D2 @3 l% {+ h4 ^) H: G

6 p( M7 B: O; I" K; ^( mPHP Code:
<?php
mssql_select_db ( "CHARACTER_01_DBF" );
5 Z0 ]* S9 B$ e& s$ N; L5 g1 B$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" ));
1 k* Z3 \% C  Qif ( $lord [ 'm_szName' ] != "" )
echo $lord ;
4 B7 g: M6 S8 Melse
echo "-" ;
?>
MVP:
' ]3 K' x- b. L8 `) L! M
$ w0 E% N) O/ |! H5 I$ s  \% j% @

PHP Code:
, P, O& e! f9 S2 x; j3 E6 X<?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" ));
9 k& J9 m7 G2 V4 X5 x5 p* Vif ( $mvp [ 'm_szName' ] != "" )
! ~, s, ~$ }% Z, K" k8 a+ iecho $mvp [ m_szName ];
0 }1 \" m4 u2 u: J/ b- Velse
# f2 l4 F& ~: e* O6 R6 becho "-" ;
?>
) {  f( K0 C) n- U+ S  ~% ]2 B. rGuild Winner:



PHP Code:
7 W9 Y$ u: X# P$ @8 Y: S  e<?php
, j. y' F1 u! A$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 ];
2 C% ~% U+ U7 v2 ?1 X4 Selse
echo "-" ;
% T' s- ^) n+ k" }0 X  R! k+ M?>
1 l+ r* s5 u$ v2 }7 m" UDon't forget to like it.. Of course if it helps...

4 h; t# t$ Y/ J/ }$ r