X-Git-Url: https://code.wpia.club/?p=gigi.git;a=blobdiff_plain;f=src%2Fclub%2Fwpia%2Fgigi%2FdbObjects%2FJob.java;h=a505eb41a05a7a70bbf5e3627361803be1185b14;hp=ac0c9cf7fd5ba086b7f41314a8b64ee58ca7ce57;hb=8a9ea3d28547e9742fcacc7cad9e8adb7784e596;hpb=e05751faad1c41298ff1bc17b9da05a95ab5a925 diff --git a/src/club/wpia/gigi/dbObjects/Job.java b/src/club/wpia/gigi/dbObjects/Job.java index ac0c9cf7..a505eb41 100644 --- a/src/club/wpia/gigi/dbObjects/Job.java +++ b/src/club/wpia/gigi/dbObjects/Job.java @@ -45,9 +45,20 @@ public class Job implements IdCachable { } protected synchronized static Job revoke(Certificate targetId, RevocationType type) { - try (GigiPreparedStatement ps = new GigiPreparedStatement("UPDATE `certs` SET `revocationType`=?::`revocationType` WHERE id=?")) { + return revoke(targetId, type, null, null, null); + } + + protected synchronized static Job revoke(Certificate targetId, String challenge, String signature, String message) { + return revoke(targetId, RevocationType.KEY_COMPROMISE, challenge, signature, message); + } + + private synchronized static Job revoke(Certificate targetId, RevocationType type, String challenge, String signature, String message) { + try (GigiPreparedStatement ps = new GigiPreparedStatement("UPDATE `certs` SET `revocationType`=?::`revocationType`, `revocationChallenge`=?, `revocationSignature`=?, `revocationMessage`=? WHERE id=?")) { ps.setEnum(1, type); - ps.setInt(2, targetId.getId()); + ps.setString(2, challenge); + ps.setString(3, signature); + ps.setString(4, message); + ps.setInt(5, targetId.getId()); ps.execute(); }