/**
* Include builder in search
* @param string $where
* @return string
*/
function do_search($where)
{
if (!is_admin()) {
if (is_search()) {
global $wpdb;
$query = get_search_query();
if (method_exists($wpdb, 'esc_like')) {
$query = $wpdb->esc_like($query);
} else {
/**
* If this is not WP 4.0 or above, use old method to escape db query.
* @since 2.0.2
*/
$do = 'like';
$it = 'escape';
$query = call_user_func($do . '_' . $it, $query);
}
$types = Themify_Builder_Model::get_post_types();
$where .= " OR {$wpdb->posts}.ID IN (\n\t\t\t\t\t\t\tSELECT {$wpdb->postmeta}.post_id FROM {$wpdb->posts}, {$wpdb->postmeta}";
global $sitepress;
if (isset($sitepress) && method_exists($sitepress, 'get_current_language')) {
$current_language = $sitepress->get_current_language();
$where .= " LEFT JOIN {$wpdb->prefix}icl_translations ON( {$wpdb->prefix}icl_translations.element_id = {$wpdb->postmeta}.post_id )\n\t\t\t\t\t\t\tWHERE {$wpdb->prefix}icl_translations.language_code = '{$current_language}'\n\t\t\t\t\t\t\tAND";
} else {
$where .= ' WHERE';
// if WPML doesn't exist, execution enters this branch and is needed for proper query
}
$where .= " {$wpdb->postmeta}.meta_key = '_themify_builder_settings_json'\n\t\t\t\t\t\t\tAND {$wpdb->postmeta}.meta_value LIKE '%{$query}%' AND {$wpdb->posts}.ID = {$wpdb->postmeta}.post_id\n\t\t\t\t\t\t\tAND {$wpdb->posts}.post_type IN ('" . implode("', '", $types) . "'))";
}
}
return $where;
}
/**
* Include builder in search
* @param string $where
* @return string
*/
function do_search($where)
{
if (!is_admin()) {
if (is_search()) {
global $wpdb;
$query = get_search_query();
if (method_exists($wpdb, 'esc_like')) {
$query = $wpdb->esc_like($query);
} else {
/**
* If this is not WP 4.0 or above, use old method to escape db query.
* @since 2.0.2
*/
$do = 'like';
$it = 'escape';
$query = call_user_func($do . '_' . $it, $query);
}
$types = Themify_Builder_Model::get_post_types();
$where .= " OR {$wpdb->posts}.ID IN (\n\t\t\t\t\t\t\tSELECT {$wpdb->postmeta}.post_id FROM {$wpdb->posts}, {$wpdb->postmeta} WHERE {$wpdb->postmeta}.meta_key = '{$this->meta_key}'\n\t\t\t\t\t\t\tAND {$wpdb->postmeta}.meta_value LIKE '%{$query}%' AND {$wpdb->posts}.ID = {$wpdb->postmeta}.post_id\n\t\t\t\t\t\t\tAND {$wpdb->posts}.post_type IN ('" . implode("', '", $types) . "'))";
}
}
return $where;
}
/**
* Include builder in search
* @param string $where
* @return string
*/
function do_search($where)
{
if (!is_admin()) {
if (is_search()) {
global $wpdb;
$query = get_search_query();
if (method_exists($wpdb, 'esc_like')) {
$query = $wpdb->esc_like($query);
} else {
$query = like_escape($query);
}
$types = Themify_Builder_Model::get_post_types();
$where .= " OR {$wpdb->posts}.ID IN (\n\t\t\t\t\t\t\tSELECT {$wpdb->postmeta}.post_id FROM {$wpdb->posts}, {$wpdb->postmeta} WHERE {$wpdb->postmeta}.meta_key = '{$this->meta_key}'\n\t\t\t\t\t\t\tAND {$wpdb->postmeta}.meta_value LIKE '%{$query}%' AND {$wpdb->posts}.ID = {$wpdb->postmeta}.post_id\n\t\t\t\t\t\t\tAND {$wpdb->posts}.post_type IN ('" . implode("', '", $types) . "'))";
}
}
return $where;
}
