'; } else{ echo'

'.esc_html($state_text).'

'; } } static function get_logs(){ global $wpdb; $table_name = $wpdb->prefix . 'siteseo_redirect_logs'; self::maybe_create_404_table(); $results = $wpdb->get_results("SELECT * FROM $table_name ORDER BY timestamp DESC"); return ['items' => $results]; } static function maybe_create_404_table(){ global $wpdb; $charset_collate = $wpdb->get_charset_collate(); $sql = "CREATE TABLE IF NOT EXISTS `".$wpdb->prefix."siteseo_redirect_logs` ( id mediumint(9) NOT NULL AUTO_INCREMENT, url varchar(255) NOT NULL, ip_address varchar(46), timestamp datetime DEFAULT CURRENT_TIMESTAMP, user_agent text, referer varchar(255), hit_count int DEFAULT 1, PRIMARY KEY (id), KEY url (url) ) $charset_collate;"; require_once(ABSPATH . 'wp-admin/includes/upgrade.php'); dbDelta($sql); } }