飞飞世界论坛
标题:
公会得主显示脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:23
标题:
公会得主显示脚本
Lord Winner:
8 L# ]; K; F0 z
: u9 H9 x) d: {. B0 M* Q: d
X) H, c% g5 I5 P; J
PHP Code:
: C- a7 f4 m9 x8 w2 F! f& }9 X
<?php
' V; F& f9 @4 K1 g/ H+ }5 \5 ?
mssql_select_db ( "CHARACTER_01_DBF" );
* c# z2 s% Z' d# k, \" U0 b6 W6 |. O
$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" ));
- u0 M$ y! F' m
if ( $lord [ 'm_szName' ] != "" )
) d- ]) d2 f8 h
echo $lord ;
8 D7 }5 [: g. X2 K# E' C' w
else
5 c0 s, y0 x) l; o) Q4 F2 h8 ^
echo "-" ;
8 [! p. q; d) {0 `- c5 Y& n7 x- `2 c
?>
$ J. X1 f6 O I' R
MVP:
( W# m/ o7 A2 f. J8 m/ I7 v7 }
; y/ h$ t( f+ Q. X( |
/ D" L" Y0 }, M g% @
! t9 W2 i" d7 q' Q
PHP Code:
6 R; t0 R# V2 H, w+ B/ N7 I4 C6 F
<?php
0 P/ a7 m5 i7 I9 u2 N V7 l
$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" ));
/ K9 [1 R! U% _
if ( $mvp [ 'm_szName' ] != "" )
( d( e1 e- b4 `' ^; K
echo $mvp [ m_szName ];
9 v' W& T& @% j" C
else
9 t Q2 _$ r2 K: J
echo "-" ;
: f9 ^& d( ^8 {3 C7 a
?>
) T* K. V3 ]7 o2 q; F( K
Guild Winner:
# F$ \8 [; n& }1 N: h
" Y9 ^* G0 `% A- I! c
~( m" v( y9 T2 R
. e+ c( y) W; w0 p8 C0 Y' o
PHP Code:
( Q3 L) a- k/ j% R9 k
<?php
* a+ ^' u+ K |4 C3 s# y! O7 e
$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" ));
. b5 y; H5 Z+ e
if ( $crown [ 'm_szGuild' ] != "" )
1 O+ r3 V8 i# O) A, W: \
echo $crown [ m_szGuild ];
: [0 Z. _6 `' x6 f! P( @. d% T4 N
else
+ p$ R: Q* p/ V( _$ _7 f! ^6 U0 W2 u
echo "-" ;
' n2 q$ y4 c0 J2 }2 X
?>
; c6 e9 y! s! o- q$ u/ F! Z
Don't forget to like it.. Of course if it helps...
% E8 E6 x" D4 a; K
0 b) M* m, p" |& A
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2