From cb08ab6a012976b8f072785bfcd5be03a55afacb Mon Sep 17 00:00:00 2001 From: Jesusaves Date: Mon, 2 Jul 2018 20:20:20 -0300 Subject: [skip ci] Referral Program Report should work now. I wish it detailed more, but that can be done via MySQL Interface. --- npc/functions/scoreboards.txt | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'npc/functions') diff --git a/npc/functions/scoreboards.txt b/npc/functions/scoreboards.txt index 49809c874..e419ba9c6 100644 --- a/npc/functions/scoreboards.txt +++ b/npc/functions/scoreboards.txt @@ -115,7 +115,7 @@ function script HallOfGMLog { function script HallOfReferral { mes ""; - .@nb = query_sql("SELECT l.userid, COUNT(a.value) FROM `acc_reg_num_db` AS a, `login` AS l WHERE a.key='REFERRAL_PROG' AND l.account_id=a.value ORDER BY COUNT(a.value) DESC LIMIT 20", .@name$, .@value); + .@nb = query_sql("SELECT l.userid, COUNT(a.value) FROM `acc_reg_num_db` AS a, `login` AS l WHERE a.key='#REFERRAL_PROG' AND l.account_id=a.value ORDER BY COUNT(a.value) DESC LIMIT 20", .@name$, .@value); mes "Referral Program Report - pg. 1"; mes("1."+.@name$[0]+" ("+.@value[0]+")"); mes("2."+.@name$[1]+" ("+.@value[1]+")"); -- cgit v1.2.3-60-g2f50