标题: 公会得主显示脚本 [打印本页] 作者: admin 时间: 2016-1-10 03:23 标题: 公会得主显示脚本 Lord Winner: 1 r* l- e1 z) I, Z& j: B" f ( T) O2 u$ N, v4 u& o/ ~! w q% W; x% r- r M9 ^: u0 J! ~
PHP Code:% o! `+ |: Z1 K' }
<?php 3 P2 j' n8 F$ V) i. E+ umssql_select_db ( "CHARACTER_01_DBF" ); ' K' d/ Z3 r X" _/ W' {
$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" )); ; }/ d/ i* y! N3 r
if ( $lord [ 'm_szName' ] != "" ) # d3 ~- ] g6 Z' _' h1 Yecho $lord ; . }3 d; u' u7 Y2 V: G' L7 o1 E# J) gelse % f e0 e( r$ E* x6 @4 M8 n% J6 |echo "-" ; 3 Y0 Z9 t3 _" \$ ^
?> m5 p0 w7 _# b' D* }: J3 k
MVP: 7 q3 B8 K* M( R/ b% k6 x * c5 h2 B( Q/ `9 D8 c/ h& \2 E6 g 9 o X1 I$ C/ n3 x$ b+ E) X3 Y' L7 _, Z4 T1 q5 T# K
PHP Code:. h5 X; X( P% j d
<?php 0 R) A* N( C) f3 h% N: r4 l
$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" )); 6 P- Y) x2 U- \2 I/ bif ( $mvp [ 'm_szName' ] != "" ) 2 [9 Q) O' x. f$ y. C( xecho $mvp [ m_szName ]; ; ?7 [& Q! K& K, o/ B# W, W
else & v) @2 a1 S oecho "-" ; ) B3 U) O* [! y( a- h1 ^?> 5 u: }( M8 L$ z, J
Guild Winner: * y! r* w" q( ?. W# \$ q, E8 \. M- h$ L5 Q' V7 T0 U
# Y X, ~/ B1 F+ B0 G G9 Q+ t
' Y2 X3 Z3 q& @$ qPHP Code: + ^' w1 E# \: r" o. B<?php : J* k# B g h$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" )); % j/ a) q8 T, l; d
if ( $crown [ 'm_szGuild' ] != "" ) 0 B" f4 \, \0 [5 q5 l+ Z4 b) fecho $crown [ m_szGuild ]; : G4 G' v2 g5 ~1 P' U. e w7 kelse 3 _7 I# [0 F w( Y" }echo "-" ; 8 l8 W& Q5 k2 j- u?> ' ]: Z: X. U# B0 c
Don't forget to like it.. Of course if it helps... 8 Y1 q. z4 p( c% A - f1 C) L+ t/ F# N+ c& k; \