From 713e676a0c11f517cde63ac8cb61da2b456e9584 Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Mon, 12 Jun 2017 11:29:30 -0400 Subject: [PATCH] Adding tables for clear data Adding categories cities to be emptied when they select the clear data checkbox on member csv importing. --- models/admin/import/index.php | 3 +++ 1 file changed, 3 insertions(+) diff --git a/models/admin/import/index.php b/models/admin/import/index.php index a657d1be..a056bfee 100644 --- a/models/admin/import/index.php +++ b/models/admin/import/index.php @@ -204,8 +204,10 @@ class GlmMembersAdmin_import_index $this->wpdb->query('DELETE FROM ' . GLM_MEMBERS_PLUGIN_DB_PREFIX . 'amenity_ref'); $this->wpdb->query('DELETE FROM ' . GLM_MEMBERS_PLUGIN_DB_PREFIX . 'amenities'); $this->wpdb->query('DELETE FROM ' . GLM_MEMBERS_PLUGIN_DB_PREFIX . 'amenity_groups'); + $this->wpdb->query('DELETE FROM ' . GLM_MEMBERS_PLUGIN_DB_PREFIX . 'categories'); $this->wpdb->query('DELETE FROM ' . GLM_MEMBERS_PLUGIN_DB_PREFIX . 'grouped_amenities'); $this->wpdb->query('DELETE FROM ' . GLM_MEMBERS_PLUGIN_DB_PREFIX . 'category_member_info'); + $this->wpdb->query('DELETE FROM ' . GLM_MEMBERS_PLUGIN_DB_PREFIX . 'cities'); $this->wpdb->query('DELETE FROM ' . GLM_MEMBERS_PLUGIN_DB_PREFIX . 'regions'); $this->wpdb->query('DELETE FROM ' . GLM_MEMBERS_PLUGIN_DB_PREFIX . 'counties'); $this->wpdb->query('DELETE FROM ' . GLM_MEMBERS_PLUGIN_DB_PREFIX . 'files'); @@ -214,6 +216,7 @@ class GlmMembersAdmin_import_index $this->wpdb->query('DELETE FROM ' . GLM_MEMBERS_PLUGIN_DB_PREFIX . 'member_info'); $this->wpdb->query('DELETE FROM ' . GLM_MEMBERS_PLUGIN_DB_PREFIX . 'members'); } + //exit; foreach ( $fileData as $fileHeader => $file ) { if ( is_file( $uploadPath . '/' . $file['name'] ) ) { $fileData[$fileHeader]['results'] = $this->processFile( $uploadPath . '/' . $file['name'], $file['type'] ); -- 2.17.1