From 953bb7a4ed1a224501318eb35fa4ff6e02a096d0 Mon Sep 17 00:00:00 2001 From: Jesusaves Date: Sat, 22 Dec 2018 21:45:19 -0200 Subject: When autumn quest is over, clear all Ched's completions/incompletions from the whole table. Even without this, the game should do just fine, but this prevents some spam on quest_db. Security-wise, dangerous function. --- npc/functions/seasons.txt | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'npc/functions') diff --git a/npc/functions/seasons.txt b/npc/functions/seasons.txt index 030581417..61b7b86a8 100644 --- a/npc/functions/seasons.txt +++ b/npc/functions/seasons.txt @@ -153,7 +153,7 @@ OnSummerEnd: OnAutumnStart: // Ched's Quest Winner - .@nb = query_sql("SELECT c.name FROM `quest` AS i, `char` AS c WHERE i.quest_id=305 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 ORDER BY i.count2 DESC LIMIT 1", .@name$); $@AUTUMN_VICTOR$=.@name$[0]; // Fancy trees @@ -176,6 +176,9 @@ OnAutumnStart: end; OnAutumnEnd: + // Ched's rewards can't be claimed anymore. Delete that from all players. + DelQuestFromEveryPlayer(SQuest_Ched); + removemapmask "012-1", MASK_AUTUMN; delmonsterdrop(FafiDragon, PumpkandySeed); delmonsterdrop(Mouboo, PumpkandySeed); -- cgit v1.2.3-70-g09d2