- GigiPreparedStatement ps = DatabaseConnection.getInstance().prepare("SELECT `memid` FROM `certs` WHERE `serial`=? AND `disablelogin`='0' AND `revoked` is NULL");
- ps.setString(1, serial.toLowerCase());
- GigiResultSet rs = ps.executeQuery();
- User user = null;
- if (rs.next()) {
- user = User.getById(rs.getInt(1));
- } else {
- System.out.println("User with serial " + serial + " not found.");
+
+ CertificateOwner o = CertificateOwner.getByEnabledSerial(serial);
+ if (o == null || !(o instanceof User)) {
+ return null;