`when` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`configId` int(13) NOT NULL,
`state` enum('open', 'success', 'failed') NOT NULL,
- `challenge` varchar(16) NOT NULL,
+ `challenge` varchar(16),
`result` varchar(255)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
throw new GigiApiException(e);
}
}
+
+ public boolean isVerified() {
+ try {
+ PreparedStatement ps = DatabaseConnection.getInstance().prepare("SELECT 1 FROM domainPinglog INNER JOIN pingconfig ON pingconfig.id=domainPinglog.configId WHERE domainid=? AND state='success'");
+ ps.setInt(1, id);
+ ResultSet rs = ps.executeQuery();
+ return rs.next();
+ } catch (SQLException e) {
+ e.printStackTrace();
+ }
+ return false;
+ }
}
Domain domain = doms[point];
vars.put("id", domain.getId());
vars.put("domain", domain.getSuffix());
- vars.put("status", "??");
+ vars.put("status", l.getTranslation(domain.isVerified() ? "verified" : "not verified"));
point++;
return true;
}