公会得主显示脚本

admin

Lord Winner:


PHP Code:
6 S' k; u7 @/ E( H* R) e$ _<?php
' [4 _( M, x3 ~& O7 \9 nmssql_select_db ( "CHARACTER_01_DBF" );
) n; q6 |3 \: U- L  x, Z- U. }$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" ));
4 E8 }4 F7 c1 ~- g6 K& w& Zif ( $lord [ 'm_szName' ] != "" )
8 i# @3 j. s' Y' I# h$ [' wecho $lord ;
/ T3 `/ t! w; N9 ~else
" w, a/ P/ K0 ^9 s8 y' Y% becho "-" ;
! c1 C1 r$ t2 R) F, c: k?>
MVP:
/ H# y( G8 M, l- Z% m3 m
; I6 U( X2 ?8 t; f0 T/ A- p: y- b
+ o( F. r. P% L  J6 t* M
PHP Code:
<?php
8 L  w; u  r  K; d/ w$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' ] != "" )
1 {3 S4 [, q2 f" q9 B- v7 W) ~echo $mvp [ m_szName ];
else
0 R! T0 Z6 ?8 D% B% h' ~2 t, L, p. zecho "-" ;
?>
3 x/ Z8 w& Z$ L. w! ^! vGuild Winner:

* e$ m+ K, a! J  I. L' p4 d% |
0 _3 L6 p* _( v9 F* p1 x- A! G
PHP Code:
  C  }- x4 j/ R<?php
/ u. ^1 i3 t- [5 A2 v$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" ));
( l( r+ A' M1 J0 ?8 Oif ( $crown [ 'm_szGuild' ] != "" )
3 X) C) X1 N# O1 Z! t& eecho $crown [ m_szGuild ];
else
echo "-" ;
?>
Don't forget to like it.. Of course if it helps...
( x- a3 Y0 l" J5 _