public static void UpdateBuild(Player player, Location loc) {
String query =
"UPDATE `perks_build` SET "
+ "world = '"
+ loc.getWorld().getName()
+ "', "
+ "x = '"
+ loc.getX()
+ "', "
+ "y = '"
+ loc.getY()
+ "', "
+ "z = '"
+ loc.getZ()
+ "', "
+ "yaw = '"
+ loc.getYaw()
+ "', "
+ "pitch = '"
+ loc.getPitch()
+ "' "
+ "WHERE player = '"
+ player.getName()
+ "';";
m_perksDB.query(query);
}
public static void AddBuild(String player, Location loc) {
String query =
"INSERT INTO `perks_build` "
+ "(`player`,`world`,`x`,`y`,`z`,`yaw`,`pitch`) VALUES ("
+ "'"
+ player
+ "',"
+ "'"
+ loc.getWorld().getName()
+ "',"
+ "'"
+ loc.getX()
+ "',"
+ "'"
+ loc.getY()
+ "',"
+ "'"
+ loc.getZ()
+ "',"
+ "'"
+ loc.getYaw()
+ "',"
+ "'"
+ loc.getPitch()
+ "');";
m_perksDB.query(query);
}
public static void setSpawn(PerkWorldSpawn spawn) {
String query =
"INSERT INTO `perks_spawn` ("
+ "`world`, `x`, `y`, `z`, `yaw`, `pitch`) VALUES ("
+ "'"
+ spawn.getSpawn().getWorld().getName()
+ "',"
+ "'"
+ spawn.getSpawn().getX()
+ "',"
+ "'"
+ spawn.getSpawn().getY()
+ "',"
+ "'"
+ spawn.getSpawn().getZ()
+ "',"
+ "'"
+ spawn.getSpawn().getYaw()
+ "',"
+ "'"
+ spawn.getSpawn().getPitch()
+ "'"
+ ");";
for (int i = 0; i < spawns.size(); ++i) {
if (spawns.get(i).getWorld().getName().equalsIgnoreCase(spawn.getWorld().getName())) {
query =
"UPDATE `perks_spawn` SET "
+ "x='"
+ spawn.getSpawn().getX()
+ "', "
+ "y='"
+ spawn.getSpawn().getY()
+ "', "
+ "z='"
+ spawn.getSpawn().getZ()
+ "', "
+ "yaw='"
+ spawn.getSpawn().getYaw()
+ "', "
+ "pitch='"
+ spawn.getSpawn().getPitch()
+ "' "
+ "WHERE world='"
+ spawn.getWorld().getName()
+ "'"
+ ";";
spawns.remove(i);
break;
}
}
m_perksDB.query(query, true);
spawns.add(spawn);
PerkUtils.DebugConsole("Adding spawn for " + spawn.getWorld().getName());
}
public static void addVanishPlayer(PerkPlayer player) {
String query =
"INSERT INTO `perks_vanish` "
+ "(`player`) VALUES ("
+ "'"
+ player.getPlayer().getName()
+ "');";
m_perksDB.query(query, true);
}
public static boolean isVanished(PerkPlayer player) {
if (!player.hasPermission("perks.vanish", false)) return false;
String query =
"SELECT * FROM `perks_vanish` WHERE player='" + player.getPlayer().getName() + "'";
ResultSet result = m_perksDB.queryResult(query);
if (result == null) return false;
boolean vanished;
try {
vanished = result.next();
} catch (SQLException e) {
vanished = false;
}
m_perksDB.freeResult(result);
return vanished;
}
public static boolean isFlying(PerkPlayer player) {
if (m_perksDB == null) return false;
if (!player.hasPermission("perks.fly", false)) return false;
String query =
"SELECT * FROM `perks_flying` WHERE name ='" + player.getPlayer().getName() + "'";
ResultSet result = m_perksDB.queryResult(query);
if (result == null) return false;
boolean flying;
try {
flying = result.next();
} catch (SQLException e) {
flying = false;
}
m_perksDB.freeResult(result);
return flying;
}
public static void setFlying(PerkPlayer player, boolean flying) {
if (m_perksDB == null) return;
String query;
// if they are to be set flying insert them into the table
if (flying) {
query =
"INSERT INTO `perks_flying` (name) VALUES (" + "'" + player.getPlayer().getName() + "');";
// if not remove them from it
} else {
query = "DELETE FROM `perks_flying` WHERE " + "name='" + player.getPlayer().getName() + "';";
}
m_perksDB.query(query, true);
}
public static void Stop() {
m_perksDB.freeDatabase();
}
public static void removeVanishPlayer(PerkPlayer player) {
String query =
"DELETE FROM `perks_vanish` " + "WHERE player=" + "'" + player.getPlayer().getName() + "';";
m_perksDB.query(query, true);
}
public static void loadDatabases() {
// create an the database
m_perksDB =
bDatabaseManager.createDatabase(
PerkConfig.DATABASE.name, PerkUtils.plugin, DatabaseType.SQL);
if (!m_perksDB.login(
PerkConfig.DATABASE.ip,
PerkConfig.DATABASE.user,
PerkConfig.DATABASE.password,
PerkConfig.DATABASE.port)) return;
// see if a table called properties exist
if (!m_perksDB.tableExists("perks_homes")) {
// the table doesn't exist, so make one.
PerkUtils.DebugConsole("Could not find perk homes table, now creating one.");
String query =
"CREATE TABLE perks_homes ("
+ "player VARCHAR(64),"
+ "world VARCHAR(128),"
+ "x INT,"
+ "y INT,"
+ "z INT,"
+ "yaw INT,"
+ "pitch INT"
+ ");";
// to create a table we pass an SQL query.
m_perksDB.query(query, true);
}
// load all properties
// select every property from the table
String query = "SELECT * FROM perks_homes";
ResultSet result = m_perksDB.queryResult(query);
if (result != null) {
try {
// while we have another result, read in the data
while (result.next()) {
String worldName = result.getString("world");
String playerName = result.getString("player");
int x = result.getInt("x");
int y = result.getInt("y");
int z = result.getInt("z");
int pitch = result.getInt("pitch");
int yaw = result.getInt("yaw");
World world = PerkUtils.plugin.getServer().getWorld(worldName);
Location loc = new Location(world, x, y, z, yaw, pitch);
tpLocation newHome = new tpLocation();
newHome.playername = playerName;
newHome.loc = loc;
homes.add(newHome);
}
} catch (SQLException e) {
e.printStackTrace();
return;
}
m_perksDB.freeResult(result);
}
// see if a table called properties exist
if (!m_perksDB.tableExists("perks_build")) {
// the table doesn't exist, so make one.
PerkUtils.DebugConsole("Could not find perk homes builds, now creating one.");
query =
"CREATE TABLE perks_build ("
+ "player VARCHAR(64),"
+ "world VARCHAR(128),"
+ "x INT,"
+ "y INT,"
+ "z INT,"
+ "yaw INT,"
+ "pitch INT"
+ ");";
// to create a table we pass an SQL query.
m_perksDB.query(query, true);
}
// select every property from the table
query = "SELECT * FROM perks_build";
result = m_perksDB.queryResult(query);
if (result != null) {
try {
// while we have another result, read in the data
while (result.next()) {
String worldName = result.getString("world");
String playerName = result.getString("player");
int x = result.getInt("x");
int y = result.getInt("y");
int z = result.getInt("z");
int pitch = result.getInt("pitch");
int yaw = result.getInt("yaw");
World world = PerkUtils.plugin.getServer().getWorld(worldName);
Location loc = new Location(world, x, y, z, yaw, pitch);
tpLocation newHome = new tpLocation();
newHome.playername = playerName;
newHome.loc = loc;
builds.add(newHome);
}
} catch (SQLException e) {
e.printStackTrace();
return;
}
m_perksDB.freeResult(result);
}
// see if a table called properties exist
if (!m_perksDB.tableExists("perks_vanish")) {
// the table doesn't exist, so make one.
PerkUtils.DebugConsole("Could not find perk vanish databse, now creating one.");
query = "CREATE TABLE perks_vanish (" + "player VARCHAR(64)" + ");";
// to create a table we pass an SQL query.
m_perksDB.query(query, true);
}
// see if a table called properties exist
if (!m_perksDB.tableExists("perks_kit")) {
// the table doesn't exist, so make one.
PerkUtils.DebugConsole("Could not find perk kit databse, now creating one.");
query =
"CREATE TABLE perks_kit ("
+ "player VARCHAR(64),"
+ "kitname VARCHAR(64),"
+ "time LONG"
+ ");";
// to create a table we pass an SQL query.
m_perksDB.query(query, true);
}
if (!m_perksDB.tableExists("perks_flying")) {
PerkUtils.DebugConsole("Could not find flying table, creating one now");
query = "CREATE TABLE perks_flying (name VARCHAR(64));";
m_perksDB.query(query, true);
}
if (!m_perksDB.tableExists("perks_spawn")) {
PerkUtils.DebugConsole("Could not find spawn table, creating one now");
query =
"CREATE TABLE perks_spawn ("
+ "world VARCHAR(64),"
+ "x INT,"
+ "y INT,"
+ "z INT,"
+ "yaw FLOAT,"
+ "pitch FLOAT"
+ ");";
m_perksDB.query(query, true);
}
query = "SELECT * FROM perks_spawn";
result = m_perksDB.queryResult(query);
if (result != null) {
try {
while (result.next()) {
World world = PerkUtils.server().getWorld(result.getString("world"));
Location loc =
new Location(
world,
result.getInt("x"),
result.getInt("y"),
result.getInt("z"),
result.getFloat("yaw"),
result.getFloat("pitch"));
PerkWorldSpawn spawn = new PerkWorldSpawn(world, loc);
spawns.add(spawn);
}
PerkUtils.DebugConsole("Loaded " + spawns.size() + " spawns");
} catch (SQLException e) {
e.printStackTrace();
}
m_perksDB.freeResult(result);
}
UpgradeDatabases();
}
private static void UpgradeDatabases() {
File buildFile = FindDatabase("Build.sqlite");
if (buildFile != null) {
BukkitDatabase tempDb =
bDatabaseManager.createDatabase("Build", PerkUtils.plugin, DatabaseType.SQLite);
// select every property from the table
String query = "SELECT * FROM build";
ResultSet result = tempDb.queryResult(query);
try {
// while we have another result, read in the data
while (result.next()) {
String worldName = result.getString("world");
String playerName = result.getString("player");
int x = result.getInt("x");
int y = result.getInt("y");
int z = result.getInt("z");
int pitch = result.getInt("pitch");
int yaw = result.getInt("yaw");
World world = PerkUtils.plugin.getServer().getWorld(worldName);
if (world == null) continue;
Location loc = new Location(world, x, y, z, yaw, pitch);
tpLocation newHome = new tpLocation();
newHome.playername = playerName;
newHome.loc = loc;
builds.add(newHome);
AddBuild(playerName, loc);
}
} catch (SQLException e) {
e.printStackTrace();
return;
}
tempDb.freeResult(result);
tempDb.freeDatabase();
buildFile.renameTo(
new File(
PerkUtils.plugin.getDataFolder().getAbsolutePath() + "\\Build.sqlite.upgradded"));
}
File homeFile = FindDatabase("Homes.sqlite");
if (homeFile != null) {
BukkitDatabase tempDb =
bDatabaseManager.createDatabase("Homes", PerkUtils.plugin, DatabaseType.SQLite);
// select every property from the table
String query = "SELECT * FROM homes";
ResultSet result = tempDb.queryResult(query);
try {
// while we have another result, read in the data
while (result.next()) {
String worldName = result.getString("world");
String playerName = result.getString("player");
int x = result.getInt("x");
int y = result.getInt("y");
int z = result.getInt("z");
int pitch = result.getInt("pitch");
int yaw = result.getInt("yaw");
World world = PerkUtils.plugin.getServer().getWorld(worldName);
if (world == null) continue;
Location loc = new Location(world, x, y, z, yaw, pitch);
tpLocation newHome = new tpLocation();
newHome.playername = playerName;
newHome.loc = loc;
homes.add(newHome);
AddHome(playerName, loc);
}
} catch (SQLException e) {
e.printStackTrace();
return;
}
tempDb.freeResult(result);
tempDb.freeDatabase();
homeFile.renameTo(
new File(
PerkUtils.plugin.getDataFolder().getAbsolutePath() + "\\Homes.sqlite.upgradded"));
}
}
