/** * 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; }