AFK Scoreboard. 2020 Events scoreboards.

1 files changed, 88 insertions, 8 deletions

diff --git a/npc/functions/scoreboards.txt b/npc/functions/scoreboards.txt
index 00afa157b..3f979b47a 100644
--- a/npc/functions/scoreboards.txt
+++ b/npc/functions/scoreboards.txt
@@ -40,6 +40,9 @@ OnInit:
 	.@nb = query_sql("select name, guild_lv from `guild` WHERE `guild_id`!=1 ORDER BY guild_lv DESC LIMIT 5", $@hoguild_name$, $@hoguild_value);
 	.@nb = query_sql("SELECT c.name, i.value FROM `char_reg_num_db` AS i, `char` AS c WHERE i.key='CRAZYPOINTS' AND i.char_id=c.char_id ORDER BY i.value DESC LIMIT 10", $@cfefe_name$, $@cfefe_value);
 	.@nb = query_sql("SELECT c.name, i.value FROM `char_reg_num_db` AS i, `char` AS c WHERE i.key='UDTRANK' AND i.char_id=c.char_id ORDER BY i.value DESC LIMIT 10", $@udt_name$, $@udt_value);
+	.@nb = query_sql("SELECT c.name, i.value FROM `char_reg_num_db` AS i, `char` AS c WHERE i.key='AFKING' AND i.char_id=c.char_id ORDER BY i.value DESC LIMIT 10", $@afk_name$, $@afk_value);
+
+    // Seasonal Scoreboards
     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);
     }
@@ -254,6 +257,23 @@ function	script	HallOfReferral	{
     return;
 }
 
+// Hall of AFK
+function	script	HallOfAFK	{
+    mes "";
+	mes l("##BHall Of AFK: TOP 10##b");
+	mes("1. %s (%dh%02dm)", $@afk_name$[0], $@afk_value[0]/1200, $@afk_value[0]%1200/60);
+	mes("2. %s (%dh%02dm)", $@afk_name$[1], $@afk_value[1]/1200, $@afk_value[1]%1200/60);
+	mes("3. %s (%dh%02dm)", $@afk_name$[2], $@afk_value[2]/1200, $@afk_value[2]%1200/60);
+	mes("4. %s (%dh%02dm)", $@afk_name$[3], $@afk_value[3]/1200, $@afk_value[3]%1200/60);
+	mes("5. %s (%dh%02dm)", $@afk_name$[4], $@afk_value[4]/1200, $@afk_value[4]%1200/60);
+	mes("6. %s (%dh%02dm)", $@afk_name$[5], $@afk_value[5]/1200, $@afk_value[5]%1200/60);
+	mes("7. %s (%dh%02dm)", $@afk_name$[6], $@afk_value[6]/1200, $@afk_value[6]%1200/60);
+	mes("8. %s (%dh%02dm)", $@afk_name$[7], $@afk_value[7]/1200, $@afk_value[7]%1200/60);
+	mes("9. %s (%dh%02dm)", $@afk_name$[8], $@afk_value[8]/1200, $@afk_value[8]%1200/60);
+	mes("10. %s (%dh%02dm)", $@afk_name$[9], $@afk_value[9]/1200, $@afk_value[9]%1200/60);
+    return;
+}
+
 
 // HallOfSponsor(minimal=false)
 function	script	HallOfSponsor	{
@@ -345,9 +365,7 @@ function	script	HallOf2018	{
 }
 
 function	script	HallOf2019	{
-    mesc l("This schedule is subject to change without prior notice."), 1;
-    mesc l("Changes include but are not limited to festive events and dates."), 1;
-    next;
+    mes "";
     if ($HEROESHOLD_WINNER$ != "") {
         mes l(".:: FIRST PLAYER TO COMPLETE HEROES HOLD MASTER DUNGEON ::.");
         mes $HEROESHOLD_WINNER$;
@@ -414,13 +432,65 @@ function	script	HallOf2019	{
     mesc l("September 22nd - December 20th");
     mes "";
     mes l(".:: Thanksgiving 2019 ::.");
-    mesc l("November 1st - November 30th");
+    //mesc l("November 1st - November 30th");
+    mes l("No victor appliable.");
     mes "";
     mes l(".:: Christmas 2019 ::.");
     mesc l("Scheduled: December 19th - January 2nd");
     return;
 }
 
+function	script	HallOf2020	{
+    mesc l("This schedule is subject to change without prior notice."), 1;
+    mesc l("Changes include but are not limited to festive events and dates."), 1;
+    next;
+    mes l(".:: TMW-2 Anniversary ::.");
+    mesc l("Scheduled: January 13rd");
+    //mes l("No victor appliable.");
+    mesc l("Anniversary marks the project birthdate. Do not mistake with TMW2 Day.");
+    mes "";
+    mes l(".:: Valentine Day ::.");
+    mesc l("Scheduled: February 12th - 15th");
+    next;
+    mes l(".:: TMW2 Day ::.");
+    mesc l("Scheduled: March 2nd");
+    //mes l("No victor appliable.");
+    mesc l("TMW2 Day marks the server birthdate. Do not mistake with TMW2 Anniversary.");
+    mes "";
+    mes l(".:: Easter 2020 ::.");
+    mesc l("Scheduled: April 17th - 24th");
+    mes "";
+    mes l(".:: Worker Day ::.");
+    mesc l("Scheduled: April 27th - May 3rd");
+    //mes l("No victor appliable.");
+    next;
+    mes l(".:: Ched's Summer 2020 ::.");
+    mesc l("June 21st - September 21st");
+    mes "";
+    mes l(".:: Chocolate Day ::.");
+    //mesc l("Event Canceled"), 1;
+    mesc l("Scheduled: July 7th");
+    mes "";
+    mes l(".:: Free Software Day ::.");
+    //mesc l("Event Canceled"), 1;
+    mesc l("Scheduled: September 9th");
+    mes "";
+    mes l(".:: International Coffee Day ::.");
+    mesc l("Scheduled: October 1st");
+    //mes l("No victor appliable.");
+    mes "";
+    mes l(".:: Hasan Scorpion Killing Challenge 2020 ::.");
+    mesc l("September 22nd - December 20th");
+    mes "";
+    mes l(".:: Thanksgiving 2020 ::.");
+    mesc l("November 1st - November 30th");
+    //mes l("No victor appliable.");
+    mes "";
+    mes l(".:: Christmas 2020 ::.");
+    mesc l("Scheduled: December 19th - January 2nd");
+    return;
+}
+
 -	script	@scoreboard	NPC_HIDDEN,{
     end;
 
@@ -439,10 +509,12 @@ OnCall:
             l("Hall Of Guilds"),
             l("Hall Of Crazyfefe Battle"),
             l("Hall Of Doppelganger Arena"),
+            l("Hall Of AF King"),
             rif(season() == SUMMER || season() == AUTUMN, l("Hall Of Ched")),
             l("Hall Of Fame"),
             l("2018 Event Winners"),
             l("2019 Event Winners"),
+            l("2020 Event Winners"),
             l("Game Statistics"),
             l("Quit");
         mes "";
@@ -484,6 +556,10 @@ OnCall:
             next;
             break;
         case 10:
+            HallOfAFK();
+            next;
+            break;
+        case 11:
             mes b(l("Top 10 - Summer Ched's Event"));
 	        mes("1."+$@ched_name$[0]+" ("+$@ched_value[0]+")");
 	        mes("2."+$@ched_name$[1]+" ("+$@ched_value[1]+")");
@@ -497,19 +573,23 @@ OnCall:
 	        mes("10."+$@ched_name$[9]+" ("+$@ched_value[9]+")");
             next;
             break;
-        case 11:
+        case 12:
             mes l("Hero: ")+$MOST_HEROIC$;
             next;
             break;
-        case 12:
+        case 13:
             HallOf2018();
             next;
             break;
-        case 13:
+        case 14:
             HallOf2019();
             next;
             break;
-        case 14:
+        case 15:
+            HallOf2020();
+            next;
+            break;
+        case 16:
             HallOfGame();
             next;
             break;