公会得主显示脚本

admin

Lord Winner:


PHP Code:
<?php
, T; Y& |' `& k" C2 H( u7 Imssql_select_db ( "CHARACTER_01_DBF" );
' C8 u5 `" G  v" u/ {) K( k* 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" ));
. u, D7 A! `/ bif ( $lord [ 'm_szName' ] != "" )
echo $lord ;
else
echo "-" ;
?>
MVP:
% y( X9 T( c* a9 w( Z$ H+ L


4 {8 h9 Q6 l/ o3 W$ gPHP Code:
) F7 X* m3 o% J* L, D; R<?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 \+ G: N! `, ?$ Cif ( $mvp [ 'm_szName' ] != "" )
, j( u( D4 C9 Aecho $mvp [ m_szName ];
& T; b% K" t* c) k4 C6 delse
5 G- `/ k: K% [echo "-" ;
9 d+ W9 M7 b5 Y5 x* y" L+ Z8 x?>
8 ^7 n  s% j1 ~Guild Winner:
* t1 @! v& F" x6 J8 x, A


PHP Code:
" b+ H9 Z$ F4 {0 h<?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" ));
! L, g4 q6 ~4 rif ( $crown [ 'm_szGuild' ] != "" )
echo $crown [ m_szGuild ];
* V! {0 f9 C6 v* |! ?0 W  D. Q# l9 l6 u5 ielse
echo "-" ;
2 u7 Z) R. l5 M5 i?>
9 b0 Y# F( Z/ `1 kDon't forget to like it.. Of course if it helps...