DatabaseConnection.init(p);
readyMail = DatabaseConnection.getInstance().prepare(
- "SELECT id, csr_name FROM emailcerts"
+ "SELECT id, csr_name, subject FROM emailcerts"
+ " WHERE csr_name is not null"//
+ " AND created=0"//
+ " AND crt_name=''"//
"-out", "../" + crt.getPath(),//
"-days", "356",//
"-batch",//
+ "-subj", rs.getString(3),//
"-config", "selfsign.config"
};