AJAX
2 years ago
Admin_Page
2 years ago
Date_Range
2 years ago
Filter_Lists
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.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.php
87 lines
| 1 | <?php |
| 2 | |
| 3 | namespace IAWP; |
| 4 | |
| 5 | use IAWPSCOPED\Illuminate\Database\QueryException; |
| 6 | /** |
| 7 | * There are plenty of good reasons to avoid $wpdb->get_charset_collate. As users move their site |
| 8 | * around, old tables might have one collation while newly created tables might have a different |
| 9 | * one. |
| 10 | * |
| 11 | * @internal |
| 12 | */ |
| 13 | class Database |
| 14 | { |
| 15 | private static $character_set = null; |
| 16 | private static $collation = null; |
| 17 | private static $user_privileges = null; |
| 18 | private static $required_privileges = ['SELECT', 'INSERT', 'UPDATE', 'DELETE', 'CREATE', 'ALTER', 'INDEX', 'DROP']; |
| 19 | public static function has_correct_database_privileges() : bool |
| 20 | { |
| 21 | return \count(self::missing_database_privileges()) === 0; |
| 22 | } |
| 23 | public static function missing_database_privileges() : array |
| 24 | { |
| 25 | return \array_diff(self::$required_privileges, self::user_privileges()); |
| 26 | } |
| 27 | public static function is_missing_all_tables() : bool |
| 28 | { |
| 29 | global $wpdb; |
| 30 | $tables = \IAWP\Illuminate_Builder::get_builder()->select('*')->from('INFORMATION_SCHEMA.TABLES')->where('TABLE_SCHEMA', '=', $wpdb->dbname)->where('TABLE_NAME', 'LIKE', $wpdb->prefix . 'independent_analytics_%'); |
| 31 | $views_table = \IAWP\Query::get_table_name(\IAWP\Query::VIEWS); |
| 32 | $views_query = \IAWP\Illuminate_Builder::get_builder()->selectRaw('0 AS number')->from($views_table); |
| 33 | try { |
| 34 | $views_query->doesntExist(); |
| 35 | $missing_views_table = \false; |
| 36 | } catch (QueryException $exception) { |
| 37 | $missing_views_table = \true; |
| 38 | } |
| 39 | return $tables->doesntExist() && $missing_views_table; |
| 40 | } |
| 41 | public static function character_set() : string |
| 42 | { |
| 43 | if (\is_null(self::$character_set)) { |
| 44 | self::populate_character_set_and_collation(); |
| 45 | } |
| 46 | return self::$character_set; |
| 47 | } |
| 48 | public static function collation() : string |
| 49 | { |
| 50 | if (\is_null(self::$collation)) { |
| 51 | self::populate_character_set_and_collation(); |
| 52 | } |
| 53 | return self::$collation; |
| 54 | } |
| 55 | private static function user_privileges() : array |
| 56 | { |
| 57 | if (!\is_null(self::$user_privileges)) { |
| 58 | return self::$user_privileges; |
| 59 | } |
| 60 | global $wpdb; |
| 61 | $user = \IAWP\Illuminate_Builder::get_builder()->selectRaw('CURRENT_USER() as user')->value('user'); |
| 62 | $parts = \explode('@', $user); |
| 63 | $grantee = "'" . $parts[0] . "'@'" . $parts[1] . "'"; |
| 64 | $query = \IAWP\Illuminate_Builder::get_builder()->select('*')->from('information_schema.schema_privileges')->where('grantee', '=', $grantee)->where('table_schema', '=', $wpdb->dbname); |
| 65 | self::$user_privileges = \array_map(function ($record) { |
| 66 | return $record->PRIVILEGE_TYPE; |
| 67 | }, $query->get()->all()); |
| 68 | // If SELECT is missing, that means our query is broken and should be ignored |
| 69 | if (!\in_array('SELECT', self::$user_privileges)) { |
| 70 | self::$user_privileges = self::$required_privileges; |
| 71 | } |
| 72 | return self::$user_privileges; |
| 73 | } |
| 74 | private static function populate_character_set_and_collation() : void |
| 75 | { |
| 76 | global $wpdb; |
| 77 | $query = \IAWP\Illuminate_Builder::get_builder()->selectRaw('CCSA.CHARACTER_SET_NAME AS character_set_name')->selectRaw('CCSA.COLLATION_NAME AS collation_name')->from('information_schema.TABLES', 'THE_TABLES')->leftJoin('information_schema.COLLATION_CHARACTER_SET_APPLICABILITY AS CCSA', 'CCSA.COLLATION_NAME', '=', 'THE_TABLES.TABLE_COLLATION')->where('THE_TABLES.TABLE_SCHEMA', '=', $wpdb->dbname)->where('THE_TABLES.TABLE_NAME', '=', \IAWP\Query::get_table_name(\IAWP\Query::REFERRERS)); |
| 78 | $result = $query->first(); |
| 79 | self::$character_set = $result->character_set_name ?? null; |
| 80 | self::$collation = $result->collation_name ?? null; |
| 81 | if (\is_null(self::$character_set) || \is_null(self::$collation)) { |
| 82 | self::$character_set = $wpdb->charset; |
| 83 | self::$collation = $wpdb->collate; |
| 84 | } |
| 85 | } |
| 86 | } |
| 87 |