公会得主显示脚本

admin

Lord Winner:
; p3 B8 `' E- ?
; t7 ]0 [% Y; z) U5 C
PHP Code:
  a- T( P8 {1 y9 g+ u<?php
/ i% ]9 }0 D; q- \$ vmssql_select_db ( "CHARACTER_01_DBF" );
7 f& w  \. E/ j6 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' ] != "" )
echo $lord ;
$ v' h# \5 \1 c$ felse
6 [" g- B/ O& u5 f# kecho "-" ;
6 ~  C" a2 Q9 N+ ?  v/ I# d?>
% i6 S4 d, O( x7 [' L8 ~MVP:
. B( {' X) D' w

: e) c1 d( L: g* y& t4 d: A
PHP Code:
5 V9 O$ [: L6 J- c, j* I3 s4 J$ ~<?php
/ q# H! p# [8 U$ ~7 Z! |: H- {4 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" ));
1 ~" z# y: f9 Eif ( $mvp [ 'm_szName' ] != "" )
) ]  r1 q" W' n9 [6 A4 f% @/ mecho $mvp [ m_szName ];
2 a7 D- p6 \. t- l/ |1 S( B9 A6 Qelse
echo "-" ;
?>
Guild Winner:
, x% v+ a5 h& \4 O: ~

+ ?; a' |7 X2 [9 t) P6 T, R& V
PHP Code:
+ ?+ h; C" z6 E- ?<?php
* B- ^+ M( t6 I9 b$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" ));
: B* |/ `, I6 S' X2 D- a" T5 eif ( $crown [ 'm_szGuild' ] != "" )
echo $crown [ m_szGuild ];
else
echo "-" ;
?>
- R0 w# i* ?  v7 |( k+ {Don't forget to like it.. Of course if it helps...

% h0 g9 \1 c6 P+ a) X1 Q