X-Git-Url: https://code.wpia.club/?p=gigi.git;a=blobdiff_plain;f=src%2Forg%2Fcacert%2Fgigi%2FdbObjects%2FUser.java;h=d3d5da02e3a1dc7c65a01b0c9531f9e98b0fb223;hp=c0b0128bdd37e28040605d141a80dd3fcad24b49;hb=8d8e8c319564bab8a34a62fa8a49865cf49225cc;hpb=2c9b5a0f5a7ee06a7617a0a1e7f4491da9ed9e69 diff --git a/src/org/cacert/gigi/dbObjects/User.java b/src/org/cacert/gigi/dbObjects/User.java index c0b0128b..d3d5da02 100644 --- a/src/org/cacert/gigi/dbObjects/User.java +++ b/src/org/cacert/gigi/dbObjects/User.java @@ -542,9 +542,9 @@ public class User extends CertificateOwner { return new Assurance(res.getInt("id"), User.getById(res.getInt("from")), User.getById(res.getInt("to")), res.getString("location"), res.getString("method"), res.getInt("points"), res.getString("date")); } - public static boolean isInVerificationLimit(int id) { + public boolean isInVerificationLimit() { try (GigiPreparedStatement ps = new GigiPreparedStatement("SELECT 1 FROM `notary` WHERE `to` = ? AND `when` > (now() - (interval '1 month' * ?)) AND (`expire` IS NULL OR `expire` > now()) AND `deleted` IS NULL;")) { - ps.setInt(1, id); + ps.setInt(1, getId()); ps.setInt(2, VERIFICATION_MONTHS); GigiResultSet rs = ps.executeQuery();