公会得主显示脚本

admin

Lord Winner:


PHP Code:
: E% y! p0 s) j1 ^<?php
6 H5 V. o; p" s1 I1 zmssql_select_db ( "CHARACTER_01_DBF" );
$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" ));
2 o$ @3 F* c" [8 ~) xif ( $lord [ 'm_szName' ] != "" )
echo $lord ;
7 }# Z) P# x$ L% velse
7 S- x( l9 y8 R2 Hecho "-" ;
?>
9 [2 O- c$ W. `1 b4 U% QMVP:
9 L0 I" ^: F. F2 `  t# s
3 r# {. l4 b6 [1 I( b3 }7 L, }' p7 f0 x
  v3 s, W2 j* x# j$ c6 u
PHP Code:
<?php
  e8 \8 _7 o' M, T9 _$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 ];
2 E0 ?* X1 T' J0 velse
" k" i7 f  V2 a* ~4 Necho "-" ;
?>
Guild Winner:
9 E/ Q/ O! ]! }/ l5 S% H  H

7 l/ m+ H( {) t8 f& Z( I; ]& ]
PHP Code:
  }' D( X; f% w+ W9 I) ^, C8 K<?php
# Y2 B4 E# e) ^8 W$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 ];
else
/ [! x2 p! ]/ o& x4 X, wecho "-" ;
1 y% D# C: }+ n8 O?>
Don't forget to like it.. Of course if it helps...

1 Y7 S( F- h6 d, g  K! E4 ~( J