公会得主显示脚本

admin

Lord Winner:
( U$ x  B' v+ j8 s5 \. ~. `) v

PHP Code:
, R: O! N: H& |8 w6 `& a9 T% D2 N<?php
. J* z  Z$ s, F6 Y& Lmssql_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" ));
: U! m+ K- j/ R2 rif ( $lord [ 'm_szName' ] != "" )
echo $lord ;
else
echo "-" ;
9 u4 m- N% x5 _' o) L% a?>
/ m, ]% q. g- k7 LMVP:



. g, }8 q. O  F: e$ a& S' DPHP Code:
% T# C" e( q! e/ E2 m<?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" ));
" L; l" g% ~5 Y7 H$ I+ gif ( $mvp [ 'm_szName' ] != "" )
0 v# u! `( U" z: n& ^echo $mvp [ m_szName ];
' t# e! M, X: q+ b- ]7 Z& @3 ]2 Selse
7 N! V: x/ v1 Y+ K) k# Z+ Zecho "-" ;
?>
* a6 _' r% J- ^Guild Winner:
3 n: S% [5 O1 S4 U7 U/ ?

. p0 _6 N* F/ c; d; R+ ]. j$ R- ]
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' ] != "" )
1 U: g' [) _, Q" M5 A) Techo $crown [ m_szGuild ];
else
2 g( f. }( P$ Pecho "-" ;
6 N  B) G  z/ q: ?3 T; g?>
, B8 X7 J& T$ w7 ?' cDon't forget to like it.. Of course if it helps...
8 Y& R7 q- H4 ^- N; F" @