|
Lord Winner:
7 o3 Y- ^+ u6 B ]* y
: s6 C% M! ~7 f# K/ U! A) w- p& G) ^
PHP Code:
& L1 B+ b0 _6 J3 a0 v<?php ( v V2 |7 m* Y! y* B* F
mssql_select_db ( "CHARACTER_01_DBF" );
V) ]0 V+ R: u; O4 G- k1 y$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" )); * u1 T8 u* y0 o; h
if ( $lord [ 'm_szName' ] != "" )
$ S* H7 @) Q. X p: @. o# Wecho $lord ; % z2 ~' C- u& j k" Y2 B
else
1 t9 h+ I" I% }- N) Mecho "-" ;
% d3 a' o: E/ [- g7 q?> ' {8 ?; D) v. J+ J
MVP:
+ p* N4 f2 G2 W9 @3 t; w6 T$ w/ P: G+ F( G
8 \' k8 s: n* ?1 s$ [; L
6 B4 U% K, Y- b6 k& bPHP Code:
4 ]$ i1 G/ v, b+ t; p' f2 \5 O<?php
. o, T. c! u4 L$ P2 }3 ?3 C$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" ));
- {/ s" _0 z% t- oif ( $mvp [ 'm_szName' ] != "" ) + t1 [' X3 n& B5 S
echo $mvp [ m_szName ]; # r$ K& F: s6 K, ]5 V# m; W
else ' x! \6 n+ T: _
echo "-" ;
: B2 a) w( z5 f( P! q/ s?> 3 N: H1 \5 K4 R9 q
Guild Winner:% f2 B2 o& B7 y. ~
6 h5 ~3 l- I- |. j9 U% X
: ?+ ~7 _9 q# h! l- k: X) y. N* b _8 V0 e6 Z$ L
PHP Code:! L) K6 d3 t1 J1 q. p' E
<?php
) u* }" l# Y; u2 ?* J$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 ^" U; l7 `( dif ( $crown [ 'm_szGuild' ] != "" )
/ Y9 @7 s3 W) {6 I8 Cecho $crown [ m_szGuild ];
; L- \+ [7 d% oelse
+ S# u, h! t& j, t: V4 recho "-" ;
2 n8 A/ F0 u7 W?>
5 F: q8 b8 K3 aDon't forget to like it.. Of course if it helps...
" I5 O1 H5 c% a( w0 Y, p G0 u2 v2 `: |0 r
|
|