飞飞世界论坛

标题: 公会得主显示脚本 [打印本页]

作者: admin    时间: 2016-1-10 03:23
标题: 公会得主显示脚本
Lord Winner:
- r' x+ c$ ]( }7 z. N
0 z  X8 m. F/ _9 I& `. ^! r. T' h4 G& o3 A- I9 G% m- `8 s
PHP Code:6 T+ \4 T5 S3 x  y+ z. \- C9 j
<?php   c4 r% P. G9 j, q1 F; ]6 V/ l
mssql_select_db ( "CHARACTER_01_DBF" );
  @* @$ _( g$ 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" ));
/ z1 ~! _; I( h- Z/ A' p: wif ( $lord [ 'm_szName' ] != "" ) 8 F7 \- \" d3 t' D$ {; E, a/ j
echo $lord ;
  o% t6 ^! O/ z2 \2 R0 Kelse 7 g. I, Z  q: z7 J$ G/ x, \
echo "-" ;
: @. m. Z: e3 j( Q! l) t2 G% Z?>
% y0 ^( W  X1 W/ R% f1 T: [MVP:
* ?( x/ O0 g0 M' Q. S! W, M
: A5 y* ~1 e7 ~. ~7 y
5 b" c$ p! P! d: Z6 M: Q5 u$ ^/ i6 W2 a5 {" Z+ c  h
PHP Code:
. s+ d3 }( j* j4 v" e: [<?php
2 Q! d2 r. {& b% `$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" ));
. W% R; ]3 o- p/ t" K; _8 y. gif ( $mvp [ 'm_szName' ] != "" )
  H% I0 p2 Y2 a  Techo $mvp [ m_szName ]; 7 J+ S1 b! S1 _( a; Q; \
else
! D- I  O( ^8 c2 H" P* U- }0 yecho "-" ;
4 F5 [' O; W  Z: L?> . q2 I# j6 x$ `; R
Guild Winner:, [; C/ i! K, M) p( a' z" h
' c7 t  Q+ n! X: p# Z
# v! g- y/ c6 r5 J# I0 ^

7 v1 h8 k$ M2 K1 ~- ]PHP Code:- b4 i  {! D; L
<?php # S5 v% h" x* A1 `6 o: 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" ));
* T$ b: l9 N, y& ?$ X: h- uif ( $crown [ 'm_szGuild' ] != "" )
1 f1 ^5 v% X& w. c+ R% Zecho $crown [ m_szGuild ];
* Z* X: v' Y% H' g* K  uelse 1 [0 j% q5 @$ e; z1 A0 I& A# m
echo "-" ; 4 e% y" T% X$ g/ L: a3 F9 c+ y2 a
?> 6 Q7 w3 B, a& s) }
Don't forget to like it.. Of course if it helps... 2 m4 U, I0 w6 J; }4 K4 b

" @/ y9 E1 n1 i3 c, T' b




欢迎光临 飞飞世界论坛 (http://ffwold.com/) Powered by Discuz! X3.2