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 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 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();
}
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();
}
}
}
}
}
private void addSQL(String query) {
addSQL(dbman.createStatement(query));
}
