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