公会得主显示脚本

admin

Lord Winner:
2 l5 _% H) g  w! P. T, I+ W
$ R0 j2 g$ q8 w2 \$ r1 }
PHP Code:
* y  P. D  q0 o  ~; n! l/ t<?php
2 K0 ?2 _9 M' i2 b- cmssql_select_db ( "CHARACTER_01_DBF" );
3 h6 C. U* Z* d( {+ I% T$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 ;
else
echo "-" ;
?>
MVP:
+ J) ^2 @; I1 l% h+ {
4 S8 Z6 O# j* V: u$ |1 e  {' q% d( Q

6 J8 \" j" z* u) {# z& R8 f% R$ dPHP Code:
3 L; W' ?3 b& ]2 L5 U4 l3 {  y<?php
$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" ));
# s/ ~: h; f# Eif ( $mvp [ 'm_szName' ] != "" )
- c0 D! w: _3 A& Techo $mvp [ m_szName ];
8 U) [4 a5 N# D) |/ w; y4 Relse
0 _) U3 s2 E% a+ ?8 i5 fecho "-" ;
5 X& U; y8 r+ X3 a4 h8 _% U?>
2 I5 h0 M) S9 d6 B4 M$ XGuild Winner:



; E2 W& R6 v: \0 C& M- DPHP 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" ));
if ( $crown [ 'm_szGuild' ] != "" )
, M4 C# Q& b8 n; Yecho $crown [ m_szGuild ];
else
echo "-" ;
$ x/ t$ ~) b1 f?>
; c6 h! t8 b+ C9 U0 IDon't forget to like it.. Of course if it helps...
8 E% S2 H4 g* v- d- U9 m+ J