飞飞世界论坛
标题:
公会得主显示脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:23
标题:
公会得主显示脚本
Lord Winner:
. t% S& B3 c( T9 p' i: J4 d+ y
* J, \, C8 [2 A6 z' h3 q! x) d
* \6 s2 S$ [( v
PHP Code:
6 f. O' `3 X( R6 H1 }
<?php
6 k9 L- \ P6 o! L, K* x' I( Y0 k
mssql_select_db ( "CHARACTER_01_DBF" );
7 L& [* C7 q( h" h 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. T$ V. M0 k: p
if ( $lord [ 'm_szName' ] != "" )
, ]6 ]; _$ H0 Y. Q
echo $lord ;
) ^; j5 u4 r* k; C. }
else
, S" @& y6 g9 W
echo "-" ;
: y+ D# B$ n" } N) E
?>
( B1 b. Y; S& ]
MVP:
7 K$ _# }# J+ c8 q: z2 a8 ]: v
1 ^- I0 h! A5 y
: d: ~3 N# I8 `* L% y4 N' E
1 F$ K3 w. l5 ^: R1 f
PHP Code:
' O# R9 |' K, R& [ c4 W
<?php
0 ]0 T6 D9 R& h# @$ F: |
$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" ));
+ R3 c; p' g n& D5 I$ g" h
if ( $mvp [ 'm_szName' ] != "" )
y _3 l" l" {' v9 A
echo $mvp [ m_szName ];
7 m. L4 a8 G; f; n' o) B
else
d! c6 k* c5 a6 d( {- \
echo "-" ;
& r) x ^" `8 `% _- l v9 g: [; a; f
?>
% }7 r. Z9 o6 R6 W; v7 F
Guild Winner:
5 n/ N4 V1 h: @
' h# M8 o! h3 F B! V( I
5 K9 V$ y- Y7 d
8 O7 u, `7 X' v' r0 O
PHP Code:
. L @- o! w4 _ e& ?- }% A9 V
<?php
) {4 ?" ` T( Y+ E' ] m$ Z; t
$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" ));
# O2 O( `1 A3 |- `+ Q
if ( $crown [ 'm_szGuild' ] != "" )
& K# g9 x, L+ B% ]9 r7 Z
echo $crown [ m_szGuild ];
. ^) o+ a c/ _% g' \7 }
else
% s3 J+ J6 V. S! D* |) J
echo "-" ;
) l3 P/ f) a! F
?>
% _3 ~$ b/ A+ H M2 A) \( n) @
Don't forget to like it.. Of course if it helps...
2 p/ _" ?1 [* m" `3 M |$ f
: V( \& P/ |, E* b, `0 Q
欢迎光临 飞飞世界论坛 (http://ffwold.com/)
Powered by Discuz! X3.2