AJAX
11 months ago
Admin_Page
11 months ago
Click_Tracking
1 year ago
Custom_WordPress_Columns
1 year ago
Data_Pruning
1 year ago
Date_Picker
1 year ago
Date_Range
11 months ago
Ecommerce
1 year ago
Email_Reports
11 months ago
Examiner
11 months ago
Filter_Lists
1 year ago
Form_Submissions
11 months ago
Integrations
1 year ago
Interval
1 year ago
Menu_Bar_Stats
1 year ago
Migrations
1 year ago
Models
11 months ago
Overview
11 months ago
Public_API
1 year ago
Rows
11 months ago
Statistics
11 months ago
Tables
11 months ago
Utils
11 months ago
Appearance.php
1 year ago
Campaign_Builder.php
1 year ago
Capability_Manager.php
1 year ago
Chart.php
1 year ago
Chart_Data.php
1 year ago
Click_Tracking.php
1 year ago
Cron_Job.php
1 year ago
Cron_Manager.php
1 year ago
Current_Traffic_Finder.php
1 year ago
Dashboard_Options.php
11 months ago
Dashboard_Widget.php
2 years ago
Database.php
1 year ago
Database_Manager.php
11 months ago
Empty_Report_Option.php
2 years ago
Env.php
1 year ago
Examiner_Config.php
11 months ago
Filters.php
1 year ago
Geo_Database_Background_Job.php
1 year ago
Geo_Database_Manager.php
11 months ago
Geoposition.php
1 year ago
Icon_Directory.php
2 years ago
Icon_Directory_Factory.php
2 years ago
Illuminate_Builder.php
11 months ago
Independent_Analytics.php
11 months ago
Interrupt.php
1 year ago
Known_Referrers.php
11 months ago
MainWP.php
1 year ago
Map.php
1 year ago
Map_Data.php
1 year ago
Migration_Fixer_Job.php
1 year ago
Patch.php
1 year ago
Payload_Validator.php
1 year ago
Plugin_Conflict_Detector.php
11 months ago
Plugin_Group.php
1 year ago
Plugin_Group_Option.php
2 years ago
Query.php
1 year ago
Query_Taps.php
11 months ago
Quick_Stats.php
11 months ago
REST_API.php
11 months ago
Real_Time.php
1 year ago
Report.php
1 year ago
Report_Finder.php
1 year ago
Report_Options_Parser.php
2 years ago
Resource_Identifier.php
1 year ago
Settings.php
11 months ago
Sort_Configuration.php
1 year ago
Tables.php
1 year ago
Track_Resource_Changes.php
1 year ago
View.php
11 months ago
View_Counter.php
1 year ago
Views_Over_Time_Finder.php
1 year ago
WP_Option_Cache_Bust.php
2 years ago
Illuminate_Builder.php
137 lines
| 1 | <?php |
| 2 | |
| 3 | namespace IAWP; |
| 4 | |
| 5 | use IAWPSCOPED\Illuminate\Database\Capsule\Manager as Capsule; |
| 6 | use IAWPSCOPED\Illuminate\Database\Connection; |
| 7 | use IAWPSCOPED\Illuminate\Database\ConnectionInterface; |
| 8 | use IAWPSCOPED\Illuminate\Database\Query\Builder; |
| 9 | use PDO; |
| 10 | /** |
| 11 | * Connects to the WordPress database using Illuminate from Laravel |
| 12 | * |
| 13 | * Usage: |
| 14 | * |
| 15 | * $builder = Illuminate_Builder::get_builder(); |
| 16 | * @internal |
| 17 | */ |
| 18 | class Illuminate_Builder |
| 19 | { |
| 20 | private static $connection = null; |
| 21 | public static function get_connection() : ConnectionInterface |
| 22 | { |
| 23 | if (self::$connection === null) { |
| 24 | self::$connection = self::make_connection(); |
| 25 | } |
| 26 | return self::$connection; |
| 27 | } |
| 28 | public static function new() : Builder |
| 29 | { |
| 30 | if (self::$connection === null) { |
| 31 | self::$connection = self::make_connection(); |
| 32 | } |
| 33 | return new Builder(self::$connection); |
| 34 | } |
| 35 | public static function ray(Builder $builder) |
| 36 | { |
| 37 | $add_slashes = \str_replace('?', "'?'", $builder->toSql()); |
| 38 | $escape_mysql_format_percentages = \str_replace('%', '%%', $add_slashes); |
| 39 | $replace_question_marks = \str_replace('?', '%s', $escape_mysql_format_percentages); |
| 40 | if (\function_exists('IAWPSCOPED\\ray')) { |
| 41 | return ray(\vsprintf($replace_question_marks, $builder->getBindings())); |
| 42 | } |
| 43 | } |
| 44 | private static function make_connection() : Connection |
| 45 | { |
| 46 | global $wpdb; |
| 47 | $raw_host = $wpdb->dbhost; |
| 48 | $database_name = $wpdb->dbname; |
| 49 | $charset = $wpdb->dbcharset ?? 'utf8'; |
| 50 | $username = $wpdb->dbuser; |
| 51 | $password = $wpdb->dbpassword; |
| 52 | $host_data = $wpdb->parse_db_host($raw_host); |
| 53 | list($host, $port, $socket, $is_ipv6) = $host_data; |
| 54 | if ($is_ipv6 && \extension_loaded('mysqlnd')) { |
| 55 | $host = "[{$host}]"; |
| 56 | } |
| 57 | $charset_collate = $wpdb->determine_charset($charset, ''); |
| 58 | $charset = $charset_collate['charset']; |
| 59 | // $collation = $charset_collate['collate']; |
| 60 | // Collation is no longer added due to issue with WP Rocket with testing 1.23.0. In the future, |
| 61 | // $connection_options should have the collation property added only if it's defined. It should |
| 62 | // not get set for empty strings. |
| 63 | $connection_options = ['driver' => 'mysql', 'database' => $database_name, 'username' => $username, 'password' => $password, 'charset' => $charset, 'prefix' => '', 'options' => self::ssl_options()]; |
| 64 | // Ensures that we use an SSL database connection when WordPress is using one. |
| 65 | // WordPress does SSL, but not with certificate verification. We do the same. |
| 66 | if (self::should_use_ssl()) { |
| 67 | $connection_options['options'][PDO::MYSQL_ATTR_SSL_CA] = \true; |
| 68 | $connection_options['options'][PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT] = \false; |
| 69 | } |
| 70 | if (isset($socket)) { |
| 71 | $connection_options['unix_socket'] = $socket; |
| 72 | } else { |
| 73 | $connection_options['host'] = $host; |
| 74 | if (isset($port)) { |
| 75 | $connection_options['port'] = $port; |
| 76 | } |
| 77 | } |
| 78 | $capsule = new Capsule(); |
| 79 | $capsule->addConnection($connection_options); |
| 80 | $capsule->setAsGlobal(); |
| 81 | $capsule->bootEloquent(); |
| 82 | $connection = $capsule->getConnection(); |
| 83 | self::mariadb_connection_tweaks($connection); |
| 84 | return $connection; |
| 85 | } |
| 86 | private static function mariadb_connection_tweaks(Connection $connection) : void |
| 87 | { |
| 88 | $pdo = $connection->getPdo(); |
| 89 | $version = $pdo->query("SELECT VERSION() AS version")->fetchColumn(); |
| 90 | $is_mariadb = \is_int(\strpos(\strtolower($version), 'mariadb')); |
| 91 | if (!$is_mariadb) { |
| 92 | return; |
| 93 | } |
| 94 | try { |
| 95 | // Disable the lateral derived optimization for MariaDB users. This was cause slowdowns when filtering even with few views. |
| 96 | // https://mariadb.com/kb/en/lateral-derived-optimization/ |
| 97 | $pdo->exec("SET optimizer_switch='split_materialized=off'"); |
| 98 | // Disable ONLY_FULL_GROUP_BY which MariaDB treats differently than MySQL. |
| 99 | $pdo->exec("SET sql_mode = (SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''))"); |
| 100 | } catch (\Throwable $exception) { |
| 101 | } |
| 102 | } |
| 103 | private static function ssl_options() : array |
| 104 | { |
| 105 | if (self::should_use_ssl()) { |
| 106 | if (!\defined('MYSQL_SSL_CA')) { |
| 107 | return [PDO::MYSQL_ATTR_SSL_CA => \true, PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => \false]; |
| 108 | } |
| 109 | return [PDO::MYSQL_ATTR_SSL_CA => \MYSQL_SSL_CA, PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => \true]; |
| 110 | } |
| 111 | if (self::should_use_ssl_without_certificate_verification()) { |
| 112 | return [PDO::MYSQL_ATTR_SSL_CA => \true, PDO::MYSQL_ATTR_SSL_VERIFY_SERVER_CERT => \false]; |
| 113 | } |
| 114 | return []; |
| 115 | } |
| 116 | private static function should_use_ssl() : bool |
| 117 | { |
| 118 | if (!\defined('MYSQL_CLIENT_FLAGS')) { |
| 119 | return \false; |
| 120 | } |
| 121 | if (\MYSQL_CLIENT_FLAGS & \MYSQLI_CLIENT_SSL) { |
| 122 | return \true; |
| 123 | } |
| 124 | return \false; |
| 125 | } |
| 126 | private static function should_use_ssl_without_certificate_verification() : bool |
| 127 | { |
| 128 | if (!\defined('MYSQL_CLIENT_FLAGS')) { |
| 129 | return \false; |
| 130 | } |
| 131 | if (\MYSQL_CLIENT_FLAGS & \MYSQLI_CLIENT_SSL_DONT_VERIFY_SERVER_CERT) { |
| 132 | return \true; |
| 133 | } |
| 134 | return \false; |
| 135 | } |
| 136 | } |
| 137 |