diff options
| author | Jesusaves <cpntb1@ymail.com> | 2018-09-17 16:19:26 -0300 |
|---|---|---|
| committer | Jesusaves <cpntb1@ymail.com> | 2018-09-17 16:19:26 -0300 |
| commit | 3cc8a03902b34e0bff2429ead34bf7c7f76a7457 (patch) | |
| tree | 82e22b72593fd86224fbc53a596a5a675575f8db /npc/functions/scoreboards.txt | |
| parent | c24cbdc410afa40398f10f784795a9b23a6aa55f (diff) | |
| download | serverdata-3cc8a03902b34e0bff2429ead34bf7c7f76a7457.tar.gz serverdata-3cc8a03902b34e0bff2429ead34bf7c7f76a7457.tar.bz2 serverdata-3cc8a03902b34e0bff2429ead34bf7c7f76a7457.tar.xz serverdata-3cc8a03902b34e0bff2429ead34bf7c7f76a7457.zip | |
Rewrite Referral System
Diffstat (limited to 'npc/functions/scoreboards.txt')
| -rw-r--r-- | npc/functions/scoreboards.txt | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/npc/functions/scoreboards.txt b/npc/functions/scoreboards.txt index e91645b84..3fb44e14a 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 `mapreg` AS a, `login` AS l WHERE a.varname='$REFERRAL_IDS' AND l.account_id=a.index 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]+")"); |