From 34480c6ddb7b0ee0c2992c28e7a2ceadaf468d82 Mon Sep 17 00:00:00 2001 From: Jesusaves Date: Wed, 20 Mar 2019 10:30:21 -0300 Subject: Acknowledge guild hall + sql query --- npc/003-3/malindou.txt | 2 +- npc/functions/scoreboards.txt | 1 + 2 files changed, 2 insertions(+), 1 deletion(-) (limited to 'npc') diff --git a/npc/003-3/malindou.txt b/npc/003-3/malindou.txt index 88f5b1d96..d32338e44 100644 --- a/npc/003-3/malindou.txt +++ b/npc/003-3/malindou.txt @@ -309,6 +309,7 @@ OnInit: htput($@CONTRIBUTORS, "acsvln", 260); htput($@CONTRIBUTORS, "ayruss", 210); htput($@CONTRIBUTORS, "dustman", 175); + htput($@CONTRIBUTORS, "arthur", 110); htput($@CONTRIBUTORS, "ichigoblack",100); htput($@CONTRIBUTORS, "gnulinux", 90); htput($@CONTRIBUTORS, "skydragon", 75); @@ -322,7 +323,6 @@ OnInit: htput($@CONTRIBUTORS, "john h", 2); htput($@CONTRIBUTORS, "krists", 2); htput($@CONTRIBUTORS, "filhote", 1); - htput($@CONTRIBUTORS, "arthur", 1); //htput($@CONTRIBUTORS, "", 1); end; diff --git a/npc/functions/scoreboards.txt b/npc/functions/scoreboards.txt index 7eb763dd7..0ddf20ee5 100644 --- a/npc/functions/scoreboards.txt +++ b/npc/functions/scoreboards.txt @@ -36,6 +36,7 @@ OnInit: .@nb = query_sql("select name, base_level from `char` WHERE `guild_id`!=1 ORDER BY base_level DESC LIMIT 15", $@hoblvl_name$, $@hoblvl_value); .@nb = query_sql("SELECT c.name, i.amount FROM `inventory` AS i, `char` AS c WHERE i.nameid="+StrangeCoin+" AND i.char_id=c.char_id ORDER BY i.amount DESC LIMIT 15", $@hoc_name$, $@hoc_value); .@nb = query_sql("select char_name, command from `atcommandlog` ORDER BY atcommand_id DESC LIMIT 15", $@hogm_name$, $@hogm_value$); + .@nb = query_sql("select name, guild_lv from `guild` WHERE `guild_id`!=1 ORDER BY guild_lv DESC LIMIT 5", $@hoguild_name$, $@hoguild_value); debugmes "Scoreboards reloaded"; end; } -- cgit v1.2.3-70-g09d2