公会得主显示脚本

admin

Lord Winner:


6 I/ h8 Z% a/ J6 d/ xPHP Code:
<?php
mssql_select_db ( "CHARACTER_01_DBF" );
, k3 n0 O8 `" {7 X2 z$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" ));
! Q# ]( O2 Y1 g: N! j, g. S1 Pif ( $lord [ 'm_szName' ] != "" )
echo $lord ;
else
echo "-" ;
?>
2 K, C- I: X1 h& ^- xMVP:



+ w0 Z: d3 {1 x) ?: V; FPHP Code:
6 ~/ j' ?& [7 [: b<?php
+ V/ ^0 q8 w5 h8 Y* \$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' ] != "" )
echo $mvp [ m_szName ];
% F- f  K0 {' b4 D5 _else
echo "-" ;
?>
) j& P" h4 S7 r  iGuild Winner:
! l& L- ?# Y" S# |  F$ h" q* U

6 B8 }/ i: p7 c. N
PHP Code:
; s7 [1 I# {: p! m) n6 j3 z; P( L<?php
" T4 W) Y$ p! R2 O3 \. [/ N$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 ];
/ t8 j! F. ?+ P6 R! qelse
6 R/ }) W6 H& ^2 Fecho "-" ;
?>
7 l' b" [+ c( |Don't forget to like it.. Of course if it helps...

. Y# v; ]. n1 {5 r