ABzZeLqG

1"CREATE TABLE IF NOT EXISTS " + config.getString("Table") + " (uuid CHAR(16) PRIMARY KEY, name VARCHAR(16), health DOUBLE(16, 14), foodlevel TINYINT(20), level MEDIUMINT(5), exp FLOAT(14, 7), money DOUBLE(28, 14), inventory MEDIUMTEXT, enderchest MEDIUMTEXT)" 
2     
3PreparedStatement preparedStatement = bridge.connectionSetup.getConnection().prepareStatement("REPLACE INTO " + bridge.getConfig().getString("Table") + " VALUES (?, ?, ?, ?, ?, ?, ?, ?)");
4
5            preparedStatement.setString(1, player.getUniqueId().toString());
6            preparedStatement.setDouble(2, player.getHealth());
7            preparedStatement.setInt(3, player.getFoodLevel());
8            preparedStatement.setInt(4, player.getLevel());
9            preparedStatement.setFloat(5, player.getExp());
10
11            if (bridge.getEconomy() == null) {
12                preparedStatement.setDouble(6, 0D);
13            } else {
14                preparedStatement.setDouble(6, bridge.getEconomy().getBalance(player));
15            }
16
17            preparedStatement.setString(7, bridge.inventoryHandler.save(player.getInventory()));
18            preparedStatement.setString(8, bridge.inventoryHandler.save(player.getEnderChest()));
19
20            preparedStatement.execute();