|
Lord Winner:
, { m/ a' m( c9 R8 ], n2 G1 q: k9 h ]* G9 M5 w
( U9 W1 A$ f; L$ Y6 W
PHP Code:
' d5 U6 m" K' ~! z; j4 K<?php % } v; w0 ^: Q( Q b. u
mssql_select_db ( "CHARACTER_01_DBF" ); 6 G7 D! O0 [0 `2 N% D
$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" )); [% z5 f. P" C! G- Z% {
if ( $lord [ 'm_szName' ] != "" )
& x5 ]$ A( o2 k, H) O9 A2 s5 zecho $lord ; + m) L6 a6 `( M8 V C2 c. D0 t( F
else
# r1 n9 a& F& ^! r( _) [echo "-" ;
0 C( Z7 U1 Z9 D' G5 q?>
/ r5 e# E/ M$ {* y8 A2 oMVP:) J' ^9 T' q3 p% E- c1 l
5 `# g4 m/ @3 ]) x! X
* H0 h) M+ o+ R* `1 n4 H+ z
% g+ u/ E% X+ @ t# \( kPHP Code:
1 z9 D2 _4 B! U4 k<?php
- {# B8 v5 P, n: I$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" )); ' O, O7 a2 Z; g, x" G' g( R
if ( $mvp [ 'm_szName' ] != "" ) / g# }$ X& N' |1 N9 L" D
echo $mvp [ m_szName ]; # U" n: o5 ~9 F3 y
else 4 f1 k8 h$ w! z0 `
echo "-" ;
- D0 u9 q! k, M?>
+ S. `5 W" ^" v2 {5 L2 vGuild Winner:# x0 k$ t/ O$ g
( Q- A1 O7 }% B5 u% Y2 w
5 [: h' y/ |7 b6 b% g7 n* \, }
- Y4 D2 k& }9 h. P/ s+ o
PHP Code:
( S2 y0 n' d9 ^$ b+ T5 B<?php 5 g- J2 a& V' i0 C2 e! c
$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" ));
! Z0 l4 w3 p8 d/ jif ( $crown [ 'm_szGuild' ] != "" )
( @1 m6 @, z- C5 l( N2 H; Uecho $crown [ m_szGuild ]; , l+ r4 W3 e' b0 B9 z* {$ _
else
/ z( J5 T) G6 ^( }5 e- t0 y0 eecho "-" ; ' u3 e. B' t7 d. {, U
?> . u; l: _+ G& x) A
Don't forget to like it.. Of course if it helps... 5 g7 P7 w- q$ Z* m7 c" D3 ]7 I
) ] f8 ?8 G' A) K+ t6 ?, P! ~ |
|