summaryrefslogtreecommitdiff
path: root/npc
diff options
context:
space:
mode:
authorJesusaves <cpntb1@ymail.com>2018-07-02 20:20:20 -0300
committerJesusaves <cpntb1@ymail.com>2018-07-02 20:20:20 -0300
commitcb08ab6a012976b8f072785bfcd5be03a55afacb (patch)
tree72aeed99150ec2df9eb9b40aab35314c5a63d400 /npc
parent5092532e64b5e30127fd7ac230438352065bdc1d (diff)
downloadserverdata-cb08ab6a012976b8f072785bfcd5be03a55afacb.tar.gz
serverdata-cb08ab6a012976b8f072785bfcd5be03a55afacb.tar.bz2
serverdata-cb08ab6a012976b8f072785bfcd5be03a55afacb.tar.xz
serverdata-cb08ab6a012976b8f072785bfcd5be03a55afacb.zip
[skip ci] Referral Program Report should work now.
I wish it detailed more, but that can be done via MySQL Interface.
Diffstat (limited to 'npc')
-rw-r--r--npc/functions/scoreboards.txt2
1 files changed, 1 insertions, 1 deletions
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]+")");