飞飞世界论坛
标题:
公会得主显示脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:23
标题:
公会得主显示脚本
Lord Winner:
- r' x+ c$ ]( }7 z. N
0 z X8 m. F/ _9 I& `. ^! r
. T' h4 G& o3 A- I9 G% m- `8 s
PHP Code:
6 T+ \4 T5 S3 x y+ z. \- C9 j
<?php
c4 r% P. G9 j, q1 F; ]6 V/ l
mssql_select_db ( "CHARACTER_01_DBF" );
@* @$ _( g$ e
$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" ));
/ z1 ~! _; I( h- Z/ A' p: w
if ( $lord [ 'm_szName' ] != "" )
8 F7 \- \" d3 t' D$ {; E, a/ j
echo $lord ;
o% t6 ^! O/ z2 \2 R0 K
else
7 g. I, Z q: z7 J$ G/ x, \
echo "-" ;
: @. m. Z: e3 j( Q! l) t2 G% Z
?>
% y0 ^( W X1 W/ R% f1 T: [
MVP:
* ?( x/ O0 g0 M' Q. S! W, M
: A5 y* ~1 e7 ~. ~7 y
5 b" c$ p! P! d
: Z6 M: Q5 u$ ^/ i6 W2 a5 {" Z+ c h
PHP Code:
. s+ d3 }( j* j4 v" e: [
<?php
2 Q! d2 r. {& b% `
$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" ));
. W% R; ]3 o- p/ t" K; _8 y. g
if ( $mvp [ 'm_szName' ] != "" )
H% I0 p2 Y2 a T
echo $mvp [ m_szName ];
7 J+ S1 b! S1 _( a; Q; \
else
! D- I O( ^8 c2 H" P* U- }0 y
echo "-" ;
4 F5 [' O; W Z: L
?>
. q2 I# j6 x$ `; R
Guild Winner:
, [; C/ i! K, M) p( a' z" h
' c7 t Q+ n! X: p# Z
# v! g- y/ c6 r5 J# I0 ^
7 v1 h8 k$ M2 K1 ~- ]
PHP Code:
- b4 i {! D; L
<?php
# S5 v% h" x* A1 `6 o: r
$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" ));
* T$ b: l9 N, y& ?$ X: h- u
if ( $crown [ 'm_szGuild' ] != "" )
1 f1 ^5 v% X& w. c+ R% Z
echo $crown [ m_szGuild ];
* Z* X: v' Y% H' g* K u
else
1 [0 j% q5 @$ e; z1 A0 I& A# m
echo "-" ;
4 e% y" T% X$ g/ L: a3 F9 c+ y2 a
?>
6 Q7 w3 B, a& s) }
Don't forget to like it.. Of course if it helps...
2 m4 U, I0 w6 J; }4 K4 b
" @/ y9 E1 n1 i3 c, T' b
欢迎光临 飞飞世界论坛 (http://ffwold.com/)
Powered by Discuz! X3.2