|
Lord Winner:; h$ _, V* j" H$ A
6 M. r7 ~4 P' i1 ]
" Z6 U8 o! n0 b4 M4 o! Q ^
PHP Code:
( v* u5 t: z' V4 F. K* p7 C+ s<?php
' a1 W4 ]+ g3 t9 Q, ~& j. Emssql_select_db ( "CHARACTER_01_DBF" ); , k) z. {% V9 B" b$ Y; N. r
$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" ));
3 a( g, q# C, R# N- C+ K0 lif ( $lord [ 'm_szName' ] != "" ) ( O+ k t6 s/ r; G& O1 |6 U6 L
echo $lord ;
. c( x( V# O, R; M1 W: gelse 4 w& M) t8 }% ?+ K; ]7 T
echo "-" ;
+ r2 j7 F, r7 ^% G! e; g?> & o2 `3 K$ d+ C% x
MVP:
: |/ i* i" U4 h |( L- N P5 k, ?# g' e7 C5 S( g
3 i6 z9 Z h9 V5 k: A/ O
+ f8 d C$ d7 f$ J% E4 U. vPHP Code:( e3 e/ ?* S3 O5 T- c$ J0 E+ g
<?php
( T$ ]- \8 \/ Q7 N& Q+ q$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" )); 6 [1 l$ [8 `6 F7 T' X
if ( $mvp [ 'm_szName' ] != "" )
2 B1 W' {) K9 d, n$ Iecho $mvp [ m_szName ]; 9 E g# x$ ^8 N _$ Z
else
$ F( [* `+ f, Z/ uecho "-" ;
. O# U# ^6 L+ S& U2 H1 A?> 3 D3 @' Q0 f2 d9 Q0 ^' f: h8 l
Guild Winner:
! T. D1 r% M& B Y! A8 G _* ]( R# `- h
- \0 X) d% y0 c4 c5 M g
2 S3 I3 e! M2 T5 nPHP Code:
& r2 d- K' x% j) ~& n+ h3 m<?php
+ s" d, a( _" Z, b4 ^6 n; b: _' F) y' _$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" )); 4 n' x; N$ ]/ s3 C7 Q: R! `
if ( $crown [ 'm_szGuild' ] != "" ) 9 g% I9 F, I" D2 `0 P/ M
echo $crown [ m_szGuild ]; ! k d1 o: f9 @8 i' u& L
else
, I6 l/ W5 d+ i b' {. N' |echo "-" ; ! I/ e# W# y! Y- A
?> : K- G% B, {- Z7 ]; q; Y8 D* [( h
Don't forget to like it.. Of course if it helps... 0 i8 J) z0 m) J$ k
8 m1 M- o$ h( _' y7 ]
|
|