'.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);
}
}