From 48cfe363e122b8840b93259f552a23914ea6f08f Mon Sep 17 00:00:00 2001 From: Jesusaves Date: Wed, 24 Feb 2021 20:21:52 -0300 Subject: Add a hall of death counts. Char must have logged in the past 24 hours. Less deaths are shown above more. Counts all deaths in lifetime including those in safe zones. --- npc/functions/scoreboards.txt | 37 ++++++++++++++++++++++++++++++------- 1 file changed, 30 insertions(+), 7 deletions(-) (limited to 'npc/functions') diff --git a/npc/functions/scoreboards.txt b/npc/functions/scoreboards.txt index 1e833b1c1..4488b0dd2 100644 --- a/npc/functions/scoreboards.txt +++ b/npc/functions/scoreboards.txt @@ -18,6 +18,7 @@ function script ScoreboardsReload { .@nb = query_sql("SELECT c.name, i.value FROM `char_reg_num_db` AS i, `char` AS c WHERE i.key='HONOR' AND i.char_id=c.char_id ORDER BY i.value DESC LIMIT 10", $@hof_name$, $@hof_value); .@nb = query_sql("SELECT c.name, i.value FROM `char_reg_num_db` AS i, `char` AS c WHERE i.key='ACADEMIC_RANK' AND i.char_id=c.char_id ORDER BY i.value DESC LIMIT 30", $@hoa_name$, $@hoa_value); .@nb = query_sql("SELECT c.name, i.value FROM `mapreg` AS i, `char` AS c WHERE i.varname='$REFERRAL_IDS' AND i.index=c.account_id ORDER BY i.value DESC LIMIT 20", $@hor_name$, $@hor_value); + .@nb = query_sql("SELECT c.name, i.value FROM `char_reg_num_db` AS i, `char` AS c WHERE i.key='PC_DIE_COUNTER' AND i.char_id=c.char_id AND c.last_login >= "+gettimetick(2)-86400+" ORDER BY i.value ASC LIMIT 10", $@hod_name$, $@hod_value); // Seasonal Scoreboards if (season() == SUMMER || season() == AUTUMN) { @@ -247,6 +248,23 @@ function script HallOfUDT { return; } +function script HallOfDeath { + mes ""; + mes l("##BHall Of Deaths: Reverse TOP10##b"); + mesc l("NOTE: Must have logged in the past 24 hours to be shown."); + mesf("1. %s (%s)", $@hod_name$[0], fnum($@hod_value[0])); + mesf("2. %s (%s)", $@hod_name$[1], fnum($@hod_value[1])); + mesf("3. %s (%s)", $@hod_name$[2], fnum($@hod_value[2])); + mesf("4. %s (%s)", $@hod_name$[3], fnum($@hod_value[3])); + mesf("5. %s (%s)", $@hod_name$[4], fnum($@hod_value[4])); + mesf("6. %s (%s)", $@hod_name$[5], fnum($@hod_value[5])); + mesf("7. %s (%s)", $@hod_name$[6], fnum($@hod_value[6])); + mesf("8. %s (%s)", $@hod_name$[7], fnum($@hod_value[7])); + mesf("9. %s (%s)", $@hod_name$[8], fnum($@hod_value[8])); + mesf("10. %s (%s)", $@hod_name$[9], fnum($@hod_value[9])); + return; +} + function script HallOfHonor { mes ""; mes l("##BHall Of Honor: TOP 10##b"); @@ -700,6 +718,7 @@ OnCall: l("Hall Of Crazyfefe Battle"), l("Hall Of Doppelganger Arena"), l("Hall Of AF King"), + l("Hall Of Deaths"), rif(season() == SUMMER || season() == AUTUMN, l("Hall Of Ched")), l("Hall Of Fame"), l("Hall Of Academics"), @@ -752,6 +771,10 @@ OnCall: next; break; case 11: + HallOfDeath(); + next; + break; + case 12: 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]+")"); @@ -765,33 +788,33 @@ OnCall: mes("10."+$@ched_name$[9]+" ("+$@ched_value[9]+")"); next; break; - case 12: + case 13: mes l("Hero: ")+$MOST_HEROIC$; mes ""; HallOfHonor(); next; break; - case 13: + case 14: HallOfAcademic(); next; break; - case 14: + case 15: HallOf2018(); next; break; - case 15: + case 16: HallOf2019(); next; break; - case 16: + case 17: HallOf2020(); next; break; - case 17: + case 18: HallOf2021(); next; break; - case 18: + case 19: HallOfGame(); next; break; -- cgit v1.2.3-70-g09d2