<?php
/**
 * Runs when the plugin is deleted: removes every story, the Slicewise capabilities, every slicewise_ option
 * and each administrator's dismissal of the upgrade notice.
 *
 * @package Slicewise
 */

defined( 'WP_UNINSTALL_PLUGIN' ) || exit;

foreach ( get_posts( array( 'post_type' => 'slicewise_story', 'post_status' => 'any', 'numberposts' => -1, 'fields' => 'ids' ) ) as $slicewise_story ) {
	wp_delete_post( $slicewise_story, true );
}

foreach ( wp_roles()->role_objects as $slicewise_role ) {
	$slicewise_role->remove_cap( 'slicewise_manage' );
	$slicewise_role->remove_cap( 'slicewise_view' );
}

global $wpdb;
$slicewise_options = $wpdb->get_col( $wpdb->prepare( "SELECT option_name FROM {$wpdb->options} WHERE option_name LIKE %s OR option_name LIKE %s OR option_name LIKE %s", $wpdb->esc_like( 'slicewise_' ) . '%', $wpdb->esc_like( '_transient_slicewise_' ) . '%', $wpdb->esc_like( '_transient_timeout_slicewise_' ) . '%' ) ); // phpcs:ignore WordPress.DB.DirectDatabaseQuery
foreach ( $slicewise_options as $slicewise_option ) {
	delete_option( $slicewise_option );
}

delete_metadata( 'user', 0, 'slicewise_upsell_dismissed', '', true );