package com.chickenstyle.report;

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

import org.bukkit.Bukkit;
import org.bukkit.ChatColor;
import org.bukkit.Material;
import org.bukkit.command.Command;
import org.bukkit.command.CommandExecutor;
import org.bukkit.command.CommandSender;
import org.bukkit.entity.Player;
import org.bukkit.inventory.Inventory;
import org.bukkit.inventory.ItemStack;
import org.bukkit.inventory.meta.SkullMeta;

public class Reports implements CommandExecutor {

	@Override
	public boolean onCommand(CommandSender sender, Command cmd, String label, String[] args) {
        Player player = (Player) sender;
        if (sender instanceof Player) {
        	try {
			ResultSet rs = Main.prepareState("SELECT COUNT(*) FROM reports;").executeQuery();
            rs.first();
            int rows = rs.getInt("COUNT(*)");
             if (!(rows > 54)) {
             	Inventory gui = Bukkit.createInventory(null, 54 , ChatColor.GOLD + "Reported Players");
                 for (Player p : Bukkit.getOnlinePlayers()) {
                	     ItemStack i1 = new ItemStack (Material.SKULL,1,(short) 3);
                         SkullMeta meta = (SkullMeta) i1.getItemMeta();
                         meta.setDisplayName(p.getName());
                         i1.setItemMeta(meta);
                         gui.addItem(new ItemStack[] { i1 });
                 }
             } else {

             }
			} catch (SQLException e) {
				e.printStackTrace();
			}
        }
		return false;
	}

}