飞飞世界论坛

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

公会得主显示脚本

[复制链接]

197

主题

203

帖子

1086

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
1086
QQ
跳转到指定楼层
楼主
发表于 2016-1-10 03:23:20 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式
Lord Winner:
: M% v' F! N) _1 V- N7 K+ z7 U# B  D( G% g# Q2 t- l1 E

( P5 ]( \* d5 a7 a9 o' ePHP Code:
: ~; `5 ~  z" V5 T$ M<?php
' X9 y. G* g9 C$ t0 m& Wmssql_select_db ( "CHARACTER_01_DBF" );
: `0 g( @1 a$ j# l/ S4 U  t0 e! E$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" ));
" {0 E  i- A' V6 rif ( $lord [ 'm_szName' ] != "" )
! [" w5 r2 U- d$ ~6 ^echo $lord ; . c5 C0 F5 T' U) e' V  a" G& w
else ; G$ I) j3 I) k# K0 h
echo "-" ; 7 t6 Q; L4 q* z9 v$ e% B
?> 6 s5 z( K3 S( |5 t. P
MVP:
/ h1 K8 x3 H7 a
" f; H* o# y+ a8 ^
' E+ J8 l9 Y# i9 ?+ O! r, s% P) L1 a& `& B7 C' i9 Z: Z6 [
PHP Code:
, u2 X. v% m" e5 `' S<?php " ?  X% {, v$ J6 u/ S- \
$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" ));   e6 ^( A1 @" G( x: u  r
if ( $mvp [ 'm_szName' ] != "" ) , v3 ?" P0 b# N6 E: X8 B4 a! }  P
echo $mvp [ m_szName ];   o' G2 j  Q" [, C" W$ A5 h" [) @
else
8 v9 B; b5 M7 z0 C  V/ mecho "-" ;
  B+ {- O% |7 \  q0 ?/ Q+ m. o5 Z?> $ k" X7 J) b" m5 v8 x; q8 h% A2 f
Guild Winner:
0 s- b1 o7 W5 ?, u% f* `4 w& V
* w! y' W5 T! S& Q2 r- Q4 N0 R9 c# E* P& X  W7 K4 d! S/ Y; l- y- }+ y
( u  J5 q/ s+ X2 Y7 N
PHP Code:5 c7 j+ U  e. v' w* q3 ]
<?php 7 L1 V2 w! d) h5 M$ d7 B7 B3 M) v  ]
$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" )); # T5 `& \5 M/ o; H
if ( $crown [ 'm_szGuild' ] != "" ) 0 E9 X' k( x0 {
echo $crown [ m_szGuild ]; , H/ l: H' v( C
else
; L2 f+ }1 a' S( w8 U3 Xecho "-" ; 6 P  s+ |! t4 K* T3 o0 q' N
?> - F4 p; ]7 z3 f  k+ N" V
Don't forget to like it.. Of course if it helps...
  w$ L7 x3 n' j/ Y8 h/ `4 h  D
. ?) ~2 b% G  H# }8 e2 U; Z- {) g
回复

使用道具 举报

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

本版积分规则

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

GMT+8, 2026-1-20 17:07 , Processed in 0.056945 second(s), 22 queries , Gzip On.

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

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