From 5a7befddd57f2a0870734ff60d249947c961f842 Mon Sep 17 00:00:00 2001 From: Jesusaves Date: Mon, 2 Jul 2018 20:13:57 -0300 Subject: [skip ci] Experiment with referral program report. --- npc/functions/scoreboards.txt | 35 +++++++++++++++++++++++++++++++++++ 1 file changed, 35 insertions(+) (limited to 'npc/functions/scoreboards.txt') diff --git a/npc/functions/scoreboards.txt b/npc/functions/scoreboards.txt index 3158aea56..6a3eece1d 100644 --- a/npc/functions/scoreboards.txt +++ b/npc/functions/scoreboards.txt @@ -108,3 +108,38 @@ function script HallOfGMLog { mes("15."+.@name$[14]+" ("+.@value$[14]+")"); return; } + + + + + +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.userid=a.value ORDER BY l.account_id DESC LIMIT 20", .@name$, .@value); + mes "Referral Program Report - pg. 1"; + mes("1."+.@name$[0]+" ("+.@value[0]+")"); + mes("2."+.@name$[1]+" ("+.@value[1]+")"); + mes("3."+.@name$[2]+" ("+.@value[2]+")"); + mes("4."+.@name$[3]+" ("+.@value[3]+")"); + mes("5."+.@name$[4]+" ("+.@value[4]+")"); + mes("6."+.@name$[5]+" ("+.@value[5]+")"); + mes("7."+.@name$[6]+" ("+.@value[6]+")"); + mes("8."+.@name$[7]+" ("+.@value[7]+")"); + mes("9."+.@name$[8]+" ("+.@value[8]+")"); + mes("10."+.@name$[9]+" ("+.@value[9]+")"); + next; + mes "Referral Program Report - pg. 2"; + mes("11."+.@name$[10]+" ("+.@value[10]+")"); + mes("12."+.@name$[11]+" ("+.@value[11]+")"); + mes("13."+.@name$[12]+" ("+.@value[12]+")"); + mes("14."+.@name$[13]+" ("+.@value[13]+")"); + mes("15."+.@name$[14]+" ("+.@value[14]+")"); + mes("16."+.@name$[15]+" ("+.@value[15]+")"); + mes("17."+.@name$[16]+" ("+.@value[16]+")"); + mes("18."+.@name$[17]+" ("+.@value[17]+")"); + mes("19."+.@name$[18]+" ("+.@value[18]+")"); + mes("20."+.@name$[19]+" ("+.@value[19]+")"); + return; +} + + -- cgit v1.2.3-60-g2f50