公会得主显示脚本

admin

Lord Winner:
2 P" s; \  g. z9 [) g
6 E$ k1 s/ h" w; T/ H
2 n; @) Q/ C! p# x- y7 x6 J7 G0 i6 ^PHP Code:
9 {5 H" k; Y' L<?php
3 j2 J5 L+ `. Z) Fmssql_select_db ( "CHARACTER_01_DBF" );
# b% m9 V5 I( B6 }. n$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" ));
% D2 e- F, A+ N; r+ `- Lif ( $lord [ 'm_szName' ] != "" )
echo $lord ;
  S, {$ t# ~- M. z2 e3 y; Jelse
2 H8 Z8 f3 Z! ^6 K9 w/ _  uecho "-" ;
% R: @& x3 G8 {?>
MVP:

' k7 n( l: B% b9 i

PHP Code:
<?php
% t- _7 b3 y2 {3 v0 a$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 ];
! r3 l, T; P8 I! jelse
% a8 c" h! Y, V+ q3 Recho "-" ;
. p" l6 K7 i3 q$ Z% b. g4 J?>
1 j1 _9 p% I/ IGuild Winner:

; A$ K4 C: P7 @% r# X

: s3 ]: R" m0 w  Q: R6 PPHP Code:
<?php
: R2 N+ H: z1 j$ H  S$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 ];
else
echo "-" ;
# ?4 z' O4 I7 c8 L0 m/ G/ S?>
Don't forget to like it.. Of course if it helps...

4 R- V. W* T6 @5 B' R1 k