|
|
Lord Winner:
9 ?: `, ^9 o7 j M/ D2 @3 l% {+ h4 ^) H: G# @& O6 y( S# H9 j
6 p( M7 B: O; I" K; ^( mPHP Code:" D7 q' i8 k/ u& r$ n4 R/ s
<?php . \- B9 O' _- U3 f! u
mssql_select_db ( "CHARACTER_01_DBF" );
5 Z0 ]* S9 B$ e& s$ N; L5 g1 B$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" ));
1 k* Z3 \% C Qif ( $lord [ 'm_szName' ] != "" ) . H3 K5 Z5 w6 B( O( K! ?* ^
echo $lord ;
4 B7 g: M6 S8 Melse . b/ N9 \9 V% k- ^# ^+ z
echo "-" ; : n- M% j, b7 X3 f) o( a2 @
?> + y: m0 ~8 n% b: y1 O, G8 N. L
MVP:
' ]3 K' x- b. L8 `) L! M
$ w0 E% N) O/ |! H5 I$ s \% j% @- ? [9 `& U; s/ v* Q U! I
1 D' ]+ g% x# \! m
PHP Code:
, P, O& e! f9 S2 x; j3 E6 X<?php . d7 b6 A1 q) b) v0 M
$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" ));
9 k& J9 m7 G2 V4 X5 x5 p* Vif ( $mvp [ 'm_szName' ] != "" )
! ~, s, ~$ }% Z, K" k8 a+ iecho $mvp [ m_szName ];
0 }1 \" m4 u2 u: J/ b- Velse
# f2 l4 F& ~: e* O6 R6 becho "-" ; 9 G( v' P* H) o4 V" V8 C
?>
) { f( K0 C) n- U+ S ~% ]2 B. rGuild Winner:/ W; n) O( K; q7 J% d) B$ A! G
1 s( ^6 M0 s; f3 w2 b
* a+ ]0 s8 q& @ m6 ]6 j
- e9 N% t7 Z s p% y, s. y* w
PHP Code:
7 W9 Y$ u: X# P$ @8 Y: S e<?php
, j. y' F1 u! A$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" )); , J* R* w* k6 J- C; n8 e3 q, {
if ( $crown [ 'm_szGuild' ] != "" ) 5 v, I3 I; E/ D/ r
echo $crown [ m_szGuild ];
2 C% ~% U+ U7 v2 ?1 X4 Selse $ i- w# N; P& a: m; _
echo "-" ;
% T' s- ^) n+ k" }0 X R! k+ M?>
1 l+ r* s5 u$ v2 }7 m" UDon't forget to like it.. Of course if it helps... 7 C" |: q1 N; h Q7 w
4 h; t# t$ Y/ J/ }$ r |
|