公会得主显示脚本

admin

Lord Winner:
5 f- h; c+ a! ^+ h9 K* d' H& Q! L

PHP Code:
2 S! m, z: g: Z<?php
8 _" k3 T( ]6 O" Omssql_select_db ( "CHARACTER_01_DBF" );
+ i/ _3 [8 b' @  \9 ]  W9 m$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 y. R6 Q3 I  O; x/ }. }if ( $lord [ 'm_szName' ] != "" )
0 S5 {4 g+ l: @# ^echo $lord ;
) N# @& c5 a' z4 F2 }else
echo "-" ;
?>
MVP:



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" ));
4 s% E( r6 T2 ], z2 D+ Y0 O( iif ( $mvp [ 'm_szName' ] != "" )
6 x  w% p5 u0 h" Eecho $mvp [ m_szName ];
else
3 z" R4 U* y) O" I8 v( D9 `echo "-" ;
" M( \1 p8 T. T* y" T?>
: ^8 B4 Y4 l. \4 n* W6 t: zGuild Winner:


; B  z6 ]. ?+ {) X- \
PHP Code:
" C8 o2 i; ]' P7 ?<?php
( O6 c+ B6 [+ x* @$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
1 m% h; q  X4 n  s# B+ x) Qecho "-" ;
: J1 R+ g4 g. g7 _, e. J& x?>
$ k6 R% t& L, w: C/ j' u- lDon't forget to like it.. Of course if it helps...
$ s* }, h+ L0 T( q