summaryrefslogtreecommitdiff
path: root/npc/functions/scoreboards.txt
diff options
context:
space:
mode:
authorJesusaves <cpntb1@ymail.com>2021-04-13 22:37:09 -0300
committerJesusaves <cpntb1@ymail.com>2021-04-13 22:37:09 -0300
commiteaf8bd0c57ef85accb6fb7bea07499c0005e92d4 (patch)
tree1a8a9c56f6412a1b784429d3274fec75e74f6f47 /npc/functions/scoreboards.txt
parent1d2d15c943351a930fef4b91fe8c8b435a1695c6 (diff)
downloadserverdata-eaf8bd0c57ef85accb6fb7bea07499c0005e92d4.tar.gz
serverdata-eaf8bd0c57ef85accb6fb7bea07499c0005e92d4.tar.bz2
serverdata-eaf8bd0c57ef85accb6fb7bea07499c0005e92d4.tar.xz
serverdata-eaf8bd0c57ef85accb6fb7bea07499c0005e92d4.zip
Hall of Acorns - Only consider first char (if exists).
Not using first char slot removes you from this scoreboard ^^
Diffstat (limited to 'npc/functions/scoreboards.txt')
-rw-r--r--npc/functions/scoreboards.txt2
1 files changed, 1 insertions, 1 deletions
diff --git a/npc/functions/scoreboards.txt b/npc/functions/scoreboards.txt
index 9a6400e7..442cacd7 100644
--- a/npc/functions/scoreboards.txt
+++ b/npc/functions/scoreboards.txt
@@ -169,7 +169,7 @@ OnInit:
.@nb = query_sql("select name, base_level from `char` ORDER BY base_level DESC LIMIT 15", $@hoblvl_name$, $@hoblvl_value);
.@nb = query_sql("select name, job_level from `char` ORDER BY job_level DESC LIMIT 15", $@hojlvl_name$, $@hojlvl_value);
.@nb = query_sql("select name, guild_lv from `guild` ORDER BY guild_lv DESC LIMIT 5", $@hoguild_name$, $@hoguild_value);
- .@nb = query_sql("SELECT c.name, i.amount FROM `storage` AS i, `char` AS c WHERE i.nameid="+Acorn+" AND i.account_id=c.account_id ORDER BY i.amount DESC LIMIT 15", $@hoa_name$, $@hoa_value);
+ .@nb = query_sql("SELECT c.name, i.amount FROM `storage` AS i, `char` AS c WHERE i.nameid="+Acorn+" AND i.account_id=c.account_id AND c.char_num = 0 ORDER BY i.amount DESC LIMIT 15", $@hoa_name$, $@hoa_value);
.@nb = query_sql("SELECT c.name, i.value FROM `char_reg_num_db` AS i, `char` AS c WHERE i.key='MONSTERS_KILLED' AND i.char_id=c.char_id ORDER BY i.value DESC LIMIT 15", $@hol_name$, $@hol_value);
consolemes(CONSOLEMES_DEBUG, "Scoreboards reloaded");
if (!$@SCOREBOARD_BIND) {