公会得主显示脚本

admin

Lord Winner:
6 P, A4 `5 l# n1 T# T3 ^
8 V9 q' r% F, r. Z9 \: v
PHP Code:
4 O! r# w# M, s( c- h<?php
mssql_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" ));
if ( $lord [ 'm_szName' ] != "" )
echo $lord ;
else
! ?# `0 J9 }  W+ _' ^" recho "-" ;
1 a5 ?$ e5 p# O: z, Q& k?>
MVP:
6 P) k# m) U$ y

7 M" ?9 ]. _: x
PHP Code:
0 i' o. d+ B8 |% e% A<?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" ));
  C8 s5 t  \: S/ k+ Gif ( $mvp [ 'm_szName' ] != "" )
echo $mvp [ m_szName ];
else
* `: Z+ s- y7 h/ p/ A0 ]: @echo "-" ;
?>
Guild Winner:

8 y; l# f3 O9 [9 p) R8 i
( [7 P' x# G3 ?) F
PHP Code:
2 Z3 T& I: U* L& t' H; x<?php
4 t; ?* c: ~% N1 F$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 ];
$ Y: ?& ?4 ]- Y$ S5 v7 G8 n9 l& r! jelse
" t2 J6 j: E% b" A, Iecho "-" ;
( R5 R/ T0 x, v9 y* k( |! m; D( j' M?>
( L3 V! q9 k) `+ G6 F/ L# r9 Y8 jDon't forget to like it.. Of course if it helps...