公会得主显示脚本

admin

Lord Winner:


  u# s) X$ ^$ Z& F) x$ wPHP Code:
<?php
- ]- D! e' i; l! z1 |$ ?mssql_select_db ( "CHARACTER_01_DBF" );
: E/ a9 k, [5 x$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
echo "-" ;
& Z5 T# J! ^" c& g?>
MVP:
  c- m) e- R0 h3 z
' [7 d0 r/ U' v0 p
! ?; o  X' S$ x; X# Z7 a. e
PHP Code:
# C' D8 R; M3 ^# G: b, T4 ?<?php
# Z7 f# ]' A, C5 L2 n. T: T$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 W, G. X- g! N- S( n7 Pif ( $mvp [ 'm_szName' ] != "" )
+ N9 p. c' y: h) k# e$ L# hecho $mvp [ m_szName ];
else
! N! Y8 Z  `) K! u2 J, h5 Uecho "-" ;
' m8 w2 w( j7 u/ A/ y9 x?>
Guild Winner:

& h+ q* h$ W3 A* n% N! n
9 J( j8 [( K! @5 W2 S
PHP Code:
; a. N: ]. q9 o: W( c+ b( K& I& I! ~<?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" ));
( {1 M* g/ D: j, G- aif ( $crown [ 'm_szGuild' ] != "" )
echo $crown [ m_szGuild ];
else
echo "-" ;
?>
; b( F; `9 o& ~5 A. G0 DDon't forget to like it.. Of course if it helps...

; K8 W" \* V& h