TGSalvarSenha

package me.trow.tgsalvarsenha;

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

import org.bukkit.Bukkit;
import org.bukkit.command.Command;
import org.bukkit.command.CommandSender;
import org.bukkit.command.ConsoleCommandSender;
import org.bukkit.entity.Player;
import org.bukkit.event.EventHandler;
import org.bukkit.event.Listener;
import org.bukkit.event.player.PlayerJoinEvent;
import org.bukkit.plugin.java.JavaPlugin;

public class Main extends JavaPlugin implements Listener{

    private static DB db=null;

    public void onEnable(){
        ConsoleCommandSender b = Bukkit.getConsoleSender();
        saveDefaultConfig();
        //pl = this;
        b.sendMessage("§6=-=-=-=-=-=-=-=-=-=-=-=-=-=-=");
        b.sendMessage("§3[TGSalvarSenha] §bAtivado...");
        b.sendMessage("§3Criador: §bTrow");
        b.sendMessage("§bAgradeco por usar meu(s) plugin(s)");
        b.sendMessage("§6=-=-=-=-=-=-=-=-=-=-=-=-=-=-=");
        String host = getConfig().getString("MySQL.Host");
        String database = getConfig().getString("MySQL.DB");
        String user = getConfig().getString("MySQL.User");
        String pass = getConfig().getString("MySQL.Pass");
        db=DB.load(host, database, user, pass);
        db.update("CREATE TABLE IF NOT EXISTS `tg_salvasenha` (`nome` varchar(25) not null,`ip` varchar(60) not null,`senha` varchar(60) not null);");
        Bukkit.getPluginManager().registerEvents(this, this);
    }

    public void onDisable(){
        ConsoleCommandSender b = Bukkit.getConsoleSender();
        b.sendMessage("§6=-=-=-=-=-=-=-=-=-=-=-=-=-=-=");
        b.sendMessage("§3[TGPlugin] §bDesativado...");
        b.sendMessage("§3Criador: §bTrow");
        b.sendMessage("§bAgradeco por usar meu(s) plugin(s)");
        b.sendMessage("§6=-=-=-=-=-=-=-=-=-=-=-=-=-=-=");
    }

    public String getIP(String p){
        if(!hasDado(p)) return "";
        PreparedStatement ps=null;
        try{
            ps=db.getConnection().prepareStatement("SELECT * FROM `tg_salvasenha` WHERE nome=?;");
            ps.setString(1, p);
            ResultSet rs = ps.executeQuery();
            while(rs.next()){
                return rs.getString("ip");
            }
        }catch (Exception e){}
        finally{
            try{
                ps.close();
            }catch (Exception e){}
        }
        return "";
    }

    public String getSenha(String p){
        if(!hasDado(p)) return "";
        PreparedStatement ps=null;
        try{
            ps=db.getConnection().prepareStatement("SELECT * FROM `tg_salvasenha` WHERE nome=?;");
            ps.setString(1, p);
            ResultSet rs = ps.executeQuery();
            while(rs.next()){
                return rs.getString("senha");
            }
        }catch (Exception e){}
        finally{
            try{
                ps.close();
            }catch (Exception e){}
        }
        return "";
    }

    public boolean hasDado(String p){
        PreparedStatement ps=null;
        try{
            ps=db.getConnection().prepareStatement("SELECT * FROM `tg_salvasenha` WHERE nome=?;");
            ps.setString(1, p);
            ResultSet rs = ps.executeQuery();
            while(rs.next()){
                return true;
            }
        }catch (Exception e){}
        finally{
            try{
                ps.close();
            }catch (Exception e){}
        }
        return false;
    }

    public void setDado(Player p,String pas){
        PreparedStatement ps = null;
        try{
            if(!hasDado(p.getName())){
                ps=db.getConnection().prepareStatement("INSERT INTO `tg_salvasenha` (`nome`,`ip`,`senha`) VALUES (?,?,?);");
                ps.setString(1, p.getName());
                ps.setString(2, p.getAddress().getHostName());
                ps.setString(3, pas);
                ps.executeUpdate();
            }else{
                ps=db.getConnection().prepareStatement("UPDATE `tg_salvasenha` SET ip=?,senha=? WHERE nome=?;");
                ps.setString(1, p.getAddress().getHostName());
                ps.setString(2, pas);
                ps.setString(3, p.getName());
                ps.executeUpdate();
            }
        }catch (Exception e){}
        finally{
            try{
                ps.close();
            }catch (Exception e){}
        }
    }

    @EventHandler
    public void entrar(PlayerJoinEvent e){
        final Player p = e.getPlayer();
        String ip = p.getAddress().getHostName();
        String ips = getIP(p.getName());
        if(ips.equalsIgnoreCase("")||ips==null) return;
        if(ip.equalsIgnoreCase(ips)){
            final String pass=getSenha(p.getName());
            if(pass.equalsIgnoreCase("")||pass==null){
                p.sendMessage("§cPassword nao definida, portanto nao e possivel fazer login automatico!");
                return;
            }
            Bukkit.getScheduler().scheduleSyncDelayedTask(this, new Runnable() {
                public void run() {
                    p.chat("/login "+pass);
                }
            },5*20);
        }
    }

    public boolean onCommand(CommandSender sender, Command cmd, String label, String[] args){
        if(!(sender instanceof Player)){
            sender.sendMessage("§cUse este comando in-game.");
            return true;
        }
        Player p = (Player)sender;
        if(label.equalsIgnoreCase("salvarsenha")){
            if(args.length==0){
                p.sendMessage("§cUse: §a/salvarsenha §6<Senha>§c.");
                return true;
            }
            String s = args[0];
            setDado(p, s);
            p.sendMessage("§3[Login Automatico] §bSenha §a"+s+"§b, foi salva com sucesso.");
        }
        return false;
    }

}