package pro.homiecraft;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import org.bukkit.command.Command;
import org.bukkit.command.CommandExecutor;
import org.bukkit.command.CommandSender;
import org.bukkit.entity.Player;

public class Commands implements CommandExecutor {
    public boolean onCommand(CommandSender sender, Command cmd, String commandLabel, String[] args){
        if(cmd.getName().equalsIgnoreCase("homiecraft")){
            Player player = (Player) sender;
            String pName = player.getName();

            Connection c = null;


            try {
                String sqlHost = Homiecraft.pluginST.getConfig().getString("HomieCraft.mysql.settings.host");
                String sqlPort = Homiecraft.pluginST.getConfig().getString("HomieCraft.mysql.settings.port");
                String sqlDb = Homiecraft.pluginST.getConfig().getString("HomieCraft.mysql.settings.db");
                String sqlUser = Homiecraft.pluginST.getConfig().getString("HomieCraft.mysql.settings.user");
                String sqlPw = Homiecraft.pluginST.getConfig().getString("HomieCraft.mysql.settings.pw");

                if(!(args.length == 0)){
                    if(args[0].equalsIgnoreCase("register")){
                        pro.homiecraft.MySql MySql = new pro.homiecraft.MySql(sqlHost, sqlPort, sqlDb, sqlUser, sqlPw);
                        c = MySql.open();
                        Statement statement = c.createStatement();
                        ResultSet res = statement.executeQuery("SELECT * FROM users WHERE minecraft = '" + pName + "';");
                        res.next();

                        if(res.getString("minecraft") == null){
                            String UserName = args[1];
                            String Pw = args[2];
                            String EMail = args[3];

                            statement.executeUpdate("INSERT INTO users ('minecraft', 'username', 'password', 'email') VALUES('" + pName + "', '" + UserName + "', '" + Pw + "', '" + EMail + "');");
                            //player.sendMessage("[HomieCraft] You have now registered as: " + UserName + " Password: " + Pw + " Email: " + EMail);
                        }else{
                            player.sendMessage("[HomieCraft] You have allready registered! You can login at http://homiecraft.pro");
                        }
                    }else{
                        player.sendMessage("[HomieCraft] Usage:");
                        player.sendMessage("/homiecraft register <UserName> <Password> <email>");
                    }
                }else{
                    player.sendMessage("[HomieCraft] Usage:");
                    player.sendMessage("/homiecraft register <UserName> <Password> <email>");
                }
            } catch (SQLException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();
            }
        }
        return false;
    }
}