飞飞世界论坛
标题:
公会得主显示脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:23
标题:
公会得主显示脚本
Lord Winner:
- H2 q& Y" h5 L! t3 z
+ h+ [4 j9 h2 n% C& y
: ~6 Q; u) Y( c J# J
PHP Code:
. @' R2 N; B$ O% a6 a
<?php
) u0 S D V, a) }8 v& m
mssql_select_db ( "CHARACTER_01_DBF" );
# H" M# e( s; L& V6 J
$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" ));
+ V5 A/ L: G8 _3 Y( C& J. \; Y; k
if ( $lord [ 'm_szName' ] != "" )
7 r' m6 ^ D: b6 E) J
echo $lord ;
9 l1 f+ g- {' g+ _2 Q
else
% B: M Z: E2 t8 |5 O
echo "-" ;
' r6 ^" \2 B- o/ W: N
?>
: q% K0 s6 s; A% L |, F, b7 p
MVP:
( H# k# N5 B9 h; j5 P9 C* }. \
- \& `3 X8 |- ?
+ z. G# A! M# `
7 C2 W# g: j1 ~
PHP Code:
% `! t+ b. p% S) E
<?php
; Q9 @$ ^4 T# Q5 |) ]
$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" ));
6 F/ K+ J, K/ ?8 K2 ]5 c/ e; C
if ( $mvp [ 'm_szName' ] != "" )
; g1 x0 {8 z6 X3 w& _( p( y
echo $mvp [ m_szName ];
, j$ w, K7 E) [( @0 Z/ A
else
7 |8 \/ b# {8 P1 V m
echo "-" ;
4 ^& c8 m* Q! h; b' y
?>
* k1 y5 h( C; @; l/ v7 I2 K
Guild Winner:
% C1 H8 ~1 z! O2 s% |; h
- z2 t6 i( \$ ? c1 l
6 O/ M5 y% ]5 h
1 {, ]8 j- y5 h8 J
PHP Code:
/ H1 O- v+ @1 V
<?php
8 N: W, F. D0 e4 a
$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" ));
3 ~$ Y$ U7 p( S/ {
if ( $crown [ 'm_szGuild' ] != "" )
3 Y# @$ k. o' J; ~( J
echo $crown [ m_szGuild ];
' ]! d( J0 X1 d+ P' ^
else
4 l1 u. i, \0 }! \3 U1 p
echo "-" ;
. u; C* [% v0 M8 @3 f9 F: j
?>
) x: Z: O% m. k3 x9 X. z# f
Don't forget to like it.. Of course if it helps...
6 ^9 h! |- [7 G( d: J+ Z6 N
2 F5 o, M) g9 Z' S
欢迎光临 飞飞世界论坛 (http://ffwold.com/)
Powered by Discuz! X3.2