summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorJesusaves <cpntb1@ymail.com>2018-07-02 20:17:28 -0300
committerJesusaves <cpntb1@ymail.com>2018-07-02 20:17:28 -0300
commit5092532e64b5e30127fd7ac230438352065bdc1d (patch)
treeb80eea1404c37cde717b4f5f659de5d59901bb92
parent5a7befddd57f2a0870734ff60d249947c961f842 (diff)
downloadserverdata-5092532e64b5e30127fd7ac230438352065bdc1d.tar.gz
serverdata-5092532e64b5e30127fd7ac230438352065bdc1d.tar.bz2
serverdata-5092532e64b5e30127fd7ac230438352065bdc1d.tar.xz
serverdata-5092532e64b5e30127fd7ac230438352065bdc1d.zip
[skip ci] no errors, sql simply return zero results.
-rw-r--r--npc/commands/super-menu.txt4
-rw-r--r--npc/functions/scoreboards.txt3
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;
}