公会得主显示脚本

admin

Lord Winner:


PHP Code:
: Q8 Z- E8 O; G1 x; G3 e) y+ ^# w<?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" ));
6 E- t6 E8 b" f% N$ o* oif ( $lord [ 'm_szName' ] != "" )
* c0 p( r) M- ^0 Xecho $lord ;
* S/ s$ }$ v4 L* I6 w/ P& i( Welse
echo "-" ;
?>
MVP:

3 N9 g) U9 P* `* z

( W0 u1 z" S3 v4 D3 ], V( _PHP Code:
, @/ k" J' n3 P<?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" ));
if ( $mvp [ 'm_szName' ] != "" )
echo $mvp [ m_szName ];
else
echo "-" ;
. N3 z5 w# i2 n& t. o?>
: M2 }1 G8 f3 ?/ j( F4 ]3 CGuild Winner:
% U1 p0 Q! Z! e


PHP Code:
. o8 v- O, x. C<?php
1 C5 K4 @% U6 j0 X$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" ));
0 m5 A6 n; F; f9 g1 e" @" |/ h/ G6 tif ( $crown [ 'm_szGuild' ] != "" )
% U+ P9 B# b/ e  N: Pecho $crown [ m_szGuild ];
else
echo "-" ;
?>
" a+ N5 B: q2 A% f! sDon't forget to like it.. Of course if it helps...

& d* ]6 ]# ^& Z- a3 O- B