uninstall.php — WooCommerce 10.5.1

woocommerce / uninstall.php

woocommerce Last commit date

assets 4 months ago i18n 3 months ago includes 3 months ago lib 6 months ago packages 4 months ago patterns 6 months ago sample-data 2 years ago src 3 months ago templates 3 months ago vendor 3 months ago license.txt 6 years ago readme.txt 3 months ago uninstall.php 7 months ago woocommerce.php 3 months ago

uninstall.php

138 lines

1	<?php
2	/**
3	* WooCommerce Uninstall
4	*
5	* Uninstalling WooCommerce deletes user roles, pages, tables, and options.
6	*
7	* @package WooCommerce\Uninstaller
8	* @version 2.3.0
9	*/
10
11	defined( 'WP_UNINSTALL_PLUGIN' ) \|\| exit;
12
13	global $wpdb, $wp_version, $wc_uninstalling_plugin;
14
15	$wc_uninstalling_plugin = true;
16
17	// Clear WordPress cron events.
18	wp_clear_scheduled_hook( 'woocommerce_scheduled_sales' );
19	wp_clear_scheduled_hook( 'woocommerce_cancel_unpaid_orders' );
20	wp_clear_scheduled_hook( 'woocommerce_cleanup_sessions' );
21	wp_clear_scheduled_hook( 'woocommerce_cleanup_personal_data' );
22	wp_clear_scheduled_hook( 'woocommerce_cleanup_logs' );
23	wp_clear_scheduled_hook( 'woocommerce_geoip_updater' );
24	wp_clear_scheduled_hook( 'woocommerce_tracker_send_event' );
25	wp_clear_scheduled_hook( 'woocommerce_cleanup_rate_limits' );
26	wp_clear_scheduled_hook( 'wc_admin_daily' );
27	wp_clear_scheduled_hook( 'generate_category_lookup_table' );
28	wp_clear_scheduled_hook( 'wc_admin_unsnooze_admin_notes' );
29
30	if ( class_exists( ActionScheduler::class ) && ActionScheduler::is_initialized() && function_exists( 'as_unschedule_all_actions' ) ) {
31	as_unschedule_all_actions( 'woocommerce_scheduled_sales' );
32	as_unschedule_all_actions( 'woocommerce_cancel_unpaid_orders' );
33	as_unschedule_all_actions( 'woocommerce_cleanup_sessions' );
34	as_unschedule_all_actions( 'woocommerce_cleanup_personal_data' );
35	as_unschedule_all_actions( 'woocommerce_cleanup_logs' );
36	as_unschedule_all_actions( 'woocommerce_geoip_updater' );
37	as_unschedule_all_actions( 'woocommerce_tracker_send_event' );
38	as_unschedule_all_actions( 'woocommerce_cleanup_rate_limits' );
39	as_unschedule_all_actions( 'wc_admin_daily' );
40	as_unschedule_all_actions( 'generate_category_lookup_table' );
41	as_unschedule_all_actions( 'wc_admin_unsnooze_admin_notes' );
42	}
43
44	/*
45	* Only remove ALL product and page data if WC_REMOVE_ALL_DATA constant is set to true in user's
46	* wp-config.php. This is to prevent data loss when deleting the plugin from the backend
47	* and to ensure only the site owner can perform this action.
48	*/
49	if ( defined( 'WC_REMOVE_ALL_DATA' ) && true === WC_REMOVE_ALL_DATA ) {
50	// Load WooCommerce so we can access the container, install routines, etc, during uninstall.
51	require_once __DIR__ . '/includes/class-wc-install.php';
52
53	// Drop custom WordPress tables indexes. See \WC_Install::create_tables() for details.
54	$index_exists = $wpdb->get_row( "SHOW INDEX FROM {$wpdb->comments} WHERE key_name = 'woo_idx_comment_type';" );
55	if ( null !== $index_exists ) {
56	$wpdb->query( "ALTER TABLE {$wpdb->comments} DROP INDEX woo_idx_comment_type;" );
57	}
58	$date_type_index_exists = $wpdb->get_row( "SHOW INDEX FROM {$wpdb->comments} WHERE key_name = 'woo_idx_comment_date_type';" );
59	if ( null !== $date_type_index_exists ) {
60	$wpdb->query( "ALTER TABLE {$wpdb->comments} DROP INDEX woo_idx_comment_date_type;" );
61	}
62
63	// Roles + caps.
64	WC_Install::remove_roles();
65
66	// Pages.
67	wp_trash_post( get_option( 'woocommerce_shop_page_id' ) );
68	wp_trash_post( get_option( 'woocommerce_cart_page_id' ) );
69	wp_trash_post( get_option( 'woocommerce_checkout_page_id' ) );
70	wp_trash_post( get_option( 'woocommerce_myaccount_page_id' ) );
71	wp_trash_post( get_option( 'woocommerce_edit_address_page_id' ) );
72	wp_trash_post( get_option( 'woocommerce_view_order_page_id' ) );
73	wp_trash_post( get_option( 'woocommerce_change_password_page_id' ) );
74	wp_trash_post( get_option( 'woocommerce_logout_page_id' ) );
75
76	if ( $wpdb->get_var( "SHOW TABLES LIKE '{$wpdb->prefix}woocommerce_attribute_taxonomies';" ) ) {
77	$wc_attributes = array_filter( (array) $wpdb->get_col( "SELECT attribute_name FROM {$wpdb->prefix}woocommerce_attribute_taxonomies;" ) );
78	} else {
79	$wc_attributes = array();
80	}
81
82	// Tables.
83	WC_Install::drop_tables();
84
85	// Delete options.
86	$wpdb->query( "DELETE FROM $wpdb->options WHERE option_name LIKE 'woocommerce\_%';" );
87	$wpdb->query( "DELETE FROM $wpdb->options WHERE option_name LIKE 'widget\_woocommerce\_%';" );
88
89	// Delete usermeta.
90	$wpdb->query( "DELETE FROM $wpdb->usermeta WHERE meta_key LIKE 'woocommerce\_%';" );
91
92	// Delete our data from the post and post meta tables, and remove any additional tables we created.
93	$wpdb->query( "DELETE FROM {$wpdb->posts} WHERE post_type IN ( 'product', 'product_variation', 'shop_coupon', 'shop_order', 'shop_order_refund' );" );
94	$wpdb->query( "DELETE meta FROM {$wpdb->postmeta} meta LEFT JOIN {$wpdb->posts} posts ON posts.ID = meta.post_id WHERE posts.ID IS NULL;" );
95
96	$wpdb->query( "DELETE FROM {$wpdb->comments} WHERE comment_type IN ( 'order_note' );" );
97	$wpdb->query( "DELETE meta FROM {$wpdb->commentmeta} meta LEFT JOIN {$wpdb->comments} comments ON comments.comment_ID = meta.comment_id WHERE comments.comment_ID IS NULL;" );
98
99	// Delete terms if > WP 4.2 (term splitting was added in 4.2).
100	if ( version_compare( $wp_version, '4.2', '>=' ) ) {
101	// Delete term taxonomies.
102	foreach ( array( 'product_cat', 'product_tag', 'product_shipping_class', 'product_type' ) as $_taxonomy ) {
103	$wpdb->delete(
104	$wpdb->term_taxonomy,
105	array(
106	'taxonomy' => $_taxonomy,
107	)
108	);
109	}
110
111	// Delete term attributes.
112	foreach ( $wc_attributes as $_taxonomy ) {
113	$wpdb->delete(
114	$wpdb->term_taxonomy,
115	array(
116	'taxonomy' => 'pa_' . $_taxonomy,
117	)
118	);
119	}
120
121	// Delete orphan relationships.
122	$wpdb->query( "DELETE tr FROM {$wpdb->term_relationships} tr LEFT JOIN {$wpdb->posts} posts ON posts.ID = tr.object_id WHERE posts.ID IS NULL;" );
123
124	// Delete orphan terms.
125	$wpdb->query( "DELETE t FROM {$wpdb->terms} t LEFT JOIN {$wpdb->term_taxonomy} tt ON t.term_id = tt.term_id WHERE tt.term_id IS NULL;" );
126
127	// Delete orphan term meta.
128	if ( ! empty( $wpdb->termmeta ) ) {
129	$wpdb->query( "DELETE tm FROM {$wpdb->termmeta} tm LEFT JOIN {$wpdb->term_taxonomy} tt ON tm.term_id = tt.term_id WHERE tt.term_id IS NULL;" );
130	}
131	}
132
133	// Clear any cached data that has been removed.
134	wp_cache_flush();
135	}
136
137	unset( $wc_uninstalling_plugin );
138