diff options
| author | Jesusaves <cpntb1@ymail.com> | 2019-03-20 10:30:21 -0300 |
|---|---|---|
| committer | Jesusaves <cpntb1@ymail.com> | 2019-03-20 10:30:21 -0300 |
| commit | 34480c6ddb7b0ee0c2992c28e7a2ceadaf468d82 (patch) | |
| tree | 60f997a8241b91e1702e10cf7052cf425ebdc570 /npc/functions/scoreboards.txt | |
| parent | bbaaaac39d5af7cb0474dc57f30932160f79e3a9 (diff) | |
| download | serverdata-34480c6ddb7b0ee0c2992c28e7a2ceadaf468d82.tar.gz serverdata-34480c6ddb7b0ee0c2992c28e7a2ceadaf468d82.tar.bz2 serverdata-34480c6ddb7b0ee0c2992c28e7a2ceadaf468d82.tar.xz serverdata-34480c6ddb7b0ee0c2992c28e7a2ceadaf468d82.zip | |
Acknowledge guild hall + sql query
Diffstat (limited to 'npc/functions/scoreboards.txt')
| -rw-r--r-- | npc/functions/scoreboards.txt | 1 |
1 files changed, 1 insertions, 0 deletions
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; } |