public static Inventory loadKit(Player p) { if (!(MySQL.mySQLenabled())) { if (KitFile.getData().getString("Kit." + p.getUniqueId()) != null && !KitFile.getData().getString("Kit." + p.getUniqueId()).isEmpty()) { Inventory inv = Bukkit.getServer().createInventory(p, 27, "Loadout"); kit.put( p, SaveAndLoad.fromString(inv, KitFile.getData().getList("Kit." + p.getUniqueId()))); return kit.get(p); } else { Inventory inv = Bukkit.getServer().createInventory(p, 27, "Loadout"); kit.put(p, inv); return inv; } } else { try { Connection conn = MySQL.getConnection(); PreparedStatement ps = conn.prepareStatement("SELECT uuid,list FROM CODKits"); ResultSet result = ps.executeQuery(); boolean UUIDexists = false; boolean isEmpty = false; while (result.next()) { String s = result.getString("uuid"); if (s.equals(p.getUniqueId().toString())) { UUIDexists = true; String stringList = MySQL.clobToString(result.getClob("list")); if (stringList == null || stringList.equals("")) isEmpty = true; break; } } conn.close(); ps.close(); result.close(); if ((UUIDexists) && (!(isEmpty))) { Inventory inv = Bukkit.getServer().createInventory(p, 27, "Loadout"); conn = MySQL.getConnection(); ps = conn.prepareStatement("SELECT uuid,list FROM CODKits"); result = ps.executeQuery(); String stringList = ""; while (result.next()) { String s = result.getString("uuid"); if (s.equals(p.getUniqueId().toString())) { stringList = MySQL.clobToString(result.getClob("list")); break; } } ArrayList<String> kits = (ArrayList<String>) MySQL.stringToList(stringList); inv = SaveAndLoad.fromString(inv, kits); kit.put(p, inv); conn.close(); ps.close(); result.close(); return inv; } else { Inventory inv = Bukkit.getServer().createInventory(p, 27, "Loadout"); kit.put(p, inv); return inv; } } catch (Exception e) { e.printStackTrace(); } } return null; }