AJAX
1 day ago
Admin_Page
3 weeks ago
Click_Tracking
1 month ago
ColumnOptions
7 months ago
Cron
9 months ago
Data_Pruning
2 weeks ago
Date_Picker
4 months ago
Date_Range
6 months ago
Ecommerce
1 day ago
Email_Reports
3 weeks ago
Examiner
4 months ago
Favicon
3 months ago
Form_Submissions
1 month ago
Integrations
1 month ago
Journey
3 months ago
Migrations
6 months ago
Models
1 day ago
Overview
3 months ago
Public_API
6 months ago
RealTime
2 weeks ago
Rows
2 weeks ago
Statistics
1 month ago
Tables
3 weeks ago
Utils
3 weeks ago
Views
1 month ago
ViewsColumn
1 month ago
WooCommerceOrderMetaBox
6 months ago
ActivationLifecycle.php
4 months ago
Admin_Bar_Stats.php
1 month ago
Appearance.php
1 year ago
BreakdanceFormAction.php
1 month ago
Campaign_Builder.php
1 month ago
Capability_Manager.php
1 month ago
Chart.php
3 months ago
Chart_Data.php
1 year ago
Click_Tracking.php
3 months ago
ComplianzIntegration.php
4 months ago
Cron_Job.php
6 months ago
Cron_Manager.php
6 months ago
Dashboard_Options.php
7 months ago
Dashboard_Widget.php
3 months ago
Database.php
9 months ago
Database_Manager.php
1 month ago
Empty_Report_Option.php
2 years ago
Env.php
1 month ago
Examiner_Config.php
1 year ago
FetchFaviconsJob.php
6 months ago
Filters.php
3 weeks ago
Geo_Database_Health_Check_Job.php
9 months ago
Geo_Database_Manager.php
7 months ago
Geoposition.php
1 year ago
Icon_Directory.php
7 months ago
Icon_Directory_Factory.php
2 years ago
Illuminate_Builder.php
11 months ago
Independent_Analytics.php
1 week ago
Interrupt.php
4 months ago
Known_Referrers.php
1 month ago
MainWP.php
3 months ago
Map.php
9 months ago
Map_Data.php
1 year ago
Migration_Fixer_Job.php
6 months ago
Patch.php
1 year ago
Payload_Validator.php
9 months ago
Plugin_Conflict_Detector.php
1 month ago
Plugin_Group.php
7 months ago
Plugin_Group_Option.php
2 years ago
Query.php
1 year ago
Query_Taps.php
4 months ago
Quick_Stats.php
4 months ago
REST_API.php
1 month ago
Report.php
1 year ago
Report_Finder.php
7 months ago
Report_Options_Parser.php
9 months ago
Resource_Identifier.php
1 day ago
Settings.php
3 months ago
Sort_Configuration.php
9 months ago
Tables.php
9 months ago
Track_Resource_Changes.php
1 year ago
View_Counter.php
7 months ago
VisitorSaltRefreshInterval.php
7 months ago
WP_Option_Cache_Bust.php
2 years ago
Database_Manager.php
115 lines
| 1 | <?php |
| 2 | |
| 3 | namespace IAWP; |
| 4 | |
| 5 | use IAWP\Utils\Dir; |
| 6 | use IAWP\ViewsColumn\UpdateTotalViewsPostMeta; |
| 7 | use IAWP\ViewsColumn\ViewsColumn; |
| 8 | use IAWPSCOPED\Illuminate\Support\Collection; |
| 9 | /** @internal */ |
| 10 | class Database_Manager |
| 11 | { |
| 12 | public function reset_analytics() : void |
| 13 | { |
| 14 | // Empty all analytics tables while preserving config tables |
| 15 | $this->get_tables()->where('type', 'analytics')->each(function ($table) { |
| 16 | global $wpdb; |
| 17 | $wpdb->query('TRUNCATE ' . $table['name']); |
| 18 | }); |
| 19 | // Recreate the saved reports |
| 20 | \IAWP\Report_Finder::insert_default_reports(); |
| 21 | \IAWP\Report_Finder::insert_default_user_journey_reports(); |
| 22 | $this->delete_overview_report_data(); |
| 23 | $this->delete_all_post_meta(); |
| 24 | } |
| 25 | public function delete_all_data() : void |
| 26 | { |
| 27 | $this->delete_all_iawp_options(); |
| 28 | $this->delete_all_iawp_user_metadata(); |
| 29 | $this->delete_all_iawp_tables(); |
| 30 | $this->delete_all_post_meta(); |
| 31 | $this->delete_cached_favicons(); |
| 32 | } |
| 33 | public function delete_all_iawp_options() : void |
| 34 | { |
| 35 | global $wpdb; |
| 36 | $options = $wpdb->get_results($wpdb->prepare("SELECT * FROM {$wpdb->options} WHERE option_name LIKE %s", 'iawp_%')); |
| 37 | foreach ($options as $option) { |
| 38 | \delete_option($option->option_name); |
| 39 | } |
| 40 | } |
| 41 | public function delete_overview_report_data() : void |
| 42 | { |
| 43 | global $wpdb; |
| 44 | $options = $wpdb->get_results($wpdb->prepare("SELECT * FROM {$wpdb->options} WHERE option_name LIKE %s", 'iawp_module_%')); |
| 45 | foreach ($options as $option) { |
| 46 | \delete_option($option->option_name); |
| 47 | } |
| 48 | } |
| 49 | public function delete_all_iawp_user_metadata() : void |
| 50 | { |
| 51 | global $wpdb; |
| 52 | $metadata = $wpdb->get_results($wpdb->prepare("SELECT * FROM {$wpdb->usermeta} WHERE meta_key LIKE %s", 'iawp_%')); |
| 53 | foreach ($metadata as $metadata) { |
| 54 | \delete_user_meta($metadata->user_id, $metadata->meta_key); |
| 55 | } |
| 56 | } |
| 57 | public function delete_cached_favicons() : void |
| 58 | { |
| 59 | try { |
| 60 | Dir::delete(\IAWPSCOPED\iawp_upload_path_to('iawp-favicons/')); |
| 61 | } catch (\Throwable $error) { |
| 62 | } |
| 63 | } |
| 64 | public function delete_all_iawp_tables() : void |
| 65 | { |
| 66 | $this->get_tables()->each(function ($table) { |
| 67 | global $wpdb; |
| 68 | $wpdb->query('DROP TABLE ' . $table['name']); |
| 69 | }); |
| 70 | } |
| 71 | public function get_tables() : Collection |
| 72 | { |
| 73 | global $wpdb; |
| 74 | $rows = $wpdb->get_results($wpdb->prepare("SELECT table_name AS name FROM information_schema.tables WHERE TABLE_SCHEMA = %s AND table_name LIKE %s", $wpdb->dbname, $wpdb->prefix . 'independent_analytics_%')); |
| 75 | $config_tables = [$wpdb->prefix . 'independent_analytics_campaign_urls', $wpdb->prefix . 'independent_analytics_link_rules']; |
| 76 | $tables = Collection::make($rows)->map(function ($row) use($config_tables) { |
| 77 | return ['name' => $row->name, 'type' => \in_array($row->name, $config_tables) ? 'config' : 'analytics']; |
| 78 | }); |
| 79 | return $tables; |
| 80 | } |
| 81 | public function delete_all_post_meta() : void |
| 82 | { |
| 83 | \delete_post_meta_by_key(ViewsColumn::$meta_key); |
| 84 | } |
| 85 | public static function register_actions() : void |
| 86 | { |
| 87 | \add_action('iawp_reset_analytics', function () { |
| 88 | $manager = new self(); |
| 89 | $manager->reset_analytics(); |
| 90 | }); |
| 91 | \add_action('iawp_reset_database', function () { |
| 92 | $db_version = \intval(\get_option('iawp_db_version', '0')); |
| 93 | $database_manager = new \IAWP\Database_Manager(); |
| 94 | $database_manager->delete_all_iawp_options(); |
| 95 | $database_manager->delete_all_iawp_user_metadata(); |
| 96 | $database_manager->delete_all_iawp_tables(); |
| 97 | $database_manager->delete_cached_favicons(); |
| 98 | \IAWP\Capability_Manager::reset_capabilities(); |
| 99 | \update_option('iawp_db_version', $db_version); |
| 100 | }); |
| 101 | \add_action('iawp_reset_meta', function () { |
| 102 | $db_version = \intval(\get_option('iawp_db_version', '0')); |
| 103 | $database_manager = new \IAWP\Database_Manager(); |
| 104 | $database_manager->delete_all_iawp_options(); |
| 105 | $database_manager->delete_all_iawp_user_metadata(); |
| 106 | $database_manager->delete_all_post_meta(); |
| 107 | \IAWP\Capability_Manager::reset_capabilities(); |
| 108 | \update_option('iawp_db_version', $db_version); |
| 109 | }); |
| 110 | \add_action('iawp_restore_iawp_total_views_post_meta', function () { |
| 111 | UpdateTotalViewsPostMeta::update_all(); |
| 112 | }); |
| 113 | } |
| 114 | } |
| 115 |