uninstall.php
3.13 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
<?php
/**
* Uninstall My Calendar.
*
* @category Core
* @package My Calendar
* @author Joe Dolson
* @license GPLv2 or later
* @link https://www.joedolson.com/my-calendar/
*/
if ( ! defined( 'ABSPATH' ) && ! defined( 'WP_UNINSTALL_PLUGIN' ) ) {
exit();
} else {
/**
* Delete all custom templates, stored category icons SVG data, and widget info.
*/
function mc_delete_templates() {
global $wpdb;
// Delete templates.
$results = $wpdb->get_results( 'SELECT * FROM ' . $wpdb->prefix . "options WHERE option_name LIKE '%mc_ctemplate_%'" );
foreach ( $results as $result ) {
$key = str_replace( 'mc_ctemplate_', '', $result->option_name );
delete_option( "mc_template_desc_$key" );
delete_option( "mc_ctemplate_$key" );
}
// Delete stored category icons.
$results = $wpdb->get_results( 'SELECT * FROM ' . $wpdb->prefix . "options WHERE option_name LIKE '%mc_category_icon_%'" );
foreach ( $results as $result ) {
delete_option( $result->option_name );
}
// Delete widget data.
$results = $wpdb->get_results( 'SELECT * FROM ' . $wpdb->prefix . "options WHERE option_name LIKE '%widget_my_calendar%'" );
foreach ( $results as $result ) {
delete_option( $result->option_name );
}
}
$options = get_option( 'my_calendar_options' );
if ( 'true' === $options['drop_settings'] ) {
delete_option( 'my_calendar_options' );
delete_option( 'ko_calendar_imported' );
delete_option( 'mc_count_cache' );
// Deletes custom template options.
mc_delete_templates();
}
if ( 'true' === $options['drop_tables'] ) {
global $wpdb;
// Delete posts & post meta for events.
$result = $wpdb->get_results( $wpdb->prepare( 'SELECT ID FROM ' . $wpdb->posts . ' WHERE post_type = %s', 'mc-events' ) );
foreach ( $result as $r ) {
$post_id = $r->ID;
$wpdb->query( $wpdb->prepare( 'DELETE FROM ' . $wpdb->posts . ' WHERE ID = %d AND post_type = "mc-events"', $post_id ) );
$wpdb->query( $wpdb->prepare( 'DELETE FROM ' . $wpdb->postmeta . ' WHERE post_id = %s', $post_id ) );
}
// Delete posts and post meta for locations.
$wpdb->query( $wpdb->prepare( 'SELECT ID FROM ' . $wpdb->posts . ' WHERE post_type = %s', 'mc-locations' ) );
foreach ( $result as $r ) {
$post_id = $r->ID;
$wpdb->query( $wpdb->prepare( 'DELETE FROM ' . $wpdb->posts . ' WHERE ID = %d AND post_type = "mc-locations"', $post_id ) );
$wpdb->query( $wpdb->prepare( 'DELETE FROM ' . $wpdb->postmeta . ' WHERE post_id = %s', $post_id ) );
}
// Drop custom tables.
$wpdb->query( 'DROP TABLE IF EXISTS ' . $wpdb->prefix . 'my_calendar' );
$wpdb->query( 'DROP TABLE IF EXISTS ' . $wpdb->prefix . 'my_calendar_events' );
$wpdb->query( 'DROP TABLE IF EXISTS ' . $wpdb->prefix . 'my_calendar_categories' );
$wpdb->query( 'DROP TABLE IF EXISTS ' . $wpdb->prefix . 'my_calendar_category_relationships' );
$wpdb->query( 'DROP TABLE IF EXISTS ' . $wpdb->prefix . 'my_calendar_locations' );
$wpdb->query( 'DROP TABLE IF EXISTS ' . $wpdb->prefix . 'my_calendar_location_relationships' );
}
delete_option( 'mc_promotion_scheduled' );
add_option( 'mc_uninstalled', 'true' );
}