//Make a ban that uses the name CONSOLE instead of the player
    public void createConsoleBan(String player, String admin, String reason, int time)
    {
        Calendar cal = Calendar.getInstance();
        int year = cal.get(Calendar.YEAR);
        int month = cal.get(Calendar.MONTH);
        int day = cal.get(Calendar.DATE);
        Date date = new Date(year - 1900, month, day);
        SimpleDateFormat dformat = new SimpleDateFormat("MM/dd/yy");
        String formattedDate = dformat.format(date);
        long ends = 0;
        if (time != 0)
        {
        long unixTime = System.currentTimeMillis() / 1000L;
        ends = unixTime = (time*60);
        }
        try {
            PreparedStatement sampleQueryStatement = NASConnection.prepareStatement("INSERT INTO "+config.getString("MySQLSettings.Bans Table")+" (sid, date, type, player_steamid, player_ip, player_mcname, player_name, admin_steamid, admin_ip, admin_mcname, admin_name, unbanned_by, length, ends, reason, status) VALUES ('4', '"+formattedDate+"', 'MC', 'NULL', 'NULL', '"+player+"', 'NULL', 'NULL', 'NULL', '"+admin+"', 'NULL', 'NULL', '"+time+"', '"+ends+"', '"+reason+"', '1')");
            sampleQueryStatement.executeUpdate();
            sampleQueryStatement.close();
            getServer().broadcastMessage("[NAS] Admin: "+ChatColor.GREEN+admin+ChatColor.WHITE+" banned "+ChatColor.GREEN+player+ChatColor.WHITE+" for "+ChatColor.GREEN+reason);
        } catch (SQLException ex) {
            Logger.getLogger(Nas.class.getName()).log(Level.SEVERE, null, ex);
        }
    }