公会得主显示脚本

admin

Lord Winner:
$ q' ?/ \* d, O8 T5 _" G2 t

  K/ p+ r0 e0 F/ O2 I! P) i" WPHP Code:
9 m8 |8 g$ A# C% [$ e<?php
mssql_select_db ( "CHARACTER_01_DBF" );
2 {" R  J) a% Y5 M' d/ b$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" ));
& l3 q- w7 _5 c2 i# ?if ( $lord [ 'm_szName' ] != "" )
echo $lord ;
else
echo "-" ;
1 `- [, `0 V# R/ y$ g9 }?>
MVP:



! K/ |& h/ Y( \: [* zPHP Code:
: [: b2 z5 U- }, I<?php
* Q" L( w; v- {% h% F$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" ));
/ ~$ w) X( D, g5 J+ _if ( $mvp [ 'm_szName' ] != "" )
! ^7 H5 f4 c) [( K+ A3 A8 [echo $mvp [ m_szName ];
else
0 Q) L. v3 I5 ^4 @echo "-" ;
?>
: W7 a) b; T! X7 l! d! _Guild Winner:
3 G, J- U  D$ S; L4 K' C
0 B- J' X) K: w; o5 T2 I2 n
( `1 i  v9 W7 u, B7 r! J
PHP Code:
2 a# M7 y8 i, n; H, V9 M9 |6 {<?php
+ F: m: c6 d8 M+ a# ]3 g: t$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 ];
& @! R% }: }- Gelse
; Q" t* v! C& ~7 J: }3 n% u/ cecho "-" ;
?>
; H! p+ B1 T6 m8 j9 y; IDon't forget to like it.. Of course if it helps...

3 J5 L9 {3 m2 T