{"slug":"lunexia-htaccess-shield","name":"Lunexia .htaccess Shield","description":"Professional website security hardening with IP blocking system by automatically applying common .htaccess security rules safely.","author":"lunexiait","active_installs":0,"version":"3.2.1","wp_org_url":"https://wordpress.org/plugins/lunexia-htaccess-shield/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"lunexia_blocks","full_table_name":"wp_lunexia_blocks","description":"Stores lunexia blocks data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"lunexia_feed_updates","full_table_name":"wp_lunexia_feed_updates","description":"Stores lunexia feed updates data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"feed_type","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"feed_url","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"version","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"items_updated","type":"int(10)","nullable":true,"primary_key":false},{"name":"items_added","type":"int(10)","nullable":true,"primary_key":false},{"name":"items_removed","type":"int(10)","nullable":true,"primary_key":false},{"name":"status","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"error_message","type":"text","nullable":true,"primary_key":false},{"name":"next_update","type":"datetime","nullable":true,"primary_key":false},{"name":"last_update","type":"datetime","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_lunexia_feed_updates ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, feed_type varchar(100) NOT NULL, feed_url varchar(255), version varchar(20), items_updated int(10) DEFAULT 0, items_added int(10) DEFAULT 0, items_removed int(10) DEFAULT 0, status varchar(50), error_message text, next_update datetime, last_update datetime, created_at datetime NOT NULL, PRIMARY KEY (id), KEY feed_type (feed_type), KEY last_update (last_update), KEY next_update (next_update) ) {$charset_collate};\"; dbDelta( $sql );"},{"table_name":"lunexia_geo_cache","full_table_name":"wp_lunexia_geo_cache","description":"A cache table that stores temporary computed or fetched data.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"ip_address","type":"varchar(45)","nullable":false,"primary_key":false},{"name":"country_code","type":"varchar(10)","nullable":true,"primary_key":false},{"name":"country_name","type":"varchar(191)","nullable":true,"primary_key":false},{"name":"region","type":"varchar(191)","nullable":true,"primary_key":false},{"name":"city","type":"varchar(191)","nullable":true,"primary_key":false},{"name":"latitude","type":"decimal(10,8)","nullable":true,"primary_key":false},{"name":"longitude","type":"decimal(11,8)","nullable":true,"primary_key":false},{"name":"asn","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"hosting_provider","type":"varchar(191)","nullable":true,"primary_key":false},{"name":"is_vpn","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"is_proxy","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"is_datacenter","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"threat_level","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"last_lookup","type":"datetime","nullable":true,"primary_key":false},{"name":"cache_expires","type":"datetime","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_lunexia_geo_cache ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, ip_address varchar(45) NOT NULL, country_code varchar(10), country_name varchar(191), region varchar(191), city varchar(191), latitude decimal(10,8), longitude decimal(11,8), asn varchar(50), hosting_provider varchar(191), is_vpn tinyint(1) DEFAULT 0, is_proxy tinyint(1) DEFAULT 0, is_datacenter tinyint(1) DEFAULT 0, threat_level varchar(20), last_lookup datetime, cache_expires datetime, created_at datetime NOT NULL, PRIMARY KEY (id), UNIQUE KEY ip_address (ip_address), KEY country_code (country_code), KEY asn (asn), KEY cache_expires (cache_expires) ) {$charset_collate};\"; dbDelta( $sql );"},{"table_name":"lunexia_ip_reputation","full_table_name":"wp_lunexia_ip_reputation","description":"Stores lunexia ip reputation data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"ip_address","type":"varchar(45)","nullable":false,"primary_key":false},{"name":"threat_score","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"last_activity","type":"datetime","nullable":false,"primary_key":false},{"name":"activity_count","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"failed_logins","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"sql_injection_attempts","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"xss_attempts","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"malware_uploads","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"rate_limit_violations","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"scanner_activities","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"webshells_detected","type":"int(10) unsigned","nullable":false,"primary_key":false},{"name":"notes","type":"longtext","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"expires_at","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_lunexia_ip_reputation ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, ip_address varchar(45) NOT NULL, threat_score bigint(20) NOT NULL DEFAULT 0, last_activity datetime NOT NULL, activity_count int(10) unsigned NOT NULL DEFAULT 1, failed_logins int(10) unsigned NOT NULL DEFAULT 0, sql_injection_attempts int(10) unsigned NOT NULL DEFAULT 0, xss_attempts int(10) unsigned NOT NULL DEFAULT 0, malware_uploads int(10) unsigned NOT NULL DEFAULT 0, rate_limit_violations int(10) unsigned NOT NULL DEFAULT 0, scanner_activities int(10) unsigned NOT NULL DEFAULT 0, webshells_detected int(10) unsigned NOT NULL DEFAULT 0, notes longtext, created_at datetime NOT NULL, expires_at datetime DEFAULT NULL, PRIMARY KEY (id), UNIQUE KEY ip_address (ip_address), KEY threat_score (threat_score), KEY last_activity (last_activity), KEY expires_at (expires_at) ) {$charset_collate};\"; dbDelta( $sql );"},{"table_name":"lunexia_live_traffic","full_table_name":"wp_lunexia_live_traffic","description":"Stores lunexia live traffic data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"lunexia_live_traffic_queue","full_table_name":"wp_lunexia_live_traffic_queue","description":"A job queue table for managing background tasks and scheduled operations.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"lunexia_logs","full_table_name":"wp_lunexia_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"lunexia_malicious_ips","full_table_name":"wp_lunexia_malicious_ips","description":"Stores lunexia malicious ips data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"ip_address","type":"varchar(45)","nullable":false,"primary_key":false},{"name":"threat_type","type":"varchar(100)","nullable":true,"primary_key":false},{"name":"confidence","type":"int(10)","nullable":true,"primary_key":false},{"name":"source","type":"varchar(191)","nullable":true,"primary_key":false},{"name":"first_seen","type":"datetime","nullable":true,"primary_key":false},{"name":"last_seen","type":"datetime","nullable":true,"primary_key":false},{"name":"is_active","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_lunexia_malicious_ips ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, ip_address varchar(45) NOT NULL, threat_type varchar(100), confidence int(10) DEFAULT 0, source varchar(191), first_seen datetime, last_seen datetime, is_active tinyint(1) DEFAULT 1, created_at datetime NOT NULL, PRIMARY KEY (id), UNIQUE KEY ip_address (ip_address), KEY threat_type (threat_type), KEY is_active (is_active) ) {$charset_collate};\"; dbDelta( $sql );"},{"table_name":"lunexia_malware_hashes","full_table_name":"wp_lunexia_malware_hashes","description":"Stores lunexia malware hashes data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"lunexia_scan_issues","full_table_name":"wp_lunexia_scan_issues","description":"Stores lunexia scan issues data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"lunexia_security_events","full_table_name":"wp_lunexia_security_events","description":"Stores lunexia security events data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"event_type","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"severity","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"ip_address","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"username","type":"varchar(191)","nullable":true,"primary_key":false},{"name":"event_data","type":"longtext","nullable":true,"primary_key":false},{"name":"file_path","type":"text","nullable":true,"primary_key":false},{"name":"threat_score","type":"int(10) unsigned","nullable":true,"primary_key":false},{"name":"action_taken","type":"varchar(191)","nullable":true,"primary_key":false},{"name":"resolved","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_lunexia_security_events ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, event_type varchar(100) NOT NULL, severity varchar(20) NOT NULL, ip_address varchar(45), username varchar(191), event_data longtext, file_path text, threat_score int(10) unsigned DEFAULT 0, action_taken varchar(191), resolved tinyint(1) NOT NULL DEFAULT 0, created_at datetime NOT NULL, PRIMARY KEY (id), KEY event_type (event_type), KEY severity (severity), KEY ip_address (ip_address), KEY created_at (created_at), KEY resolved (resolved) ) {$charset_collate};\"; dbDelta( $sql );"},{"table_name":"lunexia_threat_rules","full_table_name":"wp_lunexia_threat_rules","description":"Stores lunexia threat rules data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"lunexia_threat_signatures","full_table_name":"wp_lunexia_threat_signatures","description":"Stores lunexia threat signatures data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"lunexia_vulnerabilities","full_table_name":"wp_lunexia_vulnerabilities","description":"Stores lunexia vulnerabilities data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"product_type","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"product_name","type":"varchar(191)","nullable":false,"primary_key":false},{"name":"vulnerable_version_from","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"vulnerable_version_to","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"fixed_version","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"severity","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"cve_id","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"cvss_score","type":"decimal(3,1)","nullable":true,"primary_key":false},{"name":"description","type":"text","nullable":true,"primary_key":false},{"name":"reference_url","type":"text","nullable":true,"primary_key":false},{"name":"discovered_date","type":"datetime","nullable":true,"primary_key":false},{"name":"published_date","type":"datetime","nullable":true,"primary_key":false},{"name":"is_exploited","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"source","type":"varchar(191)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":false,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_lunexia_vulnerabilities ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, product_type varchar(50) NOT NULL, product_name varchar(191) NOT NULL, vulnerable_version_from varchar(50), vulnerable_version_to varchar(50), fixed_version varchar(50), severity varchar(20), cve_id varchar(50), cvss_score decimal(3,1), description text, reference_url text, discovered_date datetime, published_date datetime, is_exploited tinyint(1) DEFAULT 0, source varchar(191), created_at datetime NOT NULL, updated_at datetime, PRIMARY KEY (id), KEY product_type (product_type), KEY product_name (product_name), KEY severity (severity), KEY cve_id (cve_id) ) {$charset_collate};\"; dbDelta( $sql );"}],"table_count":14}