package ban;

import java.sql.*;
import java.sql.Driver;

public class API {

    static Connection con;

    public static void connect(){
        if(!isConnected()){
            try{
                con = DriverManager.getConnection("jdbc:mysql://localhost/BanManager?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC&autoReconnect=true","root","ohB3xaiS");
            }catch (SQLException e){
                e.printStackTrace();
            }
        }
    }

    public static boolean isConnected(){
        return con != null;
    }

    public static void close(){
        try {
            con.close();
        }catch (SQLException e){
            e.printStackTrace();
        }
    }

    public static void unban(String banneduuid, String bannedname, long end, String grund, String sender, Long createt, String ID){
        PreparedStatement statement;
        try{
            queryUpdate("INSERT INTO AbgelaufeneBans (UUID, NAME, END, GRUND, SENDER, CREATET, ID) VALUES ('"+banneduuid+"','"+bannedname+"','"+end+"','"+grund+"','"+sender+"','"+createt+"','"+ID+"')");
            statement = con.prepareStatement("DELETE FROM BanManager WHERE UUID = ?");
            statement.setString(1, banneduuid);
            statement.executeUpdate();
        }catch (SQLException e){
            e.printStackTrace();
        }
    }

    public static ResultSet query(String query){
        try {
            return query(con.prepareStatement(query));
        }catch (Exception e){
            e.printStackTrace();
            return null;
        }
    }
    public static ResultSet query(PreparedStatement statement){
        try {
            return statement.executeQuery();
        }catch (Exception e){
            e.printStackTrace();
            return null;
        }
    }
    public static void queryUpdate(String query) {
        try (PreparedStatement statement = con.prepareStatement(query)) {
            queryUpdate(statement);
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }

    public static void queryUpdate(PreparedStatement statement) {
        try {
            statement.executeUpdate();
        } catch (SQLException e) {
            e.printStackTrace();
        } finally {
            try {
                statement.close();
            } catch (Exception e) {
                e.printStackTrace();
            }
        }
    }

    public static String getGrund(String UUID){
        try {
            PreparedStatement statement = con.prepareStatement("SELECT * FROM BanManager WHERE UUID = ?");
            statement.setString(1,UUID);
            ResultSet rs = statement.executeQuery();
            if (rs.next()){
                return rs.getString("GRUND");
            }
        }catch (SQLException e){
            e.printStackTrace();
        }
        return null;
    }

    public static String getSender(String uuid){
        try{
            PreparedStatement statement = con.prepareStatement("SELECT * FROM BanManager WHERE UUID = ?");
            statement.setString(1, uuid);
            ResultSet rs = statement.executeQuery();
            if(rs.next()){
                return rs.getString("SENDER");
            }
        }catch (SQLException e){
            e.printStackTrace();
        }
        return null;
    }

    public static String getName(String uuid){
        try{
            PreparedStatement statement = con.prepareStatement("SELECT * FROM BanManager WHERE UUID = ?");
            statement.setString(1, uuid);
            ResultSet rs = statement.executeQuery();
            if(rs.next()){
                return rs.getString("NAME");
            }
        }catch (SQLException e){
            e.printStackTrace();
        }
        return null;
    }

    public static String getID(String uuid){
        try{
            PreparedStatement statement = con.prepareStatement("SELECT * FROM BanManager WHERE UUID = ?");
            statement.setString(1, uuid);
            ResultSet rs = statement.executeQuery();
            if(rs.next()){
                return rs.getString("ID");
            }
        }catch (SQLException e){
            e.printStackTrace();
        }
        return null;
    }

    public static long getCreatet(String uuid){
        ResultSet rs = getResult("SELECT * FROM BanManager WHERE UUID ='"+uuid+"'");
        try{
            if(rs.next()){
                return rs.getLong("CREATET");
            }
        }catch (SQLException e){
            e.printStackTrace();
        }
        return 0;
    }

    public static String getUUID(String name){
        try {
            PreparedStatement statement = con.prepareStatement("SELECT UUID FROM BanManager WHERE NAME = ?");
            statement.setString(1,name);
            ResultSet rs = statement.executeQuery();
            if (rs.next()){
                return rs.getString("UUID");
            }
        }catch (SQLException e){
            e.printStackTrace();
        }
        return null;
    }

    public static ResultSet getResult(String qry){
        if(isConnected()){
            try{
                return con.createStatement().executeQuery(qry);
            }catch (SQLException e){
                e.printStackTrace();
            }
        }
        return null;
    }

    public static long getEnd(String uuid){
        ResultSet rs = getResult("SELECT * FROM BanManager WHERE UUID ='"+uuid+"'");
        try{
            if(rs.next()){
                return rs.getLong("END");
            }
        }catch (SQLException e){
            e.printStackTrace();
        }
        return 0;
    }

}

package ban;

import commands.Command;
import core.PermsCore;
import net.dv8tion.jda.core.EmbedBuilder;
import net.dv8tion.jda.core.events.message.MessageReceivedEvent;

import java.awt.*;
import java.sql.SQLException;

public class CMD_clearip implements Command {
    @Override
    public boolean called(String[] args, MessageReceivedEvent e) {
        return false;
    }

    @Override
    public void action(String[] args, MessageReceivedEvent e) {

        if (PermsCore.check(e)) {

        }else{

            if (args.length != 0){
                return;
            }

            try {
                API.con.prepareStatement("DELETE FROM IP").executeUpdate();
                e.getTextChannel().sendMessage(new EmbedBuilder().setColor(Color.green).addField("Erfolg","Es wurden alle IP Adressen aus der Datenbank gelöscht!",false).build()).queue();
            }catch (SQLException r){
                e.getTextChannel().sendMessage(new EmbedBuilder().setColor(Color.red).addField("Fehler","Es ist ein Fehler aufgetreten, melde es bitte `WurmiiException`!",false).build()).queue();
                r.printStackTrace();
            }

        }
    }

    @Override
    public void executed(boolean succes, MessageReceivedEvent e) {

    }

    @Override
    public String help() {
        return null;
    }
}
package ban;

import commands.Command;
import core.Main;
import core.PermsCore;
import net.dv8tion.jda.core.EmbedBuilder;
import net.dv8tion.jda.core.events.message.MessageReceivedEvent;

import java.awt.*;
import java.util.concurrent.TimeUnit;

public class CMD_unban implements Command {
    @Override
    public boolean called(String[] args, MessageReceivedEvent e) {
        return false;
    }

    @Override
    public void action(String[] args, MessageReceivedEvent e) {

        if(PermsCore.check(e)){

        }else{
            if (args.length == 1) {
                String Name = args[0];
                String uuid = API.getUUID(Name);
                if (uuid == null) {
                    e.getTextChannel().sendMessage(new EmbedBuilder().addField("Fehler",Name + " ist falsch geschrieben oder nicht gebannt!",false).setColor(Color.red).build()).complete().delete().queueAfter(3,TimeUnit.SECONDS);
                    return;
                }
                API.unban(uuid, API.getName(uuid), API.getEnd(uuid), API.getGrund(uuid), API.getSender(uuid), API.getCreatet(uuid), API.getID(uuid));
            }else {
                Main.sendMessageToLowArgs(e, "-unban <mcname>");
            }




        }

    }

    @Override
    public void executed(boolean succes, MessageReceivedEvent e) {

    }

    @Override
    public String help() {
        return null;
    }
}
package Coins;

import java.io.BufferedReader;
import java.io.InputStreamReader;
import java.net.URL;
import java.net.URLConnection;
import java.nio.charset.Charset;

public class Api {

    public static String getUUID(String playername) {
        String output = callURL("https://api.mojang.com/users/profiles/minecraft/" + playername);

        StringBuilder result = new StringBuilder();

        readData(output, result);

        return result.toString();
    }

    private static void readData(String toRead, StringBuilder result) {
        int i = 7;

        while(i < 200) {
            if(!String.valueOf(toRead.charAt(i)).equalsIgnoreCase("\"")) {

                result.append(String.valueOf(toRead.charAt(i)));

            } else {
                break;
            }

            i++;
        }
    }

    private static String callURL(String URL) {
        StringBuilder sb = new StringBuilder();
        URLConnection urlConn = null;
        InputStreamReader in = null;
        try {
            java.net.URL url = new URL(URL);
            urlConn = url.openConnection();

            if (urlConn != null) urlConn.setReadTimeout(60 * 1000);

            if (urlConn != null && urlConn.getInputStream() != null) {
                in = new InputStreamReader(urlConn.getInputStream(), Charset.defaultCharset());
                BufferedReader bufferedReader = new BufferedReader(in);

                if (bufferedReader != null) {
                    int cp;

                    while ((cp = bufferedReader.read()) != -1) {
                        sb.append((char) cp);
                    }

                    bufferedReader.close();
                }
            }

            in.close();
        } catch (Exception e) {
            e.printStackTrace();
        }

        return sb.toString();
    }
}
package Coins;

import commands.Command;
import core.CoinPermsCore;
import core.Main;
import core.PermsCore;
import net.dv8tion.jda.core.EmbedBuilder;
import net.dv8tion.jda.core.events.message.MessageReceivedEvent;

import java.awt.*;

public class CMD_addCoins implements Command {

    String cmd = "-addcoins <spielername> <anzahl>";

    @Override
    public boolean called(String[] args, MessageReceivedEvent e) {
        return false;
    }

    @Override
    public void action(String[] args, MessageReceivedEvent e) {

        if (CoinPermsCore.check(e)){

        }else{
            if (e.getTextChannel().getName().equalsIgnoreCase("team")) {
                if (args.length == 0) {
                    Main.sendMessageToLowArgs(e, cmd);
                } else if (args.length == 1) {
                    Main.sendMessageToLowArgs(e, cmd);
                } else if (args.length == 2) {
                    if (MySQL.isExisting(null, args[0])) {
                        int coins = Integer.parseInt(args[1]);
                        sendSuccesMessage(e, args);
                        CoinAPI.addCoins(args[0], coins);
                    } else {
                        Main.isNotExisting(e, args);
                    }
                }


            }else{
                e.getMessage().delete().queue();
            }
        }


    }

    @Override
    public void executed(boolean succes, MessageReceivedEvent e) {

    }

    @Override
    public String help() {
        return null;
    }

    public void sendSuccesMessage(MessageReceivedEvent e,String[] args){
        String UUID = Api.getUUID(args[0]);
        int coins = Integer.parseInt(args[1]);
        EmbedBuilder f = new EmbedBuilder();
        f.setColor(Color.green);
        f.addField("Erfolg",args[0]+" hat nun "+CoinAPI.getCoins(args[0])+" Coins!",false);
        e.getTextChannel().sendMessage(f.build()).queue();
    }

}

package Coins;

import commands.Command;
import core.CoinPermsCore;
import core.Main;
import core.PermsCore;
import net.dv8tion.jda.core.EmbedBuilder;
import net.dv8tion.jda.core.events.message.MessageReceivedEvent;

import java.awt.*;

public class CMD_clearcoins implements Command {

    String cmd = "-clearcoins <spielername>";

    @Override
    public boolean called(String[] args, MessageReceivedEvent e) {
        return false;
    }

    @Override
    public void action(String[] args, MessageReceivedEvent e) {
        if (CoinPermsCore.check(e)) {

        } else {
                if (e.getTextChannel().getName().equalsIgnoreCase("team")) {
                    if (args.length == 1) {
                        if (MySQL.isExisting(null, args[0])) {
                            EmbedBuilder f = new EmbedBuilder();
                            f.setColor(Color.green);
                            f.addField("Dieser Spieler hat nun 0 Coins", args[0], false);
                            e.getTextChannel().sendMessage(f.build()).queue();
                            CoinAPI.setCoins(args[0], 0);
                        } else {
                            Main.isNotExisting(e, args);
                        }
                    } else {
                        Main.sendMessageToLowArgs(e, cmd);
                    }
                } else {
                    e.getMessage().delete().queue();
                }
            }
        }

    @Override
    public void executed(boolean succes, MessageReceivedEvent e) {

    }

    @Override
    public String help() {
        return null;
    }
}
package Coins;

import commands.Command;
import core.CoinPermsCore;
import core.Main;
import core.PermsCore;
import net.dv8tion.jda.core.EmbedBuilder;
import net.dv8tion.jda.core.events.message.MessageReceivedEvent;

import java.awt.*;

public class CMD_coins implements Command {

    String cmd = "-coins";

    @Override
    public boolean called(String[] args, MessageReceivedEvent e) {
        return false;
    }

    @Override
    public void action(String[] args, MessageReceivedEvent e) {

                if (args.length == 1) {
                    if (!CoinPermsCore.check(e)){
                    if (MySQL.isExisting(null, args[0])) {
                        String UUID = Api.getUUID(args[0]);
                        EmbedBuilder f = new EmbedBuilder();
                        f.setColor(Color.green);
                        f.addField("Coins von " + args[0], String.valueOf(CoinAPI.getCoins(args[0])), false);
                        e.getTextChannel().sendMessage(f.build()).queue();
                    }else{
                        Main.isNotExisting(e, args);
                    }
                } else {

                        }
                    } else if (args.length == 0){
                        if (!Verify.MySQL.isRegistered(e.getAuthor().getId())){
                            Main.isNotExisting(e,args);
                        }else{
                            e.getTextChannel().sendMessage(new EmbedBuilder().setColor(Color.green).addField("Coins von "+Verify.littlespi.getMCName(e.getAuthor().getId()),String.valueOf(CoinAPI.getCoins(Verify.littlespi.getMCName(e.getAuthor().getId()))),false).build()).queue();
                        }
                    }else{
                        Main.sendMessageToLowArgs(e, cmd);
                    }

                }

    @Override
    public void executed(boolean succes, MessageReceivedEvent e) {

    }

    @Override
    public String help() {
        return null;
    }
}
package Coins;

import commands.Command;
import core.CoinPermsCore;
import core.Main;
import net.dv8tion.jda.core.EmbedBuilder;
import net.dv8tion.jda.core.events.message.MessageReceivedEvent;

import java.awt.*;

public class CMD_removeCoins implements Command {

    String cmd = "-removecoins <spielername> <anzahl>";

    @Override
    public boolean called(String[] args, MessageReceivedEvent e) {
        return false;
    }

    @Override
    public void action(String[] args, MessageReceivedEvent e) {

        if (CoinPermsCore.check(e)) {

        } else {
                if (e.getTextChannel().getName().equalsIgnoreCase("team")) {
                    if (args.length == 0) {
                        Main.sendMessageToLowArgs(e, cmd);
                    } else if (args.length == 1) {
                        Main.sendMessageToLowArgs(e, cmd);
                    } else if (args.length == 2) {
                        if (MySQL.isExisting(null, args[0])) {
                            String UUID = Api.getUUID(args[0]);
                            int coins = Integer.parseInt(args[1]);
                            sendSuccesMessage(e, args);
                            CoinAPI.removeCoins(args[0], coins);
                        } else {
                            Main.isNotExisting(e, args);
                        }
                    }

                } else {
                    e.getMessage().delete().queue();
                }
            }
        }


        @Override
    public void executed(boolean succes, MessageReceivedEvent e) {

    }

    @Override
    public String help() {
        return null;
    }

    public void sendSuccesMessage(MessageReceivedEvent e,String[] args){
        String UUID = Api.getUUID(args[0]);
        int coins = Integer.parseInt(args[1]);
        EmbedBuilder f = new EmbedBuilder();
        f.setColor(Color.green);
        int Coins = CoinAPI.getCoins(args[0]) - 1;
        f.addField("Erfolg",args[0]+" hat nun "+ Coins +" Coins!",false);
        e.getTextChannel().sendMessage(f.build()).queue();
    }

}
package Coins;

import commands.Command;
import core.CoinPermsCore;
import core.Main;
import core.PermsCore;
import net.dv8tion.jda.core.EmbedBuilder;
import net.dv8tion.jda.core.events.message.MessageReceivedEvent;

import java.awt.*;

@SuppressWarnings("all")
public class CMD_SetCoins implements Command {

    String cmd = "-setcoins <spielername> <anzahl>";

    @Override
    public boolean called(String[] args, MessageReceivedEvent e) {
        return false;
    }

    @Override
    public void action(String[] args, MessageReceivedEvent e) {

        if (CoinPermsCore.check(e)){

        }else {
                if (e.getTextChannel().getName().equalsIgnoreCase("team")) {
                    if (args.length == 0) {
                        Main.sendMessageToLowArgs(e, cmd);
                    } else if (args.length == 1) {
                        Main.sendMessageToLowArgs(e, cmd);
                    } else if (args.length == 2) {
                        if (MySQL.isExisting(null, args[0])) {
                            String UUID = Api.getUUID(args[0]);
                            int coins = Integer.parseInt(args[1]);
                            sendSuccesMessage(e, args);
                            CoinAPI.setCoins(args[0], coins);
                        } else {
                            Main.isNotExisting(e, args);
                        }
                    }


                } else {
                    e.getMessage().delete().queue();
                }
            }
        }

    @Override
    public void executed(boolean succes, MessageReceivedEvent e) {

    }

    @Override
    public String help() {
        return null;
    }

    public void sendSuccesMessage(MessageReceivedEvent e,String[] args){
        String UUID = Api.getUUID(args[0]);
        int coins = Integer.parseInt(args[1]);
        EmbedBuilder f = new EmbedBuilder();
        f.setColor(Color.green);
        f.addField("Erfolg",args[0]+" hat nun "+coins+" Coins!",false);
        e.getTextChannel().sendMessage(f.build()).queue();
    }
}
package Coins;

import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class CoinAPI {
    public CoinAPI() {
    }

    public static int getCoins(String name) {
        try {
            PreparedStatement statement = Coins.MySQL.con.prepareStatement("SELECT coins FROM Coins WHERE NAME = ?");
            statement.setString(1, name);
            ResultSet rs = statement.executeQuery();
            if (rs.next()) {
                return rs.getInt("coins");
            }
        } catch (SQLException var3) {
            var3.printStackTrace();
        }

        return -1;
    }

    public static void setCoins(String name, int coins) {
        PreparedStatement statement;
        if (getCoins(name) == 1) {
            try {
                statement = Coins.MySQL.con.prepareStatement("INSERT INTO Coins (NAME,coins) VALUES (?,?)");
                statement.setString(1, name);
                statement.setInt(2, coins);
                statement.executeUpdate();
            } catch (SQLException var4) {
                var4.printStackTrace();
            }
        } else {
            try {
                statement = MySQL.con.prepareStatement("UPDATE Coins SET coins = ? WHERE NAME = ?");
                statement.setString(2, name);
                statement.setInt(1, coins);
                statement.executeUpdate();
            } catch (SQLException var3) {
                var3.printStackTrace();
            }
        }

    }

    public static void addCoins(String name, int coins) {
        setCoins(name, coins + getCoins(name));
    }

 /*   public static boolean hasCoins(String uuid, int coins) {
        return getCoins(uuid) >= coins;
    } */

    public static void removeCoins(String uuid, int coins) {
        setCoins(uuid, getCoins(uuid) - coins);
    }
}
package Coins;

import core.Main;

import java.sql.*;

public class MySQL {
    public static Connection con;

    public MySQL() {
    }

    public static void connect() {
        if (!isConnected()) {
            try {
                con = DriverManager.getConnection("jdbc:mysql://localhost/Coins?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC&autoReconnect=true", "root", "ohB3xaiS");
                System.out.println(Main.prefix + "§aMySQL Verbunden!");
            } catch (SQLException var1) {
                var1.printStackTrace();
                System.out.println(Main.prefix+"§cFehler");
            }
        }

    }

    public static void disconnect() {
        if (isConnected()) {
            try {
                con.close();
                System.out.println(Main.prefix + "§cMySQL verbindung geschlossen!");
            } catch (SQLException var1) {
                var1.printStackTrace();
            }
        }

    }

    public static boolean isConnected() {
        return con != null;
    }

    public static void createTable() {
        try {
            con.prepareStatement("CREATE TABLE IF NOT EXISTS Coins (UUID VARCHAR(100), coins INT(16))").executeUpdate();
        } catch (SQLException var1) {
            var1.printStackTrace();
        }

    }

    public static boolean isExisting(String uuid, String name) {
        try {
            ResultSet rs = query("SELECT * FROM Coins WHERE NAME ='" + name + "'");
            ResultSet rs1 = query("SELECT * FROM Coins WHERE UUID ='" + uuid + "'");
            return rs.next();
        } catch (Exception var2) {
            var2.printStackTrace();
            return false;
        }
    }

    public static void create(String uuid) {
        queryUpdate("INSERT INTO Coins(UUID, coins) VALUES('" + uuid + "','" + 0 + "')");
    }

    public static ResultSet query(String query) {
        try {
            return query(con.prepareStatement(query));
        } catch (Exception var2) {
            var2.printStackTrace();
            return null;
        }
    }

    public static ResultSet query(PreparedStatement statement) {
        try {
            return statement.executeQuery();
        } catch (Exception var2) {
            var2.printStackTrace();
            return null;
        }
    }

    public static void queryUpdate(String query) {
        try {
            PreparedStatement statement = con.prepareStatement(query);
            Throwable var2 = null;

            try {
                queryUpdate(statement);
            } catch (Throwable var12) {
                var2 = var12;
                throw var12;
            } finally {
                if (statement != null) {
                    if (var2 != null) {
                        try {
                            statement.close();
                        } catch (Throwable var11) {
                            var2.addSuppressed(var11);
                        }
                    } else {
                        statement.close();
                    }
                }

            }
        } catch (SQLException var14) {
            var14.printStackTrace();
        }

    }

    public static void queryUpdate(PreparedStatement statement) {
        try {
            statement.executeUpdate();
        } catch (SQLException var10) {
            var10.printStackTrace();
        } finally {
            try {
                statement.close();
            } catch (Exception var9) {
                var9.printStackTrace();
            }

        }

    }
}

package commands;

import core.Main;
import net.dv8tion.jda.core.EmbedBuilder;
import net.dv8tion.jda.core.events.message.MessageReceivedEvent;

import java.awt.*;

public class CMD_answer implements Command {

    EmbedBuilder f = new EmbedBuilder().setColor(Color.BLUE);
    EmbedBuilder r = new EmbedBuilder().setColor(Color.red);

    @Override
    public boolean called(String[] args, MessageReceivedEvent e) {
        return false;
    }

    @Override
    public void action(String[] args, MessageReceivedEvent e) {

        if (args.length > 1) {
            e.getTextChannel().sendMessage(r.setDescription("Zu viele Argumente :warning:").build()).queue();

        }else if (args.length == 0) {
            e.getTextChannel().sendMessage(r.setDescription(Main.fehler).build()).queue();
        } else {
            e.getGuild().getTextChannelsByName("umfragen", true).get(0).sendMessage(f.setDescription("Jemand antwortete mit " + e.getMessage().getContentDisplay().replace("-answer", ":")).build()).queue();

        }
    }



    @Override
    public void executed(boolean succes, MessageReceivedEvent e) {
        System.out.println("[INFO]'-answer' wurde ausgeführt");
    }

    @Override
    public String help() {
        return null;
    }
}
package commands;

import core.PermsCore;
import net.dv8tion.jda.core.EmbedBuilder;
import net.dv8tion.jda.core.entities.Message;
import net.dv8tion.jda.core.entities.MessageHistory;
import net.dv8tion.jda.core.events.message.MessageReceivedEvent;

import java.awt.*;
import java.util.List;
import java.util.Timer;
import java.util.TimerTask;

public class CMD_clear implements Command {

    EmbedBuilder error = new EmbedBuilder().setColor(Color.CYAN);

    private int getInt(String string) {
        try {
            return Integer.parseInt(string);
        } catch (Exception e) {
            e.printStackTrace();
            return 0;
        }
    }


    @Override
    public boolean called(String[] args, MessageReceivedEvent event) {
        return false;
    }

    @Override
    public void action(String[] args, MessageReceivedEvent event) {

        if (PermsCore.check(event)) {

        } else {

            int numb = getInt(args[0]);

            if (args.length < 1) {
                event.getTextChannel().sendMessage(
                        error.setDescription("Please enter a number of messages you want to delete!").build()
                ).queue();
            }

            if (numb > 1 && numb <= 100) {

                try {

                    MessageHistory history = new MessageHistory(event.getTextChannel());
                    List<Message> msgs;

                    event.getMessage().delete().queue();

                    msgs = history.retrievePast(numb).complete();
                    event.getTextChannel().deleteMessages(msgs).queue();

                    Message msg = event.getTextChannel().sendMessage(
                            new EmbedBuilder().setColor(Color.GREEN).setDescription(args[0] + " Nachricht/en gelöscht!").build()
                    ).complete();

                    new Timer().schedule(new TimerTask() {
                        @Override
                        public void run() {
                            msg.delete().queue();
                        }
                    }, 3000);


                } catch (Exception e) {
                    e.printStackTrace();
                }


            } else {
                event.getTextChannel().sendMessage(
                        error.setDescription("please enter a number of messages between 2 and 100!").build()
                ).queue();
            }
        }
    }
    @Override
    public void executed(boolean sucess, MessageReceivedEvent event) {

    }

    @Override
    public String help() {
        return null;
    }
}
package commands;

import Coins.Api;
import core.PermsCore;
import net.dv8tion.jda.core.events.message.MessageReceivedEvent;

public class CMD_getUUID implements Command{



    @Override
    public boolean called(String[] args, MessageReceivedEvent e) {
        return false;
    }

    @Override
    public void action(String[] args, MessageReceivedEvent e) {

        if (PermsCore.check(e)){

        }else{
            if (args.length == 0){
                e.getTextChannel().sendMessage("").queue();
            }else if (args.length == 1){
                String Coins = Api.getUUID(args[0]).toString();
                e.getTextChannel().sendMessage(Coins).queue();
            }
        }

    }

    @Override
    public void executed(boolean succes, MessageReceivedEvent e) {

    }

    @Override
    public String help() {
        return null;
    }
}
package commands;

import net.dv8tion.jda.core.EmbedBuilder;
import net.dv8tion.jda.core.events.message.MessageReceivedEvent;

import java.awt.*;

public class CMD_help implements Command{
    @Override
    public boolean called(String[] args, MessageReceivedEvent e) {
        return false;
    }

    @Override
    public void action(String[] args, MessageReceivedEvent e) {
        if (e.getMember().getRoles().get(1).getName().equalsIgnoreCase("Team")){
            onTeam(e);
            dontTeam(e);
        }else{
            dontTeam(e);
        }
    }

    @Override
    public void executed(boolean succes, MessageReceivedEvent e) {

    }

    @Override
    public String help() {
        return null;
    }

    public void onTeam(MessageReceivedEvent e){
        EmbedBuilder f = new EmbedBuilder();
        f.setColor(Color.green);
        f.addField("Coins","-clearcoins <mcname> -setcoins <mcname> -removecoins <mcname> -coins <mcname>",false);
        f.addField("Umfragen","-poll <umfrage> -close",false);
        f.addField("Chat","-clear <2/100>",false);
        e.getTextChannel().sendMessage(f.build()).queue();
    }

    public void dontTeam(MessageReceivedEvent e){
     EmbedBuilder f = new EmbedBuilder();
     f.setColor(Color.green);
     f.addField("Coins","-coins",false);
     f.addField("Verify","-verify <code> (nur in #verify)",false);
     f.addField("Umfragen","-answer <ja/nein>",false);
     f.addField("Musik","-m p <titel/link> -m stop",false);
     f.addField("McName","-mcname <@DiscordUser>",false);
     e.getTextChannel().sendMessage(f.build()).queue();
    }
}
package commands;

import core.PermsCore;
import net.dv8tion.jda.core.entities.Member;
import net.dv8tion.jda.core.entities.Role;
import net.dv8tion.jda.core.events.message.MessageReceivedEvent;

import java.util.concurrent.TimeUnit;

public class CMD_mute implements Command {
    @Override
    public boolean called(String[] args, MessageReceivedEvent e) {
        return false;
    }

    @Override
    public void action(String[] args, MessageReceivedEvent e) {
        if (PermsCore.check(e)){

        }else{
            Role role = e.getGuild().getRolesByName("Muted",true).get(0);
            Member target = e.getMessage().getMentionedMembers().get(0);
            if (target.getRoles().get(0).getName().equalsIgnoreCase("Team")){
                e.getTextChannel().sendMessage("Du kannst keine Teammitglieder muten!").complete().delete().queueAfter(3,TimeUnit.SECONDS);
            }
            e.getGuild().getController().addRolesToMember(target,role).queue();
            e.getTextChannel().sendMessage(target.getEffectiveName() + " wurde gemutet!").complete().delete().queueAfter(3,TimeUnit.SECONDS);
        }
    }

    @Override
    public void executed(boolean succes, MessageReceivedEvent e) {

    }

    @Override
    public String help() {
        return null;
    }
}
package commands;

import core.Main;
import core.PermsCore;
import net.dv8tion.jda.core.EmbedBuilder;
import net.dv8tion.jda.core.events.message.MessageReceivedEvent;

import java.awt.*;

public class CMD_poll implements Command {

    String t = "~poll";

    EmbedBuilder d = new EmbedBuilder().setColor(Color.CYAN);

    @Override
    public boolean called(String[] args, MessageReceivedEvent e) {
        return false;
    }

    @Override
    public void action(String[] args, MessageReceivedEvent e) {

        if(PermsCore.check(e)) {



        }else{

            if (args.length < 1) {


                e.getMessage().getTextChannel().sendMessage(d.setDescription(Main.fehler).build()).queue();

            }else{
                e.getMessage().getGuild().getTextChannelsByName("umfragen", true).get(0).sendMessage(d.setDescription(
                        "Eine neue Umfrage " + e.getMessage().getContentDisplay().replace(t, ":")).build()).queue();

            }
        }
    }

    @Override
    public void executed(boolean succes, MessageReceivedEvent e) {

    }

    @Override
    public String help() {
        return null;
    }
}
package commands;

import Coins.Api;
import ban.API;
import core.CoinPermsCore;
import core.Main;
import net.dv8tion.jda.core.EmbedBuilder;
import net.dv8tion.jda.core.events.message.MessageReceivedEvent;

import java.awt.*;
import java.util.concurrent.TimeUnit;

public class CMD_reconnect implements Command {
    @Override
    public boolean called(String[] args, MessageReceivedEvent e) {
        return false;
    }

    @Override
    public void action(String[] args, MessageReceivedEvent e) {
        if (CoinPermsCore.check(e)){

        }else{
            if (args.length == 0){
                try {
                    Connect();
                    disConnect();
                    e.getTextChannel().sendMessage(new EmbedBuilder().setColor(Color.green).addField("Erfolg","Ich habe die MySQL verbindungen erneuert!",false).build()).complete().delete().queueAfter(5,TimeUnit.SECONDS);
                }catch (Exception o){
                    e.getTextChannel().sendMessage(new EmbedBuilder().setColor(Color.red).setDescription("Fehler").build()).complete().delete().queueAfter(3,TimeUnit.SECONDS);
                    o.printStackTrace();
                }
            }else{
                Main.sendMessageToLowArgs(e,"-reconnect");
            }
        }
    }

    @Override
    public void executed(boolean succes, MessageReceivedEvent e) {

    }

    @Override
    public String help() {
        return null;
    }

    private void Connect(){
        API.connect();
        Coins.MySQL.connect();
        Verify.MySQL.connect();
    }

    private void disConnect(){
        if (API.isConnected()) {
            API.close();
        }
        if (Verify.MySQL.isConnected()) {
            Verify.MySQL.disConnect();
        }
        if (Coins.MySQL.isConnected()) {
            Coins.MySQL.disconnect();
        }
    }

}
package commands;

import core.PermsCore;
import net.dv8tion.jda.core.entities.Guild;
import net.dv8tion.jda.core.events.message.MessageReceivedEvent;

public class CMD_teammeeting implements Command {
    @Override
    public boolean called(String[] args, MessageReceivedEvent e) {
        return false;
    }

    @Override
    public void action(String[] args, MessageReceivedEvent e) {
        if (PermsCore.check(e)){

        }else{
            if (args.length == 0){
            }
        }
    }

    @Override
    public void executed(boolean succes, MessageReceivedEvent e) {

    }

    @Override
    public String help() {
        return null;
    }
}
package commands;

import net.dv8tion.jda.core.events.message.MessageReceivedEvent;

public interface Command {

    boolean called (String[] args, MessageReceivedEvent e);
    void action (String[] args, MessageReceivedEvent e);
    void executed(boolean succes, MessageReceivedEvent e);
    String help();
}
package core;

import net.dv8tion.jda.core.entities.Role;
import net.dv8tion.jda.core.events.message.MessageReceivedEvent;
import utils.STATIC;

import java.util.Arrays;

public class CoinPermsCore {

    public static boolean check(MessageReceivedEvent e) {
        for (Role r : e.getGuild().getMember(e.getAuthor()).getRoles()) {
            if (Arrays.stream(STATIC.CoinPerms).parallel().anyMatch(r.getName()::contains))
                return false;

        }
        return true;
    }
}
package core;

import commands.Command;

import java.util.HashMap;

public class commandHandler {

    public static final commandParser parser = new commandParser();
    public static HashMap<String, Command> commands = new HashMap<>();

    public static void handleCommand(commandParser.commandContainer cmd) {

        if (commands.containsKey(cmd.invoke)) {

            boolean safe = commands.get(cmd.invoke).called(cmd.args, cmd.event);

            if (!safe) {
                commands.get(cmd.invoke).action(cmd.args, cmd.event);
                commands.get(cmd.invoke).executed(safe, cmd.event);
            } else {
                commands.get(cmd.invoke).executed(safe, cmd.event);
            }

        }

    }

}
package core;

import net.dv8tion.jda.core.events.message.MessageReceivedEvent;

import java.util.ArrayList;

public class commandParser {

    public commandContainer parse(String raw, MessageReceivedEvent event) {

        String beheaded = raw.replaceFirst("\\-", "");
        String[] splitBeheaded = beheaded.split(" ");
        String invoke = splitBeheaded[0];
        ArrayList<String> split = new ArrayList<>();
        for (String s : splitBeheaded) {
            split.add(s);
        }
        String[] args = new String[split.size() - 1];
        split.subList(1, split.size()).toArray(args);

        return new commandContainer(raw, beheaded, splitBeheaded, invoke, args, event);
    }


    public class commandContainer {

        public final String raw;
        public final String beheaded;
        public final String[] splitBeheaded;
        public final String invoke;
        public final String[] args;
        public final MessageReceivedEvent event;

        public commandContainer(String rw, String beheaded, String[] splitBeheaded, String invoke, String[] args, MessageReceivedEvent event) {
            this.raw = rw;
            this.beheaded = beheaded;
            this.splitBeheaded = splitBeheaded;
            this.invoke = invoke;
            this.args = args;
            this.event = event;
        }

    }

}
package core;

import Coins.*;
import Verify.CMD_mcname;
import Verify.CMD_verify;
import ban.CMD_clearip;
import ban.CMD_unban;
import commands.*;
import listeners.*;
import net.dv8tion.jda.core.*;
import net.dv8tion.jda.core.entities.Game;
import net.dv8tion.jda.core.events.message.MessageReceivedEvent;
import pollPackage.Umfragen;
import utils.SECRETS;

import javax.security.auth.login.LoginException;
import java.awt.*;
import java.util.ArrayList;

public class Main {

    public static String prefix = "Coins";
    public static ArrayList<Umfragen> yes = new ArrayList<>();
    public static ArrayList<Umfragen> no = new ArrayList<>();

    public static String info = "[INFO] ";

    public static String fehler = "Zu wenig Argumente :warning:";

    public static EmbedBuilder cyan = new EmbedBuilder().setColor(Color.CYAN);

    public static JDABuilder builder;
    public static void main(String[] Args){
        onEnable();
    }

    public static void addCommands(){

        commandHandler.commands.put("clear", new CMD_clear());
        commandHandler.commands.put("poll", new CMD_poll());
        commandHandler.commands.put("answer", new CMD_answer());
        commandHandler.commands.put("help",new CMD_help());
        commandHandler.commands.put("m",new Music());
        commandHandler.commands.put("musik",new Music());
        commandHandler.commands.put("setcoins",new CMD_SetCoins());
        commandHandler.commands.put("coins",new CMD_coins());
        commandHandler.commands.put("clearcoins",new CMD_clearcoins());
        commandHandler.commands.put("removecoins",new CMD_removeCoins());
        commandHandler.commands.put("getuuid",new CMD_getUUID());
        commandHandler.commands.put("verify",new CMD_verify());
        commandHandler.commands.put("mcname",new CMD_mcname());
        commandHandler.commands.put("mute",new CMD_mute());
        commandHandler.commands.put("reconnect",new CMD_reconnect());
        commandHandler.commands.put("unban",new CMD_unban());
        commandHandler.commands.put("clearip",new CMD_clearip());

    }
    public static void sendMessageToLowArgs(MessageReceivedEvent e, String anwendung){
        EmbedBuilder f = new EmbedBuilder();
        f.setColor(Color.red);
        f.addField("Verwende",anwendung,false);
        e.getTextChannel().sendMessage(f.build()).queue();
    }
    public static void isNotExisting(MessageReceivedEvent e,String[] args){
        EmbedBuilder f = new EmbedBuilder();
        f.setColor(Color.red);
        f.addField("Fehler",args[0]+" existiert nicht in der Datenbank!",false);
        e.getTextChannel().sendMessage(f.build()).queue();
    }

    private static void onEnable(){
        JDABuilder builder = new JDABuilder(AccountType.BOT);
        Verify.MySQL mySQL = new Verify.MySQL();
        ban.API.connect();
        builder.setToken(SECRETS.token);
        builder.setAutoReconnect(true);
        MySQL.connect();
        mySQL.connect();
        builder.addEventListener(new commandListener());
        builder.addEventListener(new readyListener());
        builder.addEventListener(new werbungListener());
        builder.addEventListener(new RankUpdateListener());
        builder.addEventListener(new mutedListener());

        builder.setStatus(OnlineStatus.ONLINE);

        addCommands();

        builder.setGame(Game.playing("auf SkyZeit.de"));

        try {
            JDA jda = builder.buildBlocking();
        }catch (LoginException e){
            e.printStackTrace();
        }catch (InterruptedException e){
            e.printStackTrace();
        }
    }

}
package core;

import net.dv8tion.jda.core.entities.Role;
import net.dv8tion.jda.core.events.message.MessageReceivedEvent;
import utils.STATIC;

import java.util.Arrays;

public class PermsCore {

    public static boolean check(MessageReceivedEvent e) {
        for (Role r : e.getGuild().getMember(e.getAuthor()).getRoles()) {
            if (Arrays.stream(STATIC.perms).parallel().anyMatch(r.getName()::contains))
                return false;

        }
        return true;
    }

}

package listeners;

import core.commandHandler;
import net.dv8tion.jda.core.events.message.MessageReceivedEvent;
import net.dv8tion.jda.core.hooks.ListenerAdapter;
import utils.STATIC;

public class commandListener extends ListenerAdapter {

    @Override
    public void onMessageReceived(MessageReceivedEvent event) {

        if (event.getMessage().getContentDisplay().startsWith(STATIC.prefix) && event.getMessage().getAuthor().getId() != event.getJDA().getSelfUser().getId()) {
            commandHandler.handleCommand(commandHandler.parser.parse(event.getMessage().getContentDisplay(), event));
        }

    }

}

package listeners;

import net.dv8tion.jda.core.EmbedBuilder;
import net.dv8tion.jda.core.events.guild.member.GuildMemberJoinEvent;
import net.dv8tion.jda.core.hooks.ListenerAdapter;

import java.awt.*;

public class joinListener extends ListenerAdapter {

    public void onJoin(GuildMemberJoinEvent e){

    }

    public void sendMSG(GuildMemberJoinEvent e){
        EmbedBuilder f = new EmbedBuilder();
        f.setColor(Color.green);
        f.addField("Willkommen","@"+e.getMember().getEffectiveName() + " hat den "+e.getGuild().getName() + " Server betreten!",false);
    }

}

package listeners;

import net.dv8tion.jda.core.events.message.MessageReceivedEvent;
import net.dv8tion.jda.core.hooks.ListenerAdapter;

public class mutedListener extends ListenerAdapter {

    public void onMessageReceived(MessageReceivedEvent e){
        if (e.getMember().getRoles().get(0).getName().equalsIgnoreCase("Muted")){
            e.getMessage().delete().queue();
        }
    }

}

package listeners;

import Verify.MySQL;
import Verify.littlespi;
import net.dv8tion.jda.core.EmbedBuilder;
import net.dv8tion.jda.core.entities.Member;
import net.dv8tion.jda.core.entities.Role;
import net.dv8tion.jda.core.events.message.MessageReceivedEvent;
import net.dv8tion.jda.core.hooks.ListenerAdapter;
import net.dv8tion.jda.core.requests.Route;

import java.awt.*;
import java.util.Collection;
import java.util.List;

@SuppressWarnings("all")
public class RankUpdateListener extends ListenerAdapter {

    String admin = "Administrator";

    public void onMessageReceived(MessageReceivedEvent e) {
        Member p = e.getMember();

        if (!MySQL.isRegistered(p.getUser().getId())){
            Route.Roles roles = (Route.Roles) p.getRoles();
            e.getGuild().getController().removeRolesFromMember(e.getMember(), (Collection<Role>) roles);
            return;
        }

        if (p.getRoles().get(0).getName().equalsIgnoreCase("Administrator")) {
            if (littlespi.getRank2(e.getMember().getUser().getId()).equalsIgnoreCase("Admin")) {

            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Dev")) {
                Role role = e.getGuild().getRolesByName("Sr.Developer", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Dev")) {
                Role role = e.getGuild().getRolesByName("Developer", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Mod")) {
                Role role = e.getGuild().getRolesByName("Sr.Moderator", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Mod")) {
                Role role = e.getGuild().getRolesByName("Moderator", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Sup")) {
                Role role = e.getGuild().getRolesByName("Sr.Supporter", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sup")) {
                Role role = e.getGuild().getRolesByName("Supporter", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Builder")) {
                Role role = e.getGuild().getRolesByName("Sr.Builder", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Builder")) {
                Role role = e.getGuild().getRolesByName("Builder", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Premium")) {
                Role role = e.getGuild().getRolesByName("Premium", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role saas = e.getGuild().getRolesByName(admin,true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),saas).queue();
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().removeSingleRoleFromMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Spieler")) {
                Role role = e.getGuild().getRolesByName("Spieler", true).get(0);
                Role saas = e.getGuild().getRolesByName(admin,true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),saas).queue();
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().removeSingleRoleFromMember(e.getMember(),team).queue();
            }
        }else if (p.getRoles().get(0).getName().equalsIgnoreCase("Sr.Developer")){
            if (littlespi.getRank2(e.getMember().getUser().getId()).equalsIgnoreCase("Sr.Dev")) {

            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Admin")) {
                Role role = e.getGuild().getRolesByName("Administrator", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Dev")) {
                Role role = e.getGuild().getRolesByName("Developer", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Mod")) {
                Role role = e.getGuild().getRolesByName("Sr.Moderator", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Mod")) {
                Role role = e.getGuild().getRolesByName("Moderator", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Sup")) {
                Role role = e.getGuild().getRolesByName("Sr.Supporter", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sup")) {
                Role role = e.getGuild().getRolesByName("Supporter", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Builder")) {
                Role role = e.getGuild().getRolesByName("Sr.Builder", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Builder")) {
                Role role = e.getGuild().getRolesByName("Builder", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Premium")) {
                Role role = e.getGuild().getRolesByName("Premium", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                Role saas = e.getGuild().getRolesByName("Sr.Developer",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),saas).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().removeSingleRoleFromMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Spieler")) {
                Role role = e.getGuild().getRolesByName("Spieler", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role saas = e.getGuild().getRolesByName("Sr.Developer",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),saas).queue();
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().removeSingleRoleFromMember(e.getMember(),team).queue();
            }
        }else if (p.getRoles().get(0).getName().equalsIgnoreCase("Developer")){
            if (littlespi.getRank2(e.getMember().getUser().getId()).equalsIgnoreCase("Dev")) {

            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Admin")) {
                Role role = e.getGuild().getRolesByName("Administrator", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Dev")) {
                Role role = e.getGuild().getRolesByName("Sr.Developer", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Mod")) {
                Role role = e.getGuild().getRolesByName("Sr.Moderator", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Mod")) {
                Role role = e.getGuild().getRolesByName("Moderator", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Sup")) {
                Role role = e.getGuild().getRolesByName("Sr.Supporter", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sup")) {
                Role role = e.getGuild().getRolesByName("Supporter", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Builder")) {
                Role role = e.getGuild().getRolesByName("Sr.Builder", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Builder")) {
                Role role = e.getGuild().getRolesByName("Builder", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Premium")) {
                Role role = e.getGuild().getRolesByName("Premium", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().removeSingleRoleFromMember(e.getMember(),team).queue();
                Role saas = e.getGuild().getRolesByName("Developer",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),saas).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Spieler")) {
                Role role = e.getGuild().getRolesByName("Spieler", true).get(0);
                Role saas = e.getGuild().getRolesByName("Developer",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),saas).queue();
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().removeSingleRoleFromMember(e.getMember(),team).queue();
            }
        }else if (p.getRoles().get(0).getName().equalsIgnoreCase("Sr.Moderator")){
            if (littlespi.getRank2(e.getMember().getUser().getId()).equalsIgnoreCase("Sr.Mod")) {

            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Admin")) {
                Role role = e.getGuild().getRolesByName("Administrator", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Dev")) {
                Role role = e.getGuild().getRolesByName("Sr.Developer", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Dev")) {
                Role role = e.getGuild().getRolesByName("Developer", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Mod")) {
                Role role = e.getGuild().getRolesByName("Moderator", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Sup")) {
                Role role = e.getGuild().getRolesByName("Sr.Supporter", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sup")) {
                Role role = e.getGuild().getRolesByName("Supporter", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Builder")) {
                Role role = e.getGuild().getRolesByName("Sr.Builder", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Builder")) {
                Role role = e.getGuild().getRolesByName("Builder", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Premium")) {
                Role role = e.getGuild().getRolesByName("Premium", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role saas = e.getGuild().getRolesByName("Sr.Moderator",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),saas).queue();
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().removeSingleRoleFromMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Spieler")) {
                Role role = e.getGuild().getRolesByName("Spieler", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role saas = e.getGuild().getRolesByName("Sr.Moderator",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),saas).queue();
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().removeSingleRoleFromMember(e.getMember(),team).queue();
            }
        }else if (p.getRoles().get(0).getName().equalsIgnoreCase("Moderator")){
            if (littlespi.getRank2(e.getMember().getUser().getId()).equalsIgnoreCase("Mod")) {

            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Admin")) {
                Role role = e.getGuild().getRolesByName("Administrator", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Dev")) {
                Role role = e.getGuild().getRolesByName("Sr.Developer", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Dev")) {
                Role role = e.getGuild().getRolesByName("Sr.Moderator", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Mod")) {
                Role role = e.getGuild().getRolesByName("Sr.Moderator", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Sup")) {
                Role role = e.getGuild().getRolesByName("Sr.Supporter", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sup")) {
                Role role = e.getGuild().getRolesByName("Supporter", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Builder")) {
                Role role = e.getGuild().getRolesByName("Sr.Builder", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Builder")) {
                Role role = e.getGuild().getRolesByName("Builder", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Premium")) {
                Role role = e.getGuild().getRolesByName("Premium", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role saas = e.getGuild().getRolesByName("Moderator",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),saas).queue();
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().removeSingleRoleFromMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Spieler")) {
                Role role = e.getGuild().getRolesByName("Spieler", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role saas = e.getGuild().getRolesByName("Moderator",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),saas).queue();
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().removeSingleRoleFromMember(e.getMember(),team).queue();
            }
        }else if (p.getRoles().get(0).getName().equalsIgnoreCase("Sr.Supporter")){
            if (littlespi.getRank2(e.getMember().getUser().getId()).equalsIgnoreCase("Sr.Sup")) {

            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Admin")) {
                Role role = e.getGuild().getRolesByName(admin, true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Dev")) {
                Role role = e.getGuild().getRolesByName("Sr.Developer", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Dev")) {
                Role role = e.getGuild().getRolesByName("Developer", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Mod")) {
                Role role = e.getGuild().getRolesByName("Sr.Moderator", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Mod")) {
                Role role = e.getGuild().getRolesByName("Moderator", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sup")) {
                Role role = e.getGuild().getRolesByName("Supporter", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Builder")) {
                Role role = e.getGuild().getRolesByName("Sr.Builder", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Builder")) {
                Role role = e.getGuild().getRolesByName("Builder", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Premium")) {
                Role role = e.getGuild().getRolesByName("Premium", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role saas = e.getGuild().getRolesByName("Sr.Supporter",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),saas).queue();
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().removeSingleRoleFromMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Spieler")) {
                Role role = e.getGuild().getRolesByName("Spieler", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role saas = e.getGuild().getRolesByName("Sr.Supporter",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),saas).queue();
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().removeSingleRoleFromMember(e.getMember(),team).queue();
            }
        }else if (p.getRoles().get(0).getName().equalsIgnoreCase("Supporter")){
            if (littlespi.getRank2(e.getMember().getUser().getId()).equalsIgnoreCase("Sup")) {

            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Admin")) {
                Role role = e.getGuild().getRolesByName(admin, true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Dev")) {
                Role role = e.getGuild().getRolesByName("Sr.Developer", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Dev")) {
                Role role = e.getGuild().getRolesByName("Developer", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Mod")) {
                Role role = e.getGuild().getRolesByName("Sr.Moderator", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Mod")) {
                Role role = e.getGuild().getRolesByName("Moderator", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Sup")) {
                Role role = e.getGuild().getRolesByName("Sr.Supporter", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Builder")) {
                Role role = e.getGuild().getRolesByName("Sr.Builder", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Builder")) {
                Role role = e.getGuild().getRolesByName("Builder", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Premium")) {
                Role role = e.getGuild().getRolesByName("Premium", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role saas = e.getGuild().getRolesByName("Supporter",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),saas).queue();
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().removeSingleRoleFromMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Spieler")) {
                Role role = e.getGuild().getRolesByName("Spieler", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role saas = e.getGuild().getRolesByName("Supporter",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),saas).queue();
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().removeSingleRoleFromMember(e.getMember(),team).queue();
            }
        }else if (p.getRoles().get(0).getName().equalsIgnoreCase("Sr.Builder")){
            if (littlespi.getRank2(e.getMember().getUser().getId()).equalsIgnoreCase("Sr.Builder")) {

            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Admin")) {
                Role role = e.getGuild().getRolesByName(admin, true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Dev")) {
                Role role = e.getGuild().getRolesByName("Sr.Developer", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Dev")) {
                Role role = e.getGuild().getRolesByName("Developer", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Mod")) {
                Role role = e.getGuild().getRolesByName("Sr.Moderator", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Mod")) {
                Role role = e.getGuild().getRolesByName("Moderator", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Sup")) {
                Role role = e.getGuild().getRolesByName("Sr.Supporter", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sup")) {
                Role role = e.getGuild().getRolesByName("Supporter", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Builder")) {
                Role role = e.getGuild().getRolesByName("Builder", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Premium")) {
                Role role = e.getGuild().getRolesByName("Premium", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role saas = e.getGuild().getRolesByName("Sr.Builder",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),saas).queue();
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().removeSingleRoleFromMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Spieler")) {
                Role role = e.getGuild().getRolesByName("Spieler", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role saas = e.getGuild().getRolesByName("Sr.Builder",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),saas).queue();
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().removeSingleRoleFromMember(e.getMember(),team).queue();
            }
        }else if (p.getRoles().get(0).getName().equalsIgnoreCase("Builder")){
            if (littlespi.getRank2(e.getMember().getUser().getId()).equalsIgnoreCase("Builder")) {

            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Admin")) {
                Role role = e.getGuild().getRolesByName(admin, true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Dev")) {
                Role role = e.getGuild().getRolesByName("Sr.Developer", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Dev")) {
                Role role = e.getGuild().getRolesByName("Developer", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Mod")) {
                Role role = e.getGuild().getRolesByName("Sr.Moderator", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Mod")) {
                Role role = e.getGuild().getRolesByName("Moderator", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Sup")) {
                Role role = e.getGuild().getRolesByName("Sr.Supporter", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sup")) {
                Role role = e.getGuild().getRolesByName("Supporter", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Builder")) {
                Role role = e.getGuild().getRolesByName("Sr.Builder", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Premium")) {
                Role role = e.getGuild().getRolesByName("Premium", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role saas = e.getGuild().getRolesByName("Builder",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),saas).queue();
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().removeSingleRoleFromMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Spieler")) {
                Role role = e.getGuild().getRolesByName("Spieler", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role saas = e.getGuild().getRolesByName("Builder",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),saas).queue();
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().removeSingleRoleFromMember(e.getMember(),team).queue();
            }
        }else if (p.getRoles().get(0).getName().equalsIgnoreCase("Premium")){
            if (littlespi.getRank2(e.getMember().getUser().getId()).equalsIgnoreCase("Premium")) {

            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Admin")) {
                Role role = e.getGuild().getRolesByName(admin, true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role premi = e.getGuild().getRolesByName("Premium",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),premi).queue();
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Dev")) {
                Role role = e.getGuild().getRolesByName("Sr.Developer", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role premi = e.getGuild().getRolesByName("Premium",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),premi).queue();
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Dev")) {
                Role role = e.getGuild().getRolesByName("Developer", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role premi = e.getGuild().getRolesByName("Premium",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),premi).queue();
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Mod")) {
                Role role = e.getGuild().getRolesByName("Sr.Moderator", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role premi = e.getGuild().getRolesByName("Premium",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),premi).queue();
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Mod")) {
                Role role = e.getGuild().getRolesByName("Moderator", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role premi = e.getGuild().getRolesByName("Premium",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),premi).queue();
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Sup")) {
                Role role = e.getGuild().getRolesByName("Sr.Supporter", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role premi = e.getGuild().getRolesByName("Premium",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),premi).queue();
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sup")) {
                Role role = e.getGuild().getRolesByName("Supporter", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role premi = e.getGuild().getRolesByName("Premium",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),premi).queue();
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Builder")) {
                Role role = e.getGuild().getRolesByName("Sr.Builder", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role premi = e.getGuild().getRolesByName("Premium",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),premi).queue();
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Builder")) {
                Role role = e.getGuild().getRolesByName("Builder", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role premi = e.getGuild().getRolesByName("Premium",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),premi).queue();
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Spieler")) {
                Role role = e.getGuild().getRolesByName("Spieler", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role premi = e.getGuild().getRolesByName("Premium",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),premi).queue();
            }
        }else if (p.getRoles().get(0).getName().equalsIgnoreCase("Spieler")){
            if (littlespi.getRank2(e.getMember().getUser().getId()).equalsIgnoreCase("Spieler")) {

            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Admin")) {
                Role role = e.getGuild().getRolesByName(admin, true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role spieler = e.getGuild().getRolesByName("Spieler",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),spieler).queue();
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Dev")) {
                Role role = e.getGuild().getRolesByName("Sr.Developer", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role spieler = e.getGuild().getRolesByName("Spieler",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),spieler).queue();
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Dev")) {
                Role role = e.getGuild().getRolesByName("Developer", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role spieler = e.getGuild().getRolesByName("Spieler",true).get(0);
                e.getGuild().getController().removeSingleRoleFromMember(e.getMember(),spieler).queue();
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Mod")) {
                Role role = e.getGuild().getRolesByName("Sr.Moderator", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role spieler = e.getGuild().getRolesByName("Spieler",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),spieler).queue();
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Mod")) {
                Role role = e.getGuild().getRolesByName("Moderator", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role spieler = e.getGuild().getRolesByName("Spieler",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),spieler).queue();
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Sup")) {
                Role role = e.getGuild().getRolesByName("Sr.Supporter", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role spieler = e.getGuild().getRolesByName("Spieler",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),spieler).queue();
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sup")) {
                Role role = e.getGuild().getRolesByName("Supporter", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Sr.Builder")) {
                Role role = e.getGuild().getRolesByName("Sr.Builder", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role spieler = e.getGuild().getRolesByName("Spieler",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),spieler).queue();
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Builder")) {
                Role role = e.getGuild().getRolesByName("Builder", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role spieler = e.getGuild().getRolesByName("Spieler",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),spieler).queue();
                Role team = e.getGuild().getRolesByName("Team",true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
            } else if (littlespi.getRank2(p.getUser().getId()).equalsIgnoreCase("Premium")) {
                Role role = e.getGuild().getRolesByName("Premium", true).get(0);
                e.getGuild().getController().addRolesToMember(e.getMember(), role).queue();
                rankUpdate(e);
                Role spieler = e.getGuild().getRolesByName("Spieler",true).get(0);
                e.getGuild().getController().removeRolesFromMember(e.getMember(),spieler).queue();
            }
        }
    }

    public void rankUpdate(MessageReceivedEvent e){
        EmbedBuilder f = new EmbedBuilder();
        f.setColor(Color.green);
        f.addField("Rang-Update",e.getAuthor().getName()+ " du hast ein Rang Update erhalten!",false);
        e.getTextChannel().sendMessage(f.build()).queue();
    }

}
package listeners;

import net.dv8tion.jda.core.entities.Guild;
import net.dv8tion.jda.core.events.ReadyEvent;
import net.dv8tion.jda.core.hooks.ListenerAdapter;

public class readyListener extends ListenerAdapter {

    public void onReady(ReadyEvent event){

        String out = "\nDieser Bot läuft auf folgenden Servern\n";

        for ( Guild g : event.getJDA().getGuilds() ){
            out = g.getName() + " (" + g.getId() + ") \n";
        }
        System.out.println(out);




        }
    }
}
package listeners;

import net.dv8tion.jda.core.EmbedBuilder;
import net.dv8tion.jda.core.events.message.MessageReceivedEvent;
import net.dv8tion.jda.core.hooks.ListenerAdapter;

import java.awt.*;
import java.util.concurrent.TimeUnit;

public class werbungListener extends ListenerAdapter {

    EmbedBuilder f = new EmbedBuilder().setColor(Color.red);

    //".de",".net",".eu",".us",".fr",".ch",".ru"

    @Override
    public void onMessageReceived(MessageReceivedEvent event) {

        if (event.getGuild().getRoles().contains("team")) {

        } else {

            if (event.getTextChannel().getName().equalsIgnoreCase("team")) return;
            if (event.getMember().getRoles().get(0).getName().equalsIgnoreCase("Developer"))return;
            if (event.getMember().getRoles().get(0).getName().equalsIgnoreCase("Administrator"))return;
            if (event.getMember().getRoles().get(0).getName().equalsIgnoreCase("Leitung"))return;
            if (event.getMember().getRoles().get(0).getName().equalsIgnoreCase("Builder"))return;
            if (event.getMember().getRoles().get(0).getName().equalsIgnoreCase("Supporter"))return;
            if (event.getMember().getRoles().get(0).getName().equalsIgnoreCase("test-builder"))return;
            if (event.getMember().getRoles().get(0).getName().equalsIgnoreCase("Test-Supporter"))return;
            if (event.getMember().getRoles().get(0).getName().equalsIgnoreCase("Sr.Moderator"))return;
            if (event.getMember().getRoles().get(0).getName().equalsIgnoreCase("Moderator"))return;

            if (event.getMessage().getContentRaw().toLowerCase().contains(".de")) {
                event.getMessage().delete().queue();
                event.getTextChannel().sendMessage(f.setDescription("Werbung ist böse :c").build()).complete().delete().queueAfter(5,TimeUnit.SECONDS);
                event.getGuild().getTextChannelsByName("bot-log", true).get(0).sendMessage(f.setDescription(event.getMember().getUser().getName() + " machte Werbung in der Nachricht : " + event.getMessage().getContentDisplay()).build()).queue();
            } else if (event.getMessage().getContentRaw().toLowerCase().contains(".net")) {
                event.getMessage().delete().queue();
                event.getGuild().getTextChannelsByName("bot-log", true).get(0).sendMessage(f.setDescription(event.getMember().getUser().getName() + " machte Werbung in der Nachricht : " + event.getMessage().getContentDisplay()).build()).queue();
                event.getTextChannel().sendMessage(f.setDescription("Werbung ist böse :c").build()).complete().delete().queueAfter(5,TimeUnit.SECONDS);
            } else if (event.getMessage().getContentRaw().toLowerCase().contains(".eu")) {
                event.getMessage().delete().queue();
                event.getTextChannel().sendMessage(f.setDescription("Werbung ist böse :c").build()).complete().delete().queueAfter(5,TimeUnit.SECONDS);
                event.getGuild().getTextChannelsByName("bot-log", true).get(0).sendMessage(f.setDescription(event.getMember().getUser().getName() + " machte Werbung in der Nachricht : " + event.getMessage().getContentDisplay()).build()).queue();
            } else if (event.getMessage().getContentRaw().toLowerCase().contains(".us")) {
                event.getMessage().delete().queue();
                event.getTextChannel().sendMessage(f.setDescription("Werbung ist böse :c").build()).complete().delete().queueAfter(5,TimeUnit.SECONDS);
                event.getGuild().getTextChannelsByName("bot-log", true).get(0).sendMessage(f.setDescription(event.getMember().getUser().getName() + " machte Werbung in der Nachricht : " + event.getMessage().getContentDisplay()).build()).queue();
            } else if (event.getMessage().getContentRaw().toLowerCase().contains(".fr")) {
                event.getMessage().delete().queue();
                event.getTextChannel().sendMessage(f.setDescription("Werbung ist böse :c").build()).complete().delete().queueAfter(5,TimeUnit.SECONDS);
                event.getGuild().getTextChannelsByName("bot-log", true).get(0).sendMessage(f.setDescription(event.getMember().getUser().getName() + " machte Werbung in der Nachricht : " + event.getMessage().getContentDisplay()).build()).queue();
            } else if (event.getMessage().getContentRaw().toLowerCase().contains(".ch")) {
                event.getMessage().delete().queue();
                event.getTextChannel().sendMessage(f.setDescription("Werbung ist böse :c").build()).complete().delete().queueAfter(5,TimeUnit.SECONDS);
                event.getGuild().getTextChannelsByName("bot-log", true).get(0).sendMessage(f.setDescription(event.getMember().getUser().getName() + " machte Werbung in der Nachricht : " + event.getMessage().getContentDisplay()).build()).queue();
            } else if (event.getMessage().getContentRaw().toLowerCase().contains(".ru")) {
                event.getMessage().delete().queue();
                event.getTextChannel().sendMessage(f.setDescription("Werbung ist böse :c").build()).complete().delete().queueAfter(5,TimeUnit.SECONDS);
                event.getGuild().getTextChannelsByName("bot-log", true).get(0).sendMessage(f.setDescription(event.getMember().getUser().getName() + " machte Werbung in der Nachricht : " + event.getMessage().getContentDisplay()).build()).queue();
            } else if (event.getMessage().getContentRaw().toLowerCase().contains(".com")) {
                event.getMessage().delete().queue();
                event.getTextChannel().sendMessage(f.setDescription("Werbung ist böse :c").build()).complete().delete().queueAfter(5,TimeUnit.SECONDS);
                event.getGuild().getTextChannelsByName("bot-log", true).get(0).sendMessage(f.setDescription(event.getMember().getUser().getName() + " machte Werbung in der Nachricht : " + event.getMessage().getContentDisplay()).build()).queue();
            }
        }
    }
}
package musikcore;

import com.sedmelluq.discord.lavaplayer.track.AudioTrack;
import net.dv8tion.jda.core.entities.Member;

public class AudioInfo {

    private final AudioTrack TRACK;
    private final Member AUTHOR;

    /**
     * Erstellt eine Instanz der Klasse AudioInfo.
     * @param track AudioTrack
     * @param author Member, der den Track eingereiht hat
     */
    public AudioInfo(AudioTrack track, Member author) {
        this.TRACK = track;
        this.AUTHOR = author;
    }

    public AudioTrack getTrack() {
        return TRACK;
    }

    public Member getAuthor() {
        return AUTHOR;
    }

}
package musikcore;

import com.sedmelluq.discord.lavaplayer.player.AudioPlayer;
import com.sedmelluq.discord.lavaplayer.track.playback.AudioFrame;
import net.dv8tion.jda.core.audio.AudioSendHandler;

/**
 * Created by zekro on 18.06.2017 / 11:45
 * supremeBot.audioCore
 * dev.zekro.de - github.zekro.de
 * © zekro 2017
 */

public class PlaySendHandler implements AudioSendHandler {


    private final AudioPlayer audioPlayer;
    private AudioFrame lastFrame;

    public PlaySendHandler(AudioPlayer audioPlayer) {
        this.audioPlayer = audioPlayer;
    }

    @Override
    public boolean canProvide() {
        if (lastFrame == null) {
            lastFrame = audioPlayer.provide();
        }

        return lastFrame != null;
    }

    @Override
    public byte[] provide20MsAudio() {
        if (lastFrame == null) {
            lastFrame = audioPlayer.provide();
        }

        byte[] data = lastFrame != null ? lastFrame.getData() : null;
        lastFrame = null;

        return data;
    }

    @Override
    public boolean isOpus() {
        return true;
    }

}

package musikcore;

import com.sedmelluq.discord.lavaplayer.player.AudioPlayer;
import com.sedmelluq.discord.lavaplayer.player.event.AudioEventAdapter;
import com.sedmelluq.discord.lavaplayer.track.AudioTrack;
import com.sedmelluq.discord.lavaplayer.track.AudioTrackEndReason;
import net.dv8tion.jda.core.entities.Guild;
import net.dv8tion.jda.core.entities.Member;
import net.dv8tion.jda.core.entities.VoiceChannel;

import java.util.*;
import java.util.concurrent.LinkedBlockingQueue;

public class TrackManager extends AudioEventAdapter {

    private final AudioPlayer PLAYER;
    private final Queue<AudioInfo> queue;


    /**
     * Erstellt eine Instanz der Klasse TrackManager.
     * @param player
     */
    public TrackManager(AudioPlayer player) {
        this.PLAYER = player;
        this.queue = new LinkedBlockingQueue<>();
    }

    /**
     * Reiht den übergebenen Track in die Queue ein.
     * @param track AudioTrack
     * @param author Member, der den Track eingereiht hat
     */
    public void queue(AudioTrack track, Member author) {
        AudioInfo info = new AudioInfo(track, author);
        queue.add(info);

        if (PLAYER.getPlayingTrack() == null) {
            PLAYER.playTrack(track);
        }
    }

    /**
     * Returnt die momentane Queue als LinkedHashSet.
     * @return Queue
     */
    public Set<AudioInfo> getQueue() {
        return new LinkedHashSet<>(queue);
    }

    /**
     * Returnt AudioInfo des Tracks aus der Queue.
     * @param track AudioTrack
     * @return AudioInfo
     */
    public AudioInfo getInfo(AudioTrack track) {
        return queue.stream()
                .filter(info -> info.getTrack().equals(track))
                .findFirst().orElse(null);
    }

    /**
     * Leert die gesammte Queue.
     */
    public void purgeQueue() {
        queue.clear();
    }

    /**
     * Shufflet die momentane Queue.
     */
    public void shuffleQueue() {
        List<AudioInfo> cQueue = new ArrayList<>(getQueue());
        AudioInfo current = cQueue.get(0);
        cQueue.remove(0);
        Collections.shuffle(cQueue);
        cQueue.add(0, current);
        purgeQueue();
        queue.addAll(cQueue);
    }

    /**
     * PLAYER EVENT: TRACK STARTET
     * Wenn Einreiher nicht im VoiceChannel ist, wird der Player gestoppt.
     * Sonst connectet der Bot in den Voice Channel des Einreihers.
     * @param player AudioPlayer
     * @param track AudioTrack
     */
    @Override
    public void onTrackStart(AudioPlayer player, AudioTrack track) {
        AudioInfo info = queue.element();
        VoiceChannel vChan = info.getAuthor().getVoiceState().getChannel();

        if (vChan == null)
            player.stopTrack();
        else
            info.getAuthor().getGuild().getAudioManager().openAudioConnection(vChan);
    }

    /**
     * PLAYER EVENT: TRACK ENDE
     * Wenn die Queue zuende ist, verlässt der Bot den Audio Channel.
     * Sonst wird der nächste Track in der Queue wiedergegeben.
     * @param player
     * @param track
     * @param endReason
     */
    @Override
    public void onTrackEnd(AudioPlayer player, AudioTrack track, AudioTrackEndReason endReason) {
        Guild g = queue.poll().getAuthor().getGuild();

        if (queue.isEmpty())
            g.getAudioManager().closeAudioConnection();
        else
            player.playTrack(queue.element().getTrack());
    }

}
package pollPackage;

import commands.Command;
import core.Main;
import net.dv8tion.jda.core.EmbedBuilder;
import net.dv8tion.jda.core.events.message.MessageReceivedEvent;

import java.awt.*;
import java.util.ArrayList;
import java.util.concurrent.TimeUnit;

public class CMD_Answer implements Command {

    public static ArrayList<String> answered = new ArrayList<>();



    EmbedBuilder f = new EmbedBuilder().setColor(Color.BLUE);
    EmbedBuilder r = new EmbedBuilder().setColor(Color.red);

    @Override
    public boolean called(String[] args, MessageReceivedEvent e) {
        return false;
    }

    @Override
    public void action(String[] args, MessageReceivedEvent e) {


        String user = e.getAuthor().getId();

        if (args.length == 1){
            if (e.getMessage().getContentRaw().toLowerCase().contains("ja")){
                if (!answered.contains(user)) {
                    e.getGuild().getTextChannelsByName("umfragen", true).get(0).sendMessage(f.setDescription(e.getMember().getUser().getName() + " antwortete mit " + e.getMessage().getContentDisplay().replace("-answer", ":")).build()).queue();
                    answered.add(user);
                    Umfragen yes = new Umfragen();
                    yes.setYes(true);
                    Main.yes.add(yes);
                    }else{
                    e.getTextChannel().sendMessage(r.setDescription("Du hast bereits geantwortet!").build()).queue();
                    }
                }else if (e.getMessage().getContentRaw().toLowerCase().contains("nein")) {
                if (!answered.contains(user)) {
                    e.getGuild().getTextChannelsByName("umfragen", true).get(0).sendMessage(f.setDescription(e.getMember().getUser().getName() + " antwortete mit " + e.getMessage().getContentDisplay().replace("-answer", ":")).build()).queue();
                    answered.add(user);
                    Umfragen no = new Umfragen();
                    no.setNo(true);
                    Main.no.add(no);
                    }else{
                    e.getTextChannel().sendMessage(r.setDescription("Du hast bereits geantwortet!").build()).complete().delete().queueAfter(10, TimeUnit.SECONDS);
                }
            }else{
                e.getTextChannel().sendMessage(r.setDescription("Antworte mit Ja oder Nein!").build()).queue();
            }
        }else if (args.length >1){
            e.getTextChannel().sendMessage(r.setDescription("Zu viele Argumente :warning:").build()).queue();
        }else if(args.length <1) {
            e.getTextChannel().sendMessage(r.setDescription(Main.fehler).build()).queue();
        }


      /*  if (args.length == 0) {
                e.getTextChannel().sendMessage(r.setDescription(Main.fehler).build()).queue();
            } else if (args.length >1) {
            e.getTextChannel().sendMessage(r.setDescription("Zu viele Argumente :warning:").build()).queue();
            if (!answered.contains(user)) {
                e.getGuild().getTextChannelsByName("umfragen", true).get(0).sendMessage(f.setDescription("Jemand antwortet mit " + e.getMessage().getContentDisplay().replace("-answer", ":")).build()).queue();
                answered.add(user);
            }else{
                e.getTextChannel().sendMessage(r.setDescription("Du hast bereits geantwortet!").build()).queue();
                e.getMessage().delete().queue();
            }
        }*/
    }



    @Override
    public void executed(boolean succes, MessageReceivedEvent e) {
        System.out.println(Main.info + "'-answer' wurde ausgeführt");
    }

    @Override
    public String help() {
        return null;
    }
}



package pollPackage;

import commands.Command;
import core.Main;
import core.PermsCore;
import net.dv8tion.jda.core.EmbedBuilder;
import net.dv8tion.jda.core.entities.Message;
import net.dv8tion.jda.core.events.message.MessageReceivedEvent;

import java.awt.*;
import java.util.Timer;
import java.util.TimerTask;

import static pollPackage.CMD_Answer.answered;

public class CMD_njuashbf implements Command {

    EmbedBuilder f = new EmbedBuilder().setColor(Color.BLUE);

    @Override
    public boolean called(String[] args, MessageReceivedEvent e) {
        return false;
    }

    @Override
    public void action(String[] args, MessageReceivedEvent e) {

        if (PermsCore.check(e)) {

        }else {

            String user = e.getAuthor().getName();

            e.getTextChannel().sendMessage(f.setDescription("Die Umfrage wurde geschlossen").build()).queue();
            answered.removeAll(answered);



            try {
                Message msg = e.getGuild().getTextChannelsByName("umfragen", true).get(0).sendMessage("-clear 100").complete();

                new Timer().schedule(new TimerTask() {
                    @Override
                    public void run() {
                        msg.delete().queue();
                    }
                }, 5000);
            } catch (Exception r) {
                r.printStackTrace();
            }
        }
        int yesCount = 0;
        int noCount = 0;
        for (Umfragen yes : Main.yes){
            if(yes.isYes()){
                yesCount ++;
            }
        }
        for (Umfragen no : Main.no){
            if (no.isNo()){
                noCount ++;
            }
        }
        e.getGuild().getTextChannelsByName("leitung",true).get(0).sendMessage(f.setDescription("Es haben " + yesCount + " für Ja und " + noCount + " für Nein gestimmt").build()).queue();
        Main.yes.removeAll(Main.yes);
        Main.no.removeAll(Main.no);
    }

    @Override
    public void executed(boolean succes, MessageReceivedEvent e) {

    }

    @Override
    public String help() {
        return null;
    }
}


package pollPackage;

import commands.Command;
import core.Main;
import core.PermsCore;
import net.dv8tion.jda.core.EmbedBuilder;
import net.dv8tion.jda.core.events.message.MessageReceivedEvent;

import java.awt.*;

public class CMD_poll implements Command {

    String t = "-poll";

    EmbedBuilder d = new EmbedBuilder().setColor(Color.CYAN);

    @Override
    public boolean called(String[] args, MessageReceivedEvent e) {
        return false;
    }

    @Override
    public void action(String[] args, MessageReceivedEvent e) {

        if(PermsCore.check(e)) {



        }else{

        if (args.length < 1) {


            e.getMessage().getTextChannel().sendMessage(d.setDescription(Main.fehler).build()).queue();

        }else{
            e.getMessage().getGuild().getTextChannelsByName("umfragen", true).get(0).sendMessage(d.setDescription(
                    "Eine neue Umfrage " + e.getMessage().getContentDisplay().replace(t, ":")).build()).queue();

        }
    }
}

    @Override
    public void executed(boolean succes, MessageReceivedEvent e) {

    }

    @Override
    public String help() {
        return null;
    }
}


package pollPackage;

public class Umfragen {

    private boolean yes;
    private boolean no;

    public boolean isYes() {
        return yes;
    }

    public void setYes(boolean yes){
        this.yes = yes;
    }

    public boolean isNo() {
        return no;
    }

    public void setNo(boolean no) {
        this.no = no;
    }
}
package utils;

public class SECRETS {

    public static String token = "NDU4NjkyMjIxMTEwMTkwMDgw.DgrV9Q.3f6735HmQky9zLuHI_lWj6FyqIA";

}
package utils;

public class STATIC {

    public static final String prefix = "-";

    public static final String[] perms = {"Leitung","Administrator","Developer","Moderator","SR.Builder"};

    public static final String[] CoinPerms = {"Leitung","Developer"};
}
package Verify;

import commands.Command;
import core.Main;
import net.dv8tion.jda.core.EmbedBuilder;
import net.dv8tion.jda.core.entities.Member;
import net.dv8tion.jda.core.entities.MessageEmbed;
import net.dv8tion.jda.core.events.message.MessageReceivedEvent;

import java.awt.*;

public class CMD_mcname implements Command {
    @Override
    public boolean called(String[] args, MessageReceivedEvent e) {
        return false;
    }

    @Override
    public void action(String[] args, MessageReceivedEvent e) {

        Member target = e.getMessage().getMentionedMembers().get(0);
        if (target != null) {
            if (!MySQL.isRegistered(target.getUser().getId())) {
                Main.isNotExisting(e, args);
                return;
            }
        }else{
            MessageEmbed.Field f = new MessageEmbed.Field("Null",args[0] + " ist nicht auf dem Discord Server!",false);
            e.getTextChannel().sendMessage(new EmbedBuilder().setColor(Color.red).addField(f).build()).queue();
        }

        if (args.length == 1){
            sendSucces(e,target);

        }else{
            Main.sendMessageToLowArgs(e,"-mcname <user>");
        }
    }

    @Override
    public void executed(boolean succes, MessageReceivedEvent e) {

    }

    @Override
    public String help() {
        return null;
    }

    public void sendSucces(MessageReceivedEvent e,Member member){
        EmbedBuilder f = new EmbedBuilder();
        f.setColor(Color.green);
        f.addField(member.getUser().getName()+" sein Minecraft Name lautet",littlespi.getMCName(member.getUser().getId()),false);
        f.build();
        e.getTextChannel().sendMessage(f.build()).queue();
    }

}
package Verify;

import commands.Command;
import net.dv8tion.jda.core.EmbedBuilder;
import net.dv8tion.jda.core.entities.Member;
import net.dv8tion.jda.core.entities.Role;
import net.dv8tion.jda.core.events.message.MessageReceivedEvent;

import java.awt.*;
import java.util.concurrent.TimeUnit;

public class CMD_verify implements Command {
    @Override
    public boolean called(String[] args, MessageReceivedEvent e) {
        return false;
    }

    @Override
    public void action(String[] args, MessageReceivedEvent e) {
        if (args.length == 0){
            e.getMessage().delete().queue();
        }else if (args.length == 1){
            if (!e.getTextChannel().getName().equalsIgnoreCase("verify")){
                e.getMessage().delete().queue();
            }else{
                if (!args[0].equalsIgnoreCase("Null")) {
                    if (MySQL.isExisting(args[0])) {
                        littlespi api = new littlespi();
                        littlespi.setVerified(args[0], e.getMember());
                        e.getMessage().delete().queue();
                        if (littlespi.getRank(args[0]).equalsIgnoreCase("Admin")){
                            Role role = e.getGuild().getRolesByName("Administrator",true).get(0);
                            Role team = e.getGuild().getRolesByName("Team",true).get(0);
                            e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
                            e.getGuild().getController().addRolesToMember(e.getMember(),role).queue();
                            verifyMSG(e, e.getMember(),"Administrator");
                        }else if (littlespi.getRank(args[0]).equalsIgnoreCase("Sr.Dev")){
                            Role role = e.getGuild().getRolesByName("Sr.Developer",true).get(0);
                            e.getGuild().getController().addRolesToMember(e.getMember(),role).queue();
                            Role team = e.getGuild().getRolesByName("Team",true).get(0);
                            e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
                            verifyMSG(e, e.getMember(),"Sr.Developer");
                        }else if (littlespi.getRank(args[0]).equalsIgnoreCase("Dev")){
                            Role role = e.getGuild().getRolesByName("Developer",true).get(0);
                            Role team = e.getGuild().getRolesByName("Team",true).get(0);
                            e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
                            e.getGuild().getController().addRolesToMember(e.getMember(),role).queue();
                            verifyMSG(e, e.getMember(),"Developer");
                        }else if (littlespi.getRank(args[0]).equalsIgnoreCase("Sr.Mod")){
                            Role role = e.getGuild().getRolesByName("Sr.Moderator",true).get(0);
                            e.getGuild().getController().addRolesToMember(e.getMember(),role).queue();
                            verifyMSG(e, e.getMember(),"Sr.Moderator");
                        }else if (littlespi.getRank(args[0]).equalsIgnoreCase("Mod")){
                            Role role = e.getGuild().getRolesByName("Moderator",true).get(0);
                            Role team = e.getGuild().getRolesByName("Team",true).get(0);
                            e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
                            e.getGuild().getController().addRolesToMember(e.getMember(),role).queue();
                            verifyMSG(e, e.getMember(),"Moderator");
                        }else if (littlespi.getRank(args[0]).equalsIgnoreCase("Sr.Sup")){
                            Role role = e.getGuild().getRolesByName("Sr.Supporter",true).get(0);
                            e.getGuild().getController().addRolesToMember(e.getMember(),role).queue();
                            verifyMSG(e, e.getMember(),"Sr.Supporter");
                        }else if (littlespi.getRank(args[0]).equalsIgnoreCase("Sup")){
                            Role role = e.getGuild().getRolesByName("Supporter",true).get(0);
                            Role team = e.getGuild().getRolesByName("Team",true).get(0);
                            e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
                            e.getGuild().getController().addRolesToMember(e.getMember(),role).queue();
                            verifyMSG(e, e.getMember(),"Supporter");
                        }else if (littlespi.getRank(args[0]).equalsIgnoreCase("Sr.Builder")){
                            Role role = e.getGuild().getRolesByName("Sr.Builder",true).get(0);
                            Role team = e.getGuild().getRolesByName("Team",true).get(0);
                            e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
                            e.getGuild().getController().addRolesToMember(e.getMember(),role).queue();
                            verifyMSG(e, e.getMember(),"Sr.Builder");
                        }else if (littlespi.getRank(args[0]).equalsIgnoreCase("Builder")){
                            Role role = e.getGuild().getRolesByName("Builder",true).get(0);
                            Role team = e.getGuild().getRolesByName("Team",true).get(0);
                            e.getGuild().getController().addRolesToMember(e.getMember(),team).queue();
                            e.getGuild().getController().addRolesToMember(e.getMember(),role).queue();
                            verifyMSG(e, e.getMember(),"Builder");
                        }else if (littlespi.getRank(args[0]).equalsIgnoreCase("Premium")){
                            Role role = e.getGuild().getRolesByName("Premium",true).get(0);
                            e.getGuild().getController().addRolesToMember(e.getMember(),role).queue();
                            verifyMSG(e, e.getMember(),"Premium");
                        }else if (littlespi.getRank(args[0]).equalsIgnoreCase("Spieler")){
                            Role role = e.getGuild().getRolesByName("Spieler",true).get(0);
                            e.getGuild().getController().addRolesToMember(e.getMember(),role).queue();
                            verifyMSG(e, e.getMember(),"Spieler");
                        }
                        littlespi.setCodeNull(e.getMember().getUser().getId());
                    }
                }
            }
        }
    }

    /*if (p.hasPermission("tab.leitung")) {
        CodeAPI.setRank(UUID,"Leitung");
    } else if (p.hasPermission("tab.admin")) {
        CodeAPI.setRank(UUID,"Admin");
    } else if (p.hasPermission("tab.srdev")) {
        CodeAPI.setRank(UUID,"Sr.Dev");
    } else if (p.hasPermission("tab.dev")) {
        CodeAPI.setRank(UUID,"Dev");
    } else if (p.hasPermission("tab.srmod")) {
        CodeAPI.setRank(UUID,"Sr.Mod");
    } else if (p.hasPermission("tab.mod")) {
        CodeAPI.setRank(UUID,"Mod");
    } else if (p.hasPermission("tab.srsup")) {
        CodeAPI.setRank(UUID,"Sr.Sup");
    } else if (p.hasPermission("tab.sup")) {
        CodeAPI.setRank(UUID,"Sup");
    } else if (p.hasPermission("tab.srbuilder")) {
        CodeAPI.setRank(UUID,"Sr.Builder");
    } else if (p.hasPermission("tab.builder")) {
        CodeAPI.setRank(UUID,"Builder");
    } else if (p.hasPermission("tab.premium")) {
        CodeAPI.setRank(UUID,"Premium");
    } else {
        CodeAPI.setRank(UUID,"Spieler");
    }*/

    @Override
    public void executed(boolean succes, MessageReceivedEvent e) {

    }

    @Override
    public String help() {
        return null;
    }

    public void verifyMSG(MessageReceivedEvent e, Member member,String rang){
        EmbedBuilder f = new EmbedBuilder();
        f.setColor(Color.green);
        f.addField("Verify-System",member.getUser().getName() + " hat sich mit dem Minecraft Account : "+littlespi.getMCName(member.getUser().getId())+"  erfolgreich verifiziert!",false);
        f.addField("Rangvergabe",member.getUser().getName() + " hat den "+rang+" Rang erhalten!",false);
        e.getGuild().getTextChannelsByName("chat",true).get(0).sendMessage(f.build()).queue();
    }

}
package Verify;

import net.dv8tion.jda.core.entities.Member;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;

public class littlespi {



    public static int isValid (String verifycode){
        try {
            PreparedStatement statement = MySQL.con.prepareStatement("SELECT Valid FROM verifycodes WHERE Code = ? ");
            statement.setString(1,verifycode);
            ResultSet rs = statement.executeQuery();
            if (rs.next()){
                return rs.getInt("Valid");
            }
        }catch (SQLException e){
            e.printStackTrace();
        }
        return -1;
    }
    public static void unVerify(String DISCORDID){
        try {
            if (isValid(DISCORDID) == 0){
                PreparedStatement statement = MySQL.con.prepareStatement("SELECT UUID FROM verifycodes WHERE DiscordID = ?");
                statement.setString(1, DISCORDID);
                ResultSet rs = statement.executeQuery();
            }
        }catch (SQLException e){
            e.printStackTrace();
        }
    }
    public static String getCode(String DISCORDID){
        try {
            PreparedStatement statement = MySQL.con.prepareStatement("SELECT Code FROM verifycodes WHERE DiscordID = ?");
            statement.setString(1,DISCORDID);
            ResultSet rs = statement.executeQuery();
            if (rs.next()){
                return rs.getString("Code");
            }
        }catch (SQLException e){
            e.printStackTrace();
        }
        return null;
    }

    public static void setVerified(String verifycode,Member member) {
        PreparedStatement statement;
        if (isValid(verifycode) == 1) {
            try {
                statement = MySQL.con.prepareStatement("UPDATE verifycodes SET DiscordID = ? WHERE Code = ?");
                statement.setString(1,member.getUser().getId());
                statement.setString(2,verifycode);
                statement.executeUpdate();
                statement = MySQL.con.prepareStatement("UPDATE verifycodes SET Valid = ? WHERE Code = ?");
                statement.setInt(1,0);
                statement.setString(2,verifycode);
                statement.executeUpdate();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }


    public static String getMCName(String DiscordID){
        try {
            PreparedStatement statement = MySQL.con.prepareStatement("SELECT * FROM verifycodes WHERE DiscordID='"+DiscordID+"'");
            ResultSet rs = statement.executeQuery();
            if (rs.last()){
                return rs.getString("Name");
            }
        }catch (SQLException e){
            e.printStackTrace();
        }
        return null;
    }

    public static String getRank(String verifycode){
        try {
            PreparedStatement statement = MySQL.con.prepareStatement("SELECT * FROM verifycodes WHERE Code ='"+verifycode+"'");
            ResultSet rs = statement.executeQuery();
            if (rs.last()){
                return rs.getString("Rang");
            }
        }catch (SQLException e){
            e.printStackTrace();
        }
        return null;
    }

    public static String getRank2(String DiscordID){
        try {
            PreparedStatement statement = MySQL.con.prepareStatement("SELECT * FROM verifycodes WHERE DiscordID ='"+DiscordID+"'");
            ResultSet rs = statement.executeQuery();
            if (rs.last()){
                return rs.getString("Rang");
            }
        }catch (SQLException e){
            e.printStackTrace();
        }
        return null;
    }


    /*if (p.hasPermission("tab.leitung")) {
                CodeAPI.setRank(UUID,"Leitung");
            } else if (p.hasPermission("tab.admin")) {
                CodeAPI.setRank(UUID,"Admin");
            } else if (p.hasPermission("tab.srdev")) {
                CodeAPI.setRank(UUID,"Sr.Dev");
            } else if (p.hasPermission("tab.dev")) {
                CodeAPI.setRank(UUID,"Dev");
            } else if (p.hasPermission("tab.srmod")) {
                CodeAPI.setRank(UUID,"Sr.Mod");
            } else if (p.hasPermission("tab.mod")) {
                CodeAPI.setRank(UUID,"Mod");
            } else if (p.hasPermission("tab.srsup")) {
                CodeAPI.setRank(UUID,"Sr.Sup");
            } else if (p.hasPermission("tab.sup")) {
                CodeAPI.setRank(UUID,"Sup");
            } else if (p.hasPermission("tab.srbuilder")) {
                CodeAPI.setRank(UUID,"Sr.Builder");
            } else if (p.hasPermission("tab.builder")) {
                CodeAPI.setRank(UUID,"Builder");
            } else if (p.hasPermission("tab.premium")) {
                CodeAPI.setRank(UUID,"Premium");
            } else {
                CodeAPI.setRank(UUID,"Spieler");
            }*/

    public static void setCodeNull(String DiscordID){
        try {
            PreparedStatement statement;
            statement = MySQL.con.prepareStatement("UPDATE verifycodes SET Code = ? WHERE DiscordID = ?");
            statement.setString(1, "NULL");
            statement.setString(2, DiscordID);
            statement.executeUpdate();
        }catch (SQLException e){
            e.printStackTrace();
        }
    }

}

package Verify;

import java.sql.*;

public class MySQL {

    public static Connection con;

    public static void connect() {
        if (!isConnected()) {
            try {
                con = DriverManager.getConnection("jdbc:mysql://localhost/DCVerify?useUnicode=true&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC", "root", "ohB3xaiS");
                System.out.println("Erfolgreich zu MySQL Verbunden");
            } catch (SQLException e) {
                e.printStackTrace();
                System.out.println("Konnte nicht zu MySQL verbinden!");
            }
        }
    }

    public static void disConnect() {
        try {
            con.close();
            System.out.println("MySQL Verbindung geschlossen!");
        } catch (SQLException e) {
            System.out.println("Konnte MySQL Verbindung nicht schließen!");
        }
    }

    public static boolean isConnected() {
        return con != null;
    }

    public static boolean isExisting(String verifycode) {
        try {
            ResultSet rs = query("SELECT * FROM verifycodes WHERE Code ='" + verifycode + "'");
            return rs.next();
        } catch (Exception e) {
            e.printStackTrace();
            return false;
        }
    }
    public static ResultSet query(String query){
        try {
            return query(con.prepareStatement(query));
        }catch (Exception e){
            e.printStackTrace();
            return null;
        }
    }
    public static ResultSet query(PreparedStatement statement){
        try {
            return statement.executeQuery();
        }catch (Exception e){
            e.printStackTrace();
            return null;
        }
    }
    public static boolean isRegistered(String DiscordID){
        try {
            ResultSet rs = query("SELECT * FROM verifycodes WHERE DiscordID ='"+DiscordID+"'");
            return rs.next();
        }catch (Exception e){
            e.printStackTrace();
        }
        return false;
    }
}