{"slug":"dreamcore-monitor","name":"DreamCore Monitor","description":"WordPress monitoring solution that tracks login attempts, core status, plugin updates, theme status, and file integrity.","author":"ifsolutions","active_installs":10,"version":"1.1.0","wp_org_url":"https://wordpress.org/plugins/dreamcore-monitor/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"dreamcore_monitor_logins","full_table_name":"wp_dreamcore_monitor_logins","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":true},{"name":"username","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"user_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"user_role","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"ip_address","type":"VARCHAR(45)","nullable":false,"primary_key":false},{"name":"user_agent","type":"TEXT","nullable":true,"primary_key":false},{"name":"country","type":"VARCHAR(100)","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"exported","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"exported_at","type":"DATETIME","nullable":true,"primary_key":false},{"name":"batch_id","type":"VARCHAR(100)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_dreamcore_monitor_logins ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, username VARCHAR(100) NOT NULL, user_id BIGINT UNSIGNED NULL, user_role VARCHAR(50) NULL, status VARCHAR(20) NOT NULL, ip_address VARCHAR(45) NOT NULL, user_agent TEXT NULL, country VARCHAR(100) DEFAULT 'Unknown', created_at DATETIME DEFAULT CURRENT_TIMESTAMP, exported TINYINT(1) DEFAULT 0, exported_at DATETIME NULL, batch_id VARCHAR(100) NULL, INDEX idx_status (status), INDEX idx_created_at (created_at), INDEX idx_username (username), INDEX idx_ip_address (ip_address), INDEX idx_exported (exported), INDEX idx_exported_at (exported_at), INDEX idx_batch_id (batch_id) ) {$charset_collate}\"; // Safe loading of upgrade.php with proper path handling $upgrade_file = wp_normalize_path( ABSPATH . 'wp-admin/includes/upgrade.php' );"},{"table_name":"dreamcore_monitor_user_agents","full_table_name":"wp_dreamcore_monitor_user_agents","description":"Stores dreamcore monitor user agents data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":true},{"name":"user_agent_string","type":"TEXT","nullable":false,"primary_key":false},{"name":"user_agent_hash","type":"VARCHAR(32)","nullable":false,"primary_key":false},{"name":"category","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"agent_name","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"agent_version","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"visit_count","type":"BIGINT UNSIGNED","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":"last_ip","type":"VARCHAR(45)","nullable":true,"primary_key":false},{"name":"last_page","type":"TEXT","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_dreamcore_monitor_user_agents ( id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY, user_agent_string TEXT NOT NULL, user_agent_hash VARCHAR(32) NOT NULL, category VARCHAR(20) NOT NULL DEFAULT 'unknown', agent_name VARCHAR(100) NOT NULL DEFAULT 'Unknown', agent_version VARCHAR(20) DEFAULT '', visit_count BIGINT UNSIGNED DEFAULT 1, first_seen DATETIME DEFAULT CURRENT_TIMESTAMP, last_seen DATETIME DEFAULT CURRENT_TIMESTAMP, last_ip VARCHAR(45) DEFAULT '', last_page TEXT DEFAULT '', UNIQUE KEY idx_user_agent_hash (user_agent_hash), INDEX idx_category (category), INDEX idx_agent_name (agent_name), INDEX idx_visit_count (visit_count), INDEX idx_last_seen (last_seen), INDEX idx_first_seen (first_seen) ) {$charset_collate}\"; // Safe loading of upgrade.php with proper path handling $upgrade_file = wp_normalize_path( ABSPATH . 'wp-admin/includes/upgrade.php' );"}],"table_count":2}