private boolean loadClan(String owner, Clan clan, Statement st) throws SQLException {
ResultSet rs = st.executeQuery("SELECT * FROM clans WHERE owner='" + owner + "' LIMIT 1");
if (!rs.next()) {
rs.close();
return false;
}
clan.setName(rs.getString("name"));
clan.setEnabled(rs.getBoolean("enabled"));
clan.setEnterRequirement(Rank.forValue(rs.getInt("enterReq")));
clan.setTalkRequirement(Rank.forValue(rs.getInt("talkReq")));
clan.setKickRequirement(Rank.forValue(rs.getInt("kickReq")));
clan.setLootShareRequirement(Rank.forValue(rs.getInt("lootShareReq")));
String[] rankedMembers;
rankedMembers = toArray(rs.getString("recruits"), new String[0]);
for (String member : rankedMembers) {
clan.getRanks().put(member, Rank.RECRUIT);
}
rankedMembers = toArray(rs.getString("corporals"), new String[0]);
for (String member : rankedMembers) {
clan.getRanks().put(member, Rank.CORPORAL);
}
rankedMembers = toArray(rs.getString("sergeants"), new String[0]);
for (String member : rankedMembers) {
clan.getRanks().put(member, Rank.SERGEANT);
}
rankedMembers = toArray(rs.getString("lieutenants"), new String[0]);
for (String member : rankedMembers) {
clan.getRanks().put(member, Rank.LIEUTENANT);
}
rankedMembers = toArray(rs.getString("captains"), new String[0]);
for (String member : rankedMembers) {
clan.getRanks().put(member, Rank.CAPTAIN);
}
rankedMembers = toArray(rs.getString("generals"), new String[0]);
for (String member : rankedMembers) {
clan.getRanks().put(member, Rank.GENERAL);
}
rs.close();
return true;
}
