AJAX
2 years ago
Admin_Page
2 years ago
Date_Range
2 years ago
Interval
2 years ago
Menu_Bar_Stats
2 years ago
Migrations
2 years ago
Models
2 years ago
Public_API
2 years ago
Rows
2 years ago
Statistics
2 years ago
Tables
2 years ago
Utils
2 years ago
Campaign_Builder.php
2 years ago
Capability_Manager.php
2 years ago
Chart.php
2 years ago
Chart_Geo.php
2 years ago
Cron_Manager.php
2 years ago
Current_Traffic_Finder.php
2 years ago
Dashboard_Options.php
2 years ago
Dashboard_Widget.php
2 years ago
Database_Manager.php
2 years ago
Email_Chart.php
2 years ago
Email_Reports.php
2 years ago
Empty_Report_Option.php
2 years ago
Env.php
2 years ago
Filters.php
2 years ago
Geo_Database_Background_Job.php
2 years ago
Geo_Database_Manager.php
2 years ago
Geoposition.php
2 years ago
Icon_Directory.php
2 years ago
Icon_Directory_Factory.php
2 years ago
Illuminate_Builder.php
2 years ago
Independent_Analytics.php
2 years ago
Interrupt.php
2 years ago
Known_Referrers.php
2 years ago
Plugin_Conflict_Detector.php
2 years ago
Query.php
2 years ago
Quick_Stats.php
2 years ago
REST_API.php
2 years ago
Real_Time.php
2 years ago
Report.php
2 years ago
Report_Finder.php
2 years ago
Report_Options_Parser.php
2 years ago
Resource_Identifier.php
2 years ago
Settings.php
2 years ago
Sort_Configuration.php
2 years ago
Track_Resource_Changes.php
2 years ago
View.php
2 years ago
View_Counter.php
2 years ago
Visitors_Over_Time_Finder.php
2 years ago
WP_Option_Cache_Bust.php
2 years ago
WooCommerce_Order.php
2 years ago
WooCommerce_Referrer_Meta_Box.php
2 years ago
Database_Manager.php
52 lines
| 1 | <?php |
| 2 | |
| 3 | namespace IAWP_SCOPED\IAWP; |
| 4 | |
| 5 | // App data manager? |
| 6 | /** @internal */ |
| 7 | class Database_Manager |
| 8 | { |
| 9 | public function reset_analytics() : void |
| 10 | { |
| 11 | global $wpdb; |
| 12 | $tables_to_drop = [Query::get_table_name(Query::CAMPAIGNS), Query::get_table_name(Query::CITIES), Query::get_table_name(Query::COUNTRIES), Query::get_table_name(Query::DEVICES), Query::get_table_name(Query::DEVICE_TYPES), Query::get_table_name(Query::DEVICE_OSS), Query::get_table_name(Query::DEVICE_BROWSERS), Query::get_table_name(Query::REFERRERS), Query::get_table_name(Query::RESOURCES), Query::get_table_name(Query::SESSIONS), Query::get_table_name(Query::VIEWS), Query::get_table_name(Query::VISITORS_1_16_ARCHIVE), Query::get_table_name(Query::WC_ORDERS)]; |
| 13 | foreach ($tables_to_drop as $table_name) { |
| 14 | $table = $wpdb->get_row($wpdb->prepare("\n SELECT * FROM INFORMATION_SCHEMA.TABLES \n WHERE TABLE_SCHEMA = %s AND TABLE_NAME = %s\n ", $wpdb->dbname, $table_name)); |
| 15 | if (!\is_null($table)) { |
| 16 | $wpdb->query("DELETE FROM {$table_name}"); |
| 17 | } |
| 18 | } |
| 19 | } |
| 20 | public function delete_all_data() : void |
| 21 | { |
| 22 | $this->delete_all_iawp_options(); |
| 23 | $this->delete_all_iawp_user_metadata(); |
| 24 | $this->delete_all_iawp_tables(); |
| 25 | } |
| 26 | public function delete_all_iawp_options() : void |
| 27 | { |
| 28 | global $wpdb; |
| 29 | $options = $wpdb->get_results($wpdb->prepare("SELECT * FROM {$wpdb->options} WHERE option_name LIKE %s", 'iawp_%')); |
| 30 | foreach ($options as $option) { |
| 31 | \delete_option($option->option_name); |
| 32 | } |
| 33 | } |
| 34 | public function delete_all_iawp_user_metadata() : void |
| 35 | { |
| 36 | global $wpdb; |
| 37 | $metadata = $wpdb->get_results($wpdb->prepare("SELECT * FROM {$wpdb->usermeta} WHERE meta_key LIKE %s", 'iawp_%')); |
| 38 | foreach ($metadata as $metadata) { |
| 39 | \delete_user_meta($metadata->user_id, $metadata->meta_key); |
| 40 | } |
| 41 | } |
| 42 | private function delete_all_iawp_tables() : void |
| 43 | { |
| 44 | global $wpdb; |
| 45 | $prefix = $wpdb->prefix; |
| 46 | $rows = $wpdb->get_results($wpdb->prepare("SELECT table_name FROM information_schema.tables WHERE TABLE_SCHEMA = %s AND table_name LIKE %s", $wpdb->dbname, $prefix . 'independent_analytics_%')); |
| 47 | foreach ($rows as $row) { |
| 48 | $wpdb->query('DROP TABLE ' . $row->table_name); |
| 49 | } |
| 50 | } |
| 51 | } |
| 52 |