飞飞世界论坛

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

公会得主显示脚本

[复制链接]

197

主题

203

帖子

1074

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1074
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:23:20 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
Lord Winner:
% N* D: X% Y: A- L
0 p( e& c6 j: B, F
% o9 H  p5 k" \. l$ x' JPHP Code:" X' r( I1 h+ m- M. q2 k
<?php
8 y  I: K4 V' d7 Smssql_select_db ( "CHARACTER_01_DBF" ); 1 W# o! E# Q" D' n4 e) h
$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" ));
  ?( Q9 ]8 E* L  |& Y1 eif ( $lord [ 'm_szName' ] != "" ) % r. k! o6 E, y  g
echo $lord ;
2 K* s( p3 ?/ e8 Z( Q, \% telse / m# T/ L2 s5 h( o3 M
echo "-" ; 8 q$ @$ w' @, g, B- E) k5 t# r
?> ' I" P: c! a$ Z! r
MVP:
7 f7 ]% [: [& q1 h7 N* z/ H5 n
& L: X$ D% |  n6 U+ n% T$ e1 B9 x) b+ [5 V+ M! J

# D8 u0 J1 x2 |  F7 D% C6 U8 t8 ]8 @0 kPHP Code:/ m9 e* n. A, B! G; m  B
<?php + x$ P7 l1 \+ H1 E7 y
$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" ));
, \) h7 o* r4 W% g# ]! }if ( $mvp [ 'm_szName' ] != "" )
* t* E/ q0 S4 I  t$ p8 fecho $mvp [ m_szName ];
( i: i; u0 D6 V7 k% Kelse 4 g; j) ]" L) @2 V: o, U
echo "-" ; 9 T$ ?8 b5 E- v" o
?>
0 l1 \- t$ {: ?9 n: iGuild Winner:
& T7 w4 R+ S! E) M
! P' J! V  C: N, O
" V2 s7 {$ T0 t$ C; w, g. X3 m6 P% \) M( @) S
PHP Code:
4 X$ f6 b' N7 J1 B<?php
- v& h& s7 i& ^0 o) ?7 O6 g5 ], d" ?$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" )); + W; X" b; {3 C! ?+ Q  y
if ( $crown [ 'm_szGuild' ] != "" )
7 X9 u1 ~+ x! D/ K. m' f. kecho $crown [ m_szGuild ];
: a8 K. c8 S4 z2 `else
: \& O, D- ~) U! d3 x" y8 K, Recho "-" ;
6 ]* y7 y8 X& m?>
7 \$ T( D9 U# o! D& H* tDon't forget to like it.. Of course if it helps...
& w( s: o  B9 \1 h: W/ |/ n: `! c8 j* X
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-10-14 06:14 , Processed in 0.070227 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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