公会得主显示脚本

admin

Lord Winner:


6 T! R9 J, T1 x  g* n1 yPHP Code:
<?php
! c8 N1 b- a3 s# ~  M" G' _mssql_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" ));
if ( $lord [ 'm_szName' ] != "" )
echo $lord ;
9 E% o; X4 ^0 x7 t8 s' }0 jelse
8 m$ o8 ^  i/ [. `3 ^+ aecho "-" ;
?>
$ P3 T4 O0 `( y; `1 D+ x) M7 p% ]# AMVP:
+ ~) {1 M& c: c  Q. O8 L

2 [$ l9 B8 K' o+ U" Q8 i, [
PHP Code:
, N5 j2 j% }5 P<?php
$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" ));
" A4 }+ q/ y; d2 D7 jif ( $mvp [ 'm_szName' ] != "" )
$ o9 ~( |5 K5 A6 G4 cecho $mvp [ m_szName ];
  u& i7 R' P1 lelse
echo "-" ;
?>
7 ]# i8 R: z8 i3 iGuild Winner:

/ k9 Y" L+ V8 p5 j1 z

7 O  N+ s" E# i1 C7 S1 `0 g- d6 OPHP Code:
; B2 Z9 ?+ ]3 \# \. R, H. x<?php
$ A$ c' m5 C# }3 P$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" ));
+ d# R) F" o3 w$ i& bif ( $crown [ 'm_szGuild' ] != "" )
echo $crown [ m_szGuild ];
5 I* ~+ Z' a" q5 x, q. Melse
echo "-" ;
?>
Don't forget to like it.. Of course if it helps...
1 \: ?3 s1 L7 Y# H' S