飞飞世界论坛
标题:
公会得主显示脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:23
标题:
公会得主显示脚本
Lord Winner:
/ `4 @6 `" N# B9 D: k
3 k9 ^9 x9 t/ A0 o% j7 z
0 U1 v+ c" q5 z3 S, h, O
PHP Code:
5 o- a/ C2 M6 {' h. ^% r* k
<?php
# a2 Q& i6 b) C! B( J u- {3 K# {
mssql_select_db ( "CHARACTER_01_DBF" );
& n4 X; L2 ~7 B/ v) g0 d; o* Z! k
$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" ));
F( @$ b4 p& ~# w0 |; E- g. j
if ( $lord [ 'm_szName' ] != "" )
5 C" E9 _3 ]4 v& F3 P! B8 U/ [
echo $lord ;
" G* V7 t q7 D+ I. @
else
1 n0 @1 n u; v1 b! x; ^
echo "-" ;
# |" T8 s$ A, k# m+ a$ z
?>
" W ~& ^2 J) ^9 j' V1 \1 U
MVP:
$ }: k3 G% L3 @6 y# K& ^* U+ o
6 g1 }) i& @, Y6 i, u8 y0 D0 C; f8 k
/ p7 [6 U6 T9 S' T! R5 z0 M7 h
$ U% H8 r% P% Q% ?! i* G
PHP Code:
1 h% z" w) _! P
<?php
) b( \7 x S! @! Z g3 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" ));
- E4 t0 s. w( ^9 V
if ( $mvp [ 'm_szName' ] != "" )
/ d& w! w3 Q' E) [* k8 J
echo $mvp [ m_szName ];
4 e" Y) _! [% o0 d
else
6 M; N9 X+ R$ U+ ]: x, R
echo "-" ;
* Q! y: z, E/ t1 V2 F4 g
?>
7 Z: Q- B7 I i
Guild Winner:
5 u, {( s% c; V' c3 D. Y+ x
6 d8 \# h$ W! E) d4 Y2 U4 n( _. ]
( V" j) H4 z+ b6 P! H
) r5 z2 o+ ?5 J9 t3 m
PHP Code:
/ V5 R- A$ B+ P. F: v5 O0 `
<?php
# w) T8 R' l3 x; |. n; r1 f 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" ));
; ~4 ?: T$ ]2 p# u$ _
if ( $crown [ 'm_szGuild' ] != "" )
' \6 w$ y* X u7 S0 q
echo $crown [ m_szGuild ];
- U% s( C( _' j* V
else
$ m; d% c6 O) W
echo "-" ;
4 r6 Q) [6 ~" ^" @7 {4 {
?>
% H+ F; K9 S2 E4 t3 |4 `5 k1 e
Don't forget to like it.. Of course if it helps...
3 L+ e0 B3 J$ [) ^& D0 |. s6 ~
- X, ~3 A+ f2 Y8 _- E: R- c7 `
欢迎光临 飞飞世界论坛 (http://ffwold.com/)
Powered by Discuz! X3.2