公会得主显示脚本

admin

Lord Winner:
! x3 G- M$ k* ]  A; Y
. L7 G+ _' ]- ^) \: L
" F- j/ I( Z6 B, o# RPHP Code:
1 I6 y& x+ O; f3 c+ J5 C+ V7 u+ {- `; e<?php
9 Q0 D$ I8 H, W; Q: B$ F- umssql_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' ] != "" )
. b) z' W5 Y% W* Kecho $lord ;
! c# k+ a' m0 z) P0 Eelse
echo "-" ;
?>
MVP:

% U& ]" n4 j: v' Z6 d  P: |# z

PHP Code:
<?php
3 n) r/ N# ]0 r7 k- v6 ]$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' ] != "" )
. ]( f2 J% Y+ m; J3 {/ Z  Jecho $mvp [ m_szName ];
& \3 n: z9 X0 S& Kelse
echo "-" ;
9 m9 B+ e1 o6 z( `?>
Guild Winner:

. E. \# ]& `  U2 @

PHP 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' ] != "" )
7 [( i  I. E5 S, Y: S1 `$ uecho $crown [ m_szGuild ];
/ `# g0 S: \9 ^. O# O# Helse
$ O& k  a# X: @7 J6 S( K1 {) a& Secho "-" ;
4 T( ~4 R/ j3 U; S?>
! u9 I9 y* t$ \Don't forget to like it.. Of course if it helps...