public void run() {
      datafolder = p.getDataFolder();

      PluginManager pm = getServer().getPluginManager();
      setCommands();

      SettingsManager.getInstance().setup(p);
      MessageManager.getInstance().setup();
      GameManager.getInstance().setup(p);

      try { // try loading everything that uses SQL.
        FileConfiguration c = SettingsManager.getInstance().getConfig();
        if (c.getBoolean("stats.enabled")) DatabaseManager.getInstance().setup(p);
        QueueManager.getInstance().setup();
        StatsManager.getInstance().setup(p, c.getBoolean("stats.enabled"));
        dbcon = true;
      } catch (Exception e) {
        dbcon = false;
        e.printStackTrace();
        logger.severe(
            "!!!Failed to connect to the database. Please check the settings and try again!!!");
        return;
      } finally {
        LobbyManager.getInstance().setup(p);
      }

      ChestRatioStorage.getInstance().setup();
      HookManager.getInstance().setup();
      pm.registerEvents(new PlaceEvent(), p);
      pm.registerEvents(new BreakEvent(), p);
      pm.registerEvents(new DeathEvent(), p);
      pm.registerEvents(new MoveEvent(), p);
      pm.registerEvents(new CommandCatch(), p);
      pm.registerEvents(new SignClickEvent(), p);
      pm.registerEvents(new ChestReplaceEvent(), p);
      pm.registerEvents(new LogoutEvent(), p);
      pm.registerEvents(new JoinEvent(p), p);
      pm.registerEvents(new TeleportEvent(), p);
      pm.registerEvents(LoggingManager.getInstance(), p);
      pm.registerEvents(new SpectatorEvents(), p);
      pm.registerEvents(new BandageUse(), p);
      pm.registerEvents(new KitEvents(), p);

      for (Player p : Bukkit.getOnlinePlayers()) {
        if (GameManager.getInstance().getBlockGameId(p.getLocation()) != -1) {
          p.teleport(SettingsManager.getInstance().getLobbySpawn());
        }
      }

      //   new Webserver().start();
    }
public class StatsManager {

  private static StatsManager instance = new StatsManager();

  private ArrayList<PreparedStatement> queue = new ArrayList<PreparedStatement>();
  private DatabaseDumper dumper = new DatabaseDumper();
  private DatabaseManager dbman = DatabaseManager.getInstance();

  // private HashMap<Player, PlayerStatsSession>pstats = new HashMap<Player, PlayerStatsSession>();

  private HashMap<Integer, HashMap<Player, PlayerStatsSession>> arenas =
      new HashMap<Integer, HashMap<Player, PlayerStatsSession>>();

  private boolean enabled = true;

  MessageManager msgmgr;

  private StatsManager() {
    msgmgr = MessageManager.getInstance();
    ;
  }

  public static StatsManager getInstance() {
    return instance;
  }

  public void setup(Plugin p, boolean b) {
    enabled = b;
    if (b) {
      try {
        PreparedStatement s =
            dbman.createStatement(
                " CREATE TABLE "
                    + SettingsManager.getSqlPrefix()
                    + "playerstats(id int NOT NULL AUTO_INCREMENT PRIMARY KEY, gameno int,arenaid int, player text, points int,position int,"
                    + " kills int, death int, killed text,time int, ks1 int, ks2 int,ks3 int, ks4 int, ks5 int)");

        PreparedStatement s1 =
            dbman.createStatement(
                " CREATE TABLE "
                    + SettingsManager.getSqlPrefix()
                    + "gamestats(gameno int NOT NULL AUTO_INCREMENT PRIMARY KEY, arenaid int, players int, winner text, time int )");

        DatabaseMetaData dbm = dbman.getMysqlConnection().getMetaData();
        ResultSet tables =
            dbm.getTables(null, null, SettingsManager.getSqlPrefix() + "playerstats", null);
        ResultSet tables1 =
            dbm.getTables(null, null, SettingsManager.getSqlPrefix() + "gamestats", null);

        if (tables.next()) {
        } else {
          s.execute();
        }
        if (tables1.next()) {
        } else {
          s1.execute();
        }
      } catch (Exception e) {
        e.printStackTrace();
      }
    }
  }

  public void addArena(int arenaid) {
    arenas.put(arenaid, new HashMap<Player, PlayerStatsSession>());
  }

  public void addPlayer(Player p, int arenaid) {
    arenas.get(arenaid).put(p, new PlayerStatsSession(p, arenaid));
  }

  public void removePlayer(Player p, int id) {
    arenas.get(id).remove(p);
  }

  public void playerDied(Player p, int pos, int arenaid, long time) {
    /*    System.out.println("player null "+(p == null));
    System.out.println("arena null "+(arenas == null));
    System.out.println("arenagetplayer null "+(arenas.get(arenaid).get(p) == null));*/

    arenas.get(arenaid).get(p).died(pos, time);
  }

  public void playerWin(Player p, int arenaid, long time) {
    arenas.get(arenaid).get(p).win(time);
  }

  public void addKill(Player p, Player killed, int arenaid) {
    PlayerStatsSession s = arenas.get(arenaid).get(p);

    int kslevel = s.addKill(killed);
    if (kslevel > 3) {
      msgmgr.broadcastFMessage(
          PrefixType.INFO,
          "killstreak.level" + ((kslevel > 5) ? 5 : kslevel),
          "player-" + p.getName());
    } else if (kslevel > 0) {
      for (Player pl : GameManager.getInstance().getGame(arenaid).getAllPlayers()) {
        msgmgr.sendFMessage(
            PrefixType.INFO,
            "killstreak.level" + ((kslevel > 5) ? 5 : kslevel),
            pl,
            "player-" + p.getName());
      }
    }
  }

  public void saveGame(int arenaid, Player winner, int players, long time) {
    if (!enabled) return;
    int gameno = 0;
    Game g = GameManager.getInstance().getGame(arenaid);

    try {
      long time1 = new Date().getTime();
      PreparedStatement s2 =
          dbman.createStatement(
              "SELECT * FROM "
                  + SettingsManager.getSqlPrefix()
                  + "gamestats ORDER BY gameno DESC LIMIT 1");
      ResultSet rs = s2.executeQuery();
      rs.next();
      gameno = rs.getInt(1) + 1;

      if (time1 + 5000 < new Date().getTime())
        System.out.println(
            "Your database took a long time to respond. Check the connection between the server and database");
    } catch (SQLException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
      g.setRBStatus("Error: getno");
    }

    addSQL(
        "INSERT INTO "
            + SettingsManager.getSqlPrefix()
            + "gamestats VALUES(NULL,"
            + arenaid
            + ","
            + players
            + ",'"
            + winner.getName()
            + "',"
            + time
            + ")");

    for (PlayerStatsSession s : arenas.get(arenaid).values()) {
      s.setGameID(gameno);
      addSQL(s.createQuery());
    }
    arenas.get(arenaid).clear();
  }

  private void addSQL(String query) {
    addSQL(dbman.createStatement(query));
  }

  private void addSQL(PreparedStatement s) {
    queue.add(s);
    if (!dumper.isAlive()) {
      dumper = new DatabaseDumper();
      dumper.start();
    }
  }

  class DatabaseDumper extends Thread {

    public void run() {
      while (queue.size() > 0) {
        PreparedStatement s = queue.remove(0);
        try {

          s.execute();
        } catch (Exception e) {
          dbman.connect();
        }
      }
    }
  }
}