公会得主显示脚本

admin

Lord Winner:

1 I  R1 Q! p# Z6 A/ U% y5 o
; [3 X: a4 v* o) q  ^% R( ZPHP Code:
1 o  G: x2 @9 ]<?php
" k; r' o, ^. f  Cmssql_select_db ( "CHARACTER_01_DBF" );
1 W% u% g- B! ^) ^" g$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" ));
/ `% O9 {" V5 a0 j/ D3 Oif ( $lord [ 'm_szName' ] != "" )
, h7 T) J9 Q  d. Recho $lord ;
8 c* b/ g; W5 M- N5 jelse
7 v. w/ R6 F" u8 D/ w5 k' C7 Xecho "-" ;
* n- z# H4 o5 s8 Y' f?>
& Y) o" l0 D! o/ L8 z; z6 }8 BMVP:
- V) ?6 E; C/ n  z/ x: v2 U
6 P4 R7 @0 B4 H8 x/ G6 ?1 a8 t/ D5 {

PHP Code:
<?php
) @* `4 Y$ g+ U- u$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' ] != "" )
, s  E2 v- \: O9 h! u% T0 X5 xecho $mvp [ m_szName ];
else
echo "-" ;
% A8 A0 O! d( u1 ^' W* \?>
; h! P- d7 n9 V: `4 w& XGuild Winner:



* M  L" G$ J/ }& mPHP 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" ));
/ T3 w' A9 S! p- ~- Yif ( $crown [ 'm_szGuild' ] != "" )
& D7 Z2 u- i, K: wecho $crown [ m_szGuild ];
" d, Z0 s* h' A: h: i' jelse
echo "-" ;
8 Z1 Q3 m' V+ H! l$ }0 a6 f+ w?>
Don't forget to like it.. Of course if it helps...
9 L7 V: Y' X( a& D