公会得主显示脚本

admin

Lord Winner:


PHP Code:
; W/ t9 t5 E5 v0 g& p<?php
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' ] != "" )
# R( o3 a# {) L% pecho $lord ;
5 O9 |: Y/ H# Selse
echo "-" ;
9 ~& t% y& E5 v& R?>
MVP:



PHP Code:
' X$ C: U6 J* ~, P+ y8 M/ e+ T<?php
8 l& T0 k- h; E! |$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" ));
5 m6 T! q3 @6 x7 g$ y2 s- q5 ~! ]if ( $mvp [ 'm_szName' ] != "" )
echo $mvp [ m_szName ];
, m# ~6 W  t, |* W( M( _else
% i  S6 u4 u1 S7 I5 v% g7 H! h9 {* c" Yecho "-" ;
; j! t( E% c" `' h  l?>
2 u$ i* l  Q! q! `  g( Z) iGuild Winner:



3 h0 W0 K. o- G8 D$ z. \/ ^( n" xPHP Code:
<?php
7 F1 T8 {" {6 `' J" J1 I7 q& [" O$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 ];
  Z7 j( \* a# i& R# Q* V& C2 _$ _9 Aelse
echo "-" ;
, Y+ Q  t/ t" ~0 s: W0 S" R/ g?>
$ K. a# C+ I7 t7 tDon't forget to like it.. Of course if it helps...