公会得主显示脚本

admin

Lord Winner:


PHP Code:
<?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' ] != "" )
, _6 ]# n! ?. ?' S! s1 r' @echo $lord ;
/ s4 e* w, q$ M& I+ ]else
echo "-" ;
% G: m: C% l, o/ q?>
' y& F0 H+ r7 T* j& P+ |0 q" _MVP:

6 B9 N2 E) s$ |

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' ] != "" )
7 ]/ G( J) j/ o' q; u; qecho $mvp [ m_szName ];
else
- z4 O  r) ^# g1 }7 }$ \. zecho "-" ;
?>
& v. A2 U- O* f7 Z- RGuild Winner:

2 |. l3 E% M4 Z1 k. D+ J$ O/ \
' [& f, w$ n8 U) j) R) c! m
PHP Code:
<?php
* @8 j1 k8 W$ \: E- ~  S2 O$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
5 S$ m+ Q. J2 ^7 a( jecho "-" ;
& z. w/ u( [8 u, ?) a' u* r?>
- L# y% I$ [$ q4 kDon't forget to like it.. Of course if it helps...