package net.trollc.playdonate;

import java.io.Console;
import java.sql.*;

import org.bukkit.Bukkit;
import org.bukkit.command.Command;
import org.bukkit.command.CommandSender;
import org.bukkit.command.ConsoleCommandSender;
import org.bukkit.entity.Player;

public class Main {
	public boolean onCommand(Command cmd, CommandSender sender, String label, String[] args) {
		if (!(sender instanceof Player)) {
			return true;
		}
		Player p = (Player)sender;
		if (!p.hasPermission("playdonate.get")) {
			p.sendMessage("§6[§aTrollCInCraft§6] §fУ вас нет прав.");
			return true;
		}
		if (args.length == 0) {
			p.sendMessage("§6[§aTrollCInCraft§6] §f/getdonate [название]");
		}
			try {
			String driver = "org.gjt.mm.mysql.Driver";
			String url = "jdbc:mysql://localhost/leaderheads";
			Class.forName(driver);
			Connection con = DriverManager.getConnection(url, "root", "neskazhuparol");
			String query = "SELECT * FROM `leaderheadsplayers` WHERE `name` = '" + p.getName();
			Statement st = con.createStatement();
		      ResultSet rs = st.executeQuery(query);
		        int playerid = rs.getInt("player_id");
		      ResultSet res = st.executeQuery("SELECT * FROM `leaderheadsplayersdata_alltime` WHERE `player_id` = " + playerid + " AND `stat_type` = 'played'");
		      int playedtime = res.getInt("stat_value");
		      if (args[0].equalsIgnoreCase("premium")) {
		    	  if (playedtime > 120) {
		    		  Bukkit.dispatchCommand(Bukkit.getConsoleSender(), "pex user " + p.getName() + " group set premium");
		    		  p.sendMessage("§6[§aTrollCInCraft§6] §fУспешное получение доната Premium!");
		    	  } else {
		    		  p.sendMessage("§6[§aTrollCInCraft§6] §fВы еще не играли 2 часа.");
		    		  return true;
		    	  }
		      }
		      if (args[0].equalsIgnoreCase("creative")) {
		    	  if (playedtime > 300) {
		    		  Bukkit.dispatchCommand(Bukkit.getConsoleSender(), "pex user " + p.getName() + " group set creative");
		    		  p.sendMessage("§6[§aTrollCInCraft§6] §fУспешное получение доната Creative!");
		    	  } else {
		    		  p.sendMessage("§6[§aTrollCInCraft§6] §fВы еще не играли 5 часов.");
		    		  return true;
		    	  }
		      }
		      if (args[0].equalsIgnoreCase("admin")) {
		    	  if (playedtime > 600) {
		    		  Bukkit.dispatchCommand(Bukkit.getConsoleSender(), "pex user " + p.getName() + " group set admin");
		    		  p.sendMessage("§6[§aTrollCInCraft§6] §fУспешное получение доната Admin!");
		    	  } else {
		    		  p.sendMessage("§6[§aTrollCInCraft§6] §fВы еще не играли 10 часов.");
		    		  return true;
		    	  }
		      }
		      if (args[0].equalsIgnoreCase("moder")) {
		    	  if (playedtime > 1200) {
		    		  Bukkit.dispatchCommand(Bukkit.getConsoleSender(), "pex user " + p.getName() + " group set premium");
		    		  p.sendMessage("§6[§aTrollCInCraft§6] §fУспешное получение доната Moderator!");
		    	  } else {
		    		  p.sendMessage("§6[§aTrollCInCraft§6] §fВы еще не играли 20 часов.");
		    		  return true;
		    	  }
		      }
		      if (args[0].equalsIgnoreCase("osnovatel")) {
		    	  if (playedtime > 2400) {
		    		  Bukkit.dispatchCommand(Bukkit.getConsoleSender(), "pex user " + p.getName() + " group set osnovatel");
		    		  p.sendMessage("§6[§aTrollCInCraft§6] §fУспешное получение доната Основатель!");
		    	  } else {
		    		  p.sendMessage("§6[§aTrollCInCraft§6] §fВы еще не играли 40 часов.");
		    		  return true;
		    	  }
		      }
		      if (args[0].equalsIgnoreCase("vladel")) {
		    	  if (playedtime > 4800) {
		    		  Bukkit.dispatchCommand(Bukkit.getConsoleSender(), "pex user " + p.getName() + " group set vladel");
		    		  p.sendMessage("§6[§aTrollCInCraft§6] §fУспешное получение доната Владелец!");
		    	  } else {
		    		  p.sendMessage("§6[§aTrollCInCraft§6] §fВы еще не играли 80 часов.");
		    		  return true;
		    	  }
		      }
		      if (args[0].equalsIgnoreCase("sponsor")) {
		    	  if (playedtime > 12000) {
		    		  Bukkit.dispatchCommand(Bukkit.getConsoleSender(), "pex user " + p.getName() + " group set sponsor");
		    		  p.sendMessage("§6[§aTrollCInCraft§6] §fУспешное получение доната Спонсор!");
		    	  } else {
		    		  p.sendMessage("§6[§aTrollCInCraft§6] §fВы еще не играли 200 часов.");
		    		  return true;
		    	  }
		      }
		}
			catch (Exception e)
		    {
			  ConsoleCommandSender console = Bukkit.getServer().getConsoleSender();
		      console.sendMessage("Got an exception! ");
		      console.sendMessage(e.getMessage());
		    }

		return false;
}
}