From d8daf7f7c31ff20552a761942b41fc678d2eea4b Mon Sep 17 00:00:00 2001 From: Jesusaves Date: Fri, 15 Mar 2019 10:59:23 -0300 Subject: [Server Performance and Security] reload scoreboards at once, hourly. --- npc/functions/scoreboards.txt | 162 +++++++++++++++++++++++++----------------- 1 file changed, 98 insertions(+), 64 deletions(-) diff --git a/npc/functions/scoreboards.txt b/npc/functions/scoreboards.txt index ca79a2e63..7eb763dd7 100644 --- a/npc/functions/scoreboards.txt +++ b/npc/functions/scoreboards.txt @@ -4,10 +4,47 @@ // Description: // Leaderboards + GM Command Log +- script scoreboardsGen NPC_HIDDEN,{ + end; +OnHour00: +OnHour01: +OnHour02: +OnHour03: +OnHour04: +OnHour05: +OnHour06: +OnHour07: +OnHour08: +OnHour09: +OnHour10: +OnHour11: +OnHour12: +OnHour13: +OnHour14: +OnHour15: +OnHour16: +OnHour17: +OnHour18: +OnHour19: +OnHour20: +OnHour21: +OnHour22: +OnHour23: +OnInit: + debugmes "Reloading scoreboards..."; + .@nb = query_sql("select name, zeny from `char` WHERE `guild_id`!=1 ORDER BY zeny DESC LIMIT 15", $@hofortune_name$, $@hofortune_value); + .@nb = query_sql("select name, base_level from `char` WHERE `guild_id`!=1 ORDER BY base_level DESC LIMIT 15", $@hoblvl_name$, $@hoblvl_value); + .@nb = query_sql("SELECT c.name, i.amount FROM `inventory` AS i, `char` AS c WHERE i.nameid="+StrangeCoin+" AND i.char_id=c.char_id ORDER BY i.amount DESC LIMIT 15", $@hoc_name$, $@hoc_value); + .@nb = query_sql("select char_name, command from `atcommandlog` ORDER BY atcommand_id DESC LIMIT 15", $@hogm_name$, $@hogm_value$); + debugmes "Scoreboards reloaded"; + end; +} + function script HallOfFame { // Moved to event statues return; mes ""; + /* .@nb = query_sql("select name, karma from `char` WHERE `guild_id`!=1 ORDER BY karma DESC LIMIT 10", .@name$, .@value); mes l("##BHall Of Fame: TOP10##b"); mes("1."+.@name$[0]+" ("+.@value[0]+")"); @@ -20,94 +57,91 @@ function script HallOfFame { mes("8."+.@name$[7]+" ("+.@value[7]+")"); mes("9."+.@name$[8]+" ("+.@value[8]+")"); mes("10."+.@name$[9]+" ("+.@value[9]+")"); + */ return; } function script HallOfFortune { mes ""; - .@nb = query_sql("select name, zeny from `char` WHERE `guild_id`!=1 ORDER BY zeny DESC LIMIT 15", .@name$, .@value); mes l("##BHall Of Fortune: TOP15##b"); - mes("1."+.@name$[0]+" ("+format_number(.@value[0])+" GP)"); - mes("2."+.@name$[1]+" ("+format_number(.@value[1])+" GP)"); - mes("3."+.@name$[2]+" ("+format_number(.@value[2])+" GP)"); - mes("4."+.@name$[3]+" ("+format_number(.@value[3])+" GP)"); - mes("5."+.@name$[4]+" ("+format_number(.@value[4])+" GP)"); - mes("6."+.@name$[5]+" ("+format_number(.@value[5])+" GP)"); - mes("7."+.@name$[6]+" ("+format_number(.@value[6])+" GP)"); - mes("8."+.@name$[7]+" ("+format_number(.@value[7])+" GP)"); - mes("9."+.@name$[8]+" ("+format_number(.@value[8])+" GP)"); - mes("10."+.@name$[9]+" ("+format_number(.@value[9])+" GP)"); - mes("11."+.@name$[10]+" ("+format_number(.@value[10])+" GP)"); - mes("12."+.@name$[11]+" ("+format_number(.@value[11])+" GP)"); - mes("13."+.@name$[12]+" ("+format_number(.@value[12])+" GP)"); - mes("14."+.@name$[13]+" ("+format_number(.@value[13])+" GP)"); - mes("15."+.@name$[14]+" ("+format_number(.@value[14])+" GP)"); + mes("1."+$@hofortune_name$[0]+" ("+format_number($@hofortune_value[0])+" GP)"); + mes("2."+$@hofortune_name$[1]+" ("+format_number($@hofortune_value[1])+" GP)"); + mes("3."+$@hofortune_name$[2]+" ("+format_number($@hofortune_value[2])+" GP)"); + mes("4."+$@hofortune_name$[3]+" ("+format_number($@hofortune_value[3])+" GP)"); + mes("5."+$@hofortune_name$[4]+" ("+format_number($@hofortune_value[4])+" GP)"); + mes("6."+$@hofortune_name$[5]+" ("+format_number($@hofortune_value[5])+" GP)"); + mes("7."+$@hofortune_name$[6]+" ("+format_number($@hofortune_value[6])+" GP)"); + mes("8."+$@hofortune_name$[7]+" ("+format_number($@hofortune_value[7])+" GP)"); + mes("9."+$@hofortune_name$[8]+" ("+format_number($@hofortune_value[8])+" GP)"); + mes("10."+$@hofortune_name$[9]+" ("+format_number($@hofortune_value[9])+" GP)"); + mes("11."+$@hofortune_name$[10]+" ("+format_number($@hofortune_value[10])+" GP)"); + mes("12."+$@hofortune_name$[11]+" ("+format_number($@hofortune_value[11])+" GP)"); + mes("13."+$@hofortune_name$[12]+" ("+format_number($@hofortune_value[12])+" GP)"); + mes("14."+$@hofortune_name$[13]+" ("+format_number($@hofortune_value[13])+" GP)"); + mes("15."+$@hofortune_name$[14]+" ("+format_number($@hofortune_value[14])+" GP)"); return; } function script HallOfLevel { mes ""; - .@nb = query_sql("select name, base_level from `char` WHERE `guild_id`!=1 ORDER BY base_level DESC LIMIT 15", .@name$, .@value); mes l("##BHall Of Level: TOP15##b"); - mes("1."+.@name$[0]+" ("+.@value[0]+")"); - mes("2."+.@name$[1]+" ("+.@value[1]+")"); - mes("3."+.@name$[2]+" ("+.@value[2]+")"); - mes("4."+.@name$[3]+" ("+.@value[3]+")"); - mes("5."+.@name$[4]+" ("+.@value[4]+")"); - mes("6."+.@name$[5]+" ("+.@value[5]+")"); - mes("7."+.@name$[6]+" ("+.@value[6]+")"); - mes("8."+.@name$[7]+" ("+.@value[7]+")"); - mes("9."+.@name$[8]+" ("+.@value[8]+")"); - mes("10."+.@name$[9]+" ("+.@value[9]+")"); - mes("11."+.@name$[10]+" ("+.@value[10]+")"); - mes("12."+.@name$[11]+" ("+.@value[11]+")"); - mes("13."+.@name$[12]+" ("+.@value[12]+")"); - mes("14."+.@name$[13]+" ("+.@value[13]+")"); - mes("15."+.@name$[14]+" ("+.@value[14]+")"); + mes("1."+$@hoblvl_name$[0]+" ("+$@hoblvl_value[0]+")"); + mes("2."+$@hoblvl_name$[1]+" ("+$@hoblvl_value[1]+")"); + mes("3."+$@hoblvl_name$[2]+" ("+$@hoblvl_value[2]+")"); + mes("4."+$@hoblvl_name$[3]+" ("+$@hoblvl_value[3]+")"); + mes("5."+$@hoblvl_name$[4]+" ("+$@hoblvl_value[4]+")"); + mes("6."+$@hoblvl_name$[5]+" ("+$@hoblvl_value[5]+")"); + mes("7."+$@hoblvl_name$[6]+" ("+$@hoblvl_value[6]+")"); + mes("8."+$@hoblvl_name$[7]+" ("+$@hoblvl_value[7]+")"); + mes("9."+$@hoblvl_name$[8]+" ("+$@hoblvl_value[8]+")"); + mes("10."+$@hoblvl_name$[9]+" ("+$@hoblvl_value[9]+")"); + mes("11."+$@hoblvl_name$[10]+" ("+$@hoblvl_value[10]+")"); + mes("12."+$@hoblvl_name$[11]+" ("+$@hoblvl_value[11]+")"); + mes("13."+$@hoblvl_name$[12]+" ("+$@hoblvl_value[12]+")"); + mes("14."+$@hoblvl_name$[13]+" ("+$@hoblvl_value[13]+")"); + mes("15."+$@hoblvl_name$[14]+" ("+$@hoblvl_value[14]+")"); return; } function script HallOfCoins { mes ""; - .@nb = query_sql("SELECT c.name, i.amount FROM `inventory` AS i, `char` AS c WHERE i.nameid="+StrangeCoin+" AND i.char_id=c.char_id ORDER BY i.amount DESC LIMIT 15", .@name$, .@value); mes l("##BHall Of @@: TOP15##b", getitemlink(StrangeCoin)); - mes("1."+.@name$[0]+" ("+.@value[0]+")"); - mes("2."+.@name$[1]+" ("+.@value[1]+")"); - mes("3."+.@name$[2]+" ("+.@value[2]+")"); - mes("4."+.@name$[3]+" ("+.@value[3]+")"); - mes("5."+.@name$[4]+" ("+.@value[4]+")"); - mes("6."+.@name$[5]+" ("+.@value[5]+")"); - mes("7."+.@name$[6]+" ("+.@value[6]+")"); - mes("8."+.@name$[7]+" ("+.@value[7]+")"); - mes("9."+.@name$[8]+" ("+.@value[8]+")"); - mes("10."+.@name$[9]+" ("+.@value[9]+")"); - mes("11."+.@name$[10]+" ("+.@value[10]+")"); - mes("12."+.@name$[11]+" ("+.@value[11]+")"); - mes("13."+.@name$[12]+" ("+.@value[12]+")"); - mes("14."+.@name$[13]+" ("+.@value[13]+")"); - mes("15."+.@name$[14]+" ("+.@value[14]+")"); + mes("1."+$@hoc_name$[0]+" ("+$@hoc_value[0]+")"); + mes("2."+$@hoc_name$[1]+" ("+$@hoc_value[1]+")"); + mes("3."+$@hoc_name$[2]+" ("+$@hoc_value[2]+")"); + mes("4."+$@hoc_name$[3]+" ("+$@hoc_value[3]+")"); + mes("5."+$@hoc_name$[4]+" ("+$@hoc_value[4]+")"); + mes("6."+$@hoc_name$[5]+" ("+$@hoc_value[5]+")"); + mes("7."+$@hoc_name$[6]+" ("+$@hoc_value[6]+")"); + mes("8."+$@hoc_name$[7]+" ("+$@hoc_value[7]+")"); + mes("9."+$@hoc_name$[8]+" ("+$@hoc_value[8]+")"); + mes("10."+$@hoc_name$[9]+" ("+$@hoc_value[9]+")"); + mes("11."+$@hoc_name$[10]+" ("+$@hoc_value[10]+")"); + mes("12."+$@hoc_name$[11]+" ("+$@hoc_value[11]+")"); + mes("13."+$@hoc_name$[12]+" ("+$@hoc_value[12]+")"); + mes("14."+$@hoc_name$[13]+" ("+$@hoc_value[13]+")"); + mes("15."+$@hoc_name$[14]+" ("+$@hoc_value[14]+")"); return; } function script HallOfGMLog { mes ""; - .@nb = query_sql("select char_name, command from `atcommandlog` ORDER BY atcommand_id DESC LIMIT 15", .@name$, .@value$); mes l("##BLatest GM Commands##b"); - mes("1."+.@name$[0]+" ("+.@value$[0]+")"); - mes("2."+.@name$[1]+" ("+.@value$[1]+")"); - mes("3."+.@name$[2]+" ("+.@value$[2]+")"); - mes("4."+.@name$[3]+" ("+.@value$[3]+")"); - mes("5."+.@name$[4]+" ("+.@value$[4]+")"); - mes("6."+.@name$[5]+" ("+.@value$[5]+")"); - mes("7."+.@name$[6]+" ("+.@value$[6]+")"); - mes("8."+.@name$[7]+" ("+.@value$[7]+")"); - mes("9."+.@name$[8]+" ("+.@value$[8]+")"); - mes("10."+.@name$[9]+" ("+.@value$[9]+")"); - mes("11."+.@name$[10]+" ("+.@value$[10]+")"); - mes("12."+.@name$[11]+" ("+.@value$[11]+")"); - mes("13."+.@name$[12]+" ("+.@value$[12]+")"); - mes("14."+.@name$[13]+" ("+.@value$[13]+")"); - mes("15."+.@name$[14]+" ("+.@value$[14]+")"); + mes("1."+$@hogm_name$[0]+" ("+$@hogm_value$[0]+")"); + mes("2."+$@hogm_name$[1]+" ("+$@hogm_value$[1]+")"); + mes("3."+$@hogm_name$[2]+" ("+$@hogm_value$[2]+")"); + mes("4."+$@hogm_name$[3]+" ("+$@hogm_value$[3]+")"); + mes("5."+$@hogm_name$[4]+" ("+$@hogm_value$[4]+")"); + mes("6."+$@hogm_name$[5]+" ("+$@hogm_value$[5]+")"); + mes("7."+$@hogm_name$[6]+" ("+$@hogm_value$[6]+")"); + mes("8."+$@hogm_name$[7]+" ("+$@hogm_value$[7]+")"); + mes("9."+$@hogm_name$[8]+" ("+$@hogm_value$[8]+")"); + mes("10."+$@hogm_name$[9]+" ("+$@hogm_value$[9]+")"); + mes("11."+$@hogm_name$[10]+" ("+$@hogm_value$[10]+")"); + mes("12."+$@hogm_name$[11]+" ("+$@hogm_value$[11]+")"); + mes("13."+$@hogm_name$[12]+" ("+$@hogm_value$[12]+")"); + mes("14."+$@hogm_name$[13]+" ("+$@hogm_value$[13]+")"); + mes("15."+$@hogm_name$[14]+" ("+$@hogm_value$[14]+")"); return; } -- cgit v1.2.3-60-g2f50