diff options
author | Jesusaves <cpntb1@ymail.com> | 2019-03-31 12:40:40 -0300 |
---|---|---|
committer | Jesusaves <cpntb1@ymail.com> | 2019-03-31 12:40:40 -0300 |
commit | 81ed1ac55f5eb952b5f97e286479f59f391bbf45 (patch) | |
tree | ca2f79e20e46bb63240b44579c9fe5ae932d5ec8 /npc/functions | |
parent | bcc665fb84a78d794c7310e3944ddf572aecb890 (diff) | |
download | serverdata-81ed1ac55f5eb952b5f97e286479f59f391bbf45.tar.gz serverdata-81ed1ac55f5eb952b5f97e286479f59f391bbf45.tar.bz2 serverdata-81ed1ac55f5eb952b5f97e286479f59f391bbf45.tar.xz serverdata-81ed1ac55f5eb952b5f97e286479f59f391bbf45.zip |
Crazyfefe/Candor Fight TOP 10 scoreboards (hourly refresh, we have too many scoreboards)
Diffstat (limited to 'npc/functions')
-rw-r--r-- | npc/functions/scoreboards.txt | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/npc/functions/scoreboards.txt b/npc/functions/scoreboards.txt index afa5aab2a..71c1a5abf 100644 --- a/npc/functions/scoreboards.txt +++ b/npc/functions/scoreboards.txt @@ -38,6 +38,7 @@ OnInit: .@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$); .@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); debugmes "Scoreboards reloaded"; end; } @@ -179,6 +180,22 @@ function script HallOfGMLog { return; } +function script HallOfCandor { + mes ""; + mes l("##BHall Of Crazyfefe Fight: TOP 10##b"); + mes("1."+$@cfefe_name$[0]+" ("+$@cfefe_value[0]+")"); + mes("2."+$@cfefe_name$[1]+" ("+$@cfefe_value[1]+")"); + mes("3."+$@cfefe_name$[2]+" ("+$@cfefe_value[2]+")"); + mes("4."+$@cfefe_name$[3]+" ("+$@cfefe_value[3]+")"); + mes("5."+$@cfefe_name$[4]+" ("+$@cfefe_value[4]+")"); + mes("6."+$@cfefe_name$[5]+" ("+$@cfefe_value[5]+")"); + mes("7."+$@cfefe_name$[6]+" ("+$@cfefe_value[6]+")"); + mes("8."+$@cfefe_name$[7]+" ("+$@cfefe_value[7]+")"); + mes("9."+$@cfefe_name$[8]+" ("+$@cfefe_value[8]+")"); + mes("10."+$@cfefe_name$[9]+" ("+$@cfefe_value[9]+")"); + return; +} + |