飞飞世界论坛

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

公会得主显示脚本

[复制链接]

197

主题

203

帖子

1058

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1058
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:23:20 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
Lord Winner:% g3 ]0 \* f# \: v/ {
, ?: s6 W  w- ^/ Y  v- z2 V

1 E4 [; q$ U7 o  R, F  XPHP Code:2 K! U# A' \+ |: @
<?php
. S/ F. e! S0 W$ Umssql_select_db ( "CHARACTER_01_DBF" ); ) `5 U! q& `' i' l# i+ E$ N: O
$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" )); $ e8 p+ m! k) N# K2 A
if ( $lord [ 'm_szName' ] != "" )
( `, Y6 l& Y5 [" \echo $lord ;
" K' N2 \9 B" P6 J2 M" A( Yelse
* u9 G. g$ o* o/ F9 D& D/ |echo "-" ;
" }  |8 h3 i3 n/ H; A?> - x$ F4 \6 z8 q
MVP:
. Y& s5 o! W, X! {$ e9 [* v$ }; s. N
" Y4 ^1 k3 E; B% K6 {# v, I$ Y
/ z; m; u! n) m- z0 k3 l# Q
$ l% [) i# B' Q$ _, ^PHP Code:
9 F2 Z; R! L; f" \2 a, T<?php , p0 p5 s) ^# T5 H( U' T% 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" )); 8 C: v) S! r+ w+ y5 b# J
if ( $mvp [ 'm_szName' ] != "" )
7 W! ^* t) \" `) I5 |1 d- Pecho $mvp [ m_szName ]; ; G+ C0 ]0 Y! P) ?
else
0 x" }8 e5 O5 O0 N) @6 Mecho "-" ; # E9 ^0 N& b5 P9 _. s3 i
?>
+ Z5 e+ c9 o/ L# Y$ [Guild Winner:
9 Z3 ^3 I& ^7 x) u, a" W  |5 h  u$ N0 P! |3 o& Z  B7 z+ W8 c
' }  b6 A3 X( V) |- @1 Z
4 {. @; P- ]6 o0 d
PHP Code:9 E( n* i) d' _& ^3 H# T# s6 U
<?php
$ U  [% H! b4 B5 p; R' ]$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" ));
2 j1 ~0 L+ l$ Y. vif ( $crown [ 'm_szGuild' ] != "" ) 9 l8 ^" q% v# ~7 }7 k
echo $crown [ m_szGuild ]; $ c2 E4 P) t. j7 o  H) C
else
/ P, U. [+ ~) i% Techo "-" ;   L5 u& R& E& Z) E- L) D# Y
?>
& {" g7 C" Z0 d+ m3 uDon't forget to like it.. Of course if it helps...
8 D8 F. I0 P9 l% |* r& m% t8 P7 M3 i$ O" }
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-1-5 12:23 , Processed in 0.075884 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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