예제 #1
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());
  }
예제 #2
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();
  }