function wp_statistics_download_manual()
{
    global $WP_Statistics, $wpdb;
    // this is how you get access to the database
    $manage_cap = wp_statistics_validate_capability($WP_Statistics->get_option('manage_capability', 'manage_options'));
    if (current_user_can($manage_cap)) {
        $type = $_GET['type'];
        if ($type == 'odt' || $type == 'html') {
            $filepath = $WP_Statistics->plugin_dir . '/manual';
            $filename = '';
            $ext = '.' . $type;
            // open this directory
            $dir = opendir($filepath);
            // get each entry
            while ($entry = readdir($dir)) {
                if (substr($entry, -strlen($ext)) == $ext) {
                    $filename = $entry;
                }
            }
            // close directory
            closedir($dir);
            if ($filename != '') {
                $filename = substr($filename, 0, -strlen($ext));
                $filename .= ' V' . WP_STATISTICS_VERSION . $ext;
                header('Content-Type: application/octet-stream;');
                header('Content-Disposition: attachment; filename="' . $filename . '"');
                readfile($filepath . $filename);
            }
        }
    }
}

function wp_statistics_dashboard_widget_load()
{
    global $WP_Statistics;
    $WP_Statistics->load_user_options();
    // We need to fudge the display settings for first time users so not all of the widgets are displayed, we only want to do this on
    // the first time they visit the dashboard though so check to see if we've been here before.
    if (!$WP_Statistics->get_user_option('dashboard_set')) {
        $WP_Statistics->update_user_option('dashboard_set', WP_STATISTICS_VERSION);
        $hidden_widgets = get_user_meta($WP_Statistics->user_id, 'metaboxhidden_dashboard', true);
        if (!is_array($hidden_widgets)) {
            $hidden_widgets = array();
        }
        $default_hidden = array('wp-statistics-browsers-widget', 'wp-statistics-countries-widget', 'wp-statistics-hitsmap-widget', 'wp-statistics-hits-widget', 'wp-statistics-pages-widget', 'wp-statistics-recent-widget', 'wp-statistics-referring-widget', 'wp-statistics-search-widget', 'wp-statistics-summary-widget', 'wp-statistics-words-widget', 'wp-statistics-top-visitors-widget');
        foreach ($default_hidden as $widget) {
            if (!in_array($widget, $hidden_widgets)) {
                $hidden_widgets[] = $widget;
            }
        }
        update_user_meta($WP_Statistics->user_id, 'metaboxhidden_dashboard', $hidden_widgets);
    } else {
        if ($WP_Statistics->get_user_option('dashboard_set') != WP_STATISTICS_VERSION) {
            // We also have to fudge things when we add new widgets to the code base.
            if (version_compare($WP_Statistics->get_user_option('dashboard_set'), '8.7', '<')) {
                $WP_Statistics->update_user_option('dashboard_set', WP_STATISTICS_VERSION);
                $hidden_widgets = get_user_meta($WP_Statistics->user_id, 'metaboxhidden_dashboard', true);
                if (!is_array($hidden_widgets)) {
                    $hidden_widgets = array();
                }
                $default_hidden = array('wp-statistics-top-visitors-widget');
                foreach ($default_hidden as $widget) {
                    if (!in_array($widget, $hidden_widgets)) {
                        $hidden_widgets[] = $widget;
                    }
                }
                update_user_meta($WP_Statistics->user_id, 'metaboxhidden_dashboard', $hidden_widgets);
            }
        }
    }
    // If the user does not have at least read access to the status plugin, just return without adding the widgets.
    if (!current_user_can(wp_statistics_validate_capability($WP_Statistics->get_option('read_capability', 'manage_option')))) {
        return;
    }
    // If the admin has disabled the widgets, don't display them.
    if (!$WP_Statistics->get_option('disable_dashboard')) {
        wp_add_dashboard_widget('wp-statistics-quickstats-widget', __('Quick Stats', 'wp_statistics'), 'wp_statistics_quickstats_widget', $control_callback = null);
        wp_add_dashboard_widget('wp-statistics-browsers-widget', __('Top 10 Browsers', 'wp_statistics'), 'wp_statistics_browsers_widget', $control_callback = null);
        wp_add_dashboard_widget('wp-statistics-countries-widget', __('Top 10 Countries', 'wp_statistics'), 'wp_statistics_countries_widget', $control_callback = null);
        wp_add_dashboard_widget('wp-statistics-hitsmap-widget', __('Today\'s Visitor Map', 'wp_statistics'), 'wp_statistics_hitsmap_widget', $control_callback = null);
        wp_add_dashboard_widget('wp-statistics-hits-widget', __('Hit Statistics', 'wp_statistics'), 'wp_statistics_hits_widget', $control_callback = null);
        wp_add_dashboard_widget('wp-statistics-pages-widget', __('Top 10 Pages', 'wp_statistics'), 'wp_statistics_pages_widget', $control_callback = null);
        wp_add_dashboard_widget('wp-statistics-recent-widget', __('Recent Visitors', 'wp_statistics'), 'wp_statistics_recent_widget', $control_callback = null);
        wp_add_dashboard_widget('wp-statistics-referring-widget', __('Top Referring Sites', 'wp_statistics'), 'wp_statistics_referring_widget', $control_callback = null);
        wp_add_dashboard_widget('wp-statistics-search-widget', __('Search Engine Referrals', 'wp_statistics'), 'wp_statistics_search_widget', $control_callback = null);
        wp_add_dashboard_widget('wp-statistics-summary-widget', __('Summary', 'wp_statistics'), 'wp_statistics_summary_widget', $control_callback = null);
        wp_add_dashboard_widget('wp-statistics-words-widget', __('Latest Search Words', 'wp_statistics'), 'wp_statistics_words_widget', $control_callback = null);
        wp_add_dashboard_widget('wp-statistics-top-visitors-widget', __('Top 10 Visitors Today', 'wp_statistics'), 'wp_statistics_top_visitors_widget', $control_callback = null);
    }
}

function wp_statistics_generate_about_postbox_content()
{
    global $wpdb, $WP_Statistics;
    ?>

						<div style="text-align: center;">
							<a href="http://wp-statistics.com" target="_blank"><img src="<?php 
    echo plugins_url('wp-statistics/assets/images/logo-250.png');
    ?>
"></a>
						</div>

						<div id="about-links" style="text-align: center;">
							<p><a href="http://wp-statistics.com" target="_blank"><?php 
    _e('Website', 'wp_statistics');
    ?>
</a></p>
							| <p><a href="http://wordpress.org/support/view/plugin-reviews/wp-statistics" target="_blank"><?php 
    _e('Rate and Review', 'wp_statistics');
    ?>
</a></p>
<?php 
    if (current_user_can(wp_statistics_validate_capability($WP_Statistics->get_option('manage_capability', 'manage_options')))) {
        ?>

							| <p><a href="?page=wp-statistics/settings&tab=about"><?php 
        _e('More Information', 'wp_statistics');
        ?>
</a></p>
<?php 
    }
    ?>

						</div>

						<hr />
						
						<div>
							<?php 
    echo sprintf(__('This product includes GeoLite2 data created by MaxMind, available from %s.', 'wp_statistics'), '<a href="http://www.maxmind.com" target=_blank>http://www.maxmind.com</a>');
    ?>

						</div>
<?php 
}

function wp_statistics_add_editor_meta_box()
{
    global $WP_Statistics;
    $WP_Statistics->load_user_options();
    // We need to fudge the display settings for first time users so not all of the widgets are disaplyed, we only want to do this on
    // the first time they visit the dashboard though so check to see if we've been here before.
    if (!$WP_Statistics->get_user_option('editor_set')) {
        $WP_Statistics->update_user_option('editor_set', WP_STATISTICS_VERSION);
        $hidden_widgets = get_user_meta($WP_Statistics->user_id, 'metaboxhidden_post', true);
        if (!is_array($hidden_widgets)) {
            $hidden_widgets = array();
        }
        if (!in_array('wp_statistics_editor_meta_box', $hidden_widgets)) {
            $hidden_widgets[] = 'wp_statistics_editor_meta_box';
        }
        update_user_meta($WP_Statistics->user_id, 'metaboxhidden_post', $hidden_widgets);
        $hidden_widgets = get_user_meta($WP_Statistics->user_id, 'metaboxhidden_page', true);
        if (!is_array($hidden_widgets)) {
            $hidden_widgets = array();
        }
        if (!in_array('wp_statistics_editor_meta_box', $hidden_widgets)) {
            $hidden_widgets[] = 'wp_statistics_editor_meta_box';
        }
        update_user_meta($WP_Statistics->user_id, 'metaboxhidden_page', $hidden_widgets);
    }
    // If the user does not have at least read access to the status plugin, just return without adding the widgets.
    if (!current_user_can(wp_statistics_validate_capability($WP_Statistics->get_option('read_capability', 'manage_option')))) {
        return;
    }
    // If the admin has disabled the widgets don't display them.
    if ($WP_Statistics->get_option('disable_editor')) {
        return;
    }
    $screens = array('post', 'page');
    foreach ($screens as $screen) {
        add_meta_box('wp_statistics_editor_meta_box', __('Hit Statistics', 'wp_statistics'), 'wp_statistics_editor_meta_box', $screen, 'normal', 'high');
    }
}

function wp_statistics_purge_visitor_hits_action_callback()
{
    global $WP_Statistics, $wpdb;
    // this is how you get access to the database
    require $WP_Statistics->plugin_dir . '/includes/functions/purge-hits.php';
    $manage_cap = wp_statistics_validate_capability($WP_Statistics->get_option('manage_capability', 'manage_options'));
    if (current_user_can($manage_cap)) {
        $purge_hits = 10;
        if (array_key_exists('purge-hits', $_POST)) {
            // Get the number of days to purge data before.
            $purge_hits = intval($_POST['purge-hits']);
        }
        if ($purge_hits < 10) {
            _e('Number of hits must be greater than or equal to 10!', 'wp_statistics');
        } else {
            echo wp_statistics_purge_visitor_hits($purge_hits);
        }
    } else {
        _e('Access denied!', 'wp_statistics');
    }
    wp_die();
    // this is required to terminate immediately and return a proper response
}

function wp_statistics_settings()
{
    global $WP_Statistics;
    // Check the current user has the rights to be here.
    if (!current_user_can(wp_statistics_validate_capability($WP_Statistics->get_option('read_capability', 'manage_options')))) {
        wp_die(__('You do not have sufficient permissions to access this page.'));
    }
    // When we create $WP_Statistics the user has not been authenticated yet so we cannot load the user preferences
    // during the creation of the class.  Instead load them now that the user exists.
    $WP_Statistics->load_user_options();
    // Load our CSS to be used.
    wp_enqueue_style('log-css', plugin_dir_url(__FILE__) . 'assets/css/style.css', true, '1.0');
    // Load the jQuery UI code to create the tabs.
    wp_register_style("jquery-ui-css", plugin_dir_url(__FILE__) . "assets/css/jquery-ui-1.10.4.custom.css");
    wp_enqueue_style("jquery-ui-css");
    wp_enqueue_script('jquery-ui-core');
    wp_enqueue_script('jquery-ui-tabs');
    if (is_rtl()) {
        wp_enqueue_style('rtl-css', plugin_dir_url(__FILE__) . 'assets/css/rtl.css', true, '1.1');
    }
    // We could let the download happen at the end of the page, but this way we get to give some
    // feedback to the users about the result.
    if ($WP_Statistics->get_option('update_geoip') == true) {
        echo wp_statistics_download_geoip();
    }
    include_once dirname(__FILE__) . "/includes/settings/wps-settings.php";
}

<?php

$wps_nonce_valid = false;
if (array_key_exists('wp-statistics-nonce', $_POST)) {
    if (wp_verify_nonce($_POST['wp-statistics-nonce'], 'update-options')) {
        $wps_nonce_valid = true;
    }
}
$wps_admin = false;
if (current_user_can(wp_statistics_validate_capability($WP_Statistics->get_option('manage_capability', 'manage_options')))) {
    $wps_admin = true;
}
if ($wps_admin === false) {
    $wps_admin = 0;
}
$selected_tab = "";
if (array_key_exists('tab', $_GET)) {
    $selected_tab = $_GET['tab'];
}
switch ($selected_tab) {
    case 'notifications':
        if ($wps_admin) {
            $current_tab = 1;
        } else {
            $current_tab = 0;
        }
        break;
    case 'overview':
        if ($wps_admin) {
            $current_tab = 2;
        } else {

function wp_statistics_get_widget_contents_callback()
{
    global $WP_Statistics, $wpdb;
    // this is how you get access to the database
    $widgets = array('about', 'browsers', 'map', 'countries', 'hits', 'hitsmap', 'page', 'pages', 'quickstats', 'recent', 'referring', 'search', 'summary', 'top.visitors', 'words');
    $view_cap = wp_statistics_validate_capability($WP_Statistics->get_option('read_capability', 'manage_options'));
    if (current_user_can($view_cap)) {
        $widget = '';
        if (array_key_exists('widget', $_POST)) {
            // Get the widget we're going to display.
            if (in_array($_POST['widget'], $widgets)) {
                $widget = $_POST['widget'];
            }
        }
        if ('map' == $widget || 'hitsmap' == $widget) {
            if ($WP_Statistics->get_option('map_type') == 'jqvmap') {
                $widget = 'jqv.map';
            } else {
                $widget = 'google.map';
            }
        }
        if ('' == $widget) {
            _e('No matching widget found!', 'wp_statistics');
            wp_die();
        }
        $ISOCountryCode = $WP_Statistics->get_country_codes();
        $search_engines = wp_statistics_searchengine_list();
        require $WP_Statistics->plugin_dir . '/includes/log/widgets/' . $widget . '.php';
        switch ($widget) {
            case 'summary':
                wp_statistics_generate_summary_postbox_content($search_engines);
                break;
            case 'quickstats':
                wp_statistics_generate_quickstats_postbox_content($search_engines);
                break;
            case 'browsers':
                wp_statistics_generate_browsers_postbox_content();
                break;
            case 'referring':
                wp_statistics_generate_referring_postbox_content();
                break;
            case 'countries':
                wp_statistics_generate_countries_postbox_content($ISOCountryCode);
                break;
            case 'jqv.map':
            case 'google.map':
                wp_statistics_generate_map_postbox_content($ISOCountryCode);
                break;
            case 'hits':
                wp_statistics_generate_hits_postbox_content();
                break;
            case 'search':
                wp_statistics_generate_search_postbox_content($search_engines);
                break;
            case 'words':
                wp_statistics_generate_words_postbox_content($ISOCountryCode);
                break;
            case 'page':
                $pageid = (int) $_POST['page-id'];
                wp_statistics_generate_page_postbox_content(null, $pageid);
                break;
            case 'pages':
                list($total, $uris) = wp_statistics_get_top_pages();
                wp_statistics_generate_pages_postbox_content($total, $uris);
                break;
            case 'recent':
                wp_statistics_generate_recent_postbox_content($ISOCountryCode);
                break;
            case 'top.visitors':
                wp_statistics_generate_top_visitors_postbox_content($ISOCountryCode);
                break;
            case 'about':
                wp_statistics_generate_about_postbox_content($ISOCountryCode);
                break;
            default:
                _e('ERROR: Widget not found!', 'wp_statistics');
        }
    } else {
        _e('Access denied!', 'wp_statistics');
    }
    wp_die();
    // this is required to terminate immediately and return a proper response
}

function wp_statistics_export_data()
{
    global $WP_Statistics, $wpdb;
    // this is how you get access to the database
    $manage_cap = wp_statistics_validate_capability($WP_Statistics->get_option('manage_capability', 'manage_options'));
    if (current_user_can($manage_cap)) {
        $table = $_POST['table-to-export'];
        $type = $_POST['export-file-type'];
        $headers = $_POST['export-headers'];
        // Validate the table name the user passed to us.
        if (!($table == "useronline" || $table == "visit" || $table == "visitor" || $table == "exclusions" || $table == "pages")) {
            $table = FALSE;
        }
        // Validate the file type the user passed to us.
        if (!($type == "excel" || $type == "xml" || $type == "csv" || $type == "tsv")) {
            $table = FALSE;
        }
        if ($table && $type) {
            require $WP_Statistics->plugin_dir . '/includes/classes/php-export-data.class.php';
            $file_name = WPS_EXPORT_FILE_NAME . '-' . $WP_Statistics->Current_Date('Y-m-d-H-i');
            switch ($type) {
                case 'excel':
                    $exporter = new ExportDataExcel('browser', "{$file_name}.xls");
                    break;
                case 'xml':
                    $exporter = new ExportDataExcel('browser', "{$file_name}.xml");
                    break;
                case 'csv':
                    $exporter = new ExportDataCSV('browser', "{$file_name}.csv");
                    break;
                case 'tsv':
                    $exporter = new ExportDataTSV('browser', "{$file_name}.tsv");
                    break;
            }
            $exporter->initialize();
            // We need to limit the number of results we retrieve to ensure we don't run out of memory
            $query_base = "SELECT * FROM {$wpdb->prefix}statistics_{$table}";
            $query = $query_base . ' LIMIT 0,1000';
            $i = 1;
            $more_results = true;
            $result = $wpdb->get_results($query, ARRAY_A);
            if ($headers) {
                foreach ($result[0] as $key => $col) {
                    $columns[] = $key;
                }
                $exporter->addRow($columns);
            }
            while ($more_results) {
                foreach ($result as $row) {
                    $exporter->addRow($row);
                    // Make sure we've flushed the output buffer so we don't run out of memory on large exports.
                    ob_flush();
                    flush();
                }
                unset($result);
                $wpdb->flush();
                $query = $query_base . ' LIMIT ' . $i * 1000 . ',1000';
                $result = $wpdb->get_results($query, ARRAY_A);
                if (count($result) == 0) {
                    $more_results = false;
                }
                $i++;
            }
            $exporter->finalize();
            exit;
        }
    }
}