Advertisement
Guest User

Untitled

a guest
Jul 30th, 2016
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 KB | None | 0 0
  1. @EventHandler
  2. public void onJoin(LoginEvent event){
  3. try{
  4. Statement state = SQL.conn.createStatement();
  5. ResultSet res = state.executeQuery("SELECT * FROM sanctions WHERE uuid = '" + event.getConnection().getUniqueId().toString() + "';");
  6. res.next();
  7. if(res.getString("ban").equalsIgnoreCase("true")){
  8. event.setCancelled(true);
  9. event.setCancelReason("§cErreur : Vous êtes banni !\n§cPour : §f§l " + res.getString("raison_ban") + "\n§cPar : §f§l " + res.getString("sanctionneur_ban"));
  10. }
  11. if(res.getString("banip").equalsIgnoreCase("true")){
  12. event.setCancelled(true);
  13. event.setCancelReason("§cErreur : Vous êtes banni !\n§cPour : §f§l " + res.getString("raison_banip") + "\n§cPar : §f§l " + res.getString("sanctionneur_banip"));
  14. }
  15. }catch(SQLException SQLE){
  16. SQLE.printStackTrace();
  17. }
  18. }
  19. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement