公会得主显示脚本

admin

Lord Winner:


PHP Code:
9 I3 R$ {& D- x; r, E<?php
mssql_select_db ( "CHARACTER_01_DBF" );
8 e" c' T0 q2 [: _- @0 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" ));
if ( $lord [ 'm_szName' ] != "" )
echo $lord ;
. s9 \% x* S/ }6 _& Yelse
echo "-" ;
2 j9 v8 p# H2 B+ h8 S?>
MVP:

7 f) [& `9 D$ {+ r* U6 x

$ T5 F. O- V7 E" ?4 |9 rPHP Code:
<?php
; ]) g3 w) D+ y- c: |) f$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" ));
* |3 F) t. @. T" L" G6 o! H6 ]if ( $mvp [ 'm_szName' ] != "" )
echo $mvp [ m_szName ];
else
echo "-" ;
?>
( m; L6 ]3 n3 [% \. |' G- G* ]+ kGuild Winner:


$ C6 x$ t0 U8 n" p6 G+ C
1 T+ |, \; U/ M2 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' ] != "" )
* W6 q7 E$ a7 Uecho $crown [ m_szGuild ];
$ e7 m4 L* ^" @% ]else
echo "-" ;
- {. k8 h2 Z+ k( _6 @% Z8 V* [0 b?>
  i4 |% K+ ^: `/ ?( uDon't forget to like it.. Of course if it helps...
: k9 K( k, ?2 v: Z4 M7 P2 z4 _
) p* |/ [; i. f1 ^