From 1aaccb4a62fb2491447e657cf6d3c960f4ea9a8a Mon Sep 17 00:00:00 2001 From: Jesusaves Date: Sat, 9 Feb 2019 19:15:01 -0200 Subject: Fix 003-1/events valentine scoreboard (DEV, remember to update HoF) --- npc/003-1/events.txt | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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]+")"); -- cgit v1.2.3-60-g2f50