公会得主显示脚本

admin

Lord Winner:


1 |. v- l4 {/ c: \PHP Code:
<?php
- H6 S3 `9 C( j8 smssql_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 ;
else
' d; z- E! p  Q9 `) oecho "-" ;
2 d4 A+ H; @* T?>
MVP:

# |" P& G# b/ i( W9 G

PHP Code:
& J. v' L) d; a3 Q8 Y6 v<?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" ));
if ( $mvp [ 'm_szName' ] != "" )
" w! y( D9 k9 ^/ [' V% gecho $mvp [ m_szName ];
else
8 z1 i! z2 N' c2 ]2 decho "-" ;
- P" c* f% o* r8 S+ W2 q' G% u3 m' L?>
" E+ o1 V. A" x0 [9 B/ J; d: W" H2 oGuild Winner:
+ G7 Q2 I  M* ^* ]7 [

8 [# [' F1 i: B- @6 {; A/ e, K. A
4 D/ Y1 v+ g. x9 U5 R; y9 QPHP Code:
<?php
9 J5 ?/ F- ?& i! m2 {6 j$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
9 b( ~) v; N  A2 o+ ^echo "-" ;
8 h0 h0 i! l  S2 H' w?>
! W1 N$ T, U$ X# LDon't forget to like it.. Of course if it helps...