From 2af36aaabf84ad6eadc0ac5e6ad394a8227eb2dc Mon Sep 17 00:00:00 2001 From: Jesusaves Date: Tue, 3 Apr 2018 08:34:49 -0300 Subject: Hall Of Strange Coins (untested and NYI) --- npc/functions/scoreboards.txt | 22 ++++++++++++++++++++++ 1 file changed, 22 insertions(+) diff --git a/npc/functions/scoreboards.txt b/npc/functions/scoreboards.txt index 332be3e93..979b918f1 100644 --- a/npc/functions/scoreboards.txt +++ b/npc/functions/scoreboards.txt @@ -65,6 +65,28 @@ function script HallOfLevel { 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]+")"); + return; +} + function script HallOfGMLog { mes ""; .@nb = query_sql("select char_name, command from `atcommandlog` ORDER BY atcommand_id DESC LIMIT 10", .@name$, .@value$); -- cgit v1.2.3-60-g2f50