Inform top 5 winners from Hasan (and Ched) to go claim their rewards.

1 files changed, 13 insertions, 0 deletions

diff --git a/npc/functions/seasons.txt b/npc/functions/seasons.txt
index dc9fddf49..dc4112888 100644
--- a/npc/functions/seasons.txt
+++ b/npc/functions/seasons.txt
@@ -259,6 +259,12 @@ OnSummerStart:
     end;
 
 OnSummerEnd:
+    // Inform the top 5 Ched winners to gather their prizes
+    .@nb = query_sql("SELECT c.name, i.count2, c.char_id 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, $@ched_charid);
+    for (.@i=0;.@i < getarraysize($@ched_charid);.@i++) {
+        rodex_sendmail($@ched_charid[.@i], "Ched", "Summer Drinks", "Final Ranking: #"+(.@i+1)+". Rewards are available with Ched!");
+    }
+
     delmonsterdrop(Duck,                CherryCocktail);
     delmonsterdrop(Croc,                CherryCocktail);
     delmonsterdrop(SaxsoGhost,          CherryCocktail);
@@ -314,6 +320,13 @@ OnAutumnEnd:
     // Ched's rewards can't be claimed anymore. Delete that from all players.
     DelQuestFromEveryPlayer(SQuest_Ched);
 
+    // Inform the top 5 Hasan winners to gather their prizes
+    .@nb = query_sql("SELECT c.name, i.count2, c.char_id FROM `quest` AS i, `char` AS c WHERE i.quest_id="+SQuest_Autumn+" AND i.char_id=c.char_id ORDER BY i.count2 DESC LIMIT 5", $@hasn_name$, $@hasn_value, $@hasn_charid);
+    for (.@i=0;.@i < getarraysize($@hasn_charid);.@i++) {
+        rodex_sendmail($@hasn_charid[.@i], "Hasan", "Scorpion Hunting", "Final Ranking: #"+(.@i+1)+". Rewards are available with Hasan!");
+    }
+
+
     removemapmask "012-1", MASK_AUTUMN;
     delmonsterdrop(FafiDragon,          PumpkandySeed);
     delmonsterdrop(Mouboo,              PumpkandySeed);