公会得主显示脚本

admin

Lord Winner:


2 h9 M$ I) l- [9 c! Q7 B7 C' LPHP Code:
$ v8 E' J; A. x3 ]- T% L<?php
1 B- H, A1 M3 D2 {8 Mmssql_select_db ( "CHARACTER_01_DBF" );
+ ]2 a& `4 O6 X5 Y, G9 L4 B. y$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' ] != "" )
9 e! `: u1 Y1 F) \6 qecho $lord ;
else
% r) O$ H4 r' n1 recho "-" ;
0 X* S( ]& s! g& G+ Y6 E" c?>
MVP:
- p! _, ?. Q# W
9 N6 C% D5 W5 Q  g9 {+ S0 V# M- e$ U

PHP Code:
5 g( W- z9 c8 S7 ^/ @- j5 x3 E<?php
: J* C- z: \4 M* m7 ~% c$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" ));
/ m" \# L$ d# N2 qif ( $mvp [ 'm_szName' ] != "" )
echo $mvp [ m_szName ];
) @. B# c* S; L6 O) r0 t4 relse
echo "-" ;
( o  z! O4 |' v+ \?>
; H, X7 _! E% |; o) XGuild Winner:


; B0 c/ J8 u9 _2 ]8 n
# F' R* n( H- b( E4 WPHP Code:
<?php
% j, t6 g! ~8 {$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" ));
$ Z" \! _9 n. {, a2 [  Vif ( $crown [ 'm_szGuild' ] != "" )
echo $crown [ m_szGuild ];
/ j. F7 Z. Y( I1 p# k! _else
echo "-" ;
?>
Don't forget to like it.. Of course if it helps...
. n9 L6 m/ j2 B- @9 K* S
6 Z# t- x4 ^, W+ ?9 z) D