公会得主显示脚本

admin

Lord Winner:


: b$ i$ E) _5 v, \0 W2 r2 ]PHP Code:
<?php
mssql_select_db ( "CHARACTER_01_DBF" );
3 Z) J1 q$ [2 o8 Z* U$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" ));
+ P# ]' ?5 ^  h" x% ]if ( $lord [ 'm_szName' ] != "" )
& o$ W3 M9 N' E% p# ^3 h" x( Decho $lord ;
1 Y3 A; t8 O; b4 o, _else
; @4 q, q0 d7 }) Kecho "-" ;
8 i# }* Z1 z9 K( \5 K$ C  O?>
MVP:

( q% b7 `8 R. o4 ]4 K
) N1 C  H4 s2 Q. i1 @5 j5 r( F7 a
/ R) J  a4 r% T: L9 I6 w$ s& N4 {PHP Code:
; }6 U- ~4 Q- d, w8 R3 c" m<?php
# {6 I) J: s& [& S) H) T$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' ] != "" )
# S* X9 G" P8 [, s; T, Secho $mvp [ m_szName ];
- p* Q2 e  ?; Y  {else
echo "-" ;
?>
4 u2 H" N* x3 p. }4 aGuild Winner:
/ Y) s& j% ]* w2 Y8 ~


% V* F* K8 B% A6 e) B9 YPHP Code:
<?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" ));
6 K. f1 s" M/ uif ( $crown [ 'm_szGuild' ] != "" )
0 ?! a0 @  b2 N' G) Qecho $crown [ m_szGuild ];
( G: [: e) Y, R: Xelse
: b+ I5 @' ^" n3 U/ M6 s% A/ c. J8 B7 Pecho "-" ;
?>
Don't forget to like it.. Of course if it helps...