From 3da1be46e0a2d26f4ae5093b02d3ee8e236655f8 Mon Sep 17 00:00:00 2001 From: Jesusaves Date: Wed, 1 Jan 2020 03:09:17 -0300 Subject: AFK Scoreboard. 2020 Events scoreboards. --- npc/functions/scoreboards.txt | 96 +++++++++++++++++++++++++++++++++++++++---- 1 file 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; -- cgit v1.2.3-60-g2f50