公会得主显示脚本

admin

Lord Winner:

/ y6 j( Q& `9 Z; I, K0 K, n# R' S
5 u1 A( P! z* s5 M7 _  GPHP Code:
0 r* E/ s/ U: z/ I5 E) ?; ^$ o- U' v6 f<?php
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" ));
) x# z. @' n+ B' C1 _) [# Z/ bif ( $lord [ 'm_szName' ] != "" )
: p) O5 e/ A7 `6 R0 B  y8 becho $lord ;
else
echo "-" ;
?>
MVP:

5 Q0 N' P5 f" \. ~; j# I. L, W

/ ~$ A  N( _3 X/ ]. bPHP Code:
<?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' ] != "" )
echo $mvp [ m_szName ];
! H( u- J9 b" P3 i$ @- Lelse
echo "-" ;
?>
8 \* x5 p6 |* WGuild Winner:



PHP Code:
7 p0 i# S7 M2 R3 }  R7 r2 H<?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" ));
4 ?$ [4 c+ }' Z8 U9 y6 sif ( $crown [ 'm_szGuild' ] != "" )
. y, O* K  J" yecho $crown [ m_szGuild ];
else
echo "-" ;
- ~* E- f+ b3 V8 p$ D+ K?>
Don't forget to like it.. Of course if it helps...