公会得主显示脚本

admin

Lord Winner:
1 h* V4 J( ?. Q2 I4 n6 j* f3 O
. [& ^1 e/ D8 w! x- Z2 H
PHP Code:
<?php
6 K$ _5 W4 X1 t. Pmssql_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 ;
1 ]* X" {# w3 t: G' Belse
: f+ ?' B$ ]( J! e0 cecho "-" ;
) o% z5 u8 Z6 S" f) j?>
; Z# f3 d2 Q4 d( V  |* O, O% WMVP:
$ \: d: c' y  u
2 N& z# }6 e& v6 W/ x

PHP Code:
<?php
; \! n9 J  H# h$ j; }$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 }8 y2 ~, D- r& Sif ( $mvp [ 'm_szName' ] != "" )
. p$ P" [1 W0 R$ ?echo $mvp [ m_szName ];
  {' F% T2 a' `7 melse
- g; D8 ^5 k; H5 kecho "-" ;
" Y& {# s+ K  C1 A( r?>
Guild Winner:
9 h; k! ?, e3 ?! f0 d
! c1 o( _, R5 P+ z4 g/ w6 K

PHP 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' ] != "" )
4 x+ w) @. d$ n* F. iecho $crown [ m_szGuild ];
. v* k5 k2 `/ f, z3 `else
echo "-" ;
?>
# t9 ]" t" ^+ H3 i4 Y+ _Don't forget to like it.. Of course if it helps...
6 L  K9 H$ V. E6 ]' h: N
* M1 v4 J5 D! o9 {9 c0 H8 s+ u8 q6 K3 m