公会得主显示脚本

admin

Lord Winner:
( E2 ~* K2 M5 G

( d$ i7 X: q, F* U$ B% h2 L3 o6 @PHP Code:
<?php
mssql_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' ] != "" )
/ e+ V) s& B7 X$ s' }# U: Techo $lord ;
else
echo "-" ;
, L1 K2 W. \% l2 z9 Z?>
MVP:



+ `# |, o8 u+ B* A  s; G9 uPHP Code:
) r' c' |) r% p! f<?php
. y3 y: L' {( W$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" ));
if ( $mvp [ 'm_szName' ] != "" )
( o: B- \7 `( O. v+ \echo $mvp [ m_szName ];
/ ~4 \: {  m/ f% n. [else
echo "-" ;
5 n3 f/ [; P- R6 a4 F?>
Guild Winner:
/ L  r( ?8 X( R1 _
( ]* v& l: L8 G- T

PHP Code:
0 h5 F: _9 O4 }0 d/ Q2 v) T  i<?php
4 Q+ E% y  L# h' h/ }$ [. M" j  O$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' ] != "" )
3 M0 s# U9 ?) e& w4 Recho $crown [ m_szGuild ];
else
echo "-" ;
4 `/ k4 H0 r( {* y?>
# G2 W( H8 A. ?4 EDon't forget to like it.. Of course if it helps...