{"slug":"gogasys-malware-scanner","name":"Gogasys Malware Scanner","description":"Advanced WordPress malware scanner, firewall, IP blocker, security headers, and attack monitoring plugin.","author":"Gogasys IT Solutions","active_installs":0,"version":"1.0.7","wp_org_url":"https://wordpress.org/plugins/gogasys-malware-scanner/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"gogasys_ms_file_hashes","full_table_name":"wp_gogasys_ms_file_hashes","description":"Stores gogasys ms file hashes data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"gogasys_ms_ips","full_table_name":"wp_gogasys_ms_ips","description":"Stores gogasys ms ips data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"gogasys_ms_logs","full_table_name":"wp_gogasys_ms_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"ip","type":"VARCHAR(45)","nullable":false,"primary_key":false},{"name":"country","type":"VARCHAR(5)","nullable":false,"primary_key":false},{"name":"request_uri","type":"TEXT","nullable":false,"primary_key":false},{"name":"request_type","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"pattern","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"block_reason","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"user_agent","type":"TEXT","nullable":false,"primary_key":false},{"name":"logged_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"ip","type":"VARCHAR(45)","nullable":false,"primary_key":false},{"name":"status","type":"ENUM('blocked','allowed')","nullable":false,"primary_key":false},{"name":"country","type":"VARCHAR(5)","nullable":false,"primary_key":false},{"name":"reason","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"file_path","type":"TEXT","nullable":false,"primary_key":false},{"name":"threat_type","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"hash","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"status","type":"ENUM('pending','quarantined','deleted','ignored')","nullable":false,"primary_key":false},{"name":"detected_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"file_path","type":"TEXT","nullable":false,"primary_key":false},{"name":"hash","type":"VARCHAR(64)","nullable":false,"primary_key":false},{"name":"scanned_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `wp_gogasys_ms_logs` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `ip` VARCHAR(45) NOT NULL DEFAULT '', `country` VARCHAR(5) NOT NULL DEFAULT '', `request_uri` TEXT NOT NULL, `request_type` VARCHAR(20) NOT NULL DEFAULT 'GET', `pattern` VARCHAR(255) NOT NULL DEFAULT '', `block_reason` VARCHAR(255) NOT NULL DEFAULT '', `user_agent` TEXT NOT NULL, `logged_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `ip` (`ip`), KEY `logged_at` (`logged_at`), KEY `country` (`country`) ) {$charset_collate};\"; // Blocked IPs table. $sql[] = \"CREATE TABLE IF NOT EXISTS `wp_gogasys_ms_ips` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `ip` VARCHAR(45) NOT NULL DEFAULT '', `status` ENUM('blocked','allowed') NOT NULL DEFAULT 'blocked', `country` VARCHAR(5) NOT NULL DEFAULT '', `reason` VARCHAR(255) NOT NULL DEFAULT '', `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), UNIQUE KEY `ip` (`ip`), KEY `status` (`status`) ) {$charset_collate};\"; // Scan results table. $sql[] = \"CREATE TABLE IF NOT EXISTS `wp_gogasys_ms_scan_results` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `file_path` TEXT NOT NULL, `threat_type` VARCHAR(100) NOT NULL DEFAULT '', `hash` VARCHAR(64) NOT NULL DEFAULT '', `status` ENUM('pending','quarantined','deleted','ignored') NOT NULL DEFAULT 'pending', `detected_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), KEY `status` (`status`), KEY `detected_at` (`detected_at`) ) {$charset_collate};\"; // File hashes baseline table. $sql[] = \"CREATE TABLE IF NOT EXISTS `wp_gogasys_ms_file_hashes` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `file_path` TEXT NOT NULL, `hash` VARCHAR(64) NOT NULL DEFAULT '', `scanned_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) {$charset_collate};\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; foreach ( $sql as $query ) { // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery dbDelta( $query );"},{"table_name":"gogasys_ms_scan_results","full_table_name":"wp_gogasys_ms_scan_results","description":"Stores gogasys ms scan results data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":4}