公会得主显示脚本

admin

Lord Winner:

* Y: Y7 A2 Q. {  c% r) S$ I
PHP Code:
  q. i& J6 L) t; B- Z4 T+ t# W<?php
: s4 U! r" E0 M7 j1 U$ Kmssql_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" ));
7 H6 P2 G' d- ~* Z* @2 Y- F1 cif ( $lord [ 'm_szName' ] != "" )
$ Y: m% i/ V. i: f; Aecho $lord ;
3 Z4 A: q/ ^$ ]. celse
echo "-" ;
  O7 F2 E" b* |0 r4 M?>
" R( s+ D3 Z) sMVP:
( c" u0 G: v# Z. i+ l
- U& D2 b# \3 Z/ b! i8 W
% p- d; B/ m3 L0 J
2 o+ A! x7 u8 l; X3 `' ~- ~PHP 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' ] != "" )
1 H* R, ^$ z, X5 [+ Jecho $mvp [ m_szName ];
else
echo "-" ;
?>
% e# W& E; R1 R% \4 x% v) dGuild Winner:


/ N* b$ X! D# X! t
PHP Code:
7 [7 u7 V2 H% ^$ P  Z! L  h( ?<?php
3 F% W; V. s; N5 A+ G& \$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' ] != "" )
echo $crown [ m_szGuild ];
else
4 c! y( X2 Z. r) w9 Decho "-" ;
) M0 \5 ^/ q1 l+ K?>
6 f1 [; v: _4 a7 V5 ~Don't forget to like it.. Of course if it helps...
! `, `2 A8 K" a. p4 a0 J