公会得主显示脚本

admin

Lord Winner:
6 v$ q7 D7 _. B) @2 X
& O( n( p, \8 F* J, ]  u3 C
, w# ~+ X( \/ o# Q+ p' vPHP Code:
<?php
( ]6 y) E% X  ]0 z4 g# Cmssql_select_db ( "CHARACTER_01_DBF" );
% G5 B. u- w; Z$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' ] != "" )
* N6 y$ Z( |! R5 G' q0 [echo $lord ;
4 y. c3 ]* |* ]# `+ o, F  ?  telse
echo "-" ;
7 t3 a3 M/ ]& `/ U?>
MVP:

9 v' B. C0 t% A! g/ Q
5 }7 e. F/ }9 |4 F$ k& B
PHP Code:
<?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' ] != "" )
- u5 E1 Q$ @6 ~: y  Xecho $mvp [ m_szName ];
5 @! G, j# X$ O9 z( {4 E0 Delse
* G- O- f5 t; y' u3 ^echo "-" ;
?>
Guild Winner:
3 N4 O4 X, \& y* F- `) N) }


' d7 a; F7 h4 s" Z; N5 k: aPHP 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" ));
! W( ?* f: M4 C# {! m% Hif ( $crown [ 'm_szGuild' ] != "" )
% n* l& I+ V/ r4 P% d0 D/ z) iecho $crown [ m_szGuild ];
else
echo "-" ;
- F- G, c3 P: u* v. m" ?  O6 F( g9 Z?>
! R8 D5 \  m. ?) Z: fDon't forget to like it.. Of course if it helps...

2 X7 T$ b. n4 Q" M& M# i; i: j