Пример #1
0
  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);
  }
Пример #2
0
  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);
  }
Пример #3
0
  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());
  }
Пример #4
0
  public static void addVanishPlayer(PerkPlayer player) {

    String query =
        "INSERT INTO `perks_vanish` "
            + "(`player`) VALUES ("
            + "'"
            + player.getPlayer().getName()
            + "');";
    m_perksDB.query(query, true);
  }
Пример #5
0
  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;
  }
Пример #6
0
  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;
  }
Пример #7
0
  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);
  }
Пример #8
0
 public static void Stop() {
   m_perksDB.freeDatabase();
 }
Пример #9
0
  public static void removeVanishPlayer(PerkPlayer player) {

    String query =
        "DELETE FROM `perks_vanish` " + "WHERE player=" + "'" + player.getPlayer().getName() + "';";
    m_perksDB.query(query, true);
  }
Пример #10
0
  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();
  }
Пример #11
0
  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"));
    }
  }