公会得主显示脚本

admin

Lord Winner:


PHP Code:
<?php
; p0 f, Q# V  ^mssql_select_db ( "CHARACTER_01_DBF" );
2 T, ?  k2 o2 N4 B( R/ w$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 "-" ;
2 L6 N8 S/ C5 {?>
MVP:
' [# m1 Q  m" @$ X- z. h
, r# ^& T1 H+ L* ^  Y, [
) b, r7 o" I. e) o  H2 g2 C
. O0 o( \( w( l. R2 BPHP Code:
! |- {/ D" Q* ^& B2 p<?php
9 x: j" {$ i3 o+ V0 v1 }5 W$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" ));
+ e9 F# O6 R' Q" uif ( $mvp [ 'm_szName' ] != "" )
echo $mvp [ m_szName ];
2 i+ |$ @+ y8 j; Q. selse
# }8 N5 V( J+ `2 ~- lecho "-" ;
?>
Guild Winner:
& |  q; Z- h5 S/ O

! S( N# k; N+ |6 l. ]7 t
' [- p2 j$ |) H, T7 U5 V6 O6 lPHP Code:
5 l: ?: r2 e) a1 {<?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' ] != "" )
echo $crown [ m_szGuild ];
+ \* Z& @0 y8 L7 |& E: o/ V1 _else
echo "-" ;
; s+ a1 x3 c; _  J?>
Don't forget to like it.. Of course if it helps...