公会得主显示脚本

admin

Lord Winner:

3 D, g8 {) a6 [( ^
0 u! f. p7 j; {- W3 E2 Z5 o+ I' wPHP Code:
<?php
mssql_select_db ( "CHARACTER_01_DBF" );
5 n0 w( _# C0 ]: M, z- ^9 @3 L$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" ));
2 K9 H2 ?5 G7 z4 {4 ]2 _) Q/ ]if ( $lord [ 'm_szName' ] != "" )
echo $lord ;
else
echo "-" ;
?>
MVP:
" M2 a. Y" x# `
) H" f, @9 W; f/ D
, P/ R# Z. K6 P
/ e$ F* \( R7 EPHP Code:
" {3 G+ ]$ u- t- A<?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" ));
+ `. M3 S/ F7 F( i* c& f; ~9 h, @; }if ( $mvp [ 'm_szName' ] != "" )
echo $mvp [ m_szName ];
' r, z* N# `; u5 D: z! Z; Helse
echo "-" ;
?>
Guild Winner:
0 J# Q  F+ f, ]# t2 q1 L2 o
( K, U: L  u7 l! J; T, p( _5 v
0 u" G% n3 q; K) T, s9 o* c  L2 S
PHP Code:
<?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" ));
( r- l+ A" y; ?% t% d- M& Iif ( $crown [ 'm_szGuild' ] != "" )
echo $crown [ m_szGuild ];
else
! U/ f8 r3 R- D- l6 vecho "-" ;
, [( t3 S6 L: L6 Y?>
Don't forget to like it.. Of course if it helps...