X-Git-Url: https://code.wpia.club/?a=blobdiff_plain;f=util%2Forg%2Fcacert%2Fgigi%2Futil%2FSimpleSigner.java;h=d67cb8e874f563fff235f73d724cb045e2ff2742;hb=2824d1c165c501e2f3a8809044788b33b81f478a;hp=36da084a39da76e18df82d68e90935a49d4d9929;hpb=c0adaea9ecd10f332502e09f7a678f67a9027e27;p=gigi.git diff --git a/util/org/cacert/gigi/util/SimpleSigner.java b/util/org/cacert/gigi/util/SimpleSigner.java index 36da084a..d67cb8e8 100644 --- a/util/org/cacert/gigi/util/SimpleSigner.java +++ b/util/org/cacert/gigi/util/SimpleSigner.java @@ -29,19 +29,19 @@ public class SimpleSigner { DatabaseConnection.init(p); readyMail = DatabaseConnection.getInstance().prepare( - "SELECT id, csr_name, subject FROM emailcerts" + " WHERE csr_name is not null"// - + " AND created=0"// - + " AND crt_name=''"// - + " AND warning<3"); + "SELECT id, csr_name, subject FROM emailcerts" + " WHERE csr_name is not null"// + + " AND created=0"// + + " AND crt_name=''"// + + " AND warning<3"); updateMail = DatabaseConnection.getInstance().prepare( - "UPDATE emailcerts SET crt_name=?," + " created=NOW(), serial=? WHERE id=?"); + "UPDATE emailcerts SET crt_name=?," + " created=NOW(), serial=? WHERE id=?"); warnMail = DatabaseConnection.getInstance().prepare("UPDATE emailcerts SET warning=warning+1 WHERE id=?"); revoke = DatabaseConnection.getInstance().prepare( - "SELECT id, csr_name FROM emailcerts" + " WHERE csr_name is not null"// - + " AND created != 0"// - + " AND revoked = '1970-01-01'"); + "SELECT id, csr_name FROM emailcerts" + " WHERE csr_name is not null"// + + " AND created != 0"// + + " AND revoked = '1970-01-01'"); revokeCompleted = DatabaseConnection.getInstance().prepare("UPDATE emailcerts SET revoked=NOW() WHERE id=?"); gencrl(); while (true) {