summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorJesusaves <cpntb1@ymail.com>2019-03-20 10:50:48 -0300
committerJesusaves <cpntb1@ymail.com>2019-03-20 10:50:48 -0300
commitab377cc3989c8546d798b0b444f3fd7b888d86c6 (patch)
tree46c0e0325bfe7ac7a4810a8c7933be1dfbfd8cff
parent34480c6ddb7b0ee0c2992c28e7a2ceadaf468d82 (diff)
downloadserverdata-ab377cc3989c8546d798b0b444f3fd7b888d86c6.tar.gz
serverdata-ab377cc3989c8546d798b0b444f3fd7b888d86c6.tar.bz2
serverdata-ab377cc3989c8546d798b0b444f3fd7b888d86c6.tar.xz
serverdata-ab377cc3989c8546d798b0b444f3fd7b888d86c6.zip
Prepare another SQL Query too
-rw-r--r--npc/functions/scoreboards.txt1
1 files changed, 1 insertions, 0 deletions
diff --git a/npc/functions/scoreboards.txt b/npc/functions/scoreboards.txt
index 0ddf20ee5..ecfc8aeb1 100644
--- a/npc/functions/scoreboards.txt
+++ b/npc/functions/scoreboards.txt
@@ -34,6 +34,7 @@ OnInit:
debugmes "Reloading scoreboards...";
.@nb = query_sql("select name, zeny from `char` WHERE `guild_id`!=1 ORDER BY zeny DESC LIMIT 15", $@hofortune_name$, $@hofortune_value);
.@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 name, job_level from `char` WHERE `guild_id`!=1 ORDER BY job_level DESC LIMIT 15", $@hojlvl_name$, $@hojlvl_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);