diff options
| author | Jesusaves <cpntb1@ymail.com> | 2021-04-13 22:37:09 -0300 |
|---|---|---|
| committer | Jesusaves <cpntb1@ymail.com> | 2021-04-13 22:37:09 -0300 |
| commit | eaf8bd0c57ef85accb6fb7bea07499c0005e92d4 (patch) | |
| tree | 1a8a9c56f6412a1b784429d3274fec75e74f6f47 | |
| parent | 1d2d15c943351a930fef4b91fe8c8b435a1695c6 (diff) | |
| download | serverdata-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 ^^
| -rw-r--r-- | npc/functions/scoreboards.txt | 2 |
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) { |