<?php
defined('WP_UNINSTALL_PLUGIN') || exit();
$apeari_remove = static function () {
    global $wpdb;
    foreach (['apeari_', '_transient_apeari_', '_transient_timeout_apeari_'] as $prefix) {
        $apeari_names = $wpdb->get_col(
            $wpdb->prepare(
                "SELECT option_name FROM {$wpdb->options} WHERE option_name LIKE %s",
                $wpdb->esc_like($prefix) . '%',
            ),
        );
        foreach ($apeari_names as $apeari_name) {
            delete_option($apeari_name);
        }
    }
    foreach (
        ['apeari_conversations_', 'apeari_cache_', 'apeari_pro_intro_dismissed_', 'apeari_editor_tour_seen_']
        as $prefix
    ) {
        $rows = $wpdb->get_results(
            $wpdb->prepare(
                "SELECT user_id,meta_key,meta_value FROM {$wpdb->usermeta} WHERE meta_key = %s",
                $prefix . get_current_blog_id(),
            ),
        );
        foreach ($rows as $row) {
            if ($prefix === 'apeari_cache_') {
                foreach ((array) maybe_unserialize($row->meta_value) as $key => $expires) {
                    if (str_starts_with($key, 'apeari_')) {
                        delete_transient($key);
                    }
                }
            }
            delete_user_meta((int) $row->user_id, $row->meta_key);
        }
    }
    wp_clear_scheduled_hook('apeari_cleanup');
};
if (is_multisite()) {
    foreach (get_sites(['fields' => 'ids', 'number' => 0]) as $apeari_site) {
        switch_to_blog($apeari_site);
        $apeari_remove();
        restore_current_blog();
    }
    foreach (get_networks(['fields' => 'ids', 'number' => 0]) as $apeari_network) {
        delete_network_option((int) $apeari_network, 'apeari_privacy_version');
    }
} else {
    $apeari_remove();
}