飞飞世界论坛
标题:
公会得主显示脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:23
标题:
公会得主显示脚本
Lord Winner:
* T# M) j* c6 L7 }/ ^4 S
& m0 M- k( f; s& D: z
; b: r1 g$ ~% P6 F% D
PHP Code:
# q4 I/ ~5 T7 J. j( H( P
<?php
2 x2 S* o, n3 j
mssql_select_db ( "CHARACTER_01_DBF" );
# q3 l" L2 `# N3 _; j+ |1 f- z; ?$ y
$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" ));
+ l' i$ l. k) q- o+ G7 N
if ( $lord [ 'm_szName' ] != "" )
- \% P* O! a# ^/ {+ n
echo $lord ;
2 Q7 z# }, |9 E+ r1 ^( ]) b
else
3 P6 f* j1 E5 n
echo "-" ;
9 p; z/ ~2 M: S7 g5 q- S! B
?>
; }" f6 N) {* S, k
MVP:
: c! L4 v. H7 P
( z N: g2 V+ _' O6 ]
0 j' k' k8 g5 W$ z
) @% N, ? l0 K* V! s% t1 U+ {
PHP Code:
* O/ n* k+ Q% @" O6 u; ]! C
<?php
( u2 S- Z0 H* A4 G3 H& i- a* Q1 c
$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" ));
) O4 w, ]6 F# t* W
if ( $mvp [ 'm_szName' ] != "" )
5 v N& L$ M( w& k$ m& f
echo $mvp [ m_szName ];
8 @+ M+ q, s7 ~6 c
else
7 h; B2 c: {: Z& n
echo "-" ;
( A) Y- z; M1 [
?>
9 w6 Z% l! q! ?3 v0 D2 w
Guild Winner:
$ }8 I/ u6 T! B8 s' b
3 }8 `% Y' T) x2 o: v5 i- R- |
: S1 C3 u, q% N# b( O* ~ G. {5 c- S& r
) m, [, J, P* R% P" ~' ~. u
PHP Code:
3 \) S3 M- t- e4 w; T2 ?
<?php
: }. n3 x* L. S/ I
$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" ));
! h% c$ e/ g/ V
if ( $crown [ 'm_szGuild' ] != "" )
; c# U0 ]7 Z* X }2 s
echo $crown [ m_szGuild ];
5 j+ h! E) r* d; ~3 \, Q9 [# v
else
" O( k- @% I' ?/ q' w2 K
echo "-" ;
/ N) Y! ?. M* i$ J
?>
; |* N$ }6 c) Z6 m1 L, ^
Don't forget to like it.. Of course if it helps...
* o S Q: f1 e+ X! l1 t x
K1 K7 ^7 X9 y8 w5 S$ o
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2