From ac10f5f2753fec48d6c742d33acb052a100d15e1 Mon Sep 17 00:00:00 2001 From: Jesusaves Date: Thu, 19 Dec 2019 03:53:36 -0300 Subject: Refactor Christmas scoreboards --- npc/functions/scoreboards.txt | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'npc/functions/scoreboards.txt') diff --git a/npc/functions/scoreboards.txt b/npc/functions/scoreboards.txt index bc7f0a72d..dd216e24f 100644 --- a/npc/functions/scoreboards.txt +++ b/npc/functions/scoreboards.txt @@ -43,6 +43,10 @@ OnInit: if (season() == SUMMER || season() == AUTUMN) { .@nb = query_sql("SELECT c.name, i.count2 FROM `quest` AS i, `char` AS c WHERE i.quest_id=305 AND i.char_id=c.char_id AND i.count1="+(gettime(GETTIME_YEAR)-2000)+" ORDER BY i.count2 DESC LIMIT 10", $@ched_name$, $@ched_value); } + if (season() == WINTER || season() == SPRING) { + .@nb = query_sql("SELECT c.name, i.count2 FROM `quest` AS i, `char` AS c WHERE i.quest_id="+SQuest_Christmas+" AND i.char_id=c.char_id ORDER BY i.count2 DESC LIMIT 5", $@xmas_box_name$, $@xmas_box_value); + .@nb = query_sql("SELECT c.name, i.count3 FROM `quest` AS i, `char` AS c WHERE i.quest_id="+SQuest_Christmas+" AND i.char_id=c.char_id ORDER BY i.count3 DESC LIMIT 5", $@xmas_gp_name$, $@xmas_gp_value); + } debugmes "Scoreboards reloaded"; end; } -- cgit v1.2.3-70-g09d2