prefix . 'ainews_history'; // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching,WordPress.DB.DirectDatabaseQuery.SchemaChange $wpdb->query("DROP TABLE IF EXISTS {$table_name}"); // Remove post meta data for AI generated posts using optimized queries // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching $wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->postmeta} WHERE meta_key = %s", '_ainews_generated')); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching $wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->postmeta} WHERE meta_key = %s", '_ainews_language')); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching $wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->postmeta} WHERE meta_key = %s", '_ainews_featured_image_generated')); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching $wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->postmeta} WHERE meta_key = %s", '_ainews_featured_image_service')); // Clean up any transients // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching $wpdb->query("DELETE FROM {$wpdb->options} WHERE option_name LIKE '_transient_ainews_%'"); // phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching $wpdb->query("DELETE FROM {$wpdb->options} WHERE option_name LIKE '_transient_timeout_ainews_%'"); // Remove any custom prompts files in uploads directory (if they exist) $uploads = wp_upload_dir(); if (!empty($uploads['basedir'])) { $ainews_dir = trailingslashit($uploads['basedir']) . 'ainews/'; // Initialize WP_Filesystem before using it global $wp_filesystem; if (empty($wp_filesystem)) { require_once(ABSPATH . '/wp-admin/includes/file.php'); WP_Filesystem(); } if ($wp_filesystem->is_dir($ainews_dir)) { // Remove prompts.json override file if exists $prompts_file = $ainews_dir . 'prompts.json'; if ($wp_filesystem->exists($prompts_file)) { $wp_filesystem->delete($prompts_file); } // Remove directory if empty if ($wp_filesystem->is_dir($ainews_dir)) { $wp_filesystem->rmdir($ainews_dir); } } } // Optional: Remove generated posts (commented out by default to prevent accidental data loss) // Uncomment the following lines if you want to delete all AI-generated posts on uninstall /* $ai_posts = get_posts(array( 'meta_key' => '_ainews_generated', 'meta_value' => true, 'post_type' => 'post', 'post_status' => 'any', 'numberposts' => -1 )); foreach ($ai_posts as $post) { wp_delete_post($post->ID, true); // true = force delete (skip trash) } */