公会得主显示脚本

admin

Lord Winner:
- _) E$ G, w' v4 ^7 g4 i

PHP Code:
<?php
mssql_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' ] != "" )
# X1 \# E) H1 D  Y+ \' `, eecho $lord ;
else
8 y/ Y/ [1 d, \0 j  gecho "-" ;
" f; ?0 G  L! p+ Z) j+ n?>
MVP:
  i2 B* u7 d2 U3 l: _! J

1 R* W' N5 g7 J; w4 |! \. z5 D
PHP Code:
<?php
) v3 L5 g: \& F% J* P0 G$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' ] != "" )
& b- T) i+ M. [8 K" t! j( z2 w4 _echo $mvp [ m_szName ];
else
! _6 |, s8 {2 t6 W/ Q* ^, zecho "-" ;
?>
" S3 i. w/ e# N3 sGuild Winner:

+ H3 @7 L. U& L/ `2 [& y$ B, n
5 ^' K) ~  h( r7 X3 m
. [. m1 B8 c4 l8 }1 U+ APHP Code:
: ]) w" \1 _% |. ~4 f, T<?php
- V3 |  v8 p# e3 @$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 ];
. `# S) F: s% t! ?  M1 x0 xelse
/ `( s: H9 b8 l* A' j) }: ^echo "-" ;
0 x1 X+ A! N2 a* ?- S2 ^1 A?>
Don't forget to like it.. Of course if it helps...

- }3 P1 g' R) u+ a$ I# d