Java code by Maxi12_K

main.java

package me.Maxi12_K;

import org.bukkit.Bukkit;
import org.bukkit.command.Command;
import org.bukkit.command.CommandSender;
import org.bukkit.entity.Player;
import org.bukkit.event.Listener;
import org.bukkit.event.player.PlayerLoginEvent;
import org.bukkit.plugin.java.JavaPlugin;
import org.bukkit.scoreboard.Scoreboard;
public class main extends JavaPlugin implements Listener{

	private MySQL mysql;
	Scoreboard sb;	
	@Override
	public void onEnable()
	{
	MySQL.connect();
	MySQL.createTable();
	Bukkit.getServer().getPluginManager().registerEvents(this, this);
    sb = Bukkit.getScoreboardManager().getNewScoreboard();
    sb.registerNewTeam("0000Serverleiter");
    sb.registerNewTeam("0001Developer");
    sb.registerNewTeam("0002Admin");
    sb.registerNewTeam("0003Moderator");
    sb.registerNewTeam("0004Supporter");
    sb.registerNewTeam("0005Builder");
    sb.registerNewTeam("0008T-Sup");
    sb.registerNewTeam("0009Member");
    sb.registerNewTeam("0010gast");
    
    sb.getTeam("0000Serverleiter").setPrefix("§4SI§8|§c");
	sb.getTeam("0001Developer").setPrefix("§4Dev§8|§5");
	sb.getTeam("0002Admin").setPrefix("4Admin§|§d");
	sb.getTeam("0003Moderator").setPrefix("§1Mod§8|§9");
	sb.getTeam("0004Supporter").setPrefix("§bSup§8|§3");   
	sb.getTeam("0006Builder").setPrefix("§dBuilder§8|§7");
	sb.getTeam("0008T-Sup").setPrefix("§2T-Sup§8|§a");
	sb.getTeam("0009Member").setPrefix("§7MB|");
	sb.getTeam("0010gast").setPrefix("§fGuest|");
	}
	
	public void onLogin(PlayerLoginEvent a)
	{
		mysql.newplayer(a.getPlayer());
		setPrefix(a.getPlayer());
		 }
	
  
	
	public void setPrefix(Player p){
		String team = "";
		Player player = p.getPlayer();
	    if(player.hasPermission("rank.si")){
	    team = "0000Serverleiter";}
	    else if(player.hasPermission("rank.dev")){
	    team = "0001Developer";}
	    else if(player.hasPermission("rank.admin")){
	    team = "0002Admin";}
	    else if(player.hasPermission("rank.mod")){
	    team = "0003Moderator";}
	    else if(player.hasPermission("rank.sup")){
	    team = "0004Supporter";}
	    else if(player.hasPermission("rank.builder")){
	    team = "0005Builder";}
	    else if(player.hasPermission("rank.tsup")){
	    team = "0006T-Sup";}
	    else if(player.hasPermission("rank.member")){
	    team = "0009Member";}
	    else if(player.hasPermission("rank.gast")){
	    team = "0010gast";}
	    sb.getTeam(team).addPlayer(p);
	    p.setDisplayName(sb.getTeam(team).getPrefix());
		for(Player all : Bukkit.getOnlinePlayers()){
		all.setScoreboard(sb);
	}}
	
	public boolean onCommand(CommandSender sender, Command cmd, String lable, String[] args)
	{
		if(cmd.getName().equalsIgnoreCase("cc")){
			Player p = (Player) sender;
			if(p.hasPermission("chat.clear") || p.isOp()){
				for (Player all : Bukkit.getOnlinePlayers()){
					for(int i=0; i < 100; i ++)
					{
					all.sendMessage("");
					}
					}
				}
				
				Bukkit.broadcastMessage("§e[§bChat§e] » Der Chat wurde von §b" + p.getDisplayName() + "§e geleert!");
			}
		return false;}
	
	}
	 

mysql.java

package me.Maxi12_K;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import org.bukkit.Bukkit;
import org.bukkit.entity.Player;

public class MySQL
{
  public static String username;
  public static String password;
  public static String database;
  public static String host;
  public static String port;
  public static Connection con;
  
  public static void connect()
  {
    if (!isConnected()) {
      try
      {
        con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mc", "test", "test2457");
        Bukkit.getConsoleSender().sendMessage("MySQL Verbindung aufgebaut!");
      }
      catch (SQLException e)
      {
        e.printStackTrace();
      }
    }
  }
  
  public static void close()
  {
    if (isConnected()) {
      try
      {
        con.close();
        Bukkit.getConsoleSender().sendMessage("MySQL Verbindung geschlossen!");
      }
      catch (SQLException e)
      {
        e.printStackTrace();
      }
    }
  }
  
  public static boolean isConnected()
  {
    return con != null;
  }
  
  public static void createTable()
  {
    if (isConnected()) {
      try
      {
        con.createStatement().executeUpdate("CREATE TABLE IF NOT EXISTS AllUsers(uuid varchar(64), username varchar(64), rank varchar(64), banned boolean, bannreason varchar(64), temban int)");
      }
      catch (SQLException e)
      {
        e.printStackTrace();
      }
    }
  }
  
  public static void update(String qry)
  {
    if (isConnected()) {
      try
      {
        con.createStatement().executeUpdate(qry);
      }
      catch (SQLException e)
      {
        e.printStackTrace();
      }
    }
  }
  
  public static ResultSet getResult(String qry)
  {
    if (isConnected()) {
      try
      {
        return con.createStatement().executeQuery(qry);
      }
      catch (SQLException e)
      {
        e.printStackTrace();
      }
    }
    return null;
  }
  public void newplayer(Player p){
	  try
	  {
		 PreparedStatement stmt = con.prepareStatement("select uuid from AllUsers where uuid='" + p.getUniqueId() + "'"); 
		  ResultSet rs = stmt.executeQuery();
		  if(rs != null){
			  p.sendMessage("willkommen zurück");
		
			  }
		  else 
		  {
			  p.sendMessage("willkommen");
			  con.createStatement().executeQuery("INSERT INTO AllUsers(uuid, username, rank, banned, bannreason, temban) VALUES ('" + p.getUniqueId() + "', '" + p.getDisplayName() + "', guest, 0, 0, 0);");
			
		  }
	  }
	  catch (SQLException e)
	  {
		  e.printStackTrace();
	  }
  }
}