公会得主显示脚本

admin

Lord Winner:
# Q. x, t3 ^3 ]+ D4 ~* {# X0 ?8 `
' G( j3 j, ~- M# S. P: j
1 {! A. _/ o: `) n5 g5 O0 M4 w8 ?PHP Code:
. F2 B" B! B) z" p<?php
" \6 p  Q2 F1 r5 V! ]4 Vmssql_select_db ( "CHARACTER_01_DBF" );
! ~+ g! S3 f; E( ?9 I4 |) Y5 x$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" ));
5 m+ ?. g# o9 P6 A" @9 u& X- Oif ( $lord [ 'm_szName' ] != "" )
echo $lord ;
& O) e6 O( D2 _7 p1 Celse
" O9 N$ W) H& T; W9 v1 f3 Qecho "-" ;
8 r1 `8 p- Y# r/ l( G* M# x7 R# [?>
MVP:

' [5 m: f, g  ^( O3 N3 U9 x
; S% h; D4 z) \
: B# e7 F8 \) {0 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' ] != "" )
+ a; m) _! ~, p# {/ B9 yecho $mvp [ m_szName ];
! V3 N: E1 b' k* O* M1 G9 }else
echo "-" ;
?>
Guild Winner:
" u) q6 x: U# F
' d' J6 M3 ]2 P
, L0 I  j% a+ E
7 ^, X3 N7 e; `PHP Code:
) }5 x' H- `, g( ]5 p; t<?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' ] != "" )
. T! ]. m! }5 }+ N& F' Xecho $crown [ m_szGuild ];
7 t) L% L1 c$ y3 B7 d" gelse
echo "-" ;
?>
Don't forget to like it.. Of course if it helps...

# N  l$ s3 d/ j& f