<?php

// phpcs:disable PSR12.Properties.ConstantVisibility.NotFound

defined('ABSPATH') or die();

/**
 * Main class for Simple History
 */
class SimpleHistory
{
    const NAME = 'Simple History';

    /**
     * For singleton
     */
    private static $instance;

    /**
     * Array with external loggers to load
     */
    private $externalLoggers;

    /**
     * Array with external dropins to load
     */
    private $externalDropins;

    /**
     * Array with all instantiated loggers
     */
    private $instantiatedLoggers;

    /**
     * Array with all instantiated dropins
     */
    private $instantiatedDropins;

    /**
     * Bool if gettext filter function should be active
     * Should only be active during the load of a logger
     */
    private $doFilterGettext = false;

    /**
     * Used by gettext filter to temporarily store current logger
     */
    private $doFilterGettext_currentLogger = null;

    /**
     * Used to store latest translations used by __()
     * Required to automagically determine orginal text and text domain
     * for calls like this `SimpleLogger()->log( __("My translated message") );`
     */
    public $gettextLatestTranslations = [];

    /**
     * All registered settings tabs
     */
    private $arr_settings_tabs = [];

    const DBTABLE = 'simple_history';
    const DBTABLE_CONTEXTS = 'simple_history_contexts';

    /** Slug for the settings menu */
    const SETTINGS_MENU_SLUG = 'simple_history_settings_menu_slug';

    /** Slug for the settings menu */
    const SETTINGS_GENERAL_OPTION_GROUP = 'simple_history_settings_group';

    /** ID for the general settings section */
    const SETTINGS_SECTION_GENERAL_ID = 'simple_history_settings_section_general';

    public function __construct()
    {
        $this->init();
    }

    /**
     * @since 2.5.2
     */
    public function init()
    {
        /**
         * Fires before Simple History does it's init stuff
         *
         * @since 2.0
         *
         * @param SimpleHistory $SimpleHistory This class.
         */
        do_action('simple_history/before_init', $this);

        $this->setup_variables();

        // Actions and filters, ordered by order specified in codex: http://codex.wordpress.org/Plugin_API/Action_Reference
        add_action('after_setup_theme', [$this, 'load_plugin_textdomain']);
        add_action('after_setup_theme', [$this, 'add_default_settings_tabs']);

        // Plugins and dropins are loaded using the "after_setup_theme" filter so
        // themes can use filters to modify the loading of them.
        // The drawback with this is that for example logouts done when plugins like
        // iThemes Security is installed is not logged, because those plugins fire wp_logout()
        // using filter "plugins_loaded", i.e. before simple history has loaded its filters.
        add_action('after_setup_theme', [$this, 'load_loggers']);
        add_action('after_setup_theme', [$this, 'load_dropins']);

        // Run before loading of loggers and before menu items are added.
        add_action('after_setup_theme', [$this, 'check_for_upgrade'], 5);

        add_action('after_setup_theme', [$this, 'setup_cron']);

        // Filters and actions not called during regular boot.
        add_filter('gettext', [$this, 'filter_gettext'], 20, 3);
        add_filter('gettext_with_context', [$this, 'filter_gettext_with_context'], 20, 4);

        add_filter('gettext', [$this, 'filter_gettext_storeLatestTranslations'], 10, 3);

        add_action('admin_bar_menu', [$this, 'add_admin_bar_network_menu_item'], 40);
        add_action('admin_bar_menu', [$this, 'add_admin_bar_menu_item'], 40);

        /**
         * Filter that is used to log things, without the need to check that simple history is available
         * i.e. you can have simple history acivated and log things and then you can disable the plugin
         * and no errors will occur
         *
         * Usage:
         * apply_filters("simple_history_log", "This is the log message");
         * apply_filters("simple_history_log", "This is the log message with some extra data/info", ["extraThing1" => $variableWIihThing]);
         * apply_filters("simple_history_log", "This is the log message with severity debug", null, "debug");
         * apply_filters("simple_history_log", "This is the log message with severity debug and with some extra info/data logged", ["userData" => $userData, "shoppingCartDebugData" => $shopDebugData], "debug",);
         *
         * @since 2.13
         */
        add_filter('simple_history_log', [$this, 'on_filter_simple_history_log'], 10, 3);

        /**
         * Filter to log with specific log level, for example:
         * apply_filters('simple_history_log_debug', 'My debug message');
         * apply_filters('simple_history_log_warning', 'My warning message');
         *
         * @since 2.17
         */
        add_filter('simple_history_log_emergency', [$this, 'on_filter_simple_history_log_emergency'], 10, 3);
        add_filter('simple_history_log_alert', [$this, 'on_filter_simple_history_log_alert'], 10, 2);
        add_filter('simple_history_log_critical', [$this, 'on_filter_simple_history_log_critical'], 10, 2);
        add_filter('simple_history_log_error', [$this, 'on_filter_simple_history_log_error'], 10, 2);
        add_filter('simple_history_log_warning', [$this, 'on_filter_simple_history_log_warning'], 10, 2);
        add_filter('simple_history_log_notice', [$this, 'on_filter_simple_history_log_notice'], 10, 2);
        add_filter('simple_history_log_info', [$this, 'on_filter_simple_history_log_info'], 10, 2);
        add_filter('simple_history_log_debug', [$this, 'on_filter_simple_history_log_debug'], 10, 2);

        if (is_admin()) {
            $this->add_admin_actions();
        }

        /**
         * Fires after Simple History has done it's init stuff
         *
         * @since 2.0
         *
         * @param SimpleHistory $SimpleHistory This class.
         */
        do_action('simple_history/after_init', $this);
    }

    /**
     * Log a message
     *
     * Function called when running filter "simple_history_log"
     *
     * @since 2.13
     * @param string $message The message to log.
     * @param array  $context Optional context to add to the logged data.
     * @param string $level The loglevel. Must be one of the existing ones. Defaults to "info".
     */
    public function on_filter_simple_history_log($message = null, $context = null, $level = 'info')
    {
        SimpleLogger()->log($level, $message, $context);
    }

    /**
     * Log a message, triggered by filter 'on_filter_simple_history_log_emergency'.
     *
     * @param string $message The message to log.
     * @param array  $context The context (optional).
     */
    public function on_filter_simple_history_log_emergency($message = null, $context = null)
    {
        SimpleLogger()->log('emergency', $message, $context);
    }

    /**
     * Log a message, triggered by filter 'on_filter_simple_history_log_alert'.
     *
     * @param string $message The message to log.
     * @param array  $context The context (optional).
     */
    public function on_filter_simple_history_log_alert($message = null, $context = null)
    {
        SimpleLogger()->log('alert', $message, $context);
    }

    /**
     * Log a message, triggered by filter 'on_filter_simple_history_log_critical'.
     *
     * @param string $message The message to log.
     * @param array  $context The context (optional).
     */
    public function on_filter_simple_history_log_critical($message = null, $context = null)
    {
        SimpleLogger()->log('critical', $message, $context);
    }

    /**
     * Log a message, triggered by filter 'on_filter_simple_history_log_error'.
     *
     * @param string $message The message to log.
     * @param array  $context The context (optional).
     */
    public function on_filter_simple_history_log_error($message = null, $context = null)
    {
        SimpleLogger()->log('error', $message, $context);
    }

    /**
     * Log a message, triggered by filter 'on_filter_simple_history_log_warning'.
     *
     * @param string $message The message to log.
     * @param array  $context The context (optional).
     */
    public function on_filter_simple_history_log_warning($message = null, $context = null)
    {
        SimpleLogger()->log('warning', $message, $context);
    }

    /**
     * Log a message, triggered by filter 'on_filter_simple_history_log_notice'.
     *
     * @param string $message The message to log.
     * @param array  $context The context (optional).
     */
    public function on_filter_simple_history_log_notice($message = null, $context = null)
    {
        SimpleLogger()->log('notice', $message, $context);
    }

    /**
     * Log a message, triggered by filter 'on_filter_simple_history_log_info'.
     *
     * @param string $message The message to log.
     * @param array  $context The context (optional).
     */
    public function on_filter_simple_history_log_info($message = null, $context = null)
    {
        SimpleLogger()->log('info', $message, $context);
    }

    /**
     * Log a message, triggered by filter 'on_filter_simple_history_log_debug'.
     *
     * @param string $message The message to log.
     * @param array  $context The context (optional).
     */
    public function on_filter_simple_history_log_debug($message = null, $context = null)
    {
        SimpleLogger()->log('debug', $message, $context);
    }

    /**
     * @since 2.5.2
     */
    private function add_admin_actions()
    {
        add_action('admin_menu', [$this, 'add_admin_pages']);
        add_action('admin_menu', [$this, 'add_settings']);

        add_action('admin_footer', [$this, 'add_js_templates']);

        add_action('wp_dashboard_setup', [$this, 'add_dashboard_widget']);

        add_action('admin_enqueue_scripts', [$this, 'enqueue_admin_scripts']);

        add_action('admin_head', [$this, 'onAdminHead']);
        add_action('admin_footer', [$this, 'onAdminFooter']);

        add_action('simple_history/history_page/before_gui', [$this, 'output_quick_stats']);
        add_action('simple_history/dashboard/before_gui', [$this, 'output_quick_stats']);

        add_action('wp_ajax_simple_history_api', [$this, 'api']);

        add_filter('plugin_action_links_simple-history/index.php', [$this, 'plugin_action_links'], 10, 4);
    }

    /**
     * Adds a "View history" item/shortcut to the network admin, on blogs where Simple History is installed
     *
     * Useful because Simple History is something at least the author of this plugin often use on a site :)
     *
     * @since 2.7.1
     */
    public function add_admin_bar_network_menu_item($wp_admin_bar)
    {
        /**
         * Filter to control if admin bar shortcut should be added
         *
         * @since 2.7.1
         *
         * @param bool Add item
         */
        $add_items = apply_filters('simple_history/add_admin_bar_network_menu_item', true);

        if (!$add_items) {
            return;
        }

        // Don't show for logged out users or single site mode.
        if (!is_user_logged_in() || !is_multisite()) {
            return;
        }

        // Show only when the user has at least one site, or they're a super admin.
        if (count($wp_admin_bar->user->blogs) < 1 && !is_super_admin()) {
            return;
        }

        // Setting to show as page must be true
        if (!$this->setting_show_as_page()) {
            return;
        }

        // User must have capability to view the history page
        if (!current_user_can($this->get_view_history_capability())) {
            return;
        }

        /*
         menu_page_url() is defined in the WordPress Plugin Administration API, which is not loaded here by default */
        /* dito for is_plugin_active() */
        require_once ABSPATH . 'wp-admin/includes/plugin.php';

        foreach ((array) $wp_admin_bar->user->blogs as $blog) {
            switch_to_blog($blog->userblog_id);

            if (is_plugin_active(SIMPLE_HISTORY_BASENAME)) {
                $menu_id = 'simple-history-blog-' . $blog->userblog_id;
                $parent_menu_id = 'blog-' . $blog->userblog_id;
                $url = admin_url(
                    apply_filters('simple_history/admin_location', 'index') . '.php?page=simple_history_page'
                );

                // Each network site is added by WP core with id "blog-1", "blog-2" ... "blog-n"
                // https://codex.wordpress.org/Function_Reference/add_node
                $args = [
                    'id' => $menu_id,
                    'parent' => $parent_menu_id,
                    'title' => _x('View History', 'Admin bar network name', 'simple-history'),
                    'href' => $url,
                    'meta' => [
                        'class' => 'ab-item--simplehistory',
                    ],
                ];

                $wp_admin_bar->add_node($args);
            } // End if().

            restore_current_blog();
        } // End foreach().
    }

    /**
     * Adds a "View history" item/shortcut to the admin bar
     *
     * Useful because Simple History is something at least the author of this plugin often use on a site :)
     *
     * @since 2.7.1
     */
    public function add_admin_bar_menu_item($wp_admin_bar)
    {
        /**
         * Filter to control if admin bar shortcut should be added
         *
         * @since 2.7.1
         *
         * @param bool Add item
         */
        $add_item = apply_filters('simple_history/add_admin_bar_menu_item', true);

        if (!$add_item) {
            return;
        }

        // Don't show for logged out users
        if (!is_user_logged_in()) {
            return;
        }

        // Setting to show as page must be true
        if (!$this->setting_show_as_page()) {
            return;
        }

        // User must have capability to view the history page
        if (!current_user_can($this->get_view_history_capability())) {
            return;
        }

        /* menu_page_url() and is_plugin_active()is defined in the WordPress Plugin Administration API, which is not loaded here by default */
        require_once ABSPATH . 'wp-admin/includes/plugin.php';

        $menu_id = 'simple-history-view-history';
        $parent_menu_id = 'site-name';
        $url = admin_url(apply_filters('simple_history/admin_location', 'index') . '.php?page=simple_history_page');

        $args = [
            'id' => $menu_id,
            'parent' => $parent_menu_id,
            'title' => _x('Simple History', 'Admin bar name', 'simple-history'),
            'href' => $url,
            'meta' => [
                'class' => 'ab-item--simplehistory',
            ],
        ];

        $wp_admin_bar->add_node($args);
    }

    /**
     * Get singleton intance
     *
     * @return SimpleHistory instance
     */
    public static function get_instance()
    {
        if (!isset(self::$instance)) {
            self::$instance = new SimpleHistory();
        }

        return self::$instance;
    }

    public function filter_gettext_storeLatestTranslations($translation, $text, $domain)
    {
        // Check that translation is a string or integer, i.ex. the valid values for an array key
        if (!is_string($translation) || !is_integer($translation)) {
            return $translation;
        }

        $array_max_size = 5;

        // Keep a listing of the n latest translation
        // when SimpleLogger->log() is called from anywhere we can then search for the
        // translated string among our n latest things and find it there, if it's translated
        // global $sh_latest_translations;
        $sh_latest_translations = $this->gettextLatestTranslations;

        $sh_latest_translations[$translation] = [
            'translation' => $translation,
            'text' => $text,
            'domain' => $domain,
        ];

        $arr_length = sizeof($sh_latest_translations);
        if ($arr_length > $array_max_size) {
            $sh_latest_translations = array_slice($sh_latest_translations, $arr_length - $array_max_size);
        }

        $this->gettextLatestTranslations = $sh_latest_translations;

        return $translation;
    }

    public function setup_cron()
    {
        add_filter('simple_history/maybe_purge_db', [$this, 'maybe_purge_db']);

        if (!wp_next_scheduled('simple_history/maybe_purge_db')) {
            wp_schedule_event(time(), 'daily', 'simple_history/maybe_purge_db');
        } else {
        }

        // Remove old schedule (only author dev sites should have it)
        $old_next_scheduled = wp_next_scheduled('simple_history/purge_db');
        if ($old_next_scheduled) {
            wp_unschedule_event($old_next_scheduled, 'simple_history/purge_db');
        }
    }

    public function onAdminHead()
    {
        if ($this->is_on_our_own_pages()) {
            do_action('simple_history/admin_head', $this);
        }
    }

    public function onAdminFooter()
    {
        if ($this->is_on_our_own_pages()) {
            do_action('simple_history/admin_footer', $this);
        }
    }

    /**
     * Output JS templated into footer
     */
    public function add_js_templates($hook)
    {
        if ($this->is_on_our_own_pages()) { ?>
            <script type="text/html" id="tmpl-simple-history-base">

                <div class="SimpleHistory__waitingForFirstLoad">
                    <img src="<?php echo admin_url('/images/spinner.gif'); ?>" alt="" width="20" height="20">
                    <?php echo _x(
                        'Loading history...',
                        'Message visible while waiting for log to load from server the first time',
                        'simple-history'
                    ); ?>
                </div>

                <div class="SimpleHistoryLogitemsWrap">
                    <div class="SimpleHistoryLogitems__beforeTopPagination"></div>
                    <div class="SimpleHistoryLogitems__above"></div>
                    <ul class="SimpleHistoryLogitems"></ul>
                    <div class="SimpleHistoryLogitems__below"></div>
                    <div class="SimpleHistoryLogitems__pagination"></div>
                    <div class="SimpleHistoryLogitems__afterBottomPagination"></div>
                </div>

                <div class="SimpleHistoryLogitems__debug"></div>

            </script>

            <script type="text/html" id="tmpl-simple-history-logitems-pagination">

                <!-- this uses the (almost) the same html as WP does -->
                <div class="SimpleHistoryPaginationPages">
                    <!--
                    {{ data.page_rows_from }}–{{ data.page_rows_to }}
                    <span class="SimpleHistoryPaginationDisplayNum"> of {{ data.total_row_count }} </span>
                    -->
                    <span class="SimpleHistoryPaginationLinks">
                        <a
                            data-direction="first"
                            class="button SimpleHistoryPaginationLink SimpleHistoryPaginationLink--firstPage <# if ( data.api_args.paged <= 1 ) { #> disabled <# } #>"
                            title="{{ data.strings.goToTheFirstPage }}"
                            href="#">«</a>
                        <a
                            data-direction="prev"
                            class="button SimpleHistoryPaginationLink SimpleHistoryPaginationLink--prevPage <# if ( data.api_args.paged <= 1 ) { #> disabled <# } #>"
                            title="{{ data.strings.goToThePrevPage }}"
                            href="#">‹</a>
                        <span class="SimpleHistoryPaginationInput">
                            <input class="SimpleHistoryPaginationCurrentPage" title="{{ data.strings.currentPage }}" type="text" name="paged" value="{{ data.api_args.paged }}" size="4">
                            <?php _x('of', 'page n of n', 'simple-history'); ?>
                            <span class="total-pages">{{ data.pages_count }}</span>
                        </span>
                        <a
                            data-direction="next"
                            class="button SimpleHistoryPaginationLink SimpleHistoryPaginationLink--nextPage <# if ( data.api_args.paged >= data.pages_count ) { #> disabled <# } #>"
                            title="{{ data.strings.goToTheNextPage }}"
                            href="#">›</a>
                        <a
                            data-direction="last"
                            class="button SimpleHistoryPaginationLink SimpleHistoryPaginationLink--lastPage <# if ( data.api_args.paged >= data.pages_count ) { #> disabled <# } #>"
                            title="{{ data.strings.goToTheLastPage }}"
                            href="#">»</a>
                    </span>
                </div>

            </script>

            <script type="text/html" id="tmpl-simple-history-logitems-modal">

                <div class="SimpleHistory-modal">
                    <div class="SimpleHistory-modal__background"></div>
                    <div class="SimpleHistory-modal__content">
                        <div class="SimpleHistory-modal__contentInner">
                            <img class="SimpleHistory-modal__contentSpinner" src="<?php echo esc_url(admin_url('/images/spinner.gif')); ?>" alt="">
                        </div>
                        <div class="SimpleHistory-modal__contentClose">
                            <button class="button">✕</button>
                        </div>
                    </div>
                </div>

            </script>

            <script type="text/html" id="tmpl-simple-history-occasions-too-many">
                <li
                    class="SimpleHistoryLogitem
                           SimpleHistoryLogitem--occasion
                           SimpleHistoryLogitem--occasion-tooMany
                           ">
                    <div class="SimpleHistoryLogitem__firstcol"></div>
                    <div class="SimpleHistoryLogitem__secondcol">
                        <div class="SimpleHistoryLogitem__text">
                            <?php _e('Sorry, but there are too many similar events to show.', 'simple-history'); ?>
                        </div>
                    </div>
                </li>
            </script>

            <?php
            // Call plugins so they can add their js.
            foreach ($this->instantiatedLoggers as $one_logger) {
                if (method_exists($one_logger['instance'], 'adminJS')) {
                    $one_logger['instance']->adminJS();
                }
            }
        }
    }

    /**
     * Base url is:
     * /wp-admin/admin-ajax.php?action=simple_history_api
     *
     * Examples:
     * http://playground-root.ep/wp-admin/admin-ajax.php?action=simple_history_api&posts_per_page=5&paged=1&format=html
     */
    public function api()
    {
        global $wpdb;

        // Fake slow answers
        // sleep(2);
        // sleep(rand(0,3));
        $args = $_GET;
        unset($args['action']);

        // Type = overview | ...
        $type = isset($_GET['type']) ? $_GET['type'] : null;

        if (empty($args) || !$type) {
            wp_send_json_error([
                _x('Not enough args specified', 'API: not enought arguments passed', 'simple-history'),
            ]);
        }

        // User must have capability to view the history page
        if (!current_user_can($this->get_view_history_capability())) {
            wp_send_json_error([
                'error' => 'CAPABILITY_ERROR',
            ]);
        }

        if (isset($args['id'])) {
            $args['post__in'] = [$args['id']];
        }

        $data = [];

        switch ($type) {
            case 'overview':
            case 'occasions':
            case 'single':
                // API use SimpleHistoryLogQuery, so simply pass args on to that
                $logQuery = new SimpleHistoryLogQuery();
                $data = $logQuery->query($args);

                $data['api_args'] = $args;

                // Output can be array or HMTL
                if (isset($args['format']) && 'html' === $args['format']) {
                    $data['log_rows_raw'] = [];

                    foreach ($data['log_rows'] as $key => $oneLogRow) {
                        $args = [];
                        if ($type == 'single') {
                            $args['type'] = 'single';
                        }

                        $data['log_rows'][$key] = $this->getLogRowHTMLOutput($oneLogRow, $args);
                        $data['num_queries'] = get_num_queries();
                    }
                } else {
                    // $data["logRows"] = $logRows;
                }

                break;

            default:
                $data[] = 'Nah.';
        } // End switch().

        wp_send_json_success($data);
    }

    /**
     * During the load of info for a logger we want to get a reference
     * to the untranslated text too, because that's the version we want to store
     * in the database.
     */
    public function filter_gettext($translated_text, $untranslated_text, $domain)
    {
        if (isset($this->doFilterGettext) && $this->doFilterGettext) {
            $this->doFilterGettext_currentLogger->messages[] = [
                'untranslated_text' => $untranslated_text,
                'translated_text' => $translated_text,
                'domain' => $domain,
                'context' => null,
            ];
        }

        return $translated_text;
    }

    /**
     * Store messages with context
     */
    public function filter_gettext_with_context($translated_text, $untranslated_text, $context, $domain)
    {
        if (isset($this->doFilterGettext) && $this->doFilterGettext) {
            $this->doFilterGettext_currentLogger->messages[] = [
                'untranslated_text' => $untranslated_text,
                'translated_text' => $translated_text,
                'domain' => $domain,
                'context' => $context,
            ];
        }

        return $translated_text;
    }

    /**
     * Load language files.
     * Uses the method described here:
     * http://geertdedeckere.be/article/loading-wordpress-language-files-the-right-way
     *
     * @since 2.0
     */
    public function load_plugin_textdomain()
    {
        $domain = 'simple-history';

        // The "plugin_locale" filter is also used in load_plugin_textdomain()
        $locale = apply_filters('plugin_locale', get_locale(), $domain);
        load_textdomain($domain, WP_LANG_DIR . '/simple-history/' . $domain . '-' . $locale . '.mo');
        load_plugin_textdomain($domain, false, dirname($this->plugin_basename) . '/languages/');
    }

    /**
     * Setup variables and things
     */
    public function setup_variables()
    {
        $this->externalLoggers = [];
        $this->externalDropins = [];
        $this->instantiatedLoggers = [];
        $this->instantiatedDropins = [];

        $this->plugin_basename = SIMPLE_HISTORY_BASENAME;
    }

    /**
     * Return capability required to view history = for who will the History page be added
     *
     * @since 2.1.5
     * @return string capability
     */
    public function get_view_history_capability()
    {
        $view_history_capability = 'edit_pages';
        $view_history_capability = apply_filters('simple_history_view_history_capability', $view_history_capability);
        $view_history_capability = apply_filters('simple_history/view_history_capability', $view_history_capability);

        return $view_history_capability;
    }

    /**
     * Return capability required to view settings
     *
     * @since 2.1.5
     * @return string capability
     */
    public function get_view_settings_capability()
    {
        $view_settings_capability = 'manage_options';
        $view_settings_capability = apply_filters('simple_history_view_settings_capability', $view_settings_capability);
        $view_settings_capability = apply_filters('simple_history/view_settings_capability', $view_settings_capability);

        return $view_settings_capability;
    }

    /**
     * Check if the current user can clear the log
     *
     * @since 2.19
     * @return bool
     */
    public function user_can_clear_log()
    {
        $user_can_clear_log = apply_filters('simple_history/user_can_clear_log', true);

        return $user_can_clear_log;
    }

    /**
     * Adds default tabs to settings
     */
    public function add_default_settings_tabs()
    {
        // Add default settings tabs
        $this->arr_settings_tabs = [
            [
                'slug' => 'settings',
                'name' => __('Settings', 'simple-history'),
                'function' => [$this, 'settings_output_general'],
            ],
        ];

        if (defined('SIMPLE_HISTORY_DEV') && SIMPLE_HISTORY_DEV) {
            $arr_dev_tabs = [
                [
                    'slug' => 'log',
                    'name' => __('Log (debug)', 'simple-history'),
                    'function' => [$this, 'settings_output_log'],
                ],
                [
                    'slug' => 'styles-example',
                    'name' => __('Styles example (debug)', 'simple-history'),
                    'function' => [$this, 'settings_output_styles_example'],
                ],
            ];

            $this->arr_settings_tabs = array_merge($this->arr_settings_tabs, $arr_dev_tabs);
        }
    }

    /**
     * Register an external logger so Simple History knows about it.
     * Does not load the logger, so file with logger class must be loaded already.
     *
     * See example-logger.php for an example on how to use this.
     *
     * @since 2.1
     */
    public function register_logger($loggerClassName)
    {
        $this->externalLoggers[] = $loggerClassName;
    }

    /**
     * Register an external dropin so Simple History knows about it.
     * Does not load the dropin, so file with dropin class must be loaded already.
     *
     * See example-dropin.php for an example on how to use this.
     *
     * @since 2.1
     */
    public function register_dropin($dropinClassName)
    {
        $this->externalDropins[] = $dropinClassName;
    }

    /**
     * Load built in loggers from all files in /loggers
     * and instantiates them
     */
    public function load_loggers()
    {
        $loggersDir = SIMPLE_HISTORY_PATH . 'loggers/';

        // SimpleLogger.php must be loaded first and always since the other loggers extend it.
        // Load it manually so no risk of anyone using filters or similar disables it.
        // Also load files that contain constants used by the SimpleLogger.
        include_once $loggersDir . 'SimpleLogger.php';
        include_once $loggersDir . 'SimpleLoggerLogInitiators.php';
        include_once $loggersDir . 'SimpleLoggerLogTypes.php';
        include_once $loggersDir . 'SimpleLoggerLogLevels.php';

        // Bail if we are not in filter after_setup_theme,
        // i.e. we are probably calling SimpleLogger() early.
        if (!doing_action('after_setup_theme')) {
            return;
        }

        $loggersFiles = [
            // Main loggers.
            $loggersDir . 'SimpleCommentsLogger.php',
            $loggersDir . 'SimpleCoreUpdatesLogger.php',
            $loggersDir . 'SimpleExportLogger.php',
            $loggersDir . 'SimpleLegacyLogger.php',
            $loggersDir . 'SimpleLogger.php',
            $loggersDir . 'SimpleMediaLogger.php',
            $loggersDir . 'SimpleMenuLogger.php',
            $loggersDir . 'SimpleOptionsLogger.php',
            $loggersDir . 'SimplePluginLogger.php',
            $loggersDir . 'SimplePostLogger.php',
            $loggersDir . 'SimpleThemeLogger.php',
            $loggersDir . 'SimpleUserLogger.php',
            $loggersDir . 'SimpleCategoriesLogger.php',
            $loggersDir . 'AvailableUpdatesLogger.php',
            $loggersDir . 'FileEditsLogger.php',
            $loggersDir . 'class-sh-privacy-logger.php',
            $loggersDir . 'class-sh-translations-logger.php',
            $loggersDir . 'class-sh-jetpack-logger.php',

            // Loggers for third party plugins.
            $loggersDir . 'PluginUserSwitchingLogger.php',
            $loggersDir . 'PluginWPCrontrolLogger.php',
            $loggersDir . 'PluginEnableMediaReplaceLogger.php',
            $loggersDir . 'Plugin_UltimateMembers_Logger.php',
            $loggersDir . 'Plugin_LimitLoginAttempts.php',
            $loggersDir . 'Plugin_Redirection.php',
            $loggersDir . 'Plugin_DuplicatePost.php',
            $loggersDir . 'Plugin_ACF.php',
            $loggersDir . 'Plugin_BeaverBuilder.php',
        ];

        /**
         * Filter the array with absolute paths to logger files to be loaded.
         *
         * Each file will be loaded and will be assumed to be a logger with a classname
         * the same as the filename.
         *
         * @since 2.0
         *
         * @param array $loggersFiles Array with filenames
         */
        $loggersFiles = apply_filters('simple_history/loggers_files', $loggersFiles);

        // Array with slug of loggers to instantiate.
        // Slug of logger must also be the name of the logger class.
        $arr_loggers_to_instantiate = [];

        // $one_logger_file = "SimpleCommentsLogger.php", "class-privacy-logger.php", and so on.
        foreach ($loggersFiles as $one_logger_file) {
            $load_logger = true;

            // SimpleCommentsLogger.php -> SimpleCommentsLogger.
            // class-privacy-logger.php -> class-privacy-logger.
            $basename_no_suffix = basename($one_logger_file, '.php');

            /**
             * Filter to completely skip loading of a logger
             *
             * @since 2.0.22
             *
             * @param bool if to load the logger. return false to not load it.
             * @param string basename of logger, i.e. "SimpleCommentsLogger" or "class-privacy-logger"
             */
            $load_logger = apply_filters('simple_history/logger/load_logger', $load_logger, $basename_no_suffix);

            // If logger was SimpleLogger then force it to be loaded because for example
            // custom extended plugins added later probably depends on it.
            if ('SimpleLogger' === $basename_no_suffix) {
                $load_logger = true;
            }

            if (!$load_logger) {
                continue;
            }

            include_once $one_logger_file;

            $arr_loggers_to_instantiate[] = $basename_no_suffix;
        }

        /**
         * Action that plugins can use to add their custom loggers.
         * See register_logger() for more info.
         *
         * @since 2.1
         *
         * @param SimpleHistory instance
         */
        do_action('simple_history/add_custom_logger', $this);

        $arr_loggers_to_instantiate = array_merge($arr_loggers_to_instantiate, $this->externalLoggers);

        /**
         * Filter the array with names of loggers to instantiate.
         *
         * Array
         * (
         *  [0] => SimpleCommentsLogger
         *  [1] => SimpleCoreUpdatesLogger
         *   ...
         * )
         *
         * @since 2.0
         *
         * @param array $arr_loggers_to_instantiate Array with class names
         */
        $arr_loggers_to_instantiate = apply_filters(
            'simple_history/loggers_to_instantiate',
            $arr_loggers_to_instantiate
        );

        // Instantiate each logger.
        foreach ($arr_loggers_to_instantiate as $one_logger_name) {
            // Detect logger class name.
            $logger_class_name = null;

            if (class_exists($one_logger_name)) {
                // Logger name is "SimpleCommentsLogger".
                $logger_class_name = $one_logger_name;
            } else {
                // Check if class is "class-privacy-logger".
                $logger_snaked_name = substr($one_logger_name, 6);
                // "privacy-logger" -> "privacy_logger" -> Privacy_Logger
                $logger_snaked_name = str_replace('-', '_', $logger_snaked_name);
                $logger_snaked_name = sh_ucwords($logger_snaked_name, '_');

                if (class_exists($logger_snaked_name)) {
                    $logger_class_name = $logger_snaked_name;
                }
            }

            // Continue to load next logger if no valid logger class found.
            if (!$logger_class_name) {
                continue;
            }

            // Init found logger class.
            $logger_instance = new $logger_class_name($this);

            if (!is_subclass_of($logger_instance, 'SimpleLogger') && !is_a($logger_instance, 'SimpleLogger')) {
                continue;
            }

            $logger_instance->loaded();

            // Tell gettext-filter to add untranslated messages.
            $this->doFilterGettext = true;
            $this->doFilterGettext_currentLogger = $logger_instance;

            $logger_info = $logger_instance->getInfo();

            // Check so no logger has a logger slug with more than 30 chars,
            // because db column is only 30 chars.
            if (strlen($logger_instance->slug) > 30) {
                add_action('admin_notices', [$this, 'admin_notice_logger_slug_to_long']);
            }

            // Un-tell gettext filter.
            $this->doFilterGettext = false;
            $this->doFilterGettext_currentLogger = null;

            // LoggerInfo contains all messages, both translated an not, by key.
            // Add messages to the loggerInstance.
            $arr_messages_by_message_key = [];

            if (isset($logger_info['messages']) && is_array($logger_info['messages'])) {
                foreach ((array) $logger_info['messages'] as $message_key => $message_translated) {
                    // Find message in array with both translated and non translated strings.
                    foreach ($logger_instance->messages as $one_message_with_translation_info) {
                        if ($message_translated == $one_message_with_translation_info['translated_text']) {
                            $arr_messages_by_message_key[$message_key] = $one_message_with_translation_info;
                            continue;
                        }
                    }
                }
            }

            $logger_instance->messages = $arr_messages_by_message_key;

            // Add logger to array of loggers.
            $this->instantiatedLoggers[$logger_instance->slug] = [
                'name' => $logger_info['name'],
                'instance' => $logger_instance,
            ];
        } // End foreach().

        do_action('simple_history/loggers_loaded');
    }

    /**
     * Load built in dropins from all files in /dropins
     * and instantiates them
     */
    public function load_dropins()
    {
        $dropinsDir = SIMPLE_HISTORY_PATH . 'dropins/';

        $dropinsFiles = [
            $dropinsDir . 'SimpleHistoryPluginPatchesDropin.php',
            $dropinsDir . 'SimpleHistoryDonateDropin.php',
            $dropinsDir . 'SimpleHistoryExportDropin.php',
            $dropinsDir . 'SimpleHistoryFilterDropin.php',
            $dropinsDir . 'SimpleHistoryIpInfoDropin.php',
            $dropinsDir . 'SimpleHistoryNewRowsNotifier.php',
            $dropinsDir . 'SimpleHistoryRSSDropin.php',
            $dropinsDir . 'SimpleHistorySettingsLogtestDropin.php',
            $dropinsDir . 'SimpleHistorySettingsStatsDropin.php',
            $dropinsDir . 'SimpleHistorySettingsDebugDropin.php',
            $dropinsDir . 'SimpleHistorySidebarDropin.php',
            $dropinsDir . 'SimpleHistorySidebarStats.php',
            $dropinsDir . 'SimpleHistorySidebarSettings.php',
            $dropinsDir . 'SimpleHistoryWPCLIDropin.php',
            $dropinsDir . 'SimpleHistoryDebugDropin.php',
        ];

        /**
         * Filter the array with absolute paths to files as returned by glob function.
         * Each file will be loaded and will be assumed to be a dropin with a classname
         * the same as the filename.
         *
         * @since 2.0
         *
         * @param array $dropinsFiles Array with filenames
         */
        $dropinsFiles = apply_filters('simple_history/dropins_files', $dropinsFiles);

        $arrDropinsToInstantiate = [];

        foreach ($dropinsFiles as $oneDropinFile) {
            // path/path/simplehistory/dropins/SimpleHistoryDonateDropin.php => SimpleHistoryDonateDropin
            $oneDropinFileBasename = basename($oneDropinFile, '.php');

            $load_dropin = true;

            /**
             * Filter to completely skip loading of dropin
             * complete filer name will be like:
             * simple_history/dropin/load_dropin_SimpleHistoryRSSDropin
             *
             * @since 2.0.6
             *
             * @param bool if to load the dropin. return false to not load it.
             */
            $load_dropin = apply_filters("simple_history/dropin/load_dropin_{$oneDropinFileBasename}", $load_dropin);

            /**
             * Filter to completely skip loading of a dropin
             *
             * @since 2.0.22
             *
             * @param bool if to load the dropin. return false to not load it.
             * @param string slug of dropin
             */
            $load_dropin = apply_filters('simple_history/dropin/load_dropin', $load_dropin, $oneDropinFileBasename);

            if (!$load_dropin) {
                continue;
            }

            include_once $oneDropinFile;

            $arrDropinsToInstantiate[] = $oneDropinFileBasename;
        } // End foreach().

        /**
         * Action that dropins can use to add their custom loggers.
         * See register_dropin() for more info.
         *
         * @since 2.3.2
         *
         * @param array $arrDropinsToInstantiate Array with class names
         */
        do_action('simple_history/add_custom_dropin', $this);

        /**
         * Filter the array with names of dropin to instantiate.
         *
         * @since 2.0
         *
         * @param array $arrDropinsToInstantiate Array with class names
         */
        $arrDropinsToInstantiate = apply_filters('simple_history/dropins_to_instantiate', $arrDropinsToInstantiate);

        $arrDropinsToInstantiate = array_merge($arrDropinsToInstantiate, $this->externalDropins);

        // Instantiate each dropin
        foreach ($arrDropinsToInstantiate as $oneDropinName) {
            if (!class_exists($oneDropinName)) {
                continue;
            }

            $this->instantiatedDropins[$oneDropinName] = [
                'name' => $oneDropinName,
                'instance' => new $oneDropinName($this),
            ];
        }
    }

    /**
     * Gets the pager size,
     * i.e. the number of items to show on each page in the history
     *
     * @return int
     */
    public function get_pager_size()
    {
        $pager_size = get_option('simple_history_pager_size', 20);

        /**
         * Filter the pager size setting
         *
         * @since 2.0
         *
         * @param int $pager_size
         */
        $pager_size = apply_filters('simple_history/pager_size', $pager_size);

        return $pager_size;
    }

    /**
     * Gets the pager size,
     * i.e. the number of items to show on each page in the history
     *
     * @since 2.12
     * @return int
     */
    public function get_pager_size_dashboard()
    {
        $pager_size = get_option('simple_history_pager_size_dashboard', 5);

        /**
         * Filter the pager size setting
         *
         * @since 2.12
         *
         * @param int $pager_size
         */
        $pager_size = apply_filters('simple_history/pager_size_dashboard', $pager_size);

        return $pager_size;
    }

    /**
     * Show a link to our settings page on the Plugins -> Installed Plugins screen
     */
    public function plugin_action_links($actions, $b, $c, $d)
    {
        // Only add link if user has the right to view the settings page
        if (!current_user_can($this->get_view_settings_capability())) {
            return $actions;
        }

        $settings_page_url = menu_page_url(SimpleHistory::SETTINGS_MENU_SLUG, 0);

        if (empty($actions)) {
            // Create array if actions is empty (and therefore is assumed to be a string by PHP & results in PHP 7.1+ fatal error due to trying to make array modifications on what's assumed to be a string)
            $actions = [];
        } elseif (is_string($actions)) {
            // Convert the string (which it might've been retrieved as) to an array for future use as an array
            $actions = [$actions];
        }
        $actions[] = "<a href='$settings_page_url'>" . __('Settings', 'simple-history') . '</a>';

        return $actions;
    }

    /**
     * Maybe add a dashboard widget,
     * requires current user to have view history capability
     * and a setting to show dashboard to be set
     */
    public function add_dashboard_widget()
    {
        if ($this->setting_show_on_dashboard() && current_user_can($this->get_view_history_capability())) {
            /**
             * Filter to determine if history page should be added to page below dashboard or not
             *
             * @since 2.0.23
             *
             * @param bool Show the page or not
             */
            $show_dashboard_widget = apply_filters('simple_history/show_dashboard_widget', true);

            if ($show_dashboard_widget) {
                wp_add_dashboard_widget('simple_history_dashboard_widget', __('Simple History', 'simple-history'), [
                    $this,
                    'dashboard_widget_output',
                ]);
            }
        }
    }

    /**
     * Output html for the dashboard widget
     */
    public function dashboard_widget_output()
    {
        $pager_size = $this->get_pager_size_dashboard();

        /**
         * Filter the pager size setting for the dashboard
         *
         * @since 2.0
         *
         * @param int $pager_size
         */
        $pager_size = apply_filters('simple_history/dashboard_pager_size', $pager_size);

        do_action('simple_history/dashboard/before_gui', $this);
        ?>
        <div class="SimpleHistoryGui"
             data-pager-size='<?php echo $pager_size; ?>'
             ></div>
        <?php
    }

    public function is_on_our_own_pages($hook = '')
    {
        $current_screen = get_current_screen();

        $basePrefix = apply_filters('simple_history/admin_location', 'index');
        $basePrefix = $basePrefix === 'index' ? 'dashboard' : $basePrefix;

        if ($current_screen && $current_screen->base == 'settings_page_' . SimpleHistory::SETTINGS_MENU_SLUG) {
            return true;
        } elseif ($current_screen && $current_screen->base == $basePrefix . '_page_simple_history_page') {
            return true;
        } elseif (
            $hook == 'settings_page_' . SimpleHistory::SETTINGS_MENU_SLUG ||
            ($this->setting_show_on_dashboard() && $hook == 'index.php') ||
            ($this->setting_show_as_page() && $hook == $basePrefix . '_page_simple_history_page')
        ) {
            return true;
        } elseif ($current_screen && $current_screen->base == 'dashboard' && $this->setting_show_on_dashboard()) {
            return true;
        }

        return false;
    }

    /**
     * Enqueue styles and scripts for Simple History but only to our own pages.
     *
     * Only adds scripts to pages where the log is shown or the settings page.
     */
    public function enqueue_admin_scripts($hook)
    {
        if ($this->is_on_our_own_pages()) {
            add_thickbox();

            wp_enqueue_style(
                'simple_history_styles',
                SIMPLE_HISTORY_DIR_URL . 'css/styles.css',
                false,
                SIMPLE_HISTORY_VERSION
            );
            wp_enqueue_script(
                'simple_history_script',
                SIMPLE_HISTORY_DIR_URL . 'js/scripts.js',
                ['jquery', 'backbone', 'wp-util'],
                SIMPLE_HISTORY_VERSION,
                true
            );

            wp_enqueue_script('select2', SIMPLE_HISTORY_DIR_URL . 'js/select2/select2.full.min.js', ['jquery']);
            wp_enqueue_style('select2', SIMPLE_HISTORY_DIR_URL . 'js/select2/select2.min.css');

            // Translations that we use in JavaScript
            wp_localize_script('simple_history_script', 'simple_history_script_vars', [
                'settingsConfirmClearLog' => __('Remove all log items?', 'simple-history'),
                'pagination' => [
                    'goToTheFirstPage' => __('Go to the first page', 'simple-history'),
                    'goToThePrevPage' => __('Go to the previous page', 'simple-history'),
                    'goToTheNextPage' => __('Go to the next page', 'simple-history'),
                    'goToTheLastPage' => __('Go to the last page', 'simple-history'),
                    'currentPage' => __('Current page', 'simple-history'),
                ],
                'loadLogAPIError' => __('Oups, the log could not be loaded right now.', 'simple-history'),
                'ajaxLoadError' => __(
                    'Hm, the log could not be loaded right now. Perhaps another plugin is giving some errors. Anyway, below is the output I got from the server.',
                    'simple-history'
                ),
                'logNoHits' => __('Your search did not match any history events.', 'simple-history'),
            ]);

            // Call plugins adminCSS-method, so they can add their CSS
            foreach ($this->instantiatedLoggers as $one_logger) {
                if (method_exists($one_logger['instance'], 'adminCSS')) {
                    $one_logger['instance']->adminCSS();
                }
            }

            // Add timeago.js
            wp_enqueue_script(
                'timeago',
                SIMPLE_HISTORY_DIR_URL . 'js/timeago/jquery.timeago.js',
                ['jquery'],
                '1.5.2',
                true
            );

            // Determine current locale to load timeago locale
            $locale = strtolower(substr(get_locale(), 0, 2));
            $locale_url_path = SIMPLE_HISTORY_DIR_URL . 'js/timeago/locales/jquery.timeago.%s.js';
            $locale_dir_path = SIMPLE_HISTORY_PATH . 'js/timeago/locales/jquery.timeago.%s.js';

            // Only enqueue if locale-file exists on file system
            if (file_exists(sprintf($locale_dir_path, $locale))) {
                wp_enqueue_script('timeago-locale', sprintf($locale_url_path, $locale), ['jquery'], '1.5.2', true);
            } else {
                wp_enqueue_script('timeago-locale', sprintf($locale_url_path, 'en'), ['jquery'], '1.5.2', true);
            }
            // end add timeago
            // Load Select2 locale
            $locale_url_path = SIMPLE_HISTORY_DIR_URL . 'js/select2/i18n/%s.js';
            $locale_dir_path = SIMPLE_HISTORY_PATH . 'js/select2/i18n/%s.js';

            if (file_exists(sprintf($locale_dir_path, $locale))) {
                wp_enqueue_script('select2-locale', sprintf($locale_url_path, $locale), ['jquery'], '3.5.1', true);
            }

            /**
             * Fires when the admin scripts have been enqueued.
             * Only fires on any of the pages where Simple History is used
             *
             * @since 2.0
             *
             * @param SimpleHistory $SimpleHistory This class.
             */
            do_action('simple_history/enqueue_admin_scripts', $this);
        } // End if().
    }

    public function filter_option_page_capability($capability)
    {
        return $capability;
    }

    /**
     * Check if plugin version have changed, i.e. has been upgraded
     * If upgrade is detected then maybe modify database and so on for that version
     */
    public function check_for_upgrade()
    {
        global $wpdb;

        $db_version = get_option('simple_history_db_version');
        $table_name = $wpdb->prefix . SimpleHistory::DBTABLE;
        $table_name_contexts = $wpdb->prefix . SimpleHistory::DBTABLE_CONTEXTS;
        $first_install = false;

        // If no db_version is set then this
        // is a version of Simple History < 0.4
        // or it's a first install
        // Fix database not using UTF-8
        if (false === $db_version || intval($db_version) == 0) {
            require_once ABSPATH . 'wp-admin/includes/upgrade.php';

            // Table creation, used to be in register_activation_hook
            // We change the varchar size to add one num just to force update of encoding. dbdelta didn't see it otherwise.
            $sql =
                'CREATE TABLE ' .
                $table_name .
                ' (
              id bigint(20) NOT NULL AUTO_INCREMENT,
              date datetime NOT NULL,
              PRIMARY KEY  (id)
            ) CHARACTER SET=utf8;';

            // Upgrade db / fix utf for varchars
            dbDelta($sql);

            // Fix UTF-8 for table
            $sql = sprintf('alter table %1$s charset=utf8;', $table_name);
            $wpdb->query($sql);

            $db_version_prev = $db_version;
            $db_version = 1;

            update_option('simple_history_db_version', $db_version);

            // We are not 100% sure that this is a first install,
            // but it is at least a very old version that is being updated
            $first_install = true;
        } // End if().

        // If db version is 1 then upgrade to 2
        // Version 2 added the action_description column
        if (1 == intval($db_version)) {
            // V2 used to add column "action_description"
            // but it's not used any more so don't do i
            $db_version_prev = $db_version;
            $db_version = 2;

            update_option('simple_history_db_version', $db_version);
        }

        // Check that all options we use are set to their defaults, if they miss value
        // Each option that is missing a value will make a sql call otherwise = unnecessary
        $arr_options = [
            [
                'name' => 'simple_history_show_as_page',
                'default_value' => 1,
            ],
            [
                'name' => 'simple_history_show_on_dashboard',
                'default_value' => 1,
            ],
        ];

        foreach ($arr_options as $one_option) {
            if (false === ($option_value = get_option($one_option['name']))) {
                // Value is not set in db, so set it to a default
                update_option($one_option['name'], $one_option['default_value']);
            }
        }

        /**
         * If db_version is 2 then upgrade to 3:
         * - Add some fields to existing table wp_simple_history_contexts
         * - Add all new table wp_simple_history_contexts
         *
         * @since 2.0
         */
        if (2 == intval($db_version)) {
            require_once ABSPATH . 'wp-admin/includes/upgrade.php';

            // Update old table
            $sql = "
                CREATE TABLE {$table_name} (
                  id bigint(20) NOT NULL AUTO_INCREMENT,
                  date datetime NOT NULL,
                  logger varchar(30) DEFAULT NULL,
                  level varchar(20) DEFAULT NULL,
                  message varchar(255) DEFAULT NULL,
                  occasionsID varchar(32) DEFAULT NULL,
                  initiator varchar(16) DEFAULT NULL,
                  PRIMARY KEY  (id),
                  KEY date (date),
                  KEY loggerdate (logger,date)
                ) CHARSET=utf8;";

            dbDelta($sql);

            // Add context table
            $sql = "
                CREATE TABLE IF NOT EXISTS {$table_name_contexts} (
                  context_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
                  history_id bigint(20) unsigned NOT NULL,
                  `key` varchar(255) DEFAULT NULL,
                  value longtext,
                  PRIMARY KEY  (context_id),
                  KEY history_id (history_id),
                  KEY `key` (`key`)
                ) CHARSET=utf8;
            ";

            $wpdb->query($sql);

            $db_version_prev = $db_version;
            $db_version = 3;
            update_option('simple_history_db_version', $db_version);

            // Update possible old items to use SimpleLegacyLogger
            $sql = sprintf(
                '
                    UPDATE %1$s
                    SET
                        logger = "SimpleLegacyLogger",
                        level = "info"
                    WHERE logger IS NULL
                ',
                $table_name
            );

            $wpdb->query($sql);

            // Say welcome, however loggers are not added this early so we need to
            // use a filter to load it later
            add_action('simple_history/loggers_loaded', [$this, 'addWelcomeLogMessage']);
        } // End if().

        /**
         * If db version = 3
         * then we need to update database to allow null values for some old columns
         * that used to work in pre wp 4.1 beta, but since 4.1 wp uses STRICT_ALL_TABLES
         * WordPress Commit: https://github.com/WordPress/WordPress/commit/f17d168a0f72211a9bfd9d3fa680713069871bb6
         *
         * @since 2.0
         */
        if (3 == intval($db_version)) {
            require_once ABSPATH . 'wp-admin/includes/upgrade.php';

            // If old columns exist = this is an old install, then modify the columns so we still can keep them
            // we want to keep them because user may have logged items that they want to keep
            $db_cools = $wpdb->get_col("DESCRIBE $table_name");

            if (in_array('action', $db_cools)) {
                $sql = sprintf(
                    '
                        ALTER TABLE %1$s
                        MODIFY `action` varchar(255) NULL,
                        MODIFY `object_type` varchar(255) NULL,
                        MODIFY `object_subtype` varchar(255) NULL,
                        MODIFY `user_id` int(10) NULL,
                        MODIFY `object_id` int(10) NULL,
                        MODIFY `object_name` varchar(255) NULL
                    ',
                    $table_name
                );
                $wpdb->query($sql);
            }

            $db_version_prev = $db_version;
            $db_version = 4;

            update_option('simple_history_db_version', $db_version);
        } // End if().

        // Some installs on 2.2.2 got failed installs
        // We detect these by checking for db_version and then running the install stuff again
        if (4 == intval($db_version)) {
            if (!$this->does_database_have_data()) {
                // not ok, decrease db number so installs will run again and hopefully fix things
                $db_version = 0;
            } else {
                // all looks ok, upgrade to db version 5, so this part is not done again
                $db_version = 5;
            }

            update_option('simple_history_db_version', $db_version);
        }
    }

    /**
     * Check if the database has data/rows
     *
     * @since 2.1.6
     * @return bool True if database is not empty, false if database is empty = contains no data
     */
    public function does_database_have_data()
    {
        global $wpdb;

        $tableprefix = $wpdb->prefix;

        $simple_history_table = SimpleHistory::DBTABLE;
        $simple_history_context_table = SimpleHistory::DBTABLE_CONTEXTS;

        $sql_data_exists = "SELECT id AS id_exists FROM {$tableprefix}{$simple_history_table} LIMIT 1";
        $data_exists = (bool) $wpdb->get_var($sql_data_exists, 0);

        return $data_exists;
    }

    /**
     * Greet users to version 2!
     * Is only called after database has been upgraded, so only on first install (or upgrade).
     * Not called after only plugin activation.
     */
    public function addWelcomeLogMessage()
    {
        $db_data_exists = $this->does_database_have_data();
        // $db_data_exists = false;
        $pluginLogger = $this->getInstantiatedLoggerBySlug('SimplePluginLogger');
        if ($pluginLogger) {
            // Add plugin installed message
            $context = [
                'plugin_name' => 'Simple History',
                'plugin_description' =>
                    'Plugin that logs various things that occur in WordPress and then presents those events in a very nice GUI.',
                'plugin_url' => 'https://simple-history.com',
                'plugin_version' => SIMPLE_HISTORY_VERSION,
                'plugin_author' => 'Pär Thernström',
            ];

            $pluginLogger->infoMessage('plugin_installed', $context);

            // Add plugin activated message
            $context['plugin_slug'] = 'simple-history';
            $context['plugin_title'] = '<a href="https://simple-history.com/">Simple History</a>';

            $pluginLogger->infoMessage('plugin_activated', $context);
        }

        if (!$db_data_exists) {
            $welcome_message_1 = __(
                '
Welcome to Simple History!

This is the main history feed. It will contain events that this plugin has logged.
',
                'simple-history'
            );

            $welcome_message_2 = __(
                '
Because Simple History was only recently installed, this feed does not display many events yet. As long as the plugin remains activated you will soon see detailed information about page edits, plugin updates, users logging in, and much more.
',
                'simple-history'
            );

            SimpleLogger()->info($welcome_message_2, [
                '_initiator' => SimpleLoggerLogInitiators::WORDPRESS,
            ]);

            SimpleLogger()->info($welcome_message_1, [
                '_initiator' => SimpleLoggerLogInitiators::WORDPRESS,
            ]);
        }
    }

    public function registerSettingsTab($arr_tab_settings)
    {
        $this->arr_settings_tabs[] = $arr_tab_settings;
    }

    public function getSettingsTabs()
    {
        return $this->arr_settings_tabs;
    }

    /**
     * Output HTML for the settings page
     * Called from add_options_page
     */
    public function settings_page_output()
    {
        $arr_settings_tabs = $this->getSettingsTabs(); ?>
        <div class="wrap">

            <h1 class="SimpleHistoryPageHeadline">
                <div class="dashicons dashicons-backup SimpleHistoryPageHeadline__icon"></div>
                <?php _e('Simple History Settings', 'simple-history'); ?>
            </h1>

            <?php
            $active_tab = isset($_GET['selected-tab']) ? $_GET['selected-tab'] : 'settings';
            $settings_base_url = menu_page_url(SimpleHistory::SETTINGS_MENU_SLUG, 0);
            ?>

            <h2 class="nav-tab-wrapper">
                <?php foreach ($arr_settings_tabs as $one_tab) {
                    $tab_slug = $one_tab['slug'];

                    printf(
                        '<a href="%3$s" class="nav-tab %4$s">%1$s</a>',
                        $one_tab['name'], // 1
                        $tab_slug, // 2
                        esc_url(add_query_arg('selected-tab', $tab_slug, $settings_base_url)), // 3
                        $active_tab == $tab_slug ? 'nav-tab-active' : '' // 4
                    );
                } ?>
            </h2>

            <?php
            // Output contents for selected tab
            $arr_active_tab = wp_filter_object_list($arr_settings_tabs, [
                'slug' => $active_tab,
            ]);
            $arr_active_tab = current($arr_active_tab);

            // We must have found an active tab and it must have a callable function
            if (!$arr_active_tab || !is_callable($arr_active_tab['function'])) {
                wp_die(__('No valid callback found', 'simple-history'));
            }

            $args = [
                'arr_active_tab' => $arr_active_tab,
            ];
            
            call_user_func_array($arr_active_tab['function'], array_values($args));
            ?>

        </div>
        <?php
    }

    public function settings_output_log()
    {
        include SIMPLE_HISTORY_PATH . 'templates/settings-log.php';
    }

    public function settings_output_general()
    {
        include SIMPLE_HISTORY_PATH . 'templates/settings-general.php';
    }

    public function settings_output_styles_example()
    {
        include SIMPLE_HISTORY_PATH . 'templates/settings-style-example.php';
    }

    /**
     * Content for section intro. Leave it be, even if empty.
     * Called from add_sections_setting.
     */
    public function settings_section_output()
    {
    }

    /**
     * Add pages (history page and settings page)
     */
    public function add_admin_pages()
    {
        // Add a history page as a sub-page below the Dashboard menu item
        if ($this->setting_show_as_page()) {
            /**
             * Filter to determine if history page should be added to page below dashboard or not
             *
             * @since 2.0.23
             *
             * @param bool Show the page or not
             */
            $show_dashboard_page = apply_filters('simple_history/show_dashboard_page', true);

            if ($show_dashboard_page) {
                add_submenu_page(
                    apply_filters('simple_history/admin_location', 'index') . '.php',
                    _x('Simple History', 'dashboard title name', 'simple-history'),
                    _x('Simple History', 'dashboard menu name', 'simple-history'),
                    $this->get_view_history_capability(),
                    'simple_history_page',
                    [$this, 'history_page_output']
                );
            }
        }

        // Add a settings page
        $show_settings_page = true;
        $show_settings_page = apply_filters('simple_history_show_settings_page', $show_settings_page);
        $show_settings_page = apply_filters('simple_history/show_settings_page', $show_settings_page);

        if ($show_settings_page) {
            add_options_page(
                __('Simple History Settings', 'simple-history'),
                _x('Simple History', 'Options page menu title', 'simple-history'),
                $this->get_view_settings_capability(),
                SimpleHistory::SETTINGS_MENU_SLUG,
                [$this, 'settings_page_output']
            );
        }
    }

    /**
     * Add setting sections and settings for the settings page
     * Also maybe save some settings before outputing them
     */
    public function add_settings()
    {
        // Clear the log if clear button was clicked in settings
        // and redirect user to show message.
        if (
            isset($_GET['simple_history_clear_log_nonce']) &&
            wp_verify_nonce($_GET['simple_history_clear_log_nonce'], 'simple_history_clear_log')
        ) {
            if ($this->user_can_clear_log()) {
                $this->clear_log();
            }

            $msg = __('Cleared database', 'simple-history');

            add_settings_error(
                'simple_history_rss_feed_regenerate_secret',
                'simple_history_rss_feed_regenerate_secret',
                $msg,
                'updated'
            );

            set_transient('settings_errors', get_settings_errors(), 30);

            $goback = esc_url_raw(add_query_arg('settings-updated', 'true', wp_get_referer()));
            wp_redirect($goback);
            exit();
        }

        // Section for general options.
        // Will contain settings like where to show simple history and number of items.
        $settings_section_general_id = self::SETTINGS_SECTION_GENERAL_ID;
        add_settings_section(
            $settings_section_general_id,
            '',
            [$this, 'settings_section_output'],
            SimpleHistory::SETTINGS_MENU_SLUG // Same slug as for options menu page.
        );

        // Settings for the general settings section
        // Each setting = one row in the settings section
        // add_settings_field( $id, $title, $callback, $page, $section, $args );
        // Checkboxes for where to show simple history
        add_settings_field(
            'simple_history_show_where',
            __('Show history', 'simple-history'),
            [$this, 'settings_field_where_to_show'],
            SimpleHistory::SETTINGS_MENU_SLUG,
            $settings_section_general_id
        );

        // Nonces for show where inputs.
        register_setting(SimpleHistory::SETTINGS_GENERAL_OPTION_GROUP, 'simple_history_show_on_dashboard');
        register_setting(SimpleHistory::SETTINGS_GENERAL_OPTION_GROUP, 'simple_history_show_as_page');

        // Number if items to show on the history page.
        add_settings_field(
            'simple_history_number_of_items',
            __('Number of items per page on the log page', 'simple-history'),
            [$this, 'settings_field_number_of_items'],
            SimpleHistory::SETTINGS_MENU_SLUG,
            $settings_section_general_id
        );

        // Nonces for number of items inputs.
        register_setting(SimpleHistory::SETTINGS_GENERAL_OPTION_GROUP, 'simple_history_pager_size');

        // Number if items to show on dashboard.
        add_settings_field(
            'simple_history_number_of_items_dashboard',
            __('Number of items per page on the dashboard', 'simple-history'),
            [$this, 'settings_field_number_of_items_dashboard'],
            SimpleHistory::SETTINGS_MENU_SLUG,
            $settings_section_general_id
        );

        // Nonces for number of items inputs.
        register_setting(SimpleHistory::SETTINGS_GENERAL_OPTION_GROUP, 'simple_history_pager_size_dashboard');

        // Link/button to clear log.
        if ($this->user_can_clear_log()) {
            add_settings_field(
                'simple_history_clear_log',
                __('Clear log', 'simple-history'),
                [$this, 'settings_field_clear_log'],
                SimpleHistory::SETTINGS_MENU_SLUG,
                $settings_section_general_id
            );
        }
    }

    /**
     * Output for page with the history
     */
    public function history_page_output()
    {
        // global $simple_history;
        // $this->purge_db();
        global $wpdb;

        $pager_size = $this->get_pager_size();

        /**
         * Filter the pager size setting for the history page
         *
         * @since 2.0
         *
         * @param int $pager_size
         */
        $pager_size = apply_filters('simple_history/page_pager_size', $pager_size);
        ?>

        <div class="wrap SimpleHistoryWrap">

            <h1 class="SimpleHistoryPageHeadline">
                <div class="dashicons dashicons-backup SimpleHistoryPageHeadline__icon"></div>
                <?php echo _x('Simple History', 'history page headline', 'simple-history'); ?>
            </h1>
            
            <?php /**
             * Fires before the gui div
             *
             * @since 2.0
             *
             * @param SimpleHistory $SimpleHistory This class.
             */
            do_action('simple_history/history_page/before_gui', $this); ?>

            <div class="SimpleHistoryGuiWrap">

                <div class="SimpleHistoryGui"
                     data-pager-size='<?php echo $pager_size; ?>'
                     ></div>
                    <?php /**
                     * Fires after the gui div
                     *
                     * @since 2.0
                     *
                     * @param SimpleHistory $SimpleHistory This class.
                     */
                    do_action('simple_history/history_page/after_gui', $this); ?>
            </div>
        </div>
        <?php
    }

    /**
     * Get setting if plugin should be visible on dasboard.
     * Defaults to true
     *
     * @return bool
     */
    public function setting_show_on_dashboard()
    {
        $show_on_dashboard = get_option('simple_history_show_on_dashboard', 1);
        $show_on_dashboard = apply_filters('simple_history_show_on_dashboard', $show_on_dashboard);
        return (bool) $show_on_dashboard;
    }

    /**
     * Should simple history be shown as a page
     * Defaults to true
     *
     * @return bool
     */
    public function setting_show_as_page()
    {
        $setting = get_option('simple_history_show_as_page', 1);
        $setting = apply_filters('simple_history_show_as_page', $setting);

        return (bool) $setting;
    }

    /**
     * Settings field for how many rows/items to show in log on the log page
     */
    public function settings_field_number_of_items()
    {
        $current_pager_size = $this->get_pager_size(); ?>
        <select name="simple_history_pager_size">
            <option <?php echo $current_pager_size == 5 ? 'selected' : ''; ?> value="5">5</option>
            <option <?php echo $current_pager_size == 10 ? 'selected' : ''; ?> value="10">10</option>
            <option <?php echo $current_pager_size == 15 ? 'selected' : ''; ?> value="15">15</option>
            <option <?php echo $current_pager_size == 20 ? 'selected' : ''; ?> value="20">20</option>
            <option <?php echo $current_pager_size == 25 ? 'selected' : ''; ?> value="25">25</option>
            <option <?php echo $current_pager_size == 30 ? 'selected' : ''; ?> value="30">30</option>
            <option <?php echo $current_pager_size == 40 ? 'selected' : ''; ?> value="40">40</option>
            <option <?php echo $current_pager_size == 50 ? 'selected' : ''; ?> value="50">50</option>
            <option <?php echo $current_pager_size == 75 ? 'selected' : ''; ?> value="75">75</option>
            <option <?php echo $current_pager_size == 100 ? 'selected' : ''; ?> value="100">100</option>
        </select>
        <?php
    }

    /**
     * Settings field for how many rows/items to show in log on the dashboard
     */
    public function settings_field_number_of_items_dashboard()
    {
        $current_pager_size = $this->get_pager_size_dashboard(); ?>
        <select name="simple_history_pager_size_dashboard">
            <option <?php echo $current_pager_size == 5 ? 'selected' : ''; ?> value="5">5</option>
            <option <?php echo $current_pager_size == 10 ? 'selected' : ''; ?> value="10">10</option>
            <option <?php echo $current_pager_size == 15 ? 'selected' : ''; ?> value="15">15</option>
            <option <?php echo $current_pager_size == 20 ? 'selected' : ''; ?> value="20">20</option>
            <option <?php echo $current_pager_size == 25 ? 'selected' : ''; ?> value="25">25</option>
            <option <?php echo $current_pager_size == 30 ? 'selected' : ''; ?> value="30">30</option>
            <option <?php echo $current_pager_size == 40 ? 'selected' : ''; ?> value="40">40</option>
            <option <?php echo $current_pager_size == 50 ? 'selected' : ''; ?> value="50">50</option>
            <option <?php echo $current_pager_size == 75 ? 'selected' : ''; ?> value="75">75</option>
            <option <?php echo $current_pager_size == 100 ? 'selected' : ''; ?> value="100">100</option>
        </select>
        <?php
    }

    /**
     * Settings field for where to show the log, page or dashboard
     */
    public function settings_field_where_to_show()
    {
        $show_on_dashboard = $this->setting_show_on_dashboard();
        $show_as_page = $this->setting_show_as_page();
        ?>

        <input <?php echo $show_on_dashboard
            ? "checked='checked'"
            : ''; ?> type="checkbox" value="1" name="simple_history_show_on_dashboard" id="simple_history_show_on_dashboard" class="simple_history_show_on_dashboard" />
        <label for="simple_history_show_on_dashboard"><?php _e('on the dashboard', 'simple-history'); ?></label>

        <br />

        <input <?php echo $show_as_page
            ? "checked='checked'"
            : ''; ?> type="checkbox" value="1" name="simple_history_show_as_page" id="simple_history_show_as_page" class="simple_history_show_as_page" />
        <label for="simple_history_show_as_page">
            <?php _e('as a page under the dashboard menu', 'simple-history'); ?>
        </label>

        <?php
    }

    /**
     * Settings section to clear database
     */
    public function settings_field_clear_log()
    {
        // Get base URL to current page.
        // Will be like "/wordpress/wp-admin/options-general.php?page=simple_history_settings_menu_slug&"
        $clear_link = add_query_arg('', '');

        // Append nonce to URL.
        $clear_link = wp_nonce_url($clear_link, 'simple_history_clear_log', 'simple_history_clear_log_nonce');

        $clear_days = $this->get_clear_history_interval();

        echo '<p>';

        if ($clear_days > 0) {
            echo sprintf(
                __('Items in the database are automatically removed after %1$s days.', 'simple-history'),
                $clear_days
            );
        } else {
            _e('Items in the database are kept forever.', 'simple-history');
        }

        echo '</p>';

        printf(
            '<p><a class="button js-SimpleHistory-Settings-ClearLog" href="%2$s">%1$s</a></p>',
            __('Clear log now', 'simple-history'),
            esc_url($clear_link)
        );
    }

    /**
     * How old log entried are allowed to be.
     * 0 = don't delete old entries.
     *
     * @return int Number of days.
     */
    public function get_clear_history_interval()
    {
        $days = 60;

        /**
         * Filter to modify number of days of history to keep.
         * Default is 60 days.
         *
         * @param $days Number of days of history to keep
         */
        $days = (int) apply_filters('simple_history_db_purge_days_interval', $days);
        $days = (int) apply_filters('simple_history/db_purge_days_interval', $days);

        return $days;
    }

    /**
     * Removes all items from the log
     */
    public function clear_log()
    {
        global $wpdb;

        $tableprefix = $wpdb->prefix;

        $simple_history_table = SimpleHistory::DBTABLE;
        $simple_history_context_table = SimpleHistory::DBTABLE_CONTEXTS;

        // Get number of rows before delete.
        $sql_num_rows = "SELECT count(id) AS num_rows FROM {$tableprefix}{$simple_history_table}";
        $num_rows = $wpdb->get_var($sql_num_rows, 0);

        // Use truncate instead of delete because it's much faster (I think, writing this much later).
        $sql = "TRUNCATE {$tableprefix}{$simple_history_table}";
        $wpdb->query($sql);

        $sql = "TRUNCATE {$tableprefix}{$simple_history_context_table}";
        $wpdb->query($sql);

        // Zero state sucks
        SimpleLogger()->info(
            __('The log for Simple History was cleared ({num_rows} rows were removed).', 'simple-history'),
            [
                'num_rows' => $num_rows,
            ]
        );

        $this->get_cache_incrementor(true);
    }

    /**
     * Runs the purge_db() method sometimes
     * We don't want to call it each time because it performs SQL queries
     *
     * @since 2.0.17
     */
    public function maybe_purge_db()
    {
        // How often should we try to do this?
        // Once a day = a bit tiresome.
        // Let's go with sundays; purge the log on sundays.
        // Day of week, 1 = mon, 7 = sun.
        $day_of_week = date('N');
        if (7 === (int) $day_of_week) {
            $this->purge_db();
        }
    }

    /**
     * Removes old entries from the db
     */
    public function purge_db()
    {
        $do_purge_history = true;

        $do_purge_history = apply_filters('simple_history_allow_db_purge', $do_purge_history);
        $do_purge_history = apply_filters('simple_history/allow_db_purge', $do_purge_history);

        if (!$do_purge_history) {
            return;
        }

        $days = $this->get_clear_history_interval();

        // Never clear log if days = 0.
        if (0 == $days) {
            return;
        }

        global $wpdb;

        $table_name = $wpdb->prefix . SimpleHistory::DBTABLE;
        $table_name_contexts = $wpdb->prefix . SimpleHistory::DBTABLE_CONTEXTS;

        while (1 > 0) {
            // Get id of rows to delete.
            $sql = $wpdb->prepare(
                "SELECT id FROM $table_name WHERE DATE_ADD(date, INTERVAL %d DAY) < now() LIMIT 100000",
                $days
            );

            $ids_to_delete = $wpdb->get_col($sql);

            if (empty($ids_to_delete)) {
                // Nothing to delete.
                return;
            }

            $sql_ids_in = implode(',', $ids_to_delete);

            // Add number of deleted rows to total_rows option.
            $prev_total_rows = (int) get_option('simple_history_total_rows', 0);
            $total_rows = $prev_total_rows + sizeof($ids_to_delete);
            update_option('simple_history_total_rows', $total_rows);

            // Remove rows + contexts.
            $sql_delete_history = "DELETE FROM {$table_name} WHERE id IN ($sql_ids_in)";
            $sql_delete_history_context = "DELETE FROM {$table_name_contexts} WHERE history_id IN ($sql_ids_in)";

            $wpdb->query($sql_delete_history);
            $wpdb->query($sql_delete_history_context);

            $message = _nx(
                'Simple History removed one event that were older than {days} days',
                'Simple History removed {num_rows} events that were older than {days} days',
                count($ids_to_delete),
                'Database is being cleared automagically',
                'simple-history'
            );

            SimpleLogger()->info($message, [
                'days' => $days,
                'num_rows' => count($ids_to_delete),
            ]);

            $this->get_cache_incrementor(true);
        }
    }

    /**
     * Return plain text output for a log row
     * Uses the getLogRowPlainTextOutput of the logger that logged the row
     * with fallback to SimpleLogger if logger is not available.
     *
     * @param context $row
     * @return string
     */
    public function getLogRowPlainTextOutput($row)
    {
        $row_logger = $row->logger;
        $logger = null;
        $row->context = isset($row->context) && is_array($row->context) ? $row->context : [];

        if (!isset($row->context['_message_key'])) {
            $row->context['_message_key'] = null;
        }

        // Fallback to SimpleLogger if no logger exists for row
        if (!isset($this->instantiatedLoggers[$row_logger])) {
            $row_logger = 'SimpleLogger';
        }

        $logger = $this->instantiatedLoggers[$row_logger]['instance'];

        return $logger->getLogRowPlainTextOutput($row);
    }

    /**
     * Return header output for a log row.
     *
     * Uses the getLogRowHeaderOutput of the logger that logged the row
     * with fallback to SimpleLogger if logger is not available.
     *
     * Loggers are discouraged to override this in the loggers,
     * because the output should be the same for all items in the GUI.
     *
     * @param object $row
     * @return string
     */
    public function getLogRowHeaderOutput($row)
    {
        $row_logger = $row->logger;
        $logger = null;
        $row->context = isset($row->context) && is_array($row->context) ? $row->context : [];

        // Fallback to SimpleLogger if no logger exists for row
        if (!isset($this->instantiatedLoggers[$row_logger])) {
            $row_logger = 'SimpleLogger';
        }

        $logger = $this->instantiatedLoggers[$row_logger]['instance'];

        return $logger->getLogRowHeaderOutput($row);
    }

    /**
     *
     *
     * @param object $row
     * @return string
     */
    private function getLogRowSenderImageOutput($row)
    {
        $row_logger = $row->logger;
        $logger = null;
        $row->context = isset($row->context) && is_array($row->context) ? $row->context : [];

        // Fallback to SimpleLogger if no logger exists for row
        if (!isset($this->instantiatedLoggers[$row_logger])) {
            $row_logger = 'SimpleLogger';
        }

        $logger = $this->instantiatedLoggers[$row_logger]['instance'];

        return $logger->getLogRowSenderImageOutput($row);
    }

    public function getLogRowDetailsOutput($row)
    {
        $row_logger = $row->logger;
        $logger = null;
        $row->context = isset($row->context) && is_array($row->context) ? $row->context : [];

        // Fallback to SimpleLogger if no logger exists for row
        if (!isset($this->instantiatedLoggers[$row_logger])) {
            $row_logger = 'SimpleLogger';
        }

        $logger = $this->instantiatedLoggers[$row_logger]['instance'];

        return $logger->getLogRowDetailsOutput($row);
    }

    /**
     * Works like json_encode, but adds JSON_PRETTY_PRINT if the current php version supports it
     * i.e. PHP is 5.4.0 or greated
     *
     * @param mixed $value array|object|string|whatever that is json_encode'able.
     */
    public static function json_encode($value)
    {
        return version_compare(PHP_VERSION, '5.4.0') >= 0
            ? json_encode($value, JSON_PRETTY_PRINT)
            : json_encode($value);
    }

    /**
     * Returns true if $haystack ends with $needle
     *
     * @param string $haystack
     * @param string $needle
     */
    public static function ends_with($haystack, $needle)
    {
        return $needle === substr($haystack, -strlen($needle));
    }

    /**
     * Returns the HTML output for a log row, to be used in the GUI/Activity Feed.
     * This includes HTML for the header, the sender image, and the details.
     *
     * @param object $oneLogRow SimpleHistoryLogQuery array with data from SimpleHistoryLogQuery
     * @return string
     */
    public function getLogRowHTMLOutput($oneLogRow, $args)
    {
        $defaults = [
            'type' => 'overview', // or "single" to include more stuff (used in for example modal details window)
        ];

        $args = wp_parse_args($args, $defaults);

        $header_html = $this->getLogRowHeaderOutput($oneLogRow);
        $plain_text_html = $this->getLogRowPlainTextOutput($oneLogRow);
        $sender_image_html = $this->getLogRowSenderImageOutput($oneLogRow);

        // Details = for example thumbnail of media
        $details_html = trim($this->getLogRowDetailsOutput($oneLogRow));
        if ($details_html) {
            $details_html = sprintf('<div class="SimpleHistoryLogitem__details">%1$s</div>', $details_html);
        }

        // subsequentOccasions = including the current one
        $occasions_count = $oneLogRow->subsequentOccasions - 1;
        $occasions_html = '';

        if ($occasions_count > 0) {
            $occasions_html = '<div class="SimpleHistoryLogitem__occasions">';

            $occasions_html .= '<a href="#" class="SimpleHistoryLogitem__occasionsLink">';
            $occasions_html .= sprintf(
                _n('+%1$s similar event', '+%1$s similar events', $occasions_count, 'simple-history'),
                $occasions_count
            );
            $occasions_html .= '</a>';

            $occasions_html .= '<span class="SimpleHistoryLogitem__occasionsLoading">';
            $occasions_html .= sprintf(__('Loading…', 'simple-history'), $occasions_count);
            $occasions_html .= '</span>';

            $occasions_html .= '<span class="SimpleHistoryLogitem__occasionsLoaded">';
            $occasions_html .= sprintf(__('Showing %1$s more', 'simple-history'), $occasions_count);
            $occasions_html .= '</span>';

            $occasions_html .= '</div>';
        }

        // Add data attributes to log row, so plugins can do stuff.
        $data_attrs = '';
        $data_attrs .= sprintf(' data-row-id="%1$d" ', $oneLogRow->id);
        $data_attrs .= sprintf(' data-occasions-count="%1$d" ', $occasions_count);
        $data_attrs .= sprintf(' data-occasions-id="%1$s" ', esc_attr($oneLogRow->occasionsID));

        // Add data attributes for remote address and other ip number headers.
        if (isset($oneLogRow->context['_server_remote_addr'])) {
            $data_attrs .= sprintf(' data-ip-address="%1$s" ', esc_attr($oneLogRow->context['_server_remote_addr']));
        }

        $arr_found_additional_ip_headers = $this->instantiatedLoggers['SimpleLogger'][
            'instance'
        ]->get_event_ip_number_headers($oneLogRow);

        if ($arr_found_additional_ip_headers) {
            $data_attrs .= sprintf(' data-ip-address-multiple="1" ');
        }

        // Add data attributes info for common things like logger, level, data, initiation.
        $data_attrs .= sprintf(' data-logger="%1$s" ', esc_attr($oneLogRow->logger));
        $data_attrs .= sprintf(' data-level="%1$s" ', esc_attr($oneLogRow->level));
        $data_attrs .= sprintf(' data-date="%1$s" ', esc_attr($oneLogRow->date));
        $data_attrs .= sprintf(' data-initiator="%1$s" ', esc_attr($oneLogRow->initiator));

        if (isset($oneLogRow->context['_user_id'])) {
            $data_attrs .= sprintf(' data-initiator-user-id="%1$d" ', $oneLogRow->context['_user_id']);
        }

        // If type is single then include more details.
        // This is typically shown in the modal window when clickin the event date and time.
        $more_details_html = '';
        if ($args['type'] == 'single') {
            $more_details_html = apply_filters(
                'simple_history/log_html_output_details_single/html_before_context_table',
                $more_details_html,
                $oneLogRow
            );

            $more_details_html .= sprintf(
                '<h2 class="SimpleHistoryLogitem__moreDetailsHeadline">%1$s</h2>',
                __('Context data', 'simple-history')
            );
            $more_details_html .=
                '<p>' . __('This is potentially useful meta data that a logger has saved.', 'simple-history') . '</p>';
            $more_details_html .= "<table class='SimpleHistoryLogitem__moreDetailsContext'>";
            $more_details_html .= sprintf(
                '<tr>
                    <th>%1$s</th>
                    <th>%2$s</th>
                </tr>',
                'Key',
                'Value'
            );

            $logRowKeysToShow = array_fill_keys(array_keys((array) $oneLogRow), true);

            /**
             * Filter what keys to show from oneLogRow
             *
             * Array is in format
             *
             *   Array
             *   (
             *       [id] => 1
             *       [logger] => 1
             *       [level] => 1
             *       ...
             *   )
             *
             * @since 2.0.29
             *
             * @param array with keys to show. key to show = key. value = boolean to show or not.
             * @param object log row to show details from
             */
            $logRowKeysToShow = apply_filters(
                'simple_history/log_html_output_details_table/row_keys_to_show',
                $logRowKeysToShow,
                $oneLogRow
            );

            // Hide some keys by default
            unset(
                $logRowKeysToShow['occasionsID'],
                $logRowKeysToShow['subsequentOccasions'],
                $logRowKeysToShow['rep'],
                $logRowKeysToShow['repeated'],
                $logRowKeysToShow['occasionsIDType'],
                $logRowKeysToShow['context'],
                $logRowKeysToShow['type']
            );

            foreach ($oneLogRow as $rowKey => $rowVal) {
                // Only columns from oneLogRow that exist in logRowKeysToShow will be outputed
                if (!array_key_exists($rowKey, $logRowKeysToShow) || !$logRowKeysToShow[$rowKey]) {
                    continue;
                }

                // skip arrays and objects and such
                if (is_array($rowVal) || is_object($rowVal)) {
                    continue;
                }

                $more_details_html .= sprintf(
                    '<tr>
                        <td>%1$s</td>
                        <td>%2$s</td>
                    </tr>',
                    esc_html($rowKey),
                    esc_html($rowVal)
                );
            }

            $logRowContextKeysToShow = array_fill_keys(array_keys((array) $oneLogRow->context), true);

            /**
             * Filter what keys to show from the row context
             *
             * Array is in format
             *
             *   Array
             *   (
             *       [plugin_slug] => 1
             *       [plugin_name] => 1
             *       [plugin_title] => 1
             *       [plugin_description] => 1
             *       [plugin_author] => 1
             *       [plugin_version] => 1
             *       ...
             *   )
             *
             * @since 2.0.29
             *
             * @param array with keys to show. key to show = key. value = boolean to show or not.
             * @param object log row to show details from
             */
            $logRowContextKeysToShow = apply_filters(
                'simple_history/log_html_output_details_table/context_keys_to_show',
                $logRowContextKeysToShow,
                $oneLogRow
            );

            foreach ($oneLogRow->context as $contextKey => $contextVal) {
                // Only columns from context that exist in logRowContextKeysToShow will be outputed
                if (
                    !array_key_exists($contextKey, $logRowContextKeysToShow) ||
                    !$logRowContextKeysToShow[$contextKey]
                ) {
                    continue;
                }

                $more_details_html .= sprintf(
                    '<tr>
                        <td>%1$s</td>
                        <td>%2$s</td>
                    </tr>',
                    esc_html($contextKey),
                    esc_html($contextVal)
                );
            }

            $more_details_html .= '</table>';

            $more_details_html = apply_filters(
                'simple_history/log_html_output_details_single/html_after_context_table',
                $more_details_html,
                $oneLogRow
            );

            $more_details_html = sprintf(
                '<div class="SimpleHistoryLogitem__moreDetails">%1$s</div>',
                $more_details_html
            );
        } // End if().

        // Classes to add to log item li element
        $classes = [
            'SimpleHistoryLogitem',
            "SimpleHistoryLogitem--loglevel-{$oneLogRow->level}",
            "SimpleHistoryLogitem--logger-{$oneLogRow->logger}",
        ];

        if (isset($oneLogRow->initiator) && !empty($oneLogRow->initiator)) {
            $classes[] = 'SimpleHistoryLogitem--initiator-' . $oneLogRow->initiator;
        }

        if ($arr_found_additional_ip_headers) {
            $classes[] = 'SimpleHistoryLogitem--IPAddress-multiple';
        }

        // Always append the log level tag
        $log_level_tag_html = sprintf(
            ' <span class="SimpleHistoryLogitem--logleveltag SimpleHistoryLogitem--logleveltag-%1$s">%2$s</span>',
            $oneLogRow->level,
            $this->getLogLevelTranslated($oneLogRow->level)
        );

        $plain_text_html .= $log_level_tag_html;

        /**
         * Filter to modify classes added to item li element
         *
         * @since 2.0.7
         *
         * @param $classes Array with classes
         */
        $classes = apply_filters('simple_history/logrowhtmloutput/classes', $classes);

        // Generate the HTML output for a row
        $output = sprintf(
            '
                <li %8$s class="%10$s">
                    <div class="SimpleHistoryLogitem__firstcol">
                        <div class="SimpleHistoryLogitem__senderImage">%3$s</div>
                    </div>
                    <div class="SimpleHistoryLogitem__secondcol">
                        <div class="SimpleHistoryLogitem__header">%1$s</div>
                        <div class="SimpleHistoryLogitem__text">%2$s</div>
                        %6$s <!-- details_html -->
                        %9$s <!-- more details html -->
                        %4$s <!-- occasions -->
                    </div>
                </li>
            ',
            $header_html, // 1
            $plain_text_html, // 2
            $sender_image_html, // 3
            $occasions_html, // 4
            $oneLogRow->level, // 5
            $details_html, // 6
            $oneLogRow->logger, // 7
            $data_attrs, // 8 data attributes
            $more_details_html, // 9
            esc_attr(join(' ', $classes)) // 10
        );

        // Get the main message row.
        // Should be as plain as possible, like plain text
        // but with links to for example users and posts
        // SimpleLoggerFormatter::getRowTextOutput($oneLogRow);
        // Get detailed HTML-based output
        // May include images, lists, any cool stuff needed to view
        // SimpleLoggerFormatter::getRowHTMLOutput($oneLogRow);
        return trim($output);
    }

    /**
     * Return translated loglevel
     *
     * @since 2.0.14
     * @param string $loglevel
     * @return string translated loglevel
     */
    public function getLogLevelTranslated($loglevel)
    {
        $str_translated = '';

        switch ($loglevel) {
            // Lowercase
            case 'emergency':
                $str_translated = _x('emergency', 'Log level in gui', 'simple-history');
                break;

            case 'alert':
                $str_translated = _x('alert', 'Log level in gui', 'simple-history');
                break;

            case 'critical':
                $str_translated = _x('critical', 'Log level in gui', 'simple-history');
                break;

            case 'error':
                $str_translated = _x('error', 'Log level in gui', 'simple-history');
                break;

            case 'warning':
                $str_translated = _x('warning', 'Log level in gui', 'simple-history');
                break;

            case 'notice':
                $str_translated = _x('notice', 'Log level in gui', 'simple-history');
                break;

            case 'info':
                $str_translated = _x('info', 'Log level in gui', 'simple-history');
                break;

            case 'debug':
                $str_translated = _x('debug', 'Log level in gui', 'simple-history');
                break;

            // Uppercase
            case 'Emergency':
                $str_translated = _x('Emergency', 'Log level in gui', 'simple-history');
                break;

            case 'Alert':
                $str_translated = _x('Alert', 'Log level in gui', 'simple-history');
                break;

            case 'Critical':
                $str_translated = _x('Critical', 'Log level in gui', 'simple-history');
                break;

            case 'Error':
                $str_translated = _x('Error', 'Log level in gui', 'simple-history');
                break;

            case 'Warning':
                $str_translated = _x('Warning', 'Log level in gui', 'simple-history');
                break;

            case 'Notice':
                $str_translated = _x('Notice', 'Log level in gui', 'simple-history');
                break;

            case 'Info':
                $str_translated = _x('Info', 'Log level in gui', 'simple-history');
                break;

            case 'Debug':
                $str_translated = _x('Debug', 'Log level in gui', 'simple-history');
                break;

            default:
                $str_translated = $loglevel;
        } // End switch().

        return $str_translated;
    }

    public function getInstantiatedLoggers()
    {
        return $this->instantiatedLoggers;
    }

    public function getInstantiatedDropins()
    {
        return $this->instantiatedDropins;
    }

    /**
     * @param string $slug
     * @return mixed logger instance if found, bool false if logger not found
     */
    public function getInstantiatedLoggerBySlug($slug = '')
    {
        if (empty($slug)) {
            return false;
        }

        foreach ($this->getInstantiatedLoggers() as $one_logger) {
            if ($slug == $one_logger['instance']->slug) {
                return $one_logger['instance'];
            }
        }

        return false;
    }

    /**
     * Check which loggers a user has the right to read and return an array
     * with all loggers they are allowed to read
     *
     * @param int    $user_id Id of user to get loggers for. Defaults to current user id.
     * @param string $format format to return loggers in. Default is array. Can also be "sql"
     * @return array
     */
    public function getLoggersThatUserCanRead($user_id = '', $format = 'array')
    {
        $arr_loggers_user_can_view = [];

        if (!is_numeric($user_id)) {
            $user_id = get_current_user_id();
        }

        $loggers = $this->getInstantiatedLoggers();
        foreach ($loggers as $one_logger) {
            $logger_capability = $one_logger['instance']->getCapability();

            // $arr_loggers_user_can_view = apply_filters("simple_history/loggers_user_can_read", $user_id, $arr_loggers_user_can_view);
            $user_can_read_logger = user_can($user_id, $logger_capability);
            $user_can_read_logger = apply_filters(
                'simple_history/loggers_user_can_read/can_read_single_logger',
                $user_can_read_logger,
                $one_logger['instance'],
                $user_id
            );

            if ($user_can_read_logger) {
                $arr_loggers_user_can_view[] = $one_logger;
            }
        }

        /**
         * Fires before Simple History does it's init stuff
         *
         * @since 2.0
         *
         * @param array $arr_loggers_user_can_view Array with loggers that user $user_id can read
         * @param int user_id ID of user to check read capability for
         */
        $arr_loggers_user_can_view = apply_filters(
            'simple_history/loggers_user_can_read',
            $arr_loggers_user_can_view,
            $user_id
        );

        // just return array with slugs in parenthesis suitable for sql-where
        if ('sql' == $format) {
            $str_return = '(';

            if (sizeof($arr_loggers_user_can_view)) {
                foreach ($arr_loggers_user_can_view as $one_logger) {
                    $str_return .= sprintf('"%1$s", ', esc_sql($one_logger['instance']->slug));
                }

                $str_return = rtrim($str_return, ' ,');
            } else {
                // user was not allowed to read any loggers, return in (NULL) to return nothing
                $str_return .= 'NULL';
            }

            $str_return .= ')';

            return $str_return;
        }

        return $arr_loggers_user_can_view;
    }

    /**
     * Retrieve the avatar for a user who provided a user ID or email address.
     * A modified version of the function that comes with WordPress, but we
     * want to allow/show gravatars even if they are disabled in discussion settings
     *
     * @since 2.0
     *
     * @param string $email email address
     * @param int    $size Size of the avatar image
     * @param string $default URL to a default image to use if no avatar is available
     * @param string $alt Alternative text to use in image tag. Defaults to blank
     * @return string <img> tag for the user's avatar
     */
    public function get_avatar($email, $size = '96', $default = '', $alt = false)
    {
        // WP setting for avatars is to show, so just use the built in function
        if (get_option('show_avatars')) {
            $avatar = get_avatar($email, $size, $default, $alt);

            return $avatar;
        } else {
            // WP setting for avatar was to not show, but we do it anyway, using the same code as get_avatar() would have used
            if (false === $alt) {
                $safe_alt = '';
            } else {
                $safe_alt = esc_attr($alt);
            }

            if (!is_numeric($size)) {
                $size = '96';
            }

            if (empty($default)) {
                $avatar_default = get_option('avatar_default');
                if (empty($avatar_default)) {
                    $default = 'mystery';
                } else {
                    $default = $avatar_default;
                }
            }

            if (!empty($email)) {
                $email_hash = md5(strtolower(trim($email)));
            }

            if (is_ssl()) {
                $host = 'https://secure.gravatar.com';
            } else {
                if (!empty($email)) {
                    $host = sprintf('http://%d.gravatar.com', hexdec($email_hash[0]) % 2);
                } else {
                    $host = 'http://0.gravatar.com';
                }
            }

            if ('mystery' == $default) {
                $default = "$host/avatar/ad516503a11cd5ca435acc9bb6523536?s={$size}";
            } elseif ('blank' == $default) {
                $default = $email ? 'blank' : includes_url('images/blank.gif');
            } elseif (!empty($email) && 'gravatar_default' == $default) {
                $default = '';
            } elseif ('gravatar_default' == $default) {
                $default = "$host/avatar/?s={$size}";
            } elseif (empty($email)) {
                $default = "$host/avatar/?d=$default&amp;s={$size}";
            } elseif (strpos($default, 'http://') === 0) {
                $default = add_query_arg('s', $size, $default);
            }

            if (!empty($email)) {
                $out = "$host/avatar/";
                $out .= $email_hash;
                $out .= '?s=' . $size;
                $out .= '&amp;d=' . urlencode($default);

                $rating = get_option('avatar_rating');
                if (!empty($rating)) {
                    $out .= "&amp;r={$rating}";
                }

                $out = str_replace('&#038;', '&amp;', esc_url($out));
                $avatar = "<img alt='{$safe_alt}' src='{$out}' class='avatar avatar-{$size} photo' height='{$size}' width='{$size}' />";
            } else {
                $out = esc_url($default);
                $avatar = "<img alt='{$safe_alt}' src='{$out}' class='avatar avatar-{$size} photo avatar-default' height='{$size}' width='{$size}' />";
            }

            /**
             * Filter the avatar to retrieve.
             * Same filter WordPress uses
             *
             * @since 2.0.19
             *
             * @param string            $avatar      Image tag for the user's avatar.
             * @param int|object|string $id_or_email A user ID, email address, or comment object.
             * @param int               $size        Square avatar width and height in pixels to retrieve.
             * @param string            $alt         Alternative text to use in the avatar image tag.
             *                                       Default empty.
             */
            $avatar = apply_filters('get_avatar', $avatar, $email, $size, $default, $alt);

            return $avatar;
        } // End if().
    }

    /**
     * Quick stats above the log
     * Uses filter "simple_history/history_page/before_gui" to output its contents
     */
    public function output_quick_stats()
    {
        global $wpdb;

        // Get number of events today
        $logQuery = new SimpleHistoryLogQuery();
        $logResults = $logQuery->query([
            'posts_per_page' => 1,
            'date_from' => strtotime('today'),
        ]);

        $total_row_count = (int) $logResults['total_row_count'];

        // Get sql query for where to read only loggers current user is allowed to read/view
        $sql_loggers_in = $this->getLoggersThatUserCanRead(get_current_user_id(), 'sql');

        // Get number of users today, i.e. events with wp_user as initiator
        $sql_users_today = sprintf(
            '
            SELECT
                DISTINCT(c.value) AS user_id
                #h.id, h.logger, h.level, h.initiator, h.date
                FROM %3$s AS h
            INNER JOIN %4$s AS c
            ON c.history_id = h.id AND c.key = "_user_id"
            WHERE
                initiator = "wp_user"
                AND logger IN %1$s
                AND date > "%2$s"
            ',
            $sql_loggers_in,
            date('Y-m-d H:i', strtotime('today')),
            $wpdb->prefix . SimpleHistory::DBTABLE,
            $wpdb->prefix . SimpleHistory::DBTABLE_CONTEXTS
        );

        $cache_key = 'quick_stats_users_today_' . md5(serialize($sql_loggers_in));
        $cache_group = 'simple-history-' . $this->get_cache_incrementor();
        $results_users_today = wp_cache_get($cache_key, $cache_group);

        if (false === $results_users_today) {
            $results_users_today = $wpdb->get_results($sql_users_today);
            wp_cache_set($cache_key, $results_users_today, $cache_group);
        }

        $count_users_today = sizeof($results_users_today);

        // Get number of other sources (not wp_user)
        $sql_other_sources_where = sprintf(
            '
                initiator <> "wp_user"
                AND logger IN %1$s
                AND date > "%2$s"
            ',
            $sql_loggers_in,
            date('Y-m-d H:i', strtotime('today')),
            $wpdb->prefix . SimpleHistory::DBTABLE,
            $wpdb->prefix . SimpleHistory::DBTABLE_CONTEXTS
        );

        $sql_other_sources_where = apply_filters('simple_history/quick_stats_where', $sql_other_sources_where);

        $sql_other_sources = sprintf(
            '
            SELECT
                DISTINCT(h.initiator) AS initiator
            FROM %3$s AS h
            WHERE
                %5$s
            ',
            $sql_loggers_in,
            date('Y-m-d H:i', strtotime('today')),
            $wpdb->prefix . SimpleHistory::DBTABLE,
            $wpdb->prefix . SimpleHistory::DBTABLE_CONTEXTS,
            $sql_other_sources_where // 5
        );
        // sf_d($sql_other_sources, '$sql_other_sources');
        $cache_key = 'quick_stats_results_other_sources_today_' . md5(serialize($sql_other_sources));
        $results_other_sources_today = wp_cache_get($cache_key, $cache_group);

        if (false === $results_other_sources_today) {
            $results_other_sources_today = $wpdb->get_results($sql_other_sources);
            wp_cache_set($cache_key, $results_other_sources_today, $cache_group);
        }

        $count_other_sources = sizeof($results_other_sources_today);
        // sf_d($logResults, '$logResults');
        // sf_d($results_users_today, '$sql_users_today');
        // sf_d($results_other_sources_today, '$results_other_sources_today');
        ?>
        <div class="SimpleHistoryQuickStats">
            <p>
                <?php
                $msg_tmpl = '';

                // No results today at all
                if ($total_row_count == 0) {
                    $msg_tmpl = __('No events today so far.', 'simple-history');
                } else {
                    /*
                    Type of results
                    x1 event today from 1 user.
                    x1 event today from 1 source.
                    3 events today from 1 user.
                    x2 events today from 2 users.
                    x2 events today from 1 user and 1 other source.
                    x3 events today from 2 users and 1 other source.
                    x3 events today from 1 user and 2 other sources.
                    x4 events today from 2 users and 2 other sources.
                     */

                    // A single event existed and was from a user
                    // 1 event today from 1 user.
                    if ($total_row_count == 1 && $count_users_today == 1) {
                        $msg_tmpl .= __('One event today from one user.', 'simple-history');
                    }

                    // A single event existed and was from another source
                    // 1 event today from 1 source.
                    if ($total_row_count == 1 && !$count_users_today) {
                        $msg_tmpl .= __('One event today from one source.', 'simple-history');
                    }

                    // Multiple events from a single user
                    // 3 events today from one user.
                    if ($total_row_count > 1 && $count_users_today == 1 && !$count_other_sources) {
                        $msg_tmpl .= __('%1$d events today from one user.', 'simple-history');
                    }

                    // Multiple events from only users
                    // 2 events today from 2 users.
                    if ($total_row_count > 1 && $count_users_today == $total_row_count) {
                        $msg_tmpl .= __('%1$d events today from %2$d users.', 'simple-history');
                    }

                    // Multiple events from 1 single user and 1 single other source
                    // 2 events today from 1 user and 1 other source.
                    if ($total_row_count && 1 == $count_users_today && 1 == $count_other_sources) {
                        $msg_tmpl .= __('%1$d events today from one user and one other source.', 'simple-history');
                    }

                    // Multiple events from multple users but from only 1 single other source
                    // 3 events today from 2 users and 1 other source.
                    if ($total_row_count > 1 && $count_users_today > 1 && $count_other_sources == 1) {
                        $msg_tmpl .= __('%1$d events today from one user and one other source.', 'simple-history');
                    }

                    // Multiple events from 1 user but from multiple  other source
                    // 3 events today from 1 user and 2 other sources.
                    if ($total_row_count > 1 && 1 == $count_users_today && $count_other_sources > 1) {
                        $msg_tmpl .= __('%1$d events today from one user and %3$d other sources.', 'simple-history');
                    }

                    // Multiple events from multiple user and from multiple other sources
                    // 4 events today from 2 users and 2 other sources.
                    if ($total_row_count > 1 && $count_users_today > 1 && $count_other_sources > 1) {
                        $msg_tmpl .= __('%1$s events today from %2$d users and %3$d other sources.', 'simple-history');
                    }
                } // End if().

                // only show stats if we have something to output
                if ($msg_tmpl) {
                    printf(
                        $msg_tmpl,
                        $logResults['total_row_count'], // 1
                        $count_users_today, // 2
                        $count_other_sources // 3
                    );

                    // Space between texts
                    /*
                    echo " ";

                    // http://playground-root.ep/wp-admin/options-general.php?page=simple_history_settings_menu_slug&selected-tab=stats
                    printf(
                    '<a href="%1$s">View more stats</a>.',
                    add_query_arg("selected-tab", "stats", menu_page_url(SimpleHistory::SETTINGS_MENU_SLUG, 0))
                    );
                    */
                }?>
            </p>
        </div>
        <?php
    }

    /**
     * https://www.tollmanz.com/invalidation-schemes/
     *
     * @param $refresh bool
     * @return string
     */
    public static function get_cache_incrementor($refresh = false)
    {
        $incrementor_key = 'simple_history_incrementor';
        $incrementor_value = wp_cache_get($incrementor_key);

        if (false === $incrementor_value || true === $refresh) {
            $incrementor_value = time();
            wp_cache_set($incrementor_key, $incrementor_value);
        }

        // echo "<br>incrementor_value: $incrementor_value";
        return $incrementor_value;
    }

    // Number of rows the last n days
    public function get_num_events_last_n_days($period_days = 28)
    {
        $transient_key = 'sh_' . md5(__METHOD__ . $period_days . '_2');

        $count = get_transient($transient_key);

        if (false === $count) {
            global $wpdb;

            $sqlStringLoggersUserCanRead = $this->getLoggersThatUserCanRead(null, 'sql');

            $sql = sprintf(
                '
                    SELECT count(*)
                    FROM %1$s
                    WHERE UNIX_TIMESTAMP(date) >= %2$d
                    AND logger IN %3$s
                ',
                $wpdb->prefix . SimpleHistory::DBTABLE,
                strtotime("-$period_days days"),
                $sqlStringLoggersUserCanRead
            );

            $count = $wpdb->get_var($sql);

            set_transient($transient_key, $count, HOUR_IN_SECONDS);
        }

        return $count;
    }

    public function get_num_events_per_day_last_n_days($period_days = 28)
    {
        $transient_key = 'sh_' . md5(__METHOD__ . $period_days . '_2');

        $dates = get_transient($transient_key);

        if (false === $dates) {
            global $wpdb;

            $sqlStringLoggersUserCanRead = $this->getLoggersThatUserCanRead(null, 'sql');

            $sql = sprintf(
                '
                    SELECT
                        date_format(date, "%%Y-%%m-%%d") AS yearDate,
                        count(date) AS count
                    FROM
                        %1$s
                    WHERE
                        UNIX_TIMESTAMP(date) >= %2$d
                        AND logger IN (%3$d)
                    GROUP BY yearDate
                    ORDER BY yearDate ASC
                ',
                $wpdb->prefix . SimpleHistory::DBTABLE,
                strtotime("-$period_days days"),
                $sqlStringLoggersUserCanRead
            );

            $dates = $wpdb->get_results($sql);

            set_transient($transient_key, $dates, HOUR_IN_SECONDS);
            // echo "set";exit;
        } else {
            // echo "get";exit;
        }

        return $dates;
    }

    // Number of unique events the last n days
    public function get_unique_events_for_days($days = 7)
    {
        global $wpdb;

        $days = (int) $days;

        $table_name = $wpdb->prefix . SimpleHistory::DBTABLE;

        $cache_key = 'sh_' . md5(__METHOD__ . $days);

        $numEvents = get_transient($cache_key);

        if (false == $numEvents) {
            $sql = $wpdb->prepare(
                "
                SELECT count( DISTINCT occasionsID )
                FROM $table_name
                WHERE date >= DATE_ADD(CURDATE(), INTERVAL -%d DAY)
            ",
                $days
            );

            $numEvents = $wpdb->get_var($sql);

            set_transient($cache_key, $numEvents, HOUR_IN_SECONDS);
        }

        return $numEvents;
    }

    /**
     * Output an admin notice about logger slug being to long
     */
    public function admin_notice_logger_slug_to_long()
    {
        ?>
            <div class="error notice">
                <p>
                    <?php echo esc_html__(
                        'The slug for a logger in Simple History can be max 30 chars long.',
                        'simple-history'
                    ); ?></p>
            </div>
        <?php
    }
}
