From 43f791b9e0c0a0fe7d01740e3a516d95d7d860ab Mon Sep 17 00:00:00 2001 From: Jesusaves Date: Tue, 16 Jul 2019 15:00:09 -0300 Subject: Fix rule on Ched and seasons for Ched's Summer: Disregard wrong year --- npc/functions/seasons.txt | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'npc/functions/seasons.txt') diff --git a/npc/functions/seasons.txt b/npc/functions/seasons.txt index 812e46553..458611f61 100644 --- a/npc/functions/seasons.txt +++ b/npc/functions/seasons.txt @@ -265,7 +265,7 @@ OnSummerEnd: OnAutumnStart: // Ched's Quest Winner - .@nb = query_sql("SELECT c.name FROM `quest` AS i, `char` AS c WHERE i.quest_id="+SQuest_Ched+" AND i.char_id=c.char_id ORDER BY i.count2 DESC LIMIT 1", .@name$); + .@nb = query_sql("SELECT c.name FROM `quest` AS i, `char` AS c WHERE i.quest_id="+SQuest_Ched+" AND i.char_id=c.char_id AND i.count1="+(gettime(GETTIME_YEAR)-2000)+" ORDER BY i.count2 DESC LIMIT 1", .@name$); $@AUTUMN_VICTOR$=.@name$[0]; // Fancy trees -- cgit v1.2.3-60-g2f50