public void addWinnerPoint(final String player) {
if (this.hasPlayer(player)) {
HEventos.getHEventos().getMysql().updateWins(player, 1);
} else {
HEventos.getHEventos().getMysql().addNew(player, 1, 1);
}
}
public void getTOPParticipations(final Player p) {
try {
p.sendMessage(HEventos.getHEventos().getConfigUtil().getTopParticipacoes());
Class.forName("org.sqlite.JDBC");
final String sql = "SELECT * FROM eventos ORDER BY participations DESC LIMIT 10";
final ResultSet rs = this.stmt.executeQuery(sql);
int i = 0;
while (rs.next()) {
i++;
p.sendMessage(
HEventos.getHEventos()
.getConfigUtil()
.getTopParticipacoesPosicao()
.replace("$posicao$", i + "")
.replace("$player$", rs.getString("player"))
.replace("$participacoes$", rs.getInt("wins") + ""));
}
} catch (final Exception e) {
e.printStackTrace();
}
}
public SQLite() {
try {
Class.forName("org.sqlite.JDBC");
this.connection =
DriverManager.getConnection(
"jdbc:sqlite:"
+ HEventos.getHEventos().getDataFolder().getAbsolutePath()
+ File.separator
+ "database.db");
this.stmt = this.connection.createStatement();
this.stmt.execute(
"CREATE TABLE IF NOT EXISTS eventos (player VARCHAR(255), wins INTEGER, participations INTEGER)");
} catch (final SQLException e) {
e.printStackTrace();
} catch (final ClassNotFoundException e) {
e.printStackTrace();
}
}