公会得主显示脚本

admin

Lord Winner:
& T3 {4 F1 X$ j, S% z

PHP Code:
" e1 w8 i6 N+ K( L. _& @, V<?php
mssql_select_db ( "CHARACTER_01_DBF" );
; c/ p4 L% [' [$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" ));
" E4 J9 e9 G; ?0 S2 ]) S* M% K; nif ( $lord [ 'm_szName' ] != "" )
6 z2 z- ^7 ]' T: s9 \echo $lord ;
else
echo "-" ;
- y! w4 l; m' g( i5 I+ A?>
  i- u8 i$ o: S! g" |. Q/ h* A7 DMVP:


, l8 s& G% g! W' a. y" P
PHP Code:
, L/ h& D2 R5 I4 X0 b! O  h<?php
  g, m6 L! I* v7 O; p. b$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 ];
else
( @+ ~/ G) q; E  U/ C( x( @echo "-" ;
4 u1 Z8 g* X0 H/ a  f2 ~?>
( M! B+ F2 Y' {$ T7 aGuild Winner:

/ z8 g: }9 s/ n7 }/ o" L. s& b
/ r( u( I2 L% a
( e2 D8 R0 _9 b# T3 wPHP Code:
<?php
' o1 F( \- o2 L  Q$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' ] != "" )
& N8 z$ R  b3 fecho $crown [ m_szGuild ];
( y/ Q, U0 j# m3 Qelse
echo "-" ;
?>
Don't forget to like it.. Of course if it helps...

* o% P% r& ]: K( ]  @