summaryrefslogtreecommitdiff
path: root/npc/003-1
diff options
context:
space:
mode:
authorJesusaves <cpntb1@ymail.com>2019-02-09 19:15:01 -0200
committerJesusaves <cpntb1@ymail.com>2019-02-09 19:15:01 -0200
commit1aaccb4a62fb2491447e657cf6d3c960f4ea9a8a (patch)
treeea30eb8e8107b8785633f561bfd66d0b19a2a25a /npc/003-1
parentc4e516041872c7acc9eb3af6f2d2ea8428cb45b4 (diff)
downloadserverdata-1aaccb4a62fb2491447e657cf6d3c960f4ea9a8a.tar.gz
serverdata-1aaccb4a62fb2491447e657cf6d3c960f4ea9a8a.tar.bz2
serverdata-1aaccb4a62fb2491447e657cf6d3c960f4ea9a8a.tar.xz
serverdata-1aaccb4a62fb2491447e657cf6d3c960f4ea9a8a.zip
Fix 003-1/events valentine scoreboard (DEV, remember to update HoF)
Diffstat (limited to 'npc/003-1')
-rw-r--r--npc/003-1/events.txt2
1 files changed, 1 insertions, 1 deletions
diff --git a/npc/003-1/events.txt b/npc/003-1/events.txt
index 471aa3756..71c2bdba1 100644
--- a/npc/003-1/events.txt
+++ b/npc/003-1/events.txt
@@ -78,7 +78,7 @@ OnInit:
mesq l("Valentine Day is over!");
if (#VALENTINE_SENT+#VALENTINE_OPENED <= 0)
close;
- .@nb = query_sql("SELECT c.name, i.value FROM `acc_reg_num_db` AS i, `char` AS c WHERE i.key='#VALENTINE_POINTS' AND i.account_id=c.account_id ORDER BY i.value DESC LIMIT 10", .@name$, .@value);
+ .@nb = query_sql("SELECT c.name, i.value FROM `acc_reg_num_db` AS i, `char` AS c WHERE i.key='#VALENTINE_POINTS' AND i.account_id=c.account_id AND c.char_num='0' ORDER BY i.value DESC LIMIT 10", .@name$, .@value);
mes "##B"+l("Top 10 - Valentine Day")+"##b";
mes("1." +.@name$[0]+" ("+.@value[0]+")");