uninstaller.php

<?php
/**
 * Fired when the plugin is uninstalled.
 *
 * @package WebberZone\Knowledge_Base
 */

// If uninstall not called from WordPress, then exit.
if ( ! defined( 'WP_UNINSTALL_PLUGIN' ) ) {
	exit;
}

global $wpdb;

if ( is_multisite() ) {

	// Get all blogs in the network and activate plugin on each one.
	$wzkb_blogids = $wpdb->get_col( //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching
		"
		SELECT blog_id FROM $wpdb->blogs
		WHERE archived = '0' AND spam = '0' AND deleted = '0'
	"
	);

	foreach ( $wzkb_blogids as $wzkb_blogid ) {
		switch_to_blog( $wzkb_blogid );
		wzkb_delete_data();
		restore_current_blog();
	}
} else {
	wzkb_delete_data();
}


/**
 * Delete Data.
 *
 * @since 1.3.0
 */
function wzkb_delete_data() {

	$settings = get_option( 'wzkb_settings' );

	if ( ! empty( $settings['uninstall_options'] ) ) {

		delete_option( 'wzkb_settings' );

	}

	if ( ! empty( $settings['uninstall_data'] ) ) {

		$wzkbs = get_posts(
			array(
				'post_type' => 'wz_knowledgebase',
			)
		);

		foreach ( $wzkbs as $wzkb ) {
			wp_delete_post( $wzkb->ID );
		}

		wzkb_delete_taxonomy( 'wzkb_category' );
		wzkb_delete_taxonomy( 'wzkb_tag' );
		wzkb_delete_taxonomy( 'wzkb_product' );

		// Delete rating data.
		wzkb_delete_rating_data();
	}

	// Delete the cache.
	wzkb_delete_cache();
}


/**
 * Delete Custom Taxonomy.
 *
 * @since 1.3.0
 *
 * @param string $taxonomy Custom taxonomy.
 */
function wzkb_delete_taxonomy( $taxonomy ) {
	global $wpdb;

	$query = 'SELECT t.name, t.term_id
            FROM ' . $wpdb->terms . ' AS t
            INNER JOIN ' . $wpdb->term_taxonomy . ' AS tt
            ON t.term_id = tt.term_id
            WHERE tt.taxonomy = "' . $taxonomy . '"';

	$terms = $wpdb->get_results( $query ); //phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared,WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching, PluginCheck.Security.DirectDB.UnescapedDBParameter 

	foreach ( $terms as $term ) {
		wp_delete_term( $term->term_id, $taxonomy );
	}
}

/**
 * Delete Cache.
 *
 * @since 1.8.0
 */
function wzkb_delete_cache() {
	global $wpdb;

	$sql = "
		DELETE FROM {$wpdb->termmeta}
		WHERE `meta_key` LIKE '_wzkb_cache_%'
	";

	$wpdb->query( $sql ); //phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared,WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching
}

/**
 * Delete Rating Data.
 *
 * Removes all rating-related post meta from the database.
 *
 * @since 3.0.0
 */
function wzkb_delete_rating_data() {
	global $wpdb;

	// Array of rating meta keys to delete.
	$rating_meta_keys = array(
		'_wzkb_rating_total',
		'_wzkb_rating_sum',
		'_wzkb_rating_positive',
		'_wzkb_ratings',
		'_wzkb_rating_ips',
		'_wzkb_rating_user_ids',
		'_wzkb_rating_feedback',
	);

	// Delete all rating meta for each key.
	foreach ( $rating_meta_keys as $meta_key ) {
		 //phpcs:ignore WordPress.DB.DirectDatabaseQuery.DirectQuery,WordPress.DB.DirectDatabaseQuery.NoCaching
		$wpdb->query(
			$wpdb->prepare(
				"DELETE FROM {$wpdb->postmeta} WHERE meta_key = %s",
				$meta_key
			)
		);
	}

	// Delete rating cache.
	wp_cache_delete( 'wzkb_rating_global_mean_binary', 'wzkb_rating' );
	wp_cache_delete( 'wzkb_rating_global_mean_scale', 'wzkb_rating' );
}