package me.xxx;

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

import org.bukkit.entity.Player;

import net.milkbowl.vault.permission.Permission;

public class L2 {
 DiscordBot plugin = DiscordBot.getPlugin(DiscordBot.class);

 public boolean playerExists(UUID uuid){

     try {
     PreparedStatement statement = plugin.getConnection().prepareStatement("SELECT * FROM " + plugin.table + "WHERE UUID =?");
     statement.setString(1, uuid.toString());

     ResultSet results = statement.executeQuery();
     if(results.next()) {

     }

 } catch (SQLException e) {
     e.printStackTrace();
 }
 return false;
}
public void createPlayer(final UUID uuid, Player player) {
    try {
        PreparedStatement statement = plugin.getConnection().prepareStatement("SELECT * FROM " + plugin.table + "WHERE UUID =?");
         statement.setString(1, uuid.toString());
         statement.setString(1, uuid.toString());
         ResultSet results = statement.executeQuery();
         results.next();
         if(!(playerExists(uuid) != true)) {
             PreparedStatement insert = plugin.getConnection().prepareStatement("INSERT INTO " + plugin.table + "(UUID, NAME, RANK) VALUE (?,?,?)");
             insert.setString(1, uuid.toString());
             insert.setString(2, player.getName());
             insert.setString(3, Permission.getPrimaryGroup(player));
         }
    } catch (SQLException e) {
        e.printStackTrace();
    }
}
}








package me.xxx;

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

import org.bukkit.entity.Player;

import net.milkbowl.vault.permission.Permission;

public class L2 {
 DiscordBot plugin = DiscordBot.getPlugin(DiscordBot.class);

 public boolean playerExists(UUID uuid){

     try {
     PreparedStatement statement = plugin.getConnection().prepareStatement("SELECT * FROM " + plugin.table + "WHERE UUID =?");
     statement.setString(1, uuid.toString());

     ResultSet results = statement.executeQuery();
     if(results.next()) {

     }

 } catch (SQLException e) {
     e.printStackTrace();
 }
 return false;
}
public void createPlayer(final UUID uuid, Player player) {
    try {
        PreparedStatement statement = plugin.getConnection().prepareStatement("SELECT * FROM " + plugin.table + "WHERE UUID =?");
         statement.setString(1, uuid.toString());
         statement.setString(1, uuid.toString());
         ResultSet results = statement.executeQuery();
         results.next();
         if(!(playerExists(uuid) != true)) {
             PreparedStatement insert = plugin.getConnection().prepareStatement("INSERT INTO " + plugin.table + "(UUID, NAME, RANK) VALUE (?,?,?)");
             insert.setString(1, uuid.toString());
             insert.setString(2, player.getName());
             insert.setString(3, Permission.getPrimaryGroup(player));
         }
    } catch (SQLException e) {
        e.printStackTrace();
    }
}
}






package me.xxx;


import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

import org.bukkit.Bukkit;
import org.bukkit.ChatColor;
import org.bukkit.command.Command;
import org.bukkit.command.CommandSender;
import org.bukkit.entity.Player;
import org.bukkit.plugin.RegisteredServiceProvider;
import org.bukkit.plugin.java.JavaPlugin;

import net.milkbowl.vault.permission.Permission;



public class DiscordBot extends JavaPlugin {
    public static Permission permission = null;
    private Connection connection;
    public String host, database, username, password, table;
    public int port;
    public Connection getConnection() {
        return connection;
    }

    public void onEnable() {
     registerConfig();
    mysqlSetup();
     setupPermissions();

 }



private void registerConfig() {
    getConfig().options().copyDefaults(true);
    saveConfig();
}
public void setConnection(Connection connection) {
    this.connection = connection;
}
public void mysqlSetup() {
    host = getConfig().getString("Dbhost");
    database = getConfig().getString("Db");
    username = getConfig().getString("Dbname");
    password = getConfig().getString("Dbpass");
    port = getConfig().getInt("Dbport");
    table = getConfig().getString("Table");

    try{

        synchronized (this){
            if(getConnection() != null && !getConnection().isClosed()){
                return;
            }

            Class.forName("com.mysql.jdbc.Driver");

            setConnection( DriverManager.getConnection("jdbc:mysql://" + this.host + ":" + this.port + "/" + this.database, this.username, this.password));

            Bukkit.getConsoleSender().sendMessage(ChatColor.GREEN + "MYSQL CONNECTED");
        }
    }catch(SQLException e){
        e.printStackTrace();
    }catch(ClassNotFoundException e){
        e.printStackTrace();
    }
}





public void onDisable() {

saveConfig();


 }

 public boolean onCommand(CommandSender sender, Command cmd, String label, String[] args) {


     if (cmd.getName().equalsIgnoreCase("rank") && sender instanceof Player) {

         Player player = (Player) sender;



     }

     return false;
 }
 private boolean setupPermissions()
 {
     RegisteredServiceProvider<Permission> permissionProvider = getServer().getServicesManager().getRegistration(net.milkbowl.vault.permission.Permission.class);
     if (permissionProvider != null) {
         permission = permissionProvider.getProvider();
     }
     return (permission != null);
 }













}