公会得主显示脚本

admin

Lord Winner:

6 M- I& H8 M4 D
) W6 q8 i, `$ W# \PHP Code:
% w3 O! n8 x3 x9 D# t) R# b<?php
, H0 X+ V* N& p; L+ jmssql_select_db ( "CHARACTER_01_DBF" );
$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" ));
if ( $lord [ 'm_szName' ] != "" )
0 l5 V) q4 U' D, T+ I) b; L1 xecho $lord ;
: D9 K# q" ~7 z, i& Aelse
echo "-" ;
/ W2 B. j$ R+ B1 _1 X?>
MVP:
5 [# v2 M  y* w" C6 C; c1 t; z7 u

7 Z6 n/ K5 R" w9 `. W3 E+ x
PHP Code:
; W5 |& o* G0 s/ n$ _<?php
- _: U/ H9 Q8 I5 |4 i$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" ));
if ( $mvp [ 'm_szName' ] != "" )
echo $mvp [ m_szName ];
8 Z' c0 o% h) O1 Z; W. U) G% @  gelse
echo "-" ;
+ H! _# x7 m( O5 ?. ^?>
Guild Winner:
% I- E- M& @* [# s- x0 s- s5 t, `
# |' Y* }2 \+ c/ x" P/ R
3 g7 C1 y2 r7 h9 u0 z' ?- J
: z' z0 v! H$ ~. R3 NPHP Code:
<?php
$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" ));
if ( $crown [ 'm_szGuild' ] != "" )
echo $crown [ m_szGuild ];
1 @1 i! [) x2 \4 k2 P3 u$ ?& ]6 Yelse
4 N; ]2 C) U' Pecho "-" ;
?>
Don't forget to like it.. Of course if it helps...