summaryrefslogtreecommitdiff
path: root/npc/functions/scoreboards.txt
diff options
context:
space:
mode:
authorJesusaves <cpntb1@ymail.com>2019-03-31 12:40:40 -0300
committerJesusaves <cpntb1@ymail.com>2019-03-31 12:40:40 -0300
commit81ed1ac55f5eb952b5f97e286479f59f391bbf45 (patch)
treeca2f79e20e46bb63240b44579c9fe5ae932d5ec8 /npc/functions/scoreboards.txt
parentbcc665fb84a78d794c7310e3944ddf572aecb890 (diff)
downloadserverdata-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/scoreboards.txt')
-rw-r--r--npc/functions/scoreboards.txt17
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;
+}
+