飞飞世界论坛
标题:
公会得主显示脚本
[打印本页]
作者:
admin
时间:
2016-1-10 03:23
标题:
公会得主显示脚本
Lord Winner:
% d; N$ S7 `1 ^6 f$ K
0 A, _/ ]8 P/ u( k- j% { j
7 K3 L7 V, Y3 U8 F) r0 h% O
PHP Code:
* A( m7 j- X( X5 n
<?php
5 P% K2 a% m/ _7 O, H/ g
mssql_select_db ( "CHARACTER_01_DBF" );
8 O& Z/ T1 G4 v, |4 k
$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( ], b- E0 f0 [9 D/ `" ^3 y
if ( $lord [ 'm_szName' ] != "" )
/ @4 ?6 C% g; a% ^0 I, L+ s$ X% s
echo $lord ;
4 f) G Q# ]7 L/ D; r/ F6 V0 C
else
# `( @: P: l6 Q( j7 ^
echo "-" ;
. n9 j7 [( Q* G9 a
?>
* Z( s7 y$ [' y
MVP:
/ [5 G: P- H! p9 u' R0 p
9 I( d" V1 w4 S4 i* P$ [
* F8 ?2 A; j0 g, l" R9 z+ K8 S
1 }8 C) d- ~7 Z" ]) {1 e0 z, S
PHP Code:
+ ]7 P* K Y5 A( |) T I9 X
<?php
, S$ C/ Q2 c' l: ~. X
$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" ));
- x6 M) Q3 N; {6 f
if ( $mvp [ 'm_szName' ] != "" )
# K# o/ I' [0 e, i! _
echo $mvp [ m_szName ];
7 C- P- u o3 d: o0 F& e
else
! u% a1 S8 `, Y+ C p
echo "-" ;
8 Q( u. b& n' \% v4 r& K
?>
! s) d$ F$ S: M; [
Guild Winner:
. [. Q9 Q+ \; A7 G
# I3 v- U0 j0 o' h. J7 @4 K
/ B$ |% z' O8 {- V4 q* x
# T- D; A2 E$ c9 T
PHP Code:
! D; l, A, @. x; ]% E
<?php
$ N+ D% i1 n) D2 E% h) |- M
$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" ));
/ }: z3 r% W9 [- d2 H' p5 v% f
if ( $crown [ 'm_szGuild' ] != "" )
4 V7 p( N3 ], n4 u
echo $crown [ m_szGuild ];
/ v* c+ y+ ^8 Z* k4 g
else
( L0 {, b$ I$ K7 A5 j" X: z- e
echo "-" ;
! i9 t e( L/ W0 Q$ f8 b; E( a
?>
H! f; ~# J" T' [
Don't forget to like it.. Of course if it helps...
6 z. [* E! |7 `) c
4 V6 p3 k- U6 h$ Y% R
欢迎光临 飞飞世界论坛 (http://ffwold.com/)
Powered by Discuz! X3.2