|
Lord Winner:
( V8 C* l' O: n ?$ w( l ~4 x2 {, p2 k
- T$ ^8 _3 ]/ N) T/ oPHP Code:* V, }/ _9 g0 D8 @- a1 t' S
<?php
, P8 N& K5 i" mmssql_select_db ( "CHARACTER_01_DBF" );
- `, W( ?: g4 a( W$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" ));
& H6 S/ l* v6 a% \1 oif ( $lord [ 'm_szName' ] != "" )
& r6 S. P' H: X9 r0 E% Q5 fecho $lord ;
5 V- k; P1 E) v- Xelse % s# `9 u" u" a. l
echo "-" ; & }1 l. |1 e; Q2 g; M r8 J
?> " V7 @+ H& x# [# ^0 C# D
MVP:. H( E( L7 r* K& K$ _; s* I+ d
! J1 L$ h! x( v' M
: Z/ {9 m0 a _- q c
0 }6 T, a2 @9 ~+ z& i J: B0 Z& PPHP Code:
+ S4 U0 t1 A/ S, E2 F<?php & v% i p, D9 {
$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" )); & c( u* g9 m- J- ~" \) Z
if ( $mvp [ 'm_szName' ] != "" ) ! a6 a8 a* O: K4 \' ^% n: K' F. B
echo $mvp [ m_szName ];
) J; y8 \4 T4 p7 z7 nelse
8 c2 @6 E c- f' o8 v& necho "-" ; ! z$ n0 L7 a1 }; Q/ Y$ z
?> + s" E, h" R% k" d9 l6 \
Guild Winner:$ k# R2 U6 G! X" k
% j. W9 p4 k& ^9 Z! w) U
& ]# U d6 J7 P
9 K# y( E3 g" i& C0 {PHP Code:/ H/ e) `- N) l6 U
<?php
8 w! O/ m) J! ]* j. I) m7 j$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" ));
7 A/ A! }4 B" M* U" m2 Y) yif ( $crown [ 'm_szGuild' ] != "" )
. D$ m$ A& ~3 X; a' B9 Z8 J7 N6 _echo $crown [ m_szGuild ]; $ [4 @, q8 M3 b. W* L) A5 W. ]
else
5 B; Z/ G# K" }) }: @9 o' J" Recho "-" ;
2 P2 _1 g2 Y% E! ~: I2 y6 `: ~4 \?>
* X' g! T* @3 F3 f( c- VDon't forget to like it.. Of course if it helps... 4 H" R) r9 r5 e& r8 @
6 E/ P- f8 J$ R9 S
|
|