公会得主显示脚本

admin

Lord Winner:
( m$ a6 P" o$ N6 {( G3 |
5 g  s  j2 `# ~% F! j2 y: d
$ r6 j8 m: ?0 ]+ _7 aPHP Code:
<?php
" q+ C" @9 s+ {: [mssql_select_db ( "CHARACTER_01_DBF" );
$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 ;
) ]9 N) G; R% G8 S( F- _. R9 Melse
" m: e# L$ P5 `1 B9 {echo "-" ;
?>
* O  C  x: G9 t/ v& C- L7 C% O8 QMVP:
( Q+ o6 k! v; C8 Q


! ^) p+ v2 ]2 c+ j. u* T6 gPHP Code:
<?php
7 o9 T8 ]/ R0 z5 Y9 t; t( H$ `! J  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" ));
. v! L5 e+ {) mif ( $mvp [ 'm_szName' ] != "" )
echo $mvp [ m_szName ];
' A3 D+ {3 W+ ]/ N& Ielse
* ]# j1 g4 d" U" o, e( z& a0 |' ]echo "-" ;
?>
Guild Winner:
. q1 ^0 j1 v# Q, Y; S7 O  p

* D1 D* f3 U8 u3 f1 }# s- I% o
2 X5 H5 e- f# ZPHP Code:
1 p3 X, O3 Q, O5 ?2 [<?php
& O& g( `3 k- L( H$ p$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 "-" ;
?>
) N1 [( Z. x7 V) ]Don't forget to like it.. Of course if it helps...