飞飞世界论坛
标题:
公会得主显示脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:23
标题:
公会得主显示脚本
Lord Winner:
; F- m( [0 ?, X: _* \; @6 n9 w
1 [- V7 L* f4 g1 U# O- Y
; u5 `5 \$ J [0 h/ `
PHP Code:
8 W6 q2 L% B- p0 ~. [
<?php
; F/ g7 s% f0 q5 c/ ]/ _
mssql_select_db ( "CHARACTER_01_DBF" );
% o) y' w% X6 i. f: j% _2 {' ], G# {
$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" ));
- K$ t1 D/ Q. ^. e& ~
if ( $lord [ 'm_szName' ] != "" )
, |$ G1 r; L I# ?* Y6 Y$ k
echo $lord ;
- q5 n5 i6 G: P2 d# X9 M8 L
else
# ~% ?. E/ W* k3 ]" M5 ]
echo "-" ;
1 W$ f% k0 U' F. b$ P- B( }5 k2 }
?>
: Y5 n! o; {4 I: x0 Q5 Q# o1 b
MVP:
! ^1 w- c0 e! @- c
& V$ w2 f: C# i" q' H
4 }3 P$ |# |. l# @4 D7 Q
5 S9 F7 \3 X/ Z0 s
PHP Code:
( B; U5 m/ B3 H4 P: G3 |
<?php
/ a/ l+ ~8 F% M
$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" ));
; x1 D' V4 w+ \+ ^& _# n. Z
if ( $mvp [ 'm_szName' ] != "" )
6 M1 ]/ M# p5 r, s8 j( `
echo $mvp [ m_szName ];
9 K P* e, ]5 l2 ]2 }
else
~' r! _& D9 V- G1 e! H* K/ C+ S
echo "-" ;
4 ]% K% P0 d" Q7 T
?>
3 `- r$ @& W1 @$ U
Guild Winner:
* u/ r/ J* V9 V# Y M N$ `
+ e% P+ S3 R& a+ n: M. ]
% \4 y0 F. y3 y3 Z9 Y/ h
: D g. S4 Z8 p6 y z
PHP Code:
" k h$ O6 j+ A7 b. |: A
<?php
! l/ ~% t4 t8 t- u* v7 a( F G5 u( z
$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" ));
/ \: {, S [: ]7 q
if ( $crown [ 'm_szGuild' ] != "" )
" s* Y/ P! l/ D1 n3 {
echo $crown [ m_szGuild ];
! O# _+ O2 ]1 E w1 c: z9 H
else
+ I4 u1 Y/ m" {" B9 G
echo "-" ;
: ~0 H, l D! ~9 Y
?>
* k+ w( ~: J0 ]9 h7 e
Don't forget to like it.. Of course if it helps...
" R$ B* f/ F- v4 b! x; e* v3 R( u
: F9 E Q) {; Z, x
欢迎光临 飞飞世界论坛 (http://ffwold.com/)
Powered by Discuz! X3.2