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