飞飞世界论坛

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

公会得主显示脚本

[复制链接]

197

主题

203

帖子

1078

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1078
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:23:20 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
Lord Winner:
+ O1 q9 w6 t1 h5 }2 ~
5 g% |1 \+ y, \# n' I+ [9 z) c& J0 Q  T+ z9 @. V4 g0 G2 B
PHP Code:
- p% K! C1 E' y" _) Z<?php   k) g& s8 l: Z- u6 v: r3 ^
mssql_select_db ( "CHARACTER_01_DBF" ); ' @+ u0 t/ `+ b. q9 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" ));
; @' O) c8 Q* _. cif ( $lord [ 'm_szName' ] != "" )
2 t: x  n. g% |9 zecho $lord ; ( w5 w: _% d. n/ a3 N' Q0 Z4 D8 |
else
4 Z" p1 E: _2 oecho "-" ; 4 p( L$ l, R* E7 ~
?> ' D1 }4 f. h4 M) j# f& \
MVP:
& F4 d9 [* N* V% @! c$ p8 R# q+ I! z7 A% e/ ^0 k) g( c
( Z7 S6 Z: k/ W& Y

: v% t& R. B- n% R& K+ wPHP Code:
, n# Q! O" w5 v# j: `9 p! M<?php ; Z! F2 r9 J4 g( X: w/ j5 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" )); ' y; E& c$ g" F8 D9 Q( D
if ( $mvp [ 'm_szName' ] != "" )
8 B3 r6 C- Y( j$ Z+ z! {: Pecho $mvp [ m_szName ]; / \, @1 C' Q6 e7 l5 u: W
else   o3 \/ t* Y" ^, z2 |
echo "-" ; 3 G7 I/ V. ~0 V* z
?>
. Z0 S( P6 H0 VGuild Winner:& C! s; a3 p, j1 E  S
( J/ m( W& B; N% u% H

& l& Q2 s) l# o8 t9 Q/ B( p( L8 |
9 L' F% f9 B. z1 h( K& |6 b9 EPHP Code:
. R- ?7 F. {/ F% T<?php
) Q8 i6 `' [8 E$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" )); ( I4 Y0 T8 s$ @, `6 i  A
if ( $crown [ 'm_szGuild' ] != "" ) * P3 w/ A1 }- L9 u
echo $crown [ m_szGuild ]; " }% [. k/ T2 ^
else : z7 |0 n/ C  \" `
echo "-" ;
$ i, ]% D& P/ O% D7 a. _?>
2 D- l: _  q8 d# B" HDon't forget to like it.. Of course if it helps...
7 G7 `) F; k4 |8 Y
$ v$ F$ Z# c; ]' d  E
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2025-10-22 20:00 , Processed in 0.065458 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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