Edit File by line

<?php

[0] Fix | Delete

/**

[1] Fix | Delete

* WPML Sunrise Script - START

[2] Fix | Delete

* @author OnTheGoSystems

[3] Fix | Delete

* @version 3.7.0

[4] Fix | Delete

[5] Fix | Delete

* Place this script in the wp-content folder and add "define('SUNRISE', 'on');" in wp-config.php

[6] Fix | Delete

* in order to enable using different domains for different languages in multisite mode

[7] Fix | Delete

[8] Fix | Delete

* Experimental feature

[9] Fix | Delete

[10] Fix | Delete

[11] Fix | Delete

/**

[12] Fix | Delete

* Class WPML_Sunrise_Lang_In_Domains

[13] Fix | Delete

* @author OnTheGoSystems

[14] Fix | Delete

[15] Fix | Delete

class WPML_Sunrise_Lang_In_Domains {

[16] Fix | Delete

[17] Fix | Delete

/** @var wpdb $wpdb */

[18] Fix | Delete

private $wpdb;

[19] Fix | Delete

[20] Fix | Delete

/** @var string $table_prefix */

[21] Fix | Delete

private $table_prefix;

[22] Fix | Delete

[23] Fix | Delete

/** @var string $current_blog */

[24] Fix | Delete

private $current_blog;

[25] Fix | Delete

[26] Fix | Delete

/** @var bool $no_recursion */

[27] Fix | Delete

private $no_recursion;

[28] Fix | Delete

[29] Fix | Delete

/**

[30] Fix | Delete

* Method init

[31] Fix | Delete

[32] Fix | Delete

public function init() {

[33] Fix | Delete

if ( ! defined( 'WPML_SUNRISE_MULTISITE_DOMAINS' ) ) {

[34] Fix | Delete

define( 'WPML_SUNRISE_MULTISITE_DOMAINS', true );

[35] Fix | Delete

}

[36] Fix | Delete

[37] Fix | Delete

add_filter( 'query', array( $this, 'query_filter' ) );

[38] Fix | Delete

}

[39] Fix | Delete

[40] Fix | Delete

/**

[41] Fix | Delete

* @param string $q

[42] Fix | Delete

[43] Fix | Delete

* @return string

[44] Fix | Delete

[45] Fix | Delete

public function query_filter( $q ) {

[46] Fix | Delete

$this->set_private_properties();

[47] Fix | Delete

[48] Fix | Delete

if ( ! $this->current_blog && ! $this->no_recursion ) {

[49] Fix | Delete

[50] Fix | Delete

$this->no_recursion = true;

[51] Fix | Delete

[52] Fix | Delete

$domains = $this->extract_variables_from_query( $q, 'domain' );

[53] Fix | Delete

[54] Fix | Delete

if ( $domains && $this->query_has_no_result( $q ) ) {

[55] Fix | Delete

$q = $this->transpose_query_if_one_domain_is_matching( $q, $domains );

[56] Fix | Delete

}

[57] Fix | Delete

[58] Fix | Delete

$this->no_recursion = false;

[59] Fix | Delete

}

[60] Fix | Delete

[61] Fix | Delete

return $q;

[62] Fix | Delete

}

[63] Fix | Delete

[64] Fix | Delete

/**

[65] Fix | Delete

* method set_private_properties

[66] Fix | Delete

[67] Fix | Delete

private function set_private_properties() {

[68] Fix | Delete

global $wpdb, $table_prefix, $current_blog;

[69] Fix | Delete

[70] Fix | Delete

$this->wpdb = $wpdb;

[71] Fix | Delete

$this->table_prefix = $table_prefix;

[72] Fix | Delete

$this->current_blog = $current_blog;

[73] Fix | Delete

[74] Fix | Delete

}

[75] Fix | Delete

[76] Fix | Delete

/**

[77] Fix | Delete

* @param string $query

[78] Fix | Delete

[79] Fix | Delete

* @return array

[80] Fix | Delete

[81] Fix | Delete

private function extract_variables_from_query( $query, $field ) {

[82] Fix | Delete

$variables = array();

[83] Fix | Delete

$patterns = array(

[84] Fix | Delete

'#WHERE\s+' . $field . '\s+IN\s*$([^$]+)\)#',

[85] Fix | Delete

'#WHERE\s+' . $field . '\s*=\s*([^\s]+)#',

[86] Fix | Delete

'#AND\s+' . $field . '\s+IN\s*$([^$]+)\)#',

[87] Fix | Delete

'#AND\s+' . $field . '\s*=\s*([^\s]+)#',

[88] Fix | Delete

);

[89] Fix | Delete

[90] Fix | Delete

foreach ( $patterns as $pattern ) {

[91] Fix | Delete

$found = preg_match( $pattern, $query, $matches );

[92] Fix | Delete

if ( $found && array_key_exists( 1, $matches ) ) {

[93] Fix | Delete

$variables = $matches[1];

[94] Fix | Delete

$variables = preg_replace( '/\s+/', '', $variables );

[95] Fix | Delete

$variables = preg_replace( '/[\'"]/', '', $variables );

[96] Fix | Delete

$variables = explode( ',', $variables );

[97] Fix | Delete

break;

[98] Fix | Delete

}

[99] Fix | Delete

}

[100] Fix | Delete

[101] Fix | Delete

return $variables;

[102] Fix | Delete

}

[103] Fix | Delete

[104] Fix | Delete

/**

[105] Fix | Delete

* @param string $q

[106] Fix | Delete

[107] Fix | Delete

* @return bool

[108] Fix | Delete

[109] Fix | Delete

private function query_has_no_result( $q ) {

[110] Fix | Delete

return ! (bool) $this->wpdb->get_row( $q );

[111] Fix | Delete

}

[112] Fix | Delete

[113] Fix | Delete

/**

[114] Fix | Delete

* @param string $q

[115] Fix | Delete

* @param array $domains

[116] Fix | Delete

[117] Fix | Delete

* @return string

[118] Fix | Delete

[119] Fix | Delete

private function transpose_query_if_one_domain_is_matching( $q, $domains ) {

[120] Fix | Delete

$paths = $this->extract_variables_from_query( $q, 'path' );

[121] Fix | Delete

[122] Fix | Delete

// Create as many placeholders as $paths we have.

[123] Fix | Delete

$placeholders = implode( ',', array_fill( 0, sizeof( $paths ), '%s' ) );

[124] Fix | Delete

[125] Fix | Delete

// Array with all the parameters for preparing the SQL.

[126] Fix | Delete

$parameters = $paths;

[127] Fix | Delete

$parameters[] = BLOG_ID_CURRENT_SITE;

[128] Fix | Delete

[129] Fix | Delete

// The ORDER is there to get the default site at the end of the results.

[130] Fix | Delete

$blogs = $this->wpdb->get_col( $this->wpdb->prepare(

[131] Fix | Delete

"SELECT blog_id FROM {$this->wpdb->blogs} WHERE path IN ($placeholders) ORDER BY blog_id = %d",

[132] Fix | Delete

$parameters

[133] Fix | Delete

) );

[134] Fix | Delete

[135] Fix | Delete

$found_blog_id = null;

[136] Fix | Delete

foreach ( (array) $blogs as $blog_id ) {

[137] Fix | Delete

$prefix = $this->table_prefix;

[138] Fix | Delete

[139] Fix | Delete

if ( $blog_id > 1 ) {

[140] Fix | Delete

$prefix .= $blog_id . '_';

[141] Fix | Delete

}

[142] Fix | Delete

[143] Fix | Delete

$icl_settings = $this->wpdb->get_var( "SELECT option_value FROM {$prefix}options WHERE option_name = 'icl_sitepress_settings'" );

[144] Fix | Delete

[145] Fix | Delete

if ( $icl_settings ) {

[146] Fix | Delete

$icl_settings = unserialize( $icl_settings );

[147] Fix | Delete

[148] Fix | Delete

if ( $icl_settings && 2 === (int) $icl_settings['language_negotiation_type'] ) {

[149] Fix | Delete

$found_blog_id = $this->get_blog_id_from_domain( $domains, $icl_settings, $blog_id );

[150] Fix | Delete

if ( $found_blog_id ) {

[151] Fix | Delete

$q = $this->wpdb->prepare( "SELECT blog_id FROM {$this->wpdb->blogs} WHERE blog_id = %d", $found_blog_id );

[152] Fix | Delete

break;

[153] Fix | Delete

}

[154] Fix | Delete

}

[155] Fix | Delete

}

[156] Fix | Delete

}

[157] Fix | Delete

[158] Fix | Delete

return $q;

[159] Fix | Delete

}

[160] Fix | Delete

[161] Fix | Delete

/**

[162] Fix | Delete

* @param array $domains

[163] Fix | Delete

* @param array $wpml_settings

[164] Fix | Delete

* @param $blog_id

[165] Fix | Delete

[166] Fix | Delete

* @return mixed

[167] Fix | Delete

[168] Fix | Delete

private function get_blog_id_from_domain( array $domains, array $wpml_settings, $blog_id ) {

[169] Fix | Delete

foreach ( $domains as $domain ) {

[170] Fix | Delete

if ( in_array( 'http://' . $domain, $wpml_settings['language_domains'], true ) ) {

[171] Fix | Delete

return $blog_id;

[172] Fix | Delete

} elseif ( in_array( $domain, $wpml_settings['language_domains'], true ) ) {

[173] Fix | Delete

return $blog_id;

[174] Fix | Delete

}

[175] Fix | Delete

}

[176] Fix | Delete

[177] Fix | Delete

return null;

[178] Fix | Delete

}

[179] Fix | Delete

}

[180] Fix | Delete

[181] Fix | Delete

$wpml_sunrise_lang_in_domains = new WPML_Sunrise_Lang_In_Domains();

[182] Fix | Delete

$wpml_sunrise_lang_in_domains->init();

[183] Fix | Delete

[184] Fix | Delete

/**

[185] Fix | Delete

* WPML Sunrise Script - END

[186] Fix | Delete

[187] Fix | Delete

[188] Fix | Delete