public static void loadClans() { clans.clear(); clan.clear(); admins.clear(); if (!(MySQL.mySQLenabled())) { int i = 0; while (ClansFile.getData().get("Clans." + i) != null) { clans.add(ClansFile.getData().getString("Clans." + i + ".Name")); getClanMembers(ClansFile.getData().getString("Clans." + i + ".Name")); getClanAdmins(ClansFile.getData().getString("Clan." + i + ".Name")); i++; } } else { try { Connection conn = MySQL.getConnection(); PreparedStatement ps = conn.prepareStatement("SELECT clan FROM CODClans"); ResultSet rs = ps.executeQuery(); while (rs.next()) { clans.add(rs.getString("clan")); getClanMembers(rs.getString("clan")); getClanAdmins(rs.getString("clan")); } rs.close(); ps.close(); conn.close(); } catch (Exception e) { e.printStackTrace(); } } }
public static void setOwner(Player p, String clanName) { saveClans(); if (clanExists(clanName)) { if (!(MySQL.mySQLenabled())) { ClansFile.getData().set("Clans." + getClanNumber(clanName) + ".Owner", p.getUniqueId()); ClansFile.saveData(); ClansFile.reloadData(); loadClans(); } else { try { Connection conn = MySQL.getConnection(); String INSERT = "INSERT INTO CODClans (clan, owner) VALUES(?, ?) ON DUPLICATE KEY UPDATE owner=?"; PreparedStatement ps = conn.prepareStatement(INSERT); ps.setString(1, clanName); ps.setString(2, p.getUniqueId().toString()); ps.setString(3, p.getUniqueId().toString()); ps.executeUpdate(); ps.close(); conn.close(); loadClans(); } catch (Exception e) { e.printStackTrace(); } } } }
public static int getClanNumber(String clan) { if (!(MySQL.mySQLenabled())) { if (clanExists(clan)) { int i = 0; while (ClansFile.getData().get("Clans." + i) != null) { if (ClansFile.getData().getString("Clans." + i + ".Name").equals(clan)) return i; i++; } return -1; } } return -1; }
public static String getOwner(String clanName) { /** Returns the UUID of the player */ if (!(MySQL.mySQLenabled())) { saveClans(); if ((clanExists(clanName)) && (getClanNumber(clanName) != -1)) { return (String) ClansFile.getData().get("Clans." + getClanNumber(clanName) + ".Owner"); } } else { try { Connection conn = MySQL.getConnection(); PreparedStatement ps = conn.prepareStatement("SELECT clan,owner FROM CODClans"); ResultSet rs = ps.executeQuery(); while (rs.next()) { if (rs.getString("clan").equals(clanName)) { return rs.getString("owner"); } } rs.close(); ps.close(); conn.close(); } catch (SQLException e) { e.printStackTrace(); } } return null; }
public static ArrayList<String> getClanAdmins(String clanName) { /** Returns uuids of players */ if (clanExists(clanName)) { ArrayList<String> Admins = new ArrayList<String>(); if (!(MySQL.mySQLenabled())) { Admins = (ArrayList<String>) ClansFile.getData().getStringList("Clans." + getClanNumber(clanName) + ".Admins"); } else { try { Connection conn = MySQL.getConnection(); PreparedStatement ps = conn.prepareStatement("SELECT clan,admins FROM CODClans"); ResultSet rs = ps.executeQuery(); while (rs.next()) { if (rs.getString("clan").equals(clanName)) { Admins = MySQL.stringToList(MySQL.clobToString(rs.getClob("admins"))); break; } } } catch (Exception e) { e.printStackTrace(); } } admins.put(clanName, Admins); return Admins; } ArrayList<String> newList = new ArrayList<String>(); admins.put(clanName, newList); return newList; }
public static void createClan(String ClanName, Player owner) { if (!(MySQL.mySQLenabled())) { int nextNum = 0; while (ClansFile.getData().get("Clans." + nextNum) != null) { nextNum++; } ArrayList<String> players = new ArrayList<String>(); String uuid = "" + owner.getUniqueId(); players.add(uuid); ClansFile.getData().set("Clans." + nextNum + ".Owner", uuid); clans.add(ClanName); clan.put(ClanName, players); saveClans(); } else { try { Connection conn = MySQL.getConnection(); String INSERT = "INSERT INTO CODClans (clan, owner) VALUES(?, ?) ON DUPLICATE KEY UPDATE owner=?"; PreparedStatement ps = conn.prepareStatement(INSERT); ps.setString(1, ClanName); ps.setString(2, owner.getUniqueId().toString()); ps.setString(3, owner.getUniqueId().toString()); ArrayList<String> players = new ArrayList<String>(); String uuid = "" + owner.getUniqueId(); players.add(uuid); clans.add(ClanName); clan.put(ClanName, players); ps.executeUpdate(); saveClans(); ps.close(); conn.close(); } catch (Exception e) { e.printStackTrace(); } } }
public static boolean clanExists(String clan) { if (!(MySQL.mySQLenabled())) { ArrayList<String> c = new ArrayList<String>(); ClansFile.saveData(); ClansFile.reloadData(); int i = 0; while (ClansFile.getData().get("Clans." + i) != null) { c.add(ClansFile.getData().getString("Clans." + i + ".Name")); i++; } if (c.isEmpty()) { return false; } if (c.contains(clan)) { return true; } return false; } else { try { Connection conn = MySQL.getConnection(); PreparedStatement ps = conn.prepareStatement("SELECT clan FROM CODClans"); ResultSet rs = ps.executeQuery(); while (rs.next()) { if (rs.getString("clan").equals(clan)) return true; } rs.close(); ps.close(); conn.close(); return false; } catch (Exception e) { e.printStackTrace(); } return false; } }
public static boolean deleteClan(String ClanName) { if (!(MySQL.mySQLenabled())) { if (getClanNumber(ClanName) != -1) { if (clans.contains(ClanName)) clans.remove(ClanName); if (clan.get(ClanName) != null) clan.put(ClanName, null); if (admins.get(ClanName) != null) admins.put(ClanName, null); ClansFile.getData().set("Clans", null); saveClans(); return true; } return false; } else { try { if (clanExists(ClanName)) { if (clans.contains(ClanName)) clans.remove(ClanName); if (clan.get(ClanName) != null) clan.put(ClanName, null); if (admins.get(ClanName) != null) admins.put(ClanName, null); Connection conn = MySQL.getConnection(); PreparedStatement ps = conn.prepareStatement("DELETE FROM CODClans WHERE clan=?"); ps.executeUpdate(); ps.setString(1, ClanName); ps.close(); conn.close(); return true; } return false; } catch (Exception e) { e.printStackTrace(); } } return false; }
public static void saveClans() { if (!(MySQL.mySQLenabled())) { HashMap<Integer, String> Owner = new HashMap<Integer, String>(); int next = 0; while (ClansFile.getData().get("Clans." + next) != null) { Owner.put(next, ClansFile.getData().getString("Clans." + next + ".Owner")); next++; } ClansFile.getData().set("Clans", null); ClansFile.saveData(); ClansFile.reloadData(); for (int i = 0; i < clans.size(); i++) { ClansFile.getData().set("Clans." + i + ".Name", clans.get(i)); if (clan.get(clans.get(i)) != null) { ClansFile.getData().set(("Clans." + i + ".Players"), clan.get(clans.get(i))); } if (admins.get(clans.get(i)) != null) { ClansFile.getData().set("Clans." + i + ".Admins", admins.get(clans.get(i))); } ClansFile.getData().set(("Clans." + i + ".Owner"), Owner.get(i)); } ClansFile.saveData(); ClansFile.reloadData(); loadClans(); } else { try { HashMap<String, String> Owner = new HashMap<String, String>(); Connection conn = MySQL.getConnection(); PreparedStatement ps = conn.prepareStatement("SELECT clan,owner FROM CODClans"); ResultSet rs = ps.executeQuery(); while (rs.next()) { Owner.put(rs.getString("clan"), rs.getString("owner")); } ps = conn.prepareStatement("DELETE FROM CODClans"); ps.executeUpdate(); for (int i = 0; i < clans.size(); i++) { String INSERT = "INSERT INTO CODClans (clan, owner, players, admins) VALUES(?, ?, ?, ?) ON DUPLICATE KEY UPDATE owner=?,players=?,admins=?"; ps = conn.prepareStatement(INSERT); ps.setString(1, clans.get(i)); if (clan.get(clans.get(i)) != null) { Clob clob = MySQL.stringToClob(MySQL.listToString(clan.get(clans.get(i))), conn); ps.setClob(3, clob); ps.setClob(6, clob); } else { Clob clob = MySQL.stringToClob(MySQL.listToString(new ArrayList<String>()), conn); ps.setClob(3, clob); ps.setClob(6, clob); } if (admins.get(clans.get(i)) != null) { Clob clob = MySQL.stringToClob(MySQL.listToString(admins.get(clans.get(i))), conn); ps.setClob(4, clob); ps.setClob(7, clob); } else { Clob clob = MySQL.stringToClob(MySQL.listToString(new ArrayList<String>()), conn); ps.setClob(4, clob); ps.setClob(7, clob); } ps.setString(2, Owner.get(clans.get(i))); ps.setString(5, Owner.get(clans.get(i))); ps.executeUpdate(); ps.close(); conn.close(); } } catch (Exception e) { e.printStackTrace(); } } }
public static void setUp(Plugin p) { ClansFile.setup(p); loadClans(); }