公会得主显示脚本

admin

Lord Winner:

. ]/ l( p/ g) X
7 r+ n$ n1 o$ }( f8 @PHP Code:
- Y9 o$ S- x/ x/ u. }<?php
5 N1 t8 W( ]/ [- cmssql_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' ] != "" )
5 p- Y7 C, B9 B( U" Necho $lord ;
7 U8 t( _7 i5 p' ]else
# C8 \* d3 z* g! J% n' n0 Uecho "-" ;
  U# |/ q- f0 {7 T- `% V8 n?>
MVP:

* B, \# S2 I9 q' y
) g, k9 }3 w" _
# @! O; L2 e( I# h" SPHP Code:
( J  I" T' K& F/ R<?php
! y! i# F$ l( A8 c: X# O$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 ];
9 \" x4 o8 a$ m! A" e6 aelse
5 N3 s4 s! L& N) Q) wecho "-" ;
( i% L6 M- x# _, Z1 T& A?>
8 h3 b  i' i5 B; `- ?Guild Winner:


; ^6 w$ [' k8 @& C2 U
PHP Code:
- s4 j4 |; d( k! I, k<?php
5 h$ t6 L& v# a  V9 G$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" ));
* h, g6 O. u4 c6 w$ a3 eif ( $crown [ 'm_szGuild' ] != "" )
echo $crown [ m_szGuild ];
: I5 j5 M: {/ V2 T- t5 A0 Felse
8 C7 ~) v$ L3 W4 [echo "-" ;
) r/ f* _0 A% X8 t- q  @?>
0 A7 N" O; w( V/ z6 r, ZDon't forget to like it.. Of course if it helps...