AJAX
3 months ago
Admin_Page
3 months ago
Click_Tracking
5 months ago
ColumnOptions
6 months ago
Cron
8 months ago
Custom_WordPress_Columns
8 months ago
Data_Pruning
5 months ago
Date_Picker
3 months ago
Date_Range
5 months ago
Ecommerce
5 months ago
Email_Reports
3 months ago
Examiner
3 months ago
Favicon
5 months ago
Form_Submissions
5 months ago
Integrations
3 months ago
Interval
1 year ago
Journey
5 months ago
Migrations
5 months ago
Models
5 months ago
Overview
3 months ago
Public_API
5 months ago
Rows
3 months ago
Statistics
3 months ago
Tables
3 months ago
Utils
5 months ago
Views
5 months ago
WooCommerceOrderMetaBox
5 months ago
ActivationLifecycle.php
3 months ago
Admin_Bar_Stats.php
3 months ago
Appearance.php
1 year ago
Campaign_Builder.php
3 months ago
Capability_Manager.php
3 months ago
Chart.php
3 months ago
Chart_Data.php
1 year ago
Click_Tracking.php
3 months ago
ComplianzIntegration.php
3 months ago
Cron_Job.php
5 months ago
Cron_Manager.php
5 months ago
Current_Traffic_Finder.php
1 year ago
Dashboard_Options.php
6 months ago
Dashboard_Widget.php
2 years ago
Database.php
8 months ago
Database_Manager.php
5 months ago
Empty_Report_Option.php
2 years ago
Env.php
6 months ago
Examiner_Config.php
11 months ago
FetchFaviconsJob.php
5 months ago
Filters.php
3 months ago
Geo_Database_Health_Check_Job.php
8 months ago
Geo_Database_Manager.php
6 months ago
Geoposition.php
1 year ago
Icon_Directory.php
6 months ago
Icon_Directory_Factory.php
2 years ago
Illuminate_Builder.php
10 months ago
Independent_Analytics.php
5 months ago
Interrupt.php
3 months ago
Known_Referrers.php
6 months ago
MainWP.php
1 year ago
Map.php
8 months ago
Map_Data.php
1 year ago
Migration_Fixer_Job.php
5 months ago
Patch.php
1 year ago
Payload_Validator.php
8 months ago
Plugin_Conflict_Detector.php
6 months ago
Plugin_Group.php
6 months ago
Plugin_Group_Option.php
2 years ago
Query.php
1 year ago
Query_Taps.php
3 months ago
Quick_Stats.php
3 months ago
REST_API.php
3 months ago
Real_Time.php
3 months ago
Report.php
1 year ago
Report_Finder.php
6 months ago
Report_Options_Parser.php
8 months ago
Resource_Identifier.php
8 months ago
Settings.php
3 months ago
Sort_Configuration.php
8 months ago
Tables.php
8 months ago
Track_Resource_Changes.php
1 year ago
View_Counter.php
6 months ago
Views_Over_Time_Finder.php
1 year ago
VisitorSaltRefreshInterval.php
6 months ago
WP_Option_Cache_Bust.php
2 years ago
Database.php
131 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::new()->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::new()->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 | public static function has_table(string $table) : bool |
| 56 | { |
| 57 | global $wpdb; |
| 58 | $tables = $wpdb->get_row($wpdb->prepare("SHOW TABLES LIKE %s", $table)); |
| 59 | return !\is_null($tables); |
| 60 | } |
| 61 | public static function has_index(string $table, string $index) : bool |
| 62 | { |
| 63 | global $wpdb; |
| 64 | if (!self::has_table($table)) { |
| 65 | return \false; |
| 66 | } |
| 67 | $row = $wpdb->get_row($wpdb->prepare("\n SHOW INDEX FROM {$table} WHERE Key_name = %s\n ", $index)); |
| 68 | return !\is_null($row); |
| 69 | } |
| 70 | public static function column_collation_for(string $table, string $column) : ?string |
| 71 | { |
| 72 | global $wpdb; |
| 73 | try { |
| 74 | $rows = $wpdb->get_row($wpdb->prepare("\n SHOW FULL COLUMNS FROM {$table} WHERE Field = %s\n ", $column)); |
| 75 | if (!$rows) { |
| 76 | return null; |
| 77 | } |
| 78 | $collation = $rows->Collation ?? null; |
| 79 | if (!$collation) { |
| 80 | return null; |
| 81 | } |
| 82 | return $collation; |
| 83 | } catch (\Throwable $e) { |
| 84 | } |
| 85 | return null; |
| 86 | } |
| 87 | /** |
| 88 | * From MySQL: It is not possible to deny a privilege granted at a higher level by absence of that privilege at a lower level. |
| 89 | * |
| 90 | * @return string[] |
| 91 | */ |
| 92 | private static function user_privileges() : array |
| 93 | { |
| 94 | global $wpdb; |
| 95 | if (!\is_null(self::$user_privileges)) { |
| 96 | return self::$user_privileges; |
| 97 | } |
| 98 | $user = \IAWP\Illuminate_Builder::new()->selectRaw('CURRENT_USER() as user')->value('user'); |
| 99 | $parts = \explode('@', $user); |
| 100 | $grantee = "'" . $parts[0] . "'@'" . $parts[1] . "'"; |
| 101 | $global_privileges_query = \IAWP\Illuminate_Builder::new()->select('*')->from('information_schema.user_privileges')->where('grantee', '=', $grantee); |
| 102 | $global_privileges = \array_map(function ($record) { |
| 103 | return $record->PRIVILEGE_TYPE; |
| 104 | }, $global_privileges_query->get()->all()); |
| 105 | $database_privileges_query = \IAWP\Illuminate_Builder::new()->select('*')->from('information_schema.schema_privileges')->where('grantee', '=', $grantee)->where('table_schema', '=', $wpdb->dbname); |
| 106 | $database_privileges = \array_map(function ($record) { |
| 107 | return $record->PRIVILEGE_TYPE; |
| 108 | }, $database_privileges_query->get()->all()); |
| 109 | $privileges = \array_unique(\array_merge($global_privileges, $database_privileges), \SORT_REGULAR); |
| 110 | // If SELECT is missing, that means our query is broken and should be ignored |
| 111 | if (!\in_array('SELECT', $privileges)) { |
| 112 | self::$user_privileges = self::$required_privileges; |
| 113 | } else { |
| 114 | self::$user_privileges = $privileges; |
| 115 | } |
| 116 | return self::$user_privileges; |
| 117 | } |
| 118 | private static function populate_character_set_and_collation() : void |
| 119 | { |
| 120 | global $wpdb; |
| 121 | $query = \IAWP\Illuminate_Builder::new()->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::SESSIONS)); |
| 122 | $result = $query->first(); |
| 123 | self::$character_set = $result->character_set_name ?? null; |
| 124 | self::$collation = $result->collation_name ?? null; |
| 125 | if (\is_null(self::$character_set) || \is_null(self::$collation)) { |
| 126 | self::$character_set = $wpdb->charset; |
| 127 | self::$collation = $wpdb->collate; |
| 128 | } |
| 129 | } |
| 130 | } |
| 131 |