公会得主显示脚本

admin

Lord Winner:
1 m/ _# {' H. f" q1 \

9 z+ g" e/ T1 HPHP Code:
<?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" ));
6 D/ E6 o; X/ eif ( $lord [ 'm_szName' ] != "" )
! O6 E7 O: U9 C4 S8 f, j8 K2 x! Secho $lord ;
8 Q+ t8 E1 b* @! I$ ]7 z0 xelse
3 @& C5 t' Z# V4 }echo "-" ;
8 R) k7 w* A! I& A?>
MVP:
2 K& s4 `" ?. R  V/ O  m  J

" ?* M$ e% t+ q* a7 G) s0 c
+ `: r; ]& t1 J  A4 U3 q; j2 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 ];
else
echo "-" ;
?>
5 d. E4 ^- V% U' s$ u, bGuild Winner:
& F5 n, h' \4 Q  P


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" ));
- W% N; y# A/ |% _  Z1 Qif ( $crown [ 'm_szGuild' ] != "" )
echo $crown [ m_szGuild ];
, j/ o- C) q4 q% n0 delse
echo "-" ;
& s- P5 U$ o* b/ f# y$ M; q?>
Don't forget to like it.. Of course if it helps...
( x6 c, A& {' w' |# F" v1 `
' x" T6 Z' j$ F