|
Lord Winner:
+ O1 q9 w6 t1 h5 }2 ~
5 g% |1 \+ y, \# n' I+ [9 z) c& J0 Q T+ z9 @. V4 g0 G2 B
PHP Code:
- p% K! C1 E' y" _) Z<?php k) g& s8 l: Z- u6 v: r3 ^
mssql_select_db ( "CHARACTER_01_DBF" ); ' @+ u0 t/ `+ b. q9 a
$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" ));
; @' O) c8 Q* _. cif ( $lord [ 'm_szName' ] != "" )
2 t: x n. g% |9 zecho $lord ; ( w5 w: _% d. n/ a3 N' Q0 Z4 D8 |
else
4 Z" p1 E: _2 oecho "-" ; 4 p( L$ l, R* E7 ~
?> ' D1 }4 f. h4 M) j# f& \
MVP:
& F4 d9 [* N* V% @! c$ p8 R# q+ I! z7 A% e/ ^0 k) g( c
( Z7 S6 Z: k/ W& Y
: v% t& R. B- n% R& K+ wPHP Code:
, n# Q! O" w5 v# j: `9 p! M<?php ; Z! F2 r9 J4 g( X: w/ j5 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" )); ' y; E& c$ g" F8 D9 Q( D
if ( $mvp [ 'm_szName' ] != "" )
8 B3 r6 C- Y( j$ Z+ z! {: Pecho $mvp [ m_szName ]; / \, @1 C' Q6 e7 l5 u: W
else o3 \/ t* Y" ^, z2 |
echo "-" ; 3 G7 I/ V. ~0 V* z
?>
. Z0 S( P6 H0 VGuild Winner:& C! s; a3 p, j1 E S
( J/ m( W& B; N% u% H
& l& Q2 s) l# o8 t9 Q/ B( p( L8 |
9 L' F% f9 B. z1 h( K& |6 b9 EPHP Code:
. R- ?7 F. {/ F% T<?php
) Q8 i6 `' [8 E$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" )); ( I4 Y0 T8 s$ @, `6 i A
if ( $crown [ 'm_szGuild' ] != "" ) * P3 w/ A1 }- L9 u
echo $crown [ m_szGuild ]; " }% [. k/ T2 ^
else : z7 |0 n/ C \" `
echo "-" ;
$ i, ]% D& P/ O% D7 a. _?>
2 D- l: _ q8 d# B" HDon't forget to like it.. Of course if it helps...
7 G7 `) F; k4 |8 Y
$ v$ F$ Z# c; ]' d E |
|