飞飞世界论坛

 找回密码
 立即注册
搜索
热搜: 活动 交友 discuz
查看: 9866|回复: 0
打印 上一主题 下一主题

公会得主显示脚本

[复制链接]

197

主题

203

帖子

1054

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1054
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:23:20 | 只看该作者 回帖奖励 |正序浏览 |阅读模式
Lord Winner:
( E2 ~* K2 M5 G, y* A( d# T- W' ~& }/ B# I) k

( d$ i7 X: q, F* U$ B% h2 L3 o6 @PHP Code:7 m; [7 x* ~8 ^& s: M% a& a- l8 D, H
<?php ) M& x" Q  u$ [; o/ L3 b. k* s
mssql_select_db ( "CHARACTER_01_DBF" );   D1 Y' Y4 x( y7 g$ l) P& |
$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" )); 7 m- F3 ]2 S: d/ e6 @# F
if ( $lord [ 'm_szName' ] != "" )
/ e+ V) s& B7 X$ s' }# U: Techo $lord ; 2 d$ u3 `/ @2 g9 I& l# O
else $ }/ y$ u! e0 x% E! i7 p
echo "-" ;
, L1 K2 W. \% l2 z9 Z?> + c! `7 W( ~% U5 |5 M1 H: ~
MVP:) ~3 E  x- D; h
8 O; k( A) i" f8 T% c
5 W/ ]1 T5 w- l6 @9 P

+ `# |, o8 u+ B* A  s; G9 uPHP Code:
) r' c' |) r% p! f<?php
. y3 y: L' {( W$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" )); & P) O/ R( b" x0 a
if ( $mvp [ 'm_szName' ] != "" )
( o: B- \7 `( O. v+ \echo $mvp [ m_szName ];
/ ~4 \: {  m/ f% n. [else & I- S' E+ Q* T7 x4 r! W/ Y
echo "-" ;
5 n3 f/ [; P- R6 a4 F?> ; i) h+ ]4 s: ]. \6 b/ _. V
Guild Winner:
/ L  r( ?8 X( R1 _
( ]* v& l: L8 G- T8 g+ Y8 b- J% M2 Q1 \
0 h; s$ c5 O) E7 Z! I& C
PHP Code:
0 h5 F: _9 O4 }0 d/ Q2 v) T  i<?php
4 Q+ E% y  L# h' h/ }$ [. M" j  O$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" )); % i  |' O6 H! Q2 Z5 w+ `
if ( $crown [ 'm_szGuild' ] != "" )
3 M0 s# U9 ?) e& w4 Recho $crown [ m_szGuild ]; $ K. R% P! K& D( A
else " Q# @7 F* L( ~* M  O
echo "-" ;
4 `/ k4 H0 r( {* y?>
# G2 W( H8 A. ?4 EDon't forget to like it.. Of course if it helps... 1 c0 u( H: z7 q1 t
4 u/ ^! m( W0 R. ]
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

手机版|小黑屋|飞飞世界技术论坛  

GMT+8, 2024-12-23 12:20 , Processed in 0.057620 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表