飞飞世界论坛

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

公会得主显示脚本

[复制链接]

197

主题

203

帖子

1054

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1054
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:23:20 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
Lord Winner:
! x3 G- M$ k* ]  A; Y
. L7 G+ _' ]- ^) \: L
" F- j/ I( Z6 B, o# RPHP Code:
1 I6 y& x+ O; f3 c+ J5 C+ V7 u+ {- `; e<?php
9 Q0 D$ I8 H, W; Q: B$ F- umssql_select_db ( "CHARACTER_01_DBF" ); ' ^" Q! C3 O3 ?9 X
$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" )); ' P2 B! l  T+ i; P7 u! ~
if ( $lord [ 'm_szName' ] != "" )
. b) z' W5 Y% W* Kecho $lord ;
! c# k+ a' m0 z) P0 Eelse 9 z  u3 u9 m/ I/ U
echo "-" ; & C+ J6 }" e  C; I4 t1 i6 U$ t* e
?> 8 M/ \( w6 B4 N, T. b7 ]
MVP:5 b& `) S' {6 _5 ]& ?$ {& h

% U& ]" n4 j: v' Z6 d  P: |# z/ M9 E$ b7 I, E! M, L
6 u) {0 U) a: O2 p# A
PHP Code:; v9 B2 b# A! }' z, A
<?php
3 n) r/ N# ]0 r7 k- v6 ]$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" )); . Q; m0 v4 I* s/ D- f, U% E
if ( $mvp [ 'm_szName' ] != "" )
. ]( f2 J% Y+ m; J3 {/ Z  Jecho $mvp [ m_szName ];
& \3 n: z9 X0 S& Kelse 5 K6 j! _9 J/ L- I( S8 Z9 A
echo "-" ;
9 m9 B+ e1 o6 z( `?> 5 g9 B8 ~, i. X! J- m% C  k5 t
Guild Winner:' [2 l! Y# t( w% n1 u7 c& O

. E. \# ]& `  U2 @7 P  R; {3 f; E1 m4 J$ |' Z8 \: \
. i- Q5 M- S: G
PHP Code:) r! ~- K, w6 U0 I
<?php , j8 N9 H3 R; ]9 \( d; f! S
$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" )); , W2 c5 v( {( b. a1 B
if ( $crown [ 'm_szGuild' ] != "" )
7 [( i  I. E5 S, Y: S1 `$ uecho $crown [ m_szGuild ];
/ `# g0 S: \9 ^. O# O# Helse
$ O& k  a# X: @7 J6 S( K1 {) a& Secho "-" ;
4 T( ~4 R/ j3 U; S?>
! u9 I9 y* t$ \Don't forget to like it.. Of course if it helps... 2 \  o+ ^/ ?3 b' e. J
" `( C0 \+ c" I) X. j
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2024-12-23 07:51 , Processed in 0.108332 second(s), 23 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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