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; }