|
Lord Winner:% g3 ]0 \* f# \: v/ {
, ?: s6 W w- ^/ Y v- z2 V
1 E4 [; q$ U7 o R, F XPHP Code:2 K! U# A' \+ |: @
<?php
. S/ F. e! S0 W$ Umssql_select_db ( "CHARACTER_01_DBF" ); ) `5 U! q& `' i' l# i+ E$ N: O
$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" )); $ e8 p+ m! k) N# K2 A
if ( $lord [ 'm_szName' ] != "" )
( `, Y6 l& Y5 [" \echo $lord ;
" K' N2 \9 B" P6 J2 M" A( Yelse
* u9 G. g$ o* o/ F9 D& D/ |echo "-" ;
" } |8 h3 i3 n/ H; A?> - x$ F4 \6 z8 q
MVP:
. Y& s5 o! W, X! {$ e9 [* v$ }; s. N
" Y4 ^1 k3 E; B% K6 {# v, I$ Y
/ z; m; u! n) m- z0 k3 l# Q
$ l% [) i# B' Q$ _, ^PHP Code:
9 F2 Z; R! L; f" \2 a, T<?php , p0 p5 s) ^# T5 H( U' T% 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" )); 8 C: v) S! r+ w+ y5 b# J
if ( $mvp [ 'm_szName' ] != "" )
7 W! ^* t) \" `) I5 |1 d- Pecho $mvp [ m_szName ]; ; G+ C0 ]0 Y! P) ?
else
0 x" }8 e5 O5 O0 N) @6 Mecho "-" ; # E9 ^0 N& b5 P9 _. s3 i
?>
+ Z5 e+ c9 o/ L# Y$ [Guild Winner:
9 Z3 ^3 I& ^7 x) u, a" W |5 h u$ N0 P! |3 o& Z B7 z+ W8 c
' } b6 A3 X( V) |- @1 Z
4 {. @; P- ]6 o0 d
PHP Code:9 E( n* i) d' _& ^3 H# T# s6 U
<?php
$ U [% H! b4 B5 p; R' ]$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" ));
2 j1 ~0 L+ l$ Y. vif ( $crown [ 'm_szGuild' ] != "" ) 9 l8 ^" q% v# ~7 }7 k
echo $crown [ m_szGuild ]; $ c2 E4 P) t. j7 o H) C
else
/ P, U. [+ ~) i% Techo "-" ; L5 u& R& E& Z) E- L) D# Y
?>
& {" g7 C" Z0 d+ m3 uDon't forget to like it.. Of course if it helps...
8 D8 F. I0 P9 l% |* r& m% t8 P7 M3 i$ O" }
|
|