飞飞世界论坛
标题:
公会得主显示脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:23
标题:
公会得主显示脚本
Lord Winner:
: _& n8 g: u1 }* P( n' \) G+ L- u" S
2 g2 Z8 m) H) t3 ?/ C( ]4 H& W
8 a0 [# q3 o7 i+ [3 m a
PHP Code:
; E; y1 u; U" X8 [
<?php
+ J& q# q/ ^: W2 g9 k3 w J! ]$ l
mssql_select_db ( "CHARACTER_01_DBF" );
& t4 W, {3 J7 C) m4 I! B6 a( {
$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" ));
4 U; J! {4 x/ R; V6 w! ]
if ( $lord [ 'm_szName' ] != "" )
+ d! k1 P. M3 |. L6 f
echo $lord ;
& [. Z- Q2 k" r$ W1 ]) E8 v9 ?+ r
else
/ R! p8 }+ X1 j8 {
echo "-" ;
% ]+ Y/ H; w* f+ A" |
?>
( j! Z4 {, w" Y) X+ H& W. |
MVP:
6 U- M( l4 k' Y; J9 ^; S" n5 p
/ K, Z( v7 e9 m7 f( R1 U u+ y6 I
2 {$ C* z6 |9 h- H
1 d- M1 A2 b/ c# k/ I
PHP Code:
, ^8 r/ m* G9 d( k
<?php
( G$ F$ M& ^% D/ ~/ k. `
$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" ));
( F6 k; ~! a6 R7 p% o1 h) b. S
if ( $mvp [ 'm_szName' ] != "" )
4 V6 z. P& C' c) V( D3 E; ]
echo $mvp [ m_szName ];
5 E8 q' S3 ?/ W7 W. j( d. \% O1 i
else
" W& o0 t- a/ O$ z( c& P
echo "-" ;
& d! v) N# `0 Y; ?
?>
" c9 }8 h$ X- J4 u8 t4 y
Guild Winner:
/ \- |' j. C7 e: J7 j6 K! L
$ A- Y0 J2 J7 v* F
+ L5 J8 b3 b7 ?/ p9 b
* {/ T3 |: Y) K& K6 m6 f
PHP Code:
; r8 n4 ^7 K' v r: I4 ?
<?php
6 P' e/ C i) {# @
$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" ));
, k3 z' g% ~/ B1 b4 }; y+ {
if ( $crown [ 'm_szGuild' ] != "" )
+ g3 e3 j7 K W
echo $crown [ m_szGuild ];
' n2 Q1 g5 P [/ |
else
$ `; Z) V9 s& W5 r( Q
echo "-" ;
% V- r; V9 x: L7 t. N9 e# r, t. t, g \/ d
?>
* F, T, v+ n: E! A: `5 a3 T
Don't forget to like it.. Of course if it helps...
. h9 [/ _5 j9 q- t" N
( ?( h% ? F7 H! K
欢迎光临 飞飞世界论坛 (http://www.ffwold.com/)
Powered by Discuz! X3.2