公会得主显示脚本

admin

Lord Winner:

' {' F$ P% F% Z% F0 _( v+ C7 V
. X/ v2 u8 j$ w( l$ }7 yPHP Code:
9 t0 ~/ B  W4 \5 ^<?php
mssql_select_db ( "CHARACTER_01_DBF" );
2 s1 B4 m( h  b; V4 u" \6 B$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' ] != "" )
% |' q. X$ E7 D2 i/ {4 t5 P" T! Pecho $lord ;
) h( @- V! t; M- y  E  H0 o7 belse
echo "-" ;
+ F( O5 Q6 r/ X7 M?>
MVP:


" N' p( K2 }# E  X
3 t& ^! m2 p: A$ c4 U9 j- a6 f1 E6 ^PHP Code:
<?php
$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 ];
' P2 v# F: @& ], Gelse
1 l8 p  N1 C9 e! a# W% f/ w/ }echo "-" ;
: N6 I1 w+ ?" ]/ d5 J) I?>
Guild Winner:
, F/ V8 Q; K5 g4 {5 G0 ^

5 u3 o9 @0 B9 L! k9 c- g" z
% f8 h9 r$ S+ |! wPHP 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' ] != "" )
1 Q; b/ F. w: w5 ^9 y& decho $crown [ m_szGuild ];
. t8 `/ ^! L% Z4 Jelse
echo "-" ;
( Y5 o* T$ ^: w$ B7 ?# z9 D; f* Y?>
3 ~8 }# ]4 y; E" v" {0 R7 ]. BDon't forget to like it.. Of course if it helps...
, s8 a% V! h$ w6 V7 W5 p- Y
# ]8 [' j, U, v( o) D  k8 f9 w