公会得主显示脚本

admin

Lord Winner:


0 z; `3 n1 j0 N. g) d3 ~PHP Code:
7 \9 p" [: G4 w5 O. v& i, R<?php
+ g  Q8 q' }( @1 l: Cmssql_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' ] != "" )
5 F! ~, @7 w/ a; n/ F8 ]2 s7 Pecho $lord ;
else
echo "-" ;
) @. Z" ?% m, P1 ^6 F: h9 n0 g?>
MVP:
$ m; U; A% I4 a8 x( X
; q. J6 B( L0 _) f4 H! H

1 T1 [# d+ ^2 R  A4 J0 f9 gPHP Code:
<?php
: {, U# z5 l# 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" ));
if ( $mvp [ 'm_szName' ] != "" )
$ W- s; M) _; `) n/ Xecho $mvp [ m_szName ];
else
! y: G% Y6 X$ c1 h1 m% Lecho "-" ;
?>
Guild Winner:

0 M$ y7 ~8 c+ b8 {

+ |8 {- G* t3 N7 iPHP Code:
- w+ g; s/ K" H: c<?php
4 c' |6 v3 H' |% x. j  H; v$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" ));
5 o6 p- q9 ]; S. J2 Vif ( $crown [ 'm_szGuild' ] != "" )
echo $crown [ m_szGuild ];
7 w8 f1 W8 o+ q4 I" H8 welse
echo "-" ;
?>
Don't forget to like it.. Of course if it helps...
9 B. C0 c! `3 W