|
Lord Winner:
% N* D: X% Y: A- L
0 p( e& c6 j: B, F
% o9 H p5 k" \. l$ x' JPHP Code:" X' r( I1 h+ m- M. q2 k
<?php
8 y I: K4 V' d7 Smssql_select_db ( "CHARACTER_01_DBF" ); 1 W# o! E# Q" D' n4 e) h
$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" ));
?( Q9 ]8 E* L |& Y1 eif ( $lord [ 'm_szName' ] != "" ) % r. k! o6 E, y g
echo $lord ;
2 K* s( p3 ?/ e8 Z( Q, \% telse / m# T/ L2 s5 h( o3 M
echo "-" ; 8 q$ @$ w' @, g, B- E) k5 t# r
?> ' I" P: c! a$ Z! r
MVP:
7 f7 ]% [: [& q1 h7 N* z/ H5 n
& L: X$ D% | n6 U+ n% T$ e1 B9 x) b+ [5 V+ M! J
# D8 u0 J1 x2 | F7 D% C6 U8 t8 ]8 @0 kPHP Code:/ m9 e* n. A, B! G; m B
<?php + x$ P7 l1 \+ H1 E7 y
$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" ));
, \) h7 o* r4 W% g# ]! }if ( $mvp [ 'm_szName' ] != "" )
* t* E/ q0 S4 I t$ p8 fecho $mvp [ m_szName ];
( i: i; u0 D6 V7 k% Kelse 4 g; j) ]" L) @2 V: o, U
echo "-" ; 9 T$ ?8 b5 E- v" o
?>
0 l1 \- t$ {: ?9 n: iGuild Winner:
& T7 w4 R+ S! E) M
! P' J! V C: N, O
" V2 s7 {$ T0 t$ C; w, g. X3 m6 P% \) M( @) S
PHP Code:
4 X$ f6 b' N7 J1 B<?php
- v& h& s7 i& ^0 o) ?7 O6 g5 ], d" ?$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" )); + W; X" b; {3 C! ?+ Q y
if ( $crown [ 'm_szGuild' ] != "" )
7 X9 u1 ~+ x! D/ K. m' f. kecho $crown [ m_szGuild ];
: a8 K. c8 S4 z2 `else
: \& O, D- ~) U! d3 x" y8 K, Recho "-" ;
6 ]* y7 y8 X& m?>
7 \$ T( D9 U# o! D& H* tDon't forget to like it.. Of course if it helps...
& w( s: o B9 \1 h: W/ |/ n: `! c8 j* X
|
|