飞飞世界论坛
标题:
公会得主显示脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:23
标题:
公会得主显示脚本
Lord Winner:
# b; O+ T: e; ]3 a2 h) ~* ^# K
9 C- p ?+ M( y" q
9 a0 R. a6 _: h2 R: @$ a' m4 _
PHP Code:
! ^/ T6 `- l1 z8 N
<?php
' g6 e% Z* @1 j& r1 V* e* n
mssql_select_db ( "CHARACTER_01_DBF" );
+ c" w) H, N$ j6 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" ));
$ R$ T' W8 r: [. ~2 P& \
if ( $lord [ 'm_szName' ] != "" )
" f+ D( L; l) T+ L
echo $lord ;
' ^+ V* M* h; r5 Q/ a) Q" U$ t
else
+ H( D) z6 S0 k+ `, G$ D
echo "-" ;
! |0 Y( d: e @4 n: j- [9 v
?>
! ^: [7 h. a+ R6 e6 b: T# N
MVP:
! B" k7 ^( p# c( b# o
: X& S- x* V9 G( X
- w0 H: N3 h @: j1 v& M; d/ }: M
; O3 p0 D0 e: C5 s* F/ g) p
PHP Code:
, c9 r$ u- L7 m! ]" v
<?php
|5 f$ @, U4 t: ~( }# ~
$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" ));
/ y% b0 t$ x" V0 w* |
if ( $mvp [ 'm_szName' ] != "" )
2 x! E. L$ V' ^5 B2 U3 S3 \
echo $mvp [ m_szName ];
* F. t0 A3 y2 {8 R9 w) ~6 ?
else
7 {+ v/ ~& ?9 M
echo "-" ;
& J( W! \5 b: _( K* @6 q
?>
0 Y4 z3 o3 J& \* x3 E
Guild Winner:
! L+ h* t5 m' q( p# u
# d7 m' w9 ]2 E1 r" \; Y c. i
2 E/ J& O+ x3 |9 z9 u6 B& t
: A# e" Q% F0 \3 o( R K
PHP Code:
0 d2 Z$ m7 P( K: E# F; z0 A* T
<?php
" }7 Y$ J5 q1 s8 T& M; N+ y. @
$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" ));
' C: P0 T3 E9 l* w |% b2 D
if ( $crown [ 'm_szGuild' ] != "" )
$ Q: a7 }$ S$ F
echo $crown [ m_szGuild ];
+ ]4 u r- B7 O. ]8 }! k- u A$ s
else
/ X9 _% s, j& P! D T
echo "-" ;
. a# P, S8 b* m/ E* k; O
?>
|9 d$ E6 u* \1 V+ y. T
Don't forget to like it.. Of course if it helps...
1 i0 D- L9 V1 K' D# O
( }& M* p8 q" |3 C5 M' `
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2