@EventHandler(priority = EventPriority.NORMAL)
public void onPlayerJoin(PlayerJoinEvent e) {
PreparedStatement preparedStatement = null;
ResultSet resultSet = null;
Boolean iswhitelisted = null;
try {
preparedStatement =
connection.prepareStatement(
"SELECT UUID, twKey, twSecret, twName, twID from twitterWhitelist WHERE UUID=? LIMIT 1");
preparedStatement.setString(1, e.getPlayer().getUniqueId().toString());
resultSet = preparedStatement.executeQuery();
if (resultSet.isBeforeFirst()) {
iswhitelisted = true;
plugin.getLogger().info("Player " + e.getPlayer().getName() + " is already in DB.");
resultSet.next();
if (resultSet.getString("UUID") != null) {
TwitterAPI.updateAccount(
resultSet.getString("twKey"), resultSet.getString("twSecret"), e.getPlayer());
if (resultSet.getBoolean("banned")) {
// ban the player
// force the server to run ban command
String commandLine = "ban " + e.getPlayer().getName() + " Multiaccount-Ban.";
Bukkit.dispatchCommand(Bukkit.getConsoleSender(), commandLine);
}
}
} else {
// nicht gewhitelistet, also sperren und nur tww befehle erlauben.
iswhitelisted = false;
}
} catch (SQLException err) {
plugin.getLogger().warning("Couldn't fetch user from db: " + err.getMessage());
} finally {
try {
if (preparedStatement != null) preparedStatement.close();
} catch (SQLException e1) {
}
}
if (iswhitelisted != null && !iswhitelisted) {
plugin
.getLogger()
.info(
"Player"
+ e.getPlayer().getName()
+ " is NOT whitelisted, sending message to player.");
e.getPlayer()
.sendMessage(
(Object) ChatColor.DARK_RED
+ chatPrefix
+ (Object) ChatColor.WHITE
+ "Um auf diesem Server spielen zu können, musst du dich mithilfe eines Twitter Accounts freischalten. Dies kannst du wie folgt tun:\n"
+ (Object) ChatColor.GOLD
+ "/tww r");
e.getPlayer().setGameMode(GameMode.SPECTATOR);
unwhitelisteds.add(e.getPlayer().getUniqueId());
} else {
plugin.getLogger().info("Player" + e.getPlayer().getName() + " is whitelisted");
}
}
