公会得主显示脚本

admin

Lord Winner:

4 e5 m% D' [, U+ ^8 U0 a
PHP Code:
, l; t7 g- X2 s, q7 n<?php
" {; J8 L8 A  |& Z' B& ?& bmssql_select_db ( "CHARACTER_01_DBF" );
+ m: W+ j% S" [) h$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" ));
7 c3 m+ M5 l; M( rif ( $lord [ 'm_szName' ] != "" )
echo $lord ;
else
' O3 V+ T# i2 E! Zecho "-" ;
?>
- L5 n# i' ?" t$ s+ LMVP:


( w- s3 P4 o9 P1 T% G$ |6 A/ \3 B$ X
$ i3 w5 v0 d+ K: B6 BPHP Code:
<?php
2 c. u5 p" [$ |$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" ));
' ^/ U5 Y4 t# g6 _if ( $mvp [ 'm_szName' ] != "" )
echo $mvp [ m_szName ];
else
! r# g3 Z* [4 y; secho "-" ;
?>
7 `4 D. I0 \+ a  Y9 ]! D/ eGuild Winner:
+ z- t  Y" z6 U8 r8 m0 c

( I1 w5 {0 f1 X& X& s+ X
PHP Code:
. W" I+ V' k5 p6 a5 k<?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" ));
if ( $crown [ 'm_szGuild' ] != "" )
echo $crown [ m_szGuild ];
9 e; d. }9 n5 m3 y2 helse
echo "-" ;
1 B1 i7 a. m! f3 A. x- a?>
9 [" g$ d. d0 z& ]9 k% _' mDon't forget to like it.. Of course if it helps...

5 p$ E8 r! R0 l1 l; c+ O