From a4f5cbf04ffd11b5cedcaea4756e9aa1dbc00011 Mon Sep 17 00:00:00 2001 From: Jesusaves Date: Sun, 8 Sep 2019 23:28:47 -0300 Subject: Record UDT Challenge ranking (for science) --- npc/functions/scoreboards.txt | 17 +++++++++++++++++ 1 file changed, 17 insertions(+) (limited to 'npc/functions/scoreboards.txt') diff --git a/npc/functions/scoreboards.txt b/npc/functions/scoreboards.txt index 3e6b476ab..c6735d1b6 100644 --- a/npc/functions/scoreboards.txt +++ b/npc/functions/scoreboards.txt @@ -39,6 +39,7 @@ OnInit: .@nb = query_sql("select char_name, command from `atcommandlog` ORDER BY atcommand_id DESC LIMIT 15", $@hogm_name$, $@hogm_value$); .@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); debugmes "Scoreboards reloaded"; end; } @@ -196,6 +197,22 @@ function script HallOfCandor { return; } +function script HallOfUDT { + mes ""; + mes l("##BHall Of UDT Challenge: TOP 10##b"); + mes("1."+$@udt_name$[0]+" ("+$@udt_value[0]+")"); + mes("2."+$@udt_name$[1]+" ("+$@udt_value[1]+")"); + mes("3."+$@udt_name$[2]+" ("+$@udt_value[2]+")"); + mes("4."+$@udt_name$[3]+" ("+$@udt_value[3]+")"); + mes("5."+$@udt_name$[4]+" ("+$@udt_value[4]+")"); + mes("6."+$@udt_name$[5]+" ("+$@udt_value[5]+")"); + mes("7."+$@udt_name$[6]+" ("+$@udt_value[6]+")"); + mes("8."+$@udt_name$[7]+" ("+$@udt_value[7]+")"); + mes("9."+$@udt_name$[8]+" ("+$@udt_value[8]+")"); + mes("10."+$@udt_name$[9]+" ("+$@udt_value[9]+")"); + return; +} + -- cgit v1.2.3-60-g2f50