|
|
Lord Winner:
5 \/ U. h+ [& a: x+ r& R2 B9 e- K0 s L3 X& v9 x' O
- n. R5 ?# u: x
PHP Code:5 H# J$ N5 F5 d. v" q0 Z
<?php ; j) I: U& U+ X% n1 k3 O$ X, P
mssql_select_db ( "CHARACTER_01_DBF" ); 7 I! _0 k# ]' B9 C# m. E. |
$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" )); ! T3 l, _- T h9 w
if ( $lord [ 'm_szName' ] != "" )
* c- a/ E2 v0 o0 t3 wecho $lord ;
+ K; s' m# S2 k& N( Xelse
% `9 C" V, q$ f0 i5 J1 M0 fecho "-" ;
% Q9 T0 S# G2 L+ b9 o. D# E, `?> $ p5 T5 f z. \% b9 Q
MVP:5 w4 n, S9 N" v! W/ S" ^
! b! U; i* u3 L/ E: R
- W: a' T8 B M7 K, [" r
* K5 x$ Y% X4 A+ B
PHP Code:7 i2 _# E* C" }) R t
<?php $ f4 S# T" J6 n. y' f9 X, S: ^" Z" K+ `
$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" )); $ k1 A. j1 g/ g# u8 |# U" f) Y
if ( $mvp [ 'm_szName' ] != "" ) 2 y0 b5 m: B6 Z7 I3 N$ ]9 a F, ^8 ]% [! G
echo $mvp [ m_szName ]; ! y/ ]" ~9 M4 }2 P
else 0 M. R; U3 f; @+ D/ Q$ M
echo "-" ;
* N& V6 R' J# L, E( D3 N) K?> & w' d- ?9 F" [2 x) a
Guild Winner:
7 ? n2 G6 m) l+ X+ q# s7 g0 j8 d: X- W/ q
2 t7 Z: T9 B9 K$ l0 s
# s4 e; Y) ~5 `% W u' oPHP Code:
7 L( F: m6 Y' {: f<?php 2 A5 P2 W8 m. R1 D. j5 z; _: Q! B
$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" )); 3 @" G( a y1 g
if ( $crown [ 'm_szGuild' ] != "" ) $ v% X3 W& q! ^ Z0 Q
echo $crown [ m_szGuild ];
* O$ }: Z; I' j! X7 kelse , J5 r# r! `. p4 a
echo "-" ; 4 t. v. V- @2 ^
?>
: L& v- n' _6 K: }4 h# NDon't forget to like it.. Of course if it helps... 7 M- F4 x, E/ g+ F8 W' ^1 B& ~
+ k E# k5 C( r, k9 \# b j
|
|