X-Git-Url: https://code.wpia.club/?a=blobdiff_plain;f=src%2Fclub%2Fwpia%2Fgigi%2FdbObjects%2FCATS.java;h=0f2b9ff0d0d45cd96ae9af9956a8282266263739;hb=918282ccc64e46e3e83f5087328ce477d2b200e0;hp=3ed2c9230b734cb0f8d14a7e255d41f2dd5ef7d0;hpb=bccd4cc0dba0f89aa045b113bac46eb8cc1dab4e;p=gigi.git

diff --git a/src/club/wpia/gigi/dbObjects/CATS.java b/src/club/wpia/gigi/dbObjects/CATS.java
index 3ed2c923..0f2b9ff0 100644
--- a/src/club/wpia/gigi/dbObjects/CATS.java
+++ b/src/club/wpia/gigi/dbObjects/CATS.java
@@ -11,7 +11,7 @@ import club.wpia.gigi.util.TimeConditions;
 public class CATS {
 
     public enum CATSType {
-        ASSURER_CHALLENGE("Agent Qualifying Challenge"),
+        AGENT_CHALLENGE("Agent Qualifying Challenge"),
 
         ORG_AGENT_CHALLENGE("Organisation Agent Qualifying Challenge"),
 
@@ -97,7 +97,7 @@ public class CATS {
     }
 
     public static boolean isInCatsLimit(int uID, int testID) {
-        try (GigiPreparedStatement ps = new GigiPreparedStatement("SELECT 1 FROM `cats_passed` WHERE `user_id` = ? AND `variant_id` = ? AND`pass_date` > (now() - interval '1 months' * ?)")) {
+        try (GigiPreparedStatement ps = new GigiPreparedStatement("SELECT 1 FROM `cats_passed` WHERE `user_id` = ? AND `variant_id` = ? AND`pass_date` > (now() - interval '1 months' * ?::INTEGER)")) {
             ps.setInt(1, uID);
             ps.setInt(2, testID);
             ps.setInt(3, TEST_MONTHS);