From 0802e8476a5ab5a9630192393e736386500926d4 Mon Sep 17 00:00:00 2001 From: Jesusaves Date: Mon, 17 Sep 2018 10:34:37 -0300 Subject: Ignore Monster Staff on Karma and GP halls --- npc/functions/scoreboards.txt | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/npc/functions/scoreboards.txt b/npc/functions/scoreboards.txt index ed2d3d4bb..e91645b84 100644 --- a/npc/functions/scoreboards.txt +++ b/npc/functions/scoreboards.txt @@ -6,7 +6,7 @@ function script HallOfFame { mes ""; - .@nb = query_sql("select name, karma from `char` ORDER BY karma DESC LIMIT 10", .@name$, .@value); + .@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]+")"); mes("2."+.@name$[1]+" ("+.@value[1]+")"); @@ -23,7 +23,7 @@ function script HallOfFame { function script HallOfFortune { mes ""; - .@nb = query_sql("select name, zeny from `char` ORDER BY zeny DESC LIMIT 15", .@name$, .@value); + .@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]+" ("+.@value[0]+")"); mes("2."+.@name$[1]+" ("+.@value[1]+")"); -- cgit v1.2.3-60-g2f50