X-Git-Url: https://code.wpia.club/?p=gigi.git;a=blobdiff_plain;f=src%2Fclub%2Fwpia%2Fgigi%2FdbObjects%2FCATS.java;h=0f2b9ff0d0d45cd96ae9af9956a8282266263739;hp=c9f96d11a55701064bd4548af44528ce4e2949f8;hb=0d5ae34e23b50f59e759702b1ebf6f5a3a7137f4;hpb=a1fb2906862d4edc566a49d5a6c9133cffcfba68 diff --git a/src/club/wpia/gigi/dbObjects/CATS.java b/src/club/wpia/gigi/dbObjects/CATS.java index c9f96d11..0f2b9ff0 100644 --- a/src/club/wpia/gigi/dbObjects/CATS.java +++ b/src/club/wpia/gigi/dbObjects/CATS.java @@ -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);