/**
* plugin_uninstall
*
* @access public
* @static
* @param bool $remove_all
* @return void
*/
public static function delete_all_espresso_tables_and_data($remove_all = true)
{
global $wpdb;
$undeleted_tables = array();
// load registry
foreach (EE_Registry::instance()->non_abstract_db_models as $model_name) {
if (method_exists($model_name, 'instance')) {
$model_obj = call_user_func(array($model_name, 'instance'));
if ($model_obj instanceof EEM_Base) {
foreach ($model_obj->get_tables() as $table) {
if (strpos($table->get_table_name(), 'esp_')) {
switch (EEH_Activation::delete_unused_db_table($table->get_table_name())) {
case false:
$undeleted_tables[] = $table->get_table_name();
break;
case 0:
// echo '<h4 style="color:red;">the table : ' . $table->get_table_name() . ' was not deleted <br /></h4>';
break;
default:
// echo '<h4>the table : ' . $table->get_table_name() . ' was deleted successfully <br /></h4>';
}
}
}
}
}
}
//there are some tables whose models were removed.
//they should be removed when removing all EE core's data
$tables_without_models = array('esp_promotion', 'esp_promotion_applied', 'esp_promotion_object', 'esp_promotion_rule', 'esp_rule');
foreach ($tables_without_models as $table) {
EEH_Activation::delete_db_table_if_empty($table);
}
$wp_options_to_delete = array('ee_no_ticket_prices' => true, 'ee_active_messengers' => true, 'ee_has_activated_messenger' => true, 'ee_flush_rewrite_rules' => true, 'ee_config' => false, 'ee_data_migration_current_db_state' => true, 'ee_data_migration_mapping_' => false, 'ee_data_migration_script_' => false, 'ee_data_migrations' => true, 'ee_dms_map' => false, 'ee_notices' => true, 'lang_file_check_' => false, 'ee_maintenance_mode' => true, 'ee_ueip_optin' => true, 'ee_ueip_has_notified' => true, 'ee_plugin_activation_errors' => true, 'ee_id_mapping_from' => false, 'espresso_persistent_admin_notices' => true, 'ee_encryption_key' => true, 'pue_force_upgrade_' => false, 'pue_json_error_' => false, 'pue_install_key_' => false, 'pue_verification_error_' => false, 'pu_dismissed_upgrade_' => false, 'external_updates-' => false, 'ee_extra_data' => true, 'ee_ssn_' => false, 'ee_rss_' => false, 'ee_rte_n_tx_' => false, 'ee_pers_admin_notices' => true, 'ee_job_parameters_' => false, 'ee_upload_directories_incomplete' => true);
if (is_main_site()) {
$wp_options_to_delete['ee_network_config'] = true;
}
$undeleted_options = array();
foreach ($wp_options_to_delete as $option_name => $no_wildcard) {
if ($no_wildcard) {
if (!delete_option($option_name)) {
$undeleted_options[] = $option_name;
}
} else {
$option_names_to_delete_from_wildcard = $wpdb->get_col("SELECT option_name FROM {$wpdb->options} WHERE option_name LIKE '%{$option_name}%'");
foreach ($option_names_to_delete_from_wildcard as $option_name_from_wildcard) {
if (!delete_option($option_name_from_wildcard)) {
$undeleted_options[] = $option_name_from_wildcard;
}
}
}
}
//also, let's make sure the "ee_config_option_names" wp option stays out by removing the action that adds it
remove_action('shutdown', array(EE_Config::instance(), 'shutdown'), 10);
if ($remove_all && ($espresso_db_update = get_option('espresso_db_update'))) {
$db_update_sans_ee4 = array();
foreach ($espresso_db_update as $version => $times_activated) {
if ($version[0] == '3') {
//if its NON EE4
$db_update_sans_ee4[$version] = $times_activated;
}
}
update_option('espresso_db_update', $db_update_sans_ee4);
}
$errors = '';
if (!empty($undeleted_tables)) {
$errors .= sprintf(__('The following tables could not be deleted: %s%s', 'event_espresso'), '<br/>', implode(',<br/>', $undeleted_tables));
}
if (!empty($undeleted_options)) {
$errors .= !empty($undeleted_tables) ? '<br/>' : '';
$errors .= sprintf(__('The following wp-options could not be deleted: %s%s', 'event_espresso'), '<br/>', implode(',<br/>', $undeleted_options));
}
if ($errors != '') {
EE_Error::add_attention($errors, __FILE__, __FUNCTION__, __LINE__);
}
}
/**
* plugin_uninstall
*
* @access public
* @static
* @return void
*/
public static function delete_all_espresso_tables_and_data($remove_all = TRUE)
{
// FALSE
global $wpdb;
$undeleted_tables = array();
// load registry
foreach (EE_Registry::instance()->non_abstract_db_models as $model_name) {
if (method_exists($model_name, 'instance')) {
$model_obj = call_user_func(array($model_name, 'instance'));
if ($model_obj instanceof EEM_Base) {
foreach ($model_obj->get_tables() as $table) {
if (strpos($table->get_table_name(), 'esp_')) {
switch (EEH_Activation::delete_unused_db_table($table->get_table_name())) {
case FALSE:
$undeleted_tables[] = $table->get_table_name();
break;
case 0:
// echo '<h4 style="color:red;">the table : ' . $table->get_table_name() . ' was not deleted <br /></h4>';
break;
default:
// echo '<h4>the table : ' . $table->get_table_name() . ' was deleted successully <br /></h4>';
}
}
}
}
}
}
$wp_options_to_delete = array('ee_no_ticket_prices' => TRUE, 'ee_active_messengers' => TRUE, 'ee_flush_rewrite_rules' => TRUE, 'ee_config' => TRUE, 'ee_data_migration_current_db_state' => TRUE, 'ee_data_migration_mapping_' => FALSE, 'ee_data_migration_script_' => FALSE, 'ee_data_migrations' => TRUE, 'ee_notices' => TRUE, 'lang_file_check_' => FALSE, 'ee_maintenance_mode' => TRUE, 'ee_ueip_optin' => TRUE, 'ee_ueip_has_notified' => TRUE, 'ee_plugin_activation_errors' => TRUE, 'ee_id_mapping_from' => FALSE, 'espresso_persistent_admin_notices' => TRUE, 'ee_encryption_key' => TRUE, 'pue_force_upgrade_' => FALSE, 'pue_json_error_' => FALSE, 'pue_install_key_' => FALSE, 'pue_verification_error_' => FALSE, 'pu_dismissed_upgrade_' => FALSE, 'external_updates-' => FALSE, 'ee_extra_data' => TRUE, 'ee_ssn_' => FALSE, 'ee_rss_' => FALSE, 'ee_rte_n_tx_' => FALSE);
$undeleted_options = array();
foreach ($wp_options_to_delete as $option_name => $no_wildcard) {
$option_name = $no_wildcard ? "= '{$option_name}'" : "LIKE '%{$option_name}%'";
if ($option_id = $wpdb->query("SELECT option_id FROM {$wpdb->options} WHERE option_name {$option_name}")) {
switch ($wpdb->query("DELETE FROM {$wpdb->options} WHERE option_name {$option_name}")) {
case FALSE:
$undeleted_options[] = $option_name;
break;
case 0:
// echo '<h4 style="color:red;">the option : ' . $option_name . ' was not deleted <br /></h4>';
break;
default:
// echo '<h4>the option : ' . $option_name . ' was deleted successully <br /></h4>';
}
}
}
if ($remove_all && ($espresso_db_update = get_option('espresso_db_update'))) {
$db_update_sans_ee4 = array();
foreach ($espresso_db_update as $version => $times_activated) {
if ($version[0] == '3') {
//if its NON EE4
$db_update_sans_ee4[$version] = $times_activated;
}
}
update_option('espresso_db_update', $db_update_sans_ee4);
}
$errors = '';
if (!empty($undeleted_tables)) {
$errors .= sprintf(__('The following tables could not be deleted: %s%s', 'event_espresso'), '<br/>', implode(',<br/>', $undeleted_tables));
}
if (!empty($undeleted_options)) {
$errors .= !empty($undeleted_tables) ? '<br/>' : '';
$errors .= sprintf(__('The following wp-options could not be deleted: %s%s', 'event_espresso'), '<br/>', implode(',<br/>', $undeleted_options));
}
if ($errors != '') {
echo $errors;
}
}