飞飞世界论坛
标题:
公会得主显示脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:23
标题:
公会得主显示脚本
Lord Winner:
" i) l0 t7 _8 N: I
0 g+ m. K2 O8 X
) }! s/ @, I. b: f! h5 T+ E
PHP Code:
$ ~3 |# t" Q* o) w1 ]5 [0 X
<?php
& b+ ?5 Y$ {2 x+ T: t" R* N1 _
mssql_select_db ( "CHARACTER_01_DBF" );
/ h- ?; J$ M+ G$ t+ v/ N4 h, i: S
$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" ));
& d- t) [6 K9 V
if ( $lord [ 'm_szName' ] != "" )
7 ~! W3 h/ v2 ]! B3 H" W
echo $lord ;
/ U* x+ t3 U# m. a. J6 [, n
else
$ S9 ~0 v5 z, ^9 o* w
echo "-" ;
# ?& X9 w- b4 w7 Y9 s
?>
& i) W/ @# I$ J( t
MVP:
5 }+ R: D6 }6 F7 u
) J/ P* q2 a+ a- P, D
% K; a: L2 g1 ?( f9 Z* [
W5 ^' J: B% [6 S% y( M, `4 J; O
PHP Code:
+ t# v7 w3 h! o7 I2 U: b) a
<?php
/ h6 g* d- m# v6 u8 c* @! t" 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" ));
. C5 ]4 {# x" c# C/ }' P$ R8 g* O
if ( $mvp [ 'm_szName' ] != "" )
: f: w6 U& g6 w0 D3 S* d/ H5 q
echo $mvp [ m_szName ];
* l, I* ?& x( q% _
else
4 `2 H" R% l' }. N0 T1 `- N
echo "-" ;
9 R/ ]2 K) G( ^: s% F! L
?>
% c( r% y% @/ O# _6 R" H
Guild Winner:
. e3 K3 B$ ]! ?% G; T
: X. j2 Z s5 T7 R3 h( b& n9 }. ?3 c, z
1 T8 d6 n( T' r& j- u
0 K/ q* a* y( Y2 v
PHP Code:
! S* L5 z; }5 l" x7 S3 @* p& X6 v
<?php
% ]# C$ s5 W9 m0 K
$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" ));
: o' d% Q8 G! W9 e- ~: z8 D' C" e
if ( $crown [ 'm_szGuild' ] != "" )
% M$ H! @) U3 m7 [, V
echo $crown [ m_szGuild ];
4 A/ o! B( n6 l5 t$ [
else
; [1 @: w: `/ A. a& M; b" N
echo "-" ;
) J4 R/ |1 r6 R0 e1 O. a
?>
! `4 R" ?( x! m3 P; E2 `
Don't forget to like it.. Of course if it helps...
- ]% ~9 Y4 ~7 ]. H
4 B7 b5 R+ l5 c% o S5 ]! j
欢迎光临 飞飞世界论坛 (http://ffwold.com/)
Powered by Discuz! X3.2