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