From 5092532e64b5e30127fd7ac230438352065bdc1d Mon Sep 17 00:00:00 2001 From: Jesusaves Date: Mon, 2 Jul 2018 20:17:28 -0300 Subject: [skip ci] no errors, sql simply return zero results. --- npc/commands/super-menu.txt | 4 ++-- npc/functions/scoreboards.txt | 3 ++- 2 files changed, 4 insertions(+), 3 deletions(-) diff --git a/npc/commands/super-menu.txt b/npc/commands/super-menu.txt index ba4d64efd..d8eafbef0 100644 --- a/npc/commands/super-menu.txt +++ b/npc/commands/super-menu.txt @@ -29,8 +29,8 @@ function script SuperMenu { case 4: query_sql("UPDATE `char` SET `guild_id`=1 WHERE `char_id`="+getcharid(0)); break; - case 6: HallOfReferral; break; - case 5: GlobalDebugMenu 1; break; + case 5: HallOfReferral; break; + case 6: GlobalDebugMenu 1; break; } } while (1); } diff --git a/npc/functions/scoreboards.txt b/npc/functions/scoreboards.txt index 6a3eece1d..49809c874 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.userid=a.value ORDER BY l.account_id 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]+")"); @@ -139,6 +139,7 @@ function script HallOfReferral { mes("18."+.@name$[17]+" ("+.@value[17]+")"); mes("19."+.@name$[18]+" ("+.@value[18]+")"); mes("20."+.@name$[19]+" ("+.@value[19]+")"); + next; return; } -- cgit v1.2.3-60-g2f50