public void delete() throws SQLException {
Connection databaseConnection = server.getDatabaseConnection();
try (PreparedStatement statement =
databaseConnection.prepareStatement("DELETE FROM `game` WHERE `uuid` = ?")) {
statement.setString(1, getUUID().toString());
statement.executeUpdate();
} catch (SQLException exception) {
server.getLogger().log(SEVERE, "Failed to delete game", exception);
} finally {
databaseConnection.close();
}
}
public void update() throws SQLException {
Connection databaseConnection = server.getDatabaseConnection();
try (PreparedStatement statement =
databaseConnection.prepareStatement(
"UPDATE `game` SET `player1_uuid` = ?, `player2_uuid` = ?, `winner_uuid` = ?, `timestamp` = ? WHERE `uuid` = ?")) {
statement.setString(1, getPlayer1().getUUID().toString());
statement.setString(2, getPlayer2().getUUID().toString());
statement.setString(3, getWinner().getUUID().toString());
statement.setLong(4, getTimestamp());
statement.setString(5, getUUID().toString());
statement.executeUpdate();
} catch (SQLException exception) {
server.getLogger().log(SEVERE, "Failed to update game", exception);
} finally {
databaseConnection.close();
}
}
public void insert() throws SQLException {
Connection databaseConnection = server.getDatabaseConnection();
try (PreparedStatement statement =
databaseConnection.prepareStatement(
"INSERT INTO `game`(`uuid`, `player1_uuid`, `player2_uuid`, `winner_uuid`, `timestamp`) VALUES(?, ?, ?, ?, ?)")) {
statement.setString(1, getUUID().toString());
statement.setString(2, getPlayer1().getUUID().toString());
statement.setString(3, getPlayer2().getUUID().toString());
statement.setString(4, getWinner().getUUID().toString());
statement.setLong(5, getTimestamp());
statement.executeUpdate();
} catch (SQLException exception) {
server.getLogger().log(SEVERE, "Failed to insert game", exception);
} finally {
databaseConnection.close();
}
}
public void finishGame(ActiveGame game, Player winner) {
activeGames.remove(game.getPlayer1().getUUID().toString());
activeGames.remove(game.getPlayer2().getUUID().toString());
adjustMMR(game, winner);
InactiveGame inactiveGame = new InactiveGame(server, game, winner);
try {
inactiveGame.insert();
} catch (SQLException exception) {
server.getLogger().log(SEVERE, "Failed to insert game", exception);
}
}
public void onTick() {
Set<Player> toRemove = new HashSet<>();
for (Player player : searching.keySet()) {
if (getGame(player) == null) {
searching.put(player, searching.get(player) + 1);
for (Player potentialMatch : searching.keySet()) {
if (potentialMatch == player) continue;
if (Math.abs(potentialMatch.getMMR() - player.getMMR())
< Math.min(searching.get(player), searching.get(potentialMatch))) {
Channel player1Channel = server.getHandler().getChannel(player);
Channel player2Channel = server.getHandler().getChannel(potentialMatch);
ActiveGame game =
new ActiveGame(this, player, potentialMatch, player1Channel, player2Channel);
StringBuilder levelBuilder = new StringBuilder();
Random random = new Random();
for (int i = 0; i < 100000; i += 64) {
int offset = random.nextInt(256);
if (offset < 240) {
if (random.nextInt(10) == 0) {
offset = 240 + random.nextInt(16);
}
}
levelBuilder.append("|").append(offset);
}
String message = "G" + levelBuilder.toString() + "\n";
player1Channel.writeAndFlush(message);
player2Channel.writeAndFlush(message);
addGame(game);
break;
}
}
} else {
toRemove.add(player);
}
}
for (Player player : toRemove) {
searching.remove(player);
}
Set<ActiveGame> tooLongGames = new HashSet<>();
for (ActiveGame game : activeGames.values()) {
if (System.currentTimeMillis() - game.getTimestamp() > 300000L) {
tooLongGames.add(game);
}
}
for (ActiveGame game : tooLongGames) {
if (game.getPlayer1Score() < 0) {
finishGame(game, game.getPlayer2());
} else if (game.getPlayer2Score() < 0) {
finishGame(game, game.getPlayer1());
} else {
finishGame(game);
}
}
}
private void adjustMMR(ActiveGame game, Player winner) {
Player player1 = game.getPlayer1();
Player player2 = game.getPlayer2();
Rating player1Rating =
new Rating(
player1.getUUID().toString(),
ratingCalculator,
player1.getMMR(),
player1.getRatingDeviation(),
player1.getVolatility());
player1Rating.setNumberOfResults(player1.getNumberOfResults());
Rating player2Rating =
new Rating(
player2.getUUID().toString(),
ratingCalculator,
player2.getMMR(),
player2.getRatingDeviation(),
player2.getVolatility());
player2Rating.setNumberOfResults(player2.getNumberOfResults());
RatingPeriodResults ratingPeriodResults = new RatingPeriodResults();
if (winner.getUUID().toString().equalsIgnoreCase(player1.getUUID().toString())) {
ratingPeriodResults.addResult(player1Rating, player2Rating);
} else if (winner.getUUID().toString().equalsIgnoreCase(player2.getUUID().toString())) {
ratingPeriodResults.addResult(player2Rating, player1Rating);
}
ratingCalculator.updateRatings(ratingPeriodResults);
player1.setMMR(player1Rating.getRating());
player1.setRatingDeviation(player1Rating.getRatingDeviation());
player1.setVolatility(player1Rating.getVolatility());
player1.setNumberOfResults(player1Rating.getNumberOfResults());
try {
player1.update();
} catch (SQLException exception) {
server.getLogger().log(SEVERE, "Failed to update player MMR", exception);
}
player2.setMMR(player2Rating.getRating());
player2.setRatingDeviation(player2Rating.getRatingDeviation());
player2.setVolatility(player2Rating.getVolatility());
player2.setNumberOfResults(player2Rating.getNumberOfResults());
try {
player2.update();
} catch (SQLException exception) {
server.getLogger().log(SEVERE, "Failed to update player MMR", exception);
}
Channel player1Channel = server.getHandler().getChannel(player1);
if (player1Channel != null) {
player1Channel.writeAndFlush("M|" + (int) Math.round(player1.getMMR()) + "\n");
}
Channel player2Channel = server.getHandler().getChannel(player2);
if (player2Channel != null) {
player2Channel.writeAndFlush("M|" + (int) Math.round(player2.getMMR()) + "\n");
}
}
