+ public String[] getAdminLog() {
+ try (GigiPreparedStatement prep = new GigiPreparedStatement("SELECT `when`, type, information FROM `adminLog` WHERE uid=? ORDER BY `when` ASC")) {
+ prep.setInt(1, getId());
+ GigiResultSet res = prep.executeQuery();
+ List<String> entries = new LinkedList<String>();
+
+ while (res.next()) {
+ entries.add(res.getString(2) + " (" + res.getString(3) + ")");
+ }
+ return entries.toArray(new String[0]);
+ }
+ }
+
+ public static CertificateOwner getByEnabledSerial(String serial) {
+ try (GigiPreparedStatement prep = new GigiPreparedStatement("SELECT `memid` FROM `certs` INNER JOIN `logincerts` ON `logincerts`.`id`=`certs`.`id` WHERE serial=? AND `revoked` is NULL")) {
+ prep.setString(1, serial);
+ GigiResultSet res = prep.executeQuery();
+ if (res.next()) {
+ return getById(res.getInt(1));
+ }
+ return null;
+ }
+ }
+
+ private void writeObject(ObjectOutputStream oos) throws IOException {
+ oos.writeLong(getId());
+ }
+
+ private void readObject(ObjectInputStream ois) throws IOException, ClassNotFoundException {
+ id = (int) ois.readLong();
+ }
+
+ protected Object readResolve() throws ObjectStreamException {
+ /**
+ * Returning the Object by looking up its ID in the cache.
+ *
+ * @see http://www.javalobby.org/java/forums/t17491.html
+ * @see http://www.jguru.com/faq/view.jsp?EID=44039
+ * @see http://thecodersbreakfast.net/
+ * ?post/2011/05/12/Serialization-and-magic-methods
+ */
+ CertificateOwner co = getById(this.getId());
+
+ if (null == co) {
+ throw new Error("Unknown Certificate Owner");
+ }
+
+ return co;
+ }
+