[email protected]

Hi paolo

That all worked fine .

I did notice that on step 2 of your instructions
http://docs.wpgeodirectory.com/avada-compatibility-header-php/

I could not find this line
?><div id=”main” class=”clearfix <?php echo $main_class; ?>”>

But I did find this line which i presume is the correct line to add the hook before

?><div id=”main” class=”clearfix <?php echo $main_class; ?>” style=”<?php echo $main_css; ?>”>

Thanks again
dave

great…

Thanks

dave

Thanks again Guust

That solved it..

dave

Thanks Guust

Thats fine now

dave

Hi Stiofan

I have a Place (I call it a Showroom)
One user can have one showroom

I also have a custom post type called Portfolio
One user can have many portfolio Posts

SO a User can have One Showroom with Many Portfolios

I have modified the related listings to show all the portfolios for the showroom. This all works fine.

But the search is only searching the Place post (showroom) which is fine but I want the results to also show Showrooms for Portfolios that contain the search words.

Here is the query I want (and this works fine when I use SQL executioner Plugin)

SELECT SQL_CALC_FOUND_ROWS wp_posts.*, wp_geodir_gd_place_detail.* FROM wp_posts INNER JOIN wp_geodir_gd_place_detail ON (wp_geodir_gd_place_detail.post_id = wp_posts.ID) WHERE 1=1 AND
( ( wp_posts.post_title LIKE “%renovation%” ) OR ( wp_posts.post_content LIKE “%renovation%”) OR ( wp_posts.ID IN( SELECT wp_term_relationships.object_id as post_id FROM wp_term_taxonomy, wp_terms, wp_term_relationships WHERE wp_term_taxonomy.term_id = wp_terms.term_id AND wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id AND wp_term_taxonomy.taxonomy IN ( ‘gd_place_tags’,’gd_placecategory’ ) AND (wp_terms.name LIKE”%renovation%” OR wp_terms.name IN (“renovation”)) ) )
)
AND wp_posts.post_type IN (‘gd_place’)
AND (wp_posts.post_status = ‘publish’)

OR

wp_posts.post_author in (
SELECT wp_posts.post_author FROM wp_posts INNER JOIN wp_geodir_gd_portfolio_detail ON (wp_geodir_gd_portfolio_detail.post_id = wp_posts.ID) WHERE 1=1 AND ( ( wp_posts.post_title LIKE “%renovation%” ) OR ( wp_posts.post_content LIKE “%renovation%”) OR ( wp_posts.ID IN( SELECT wp_term_relationships.object_id as post_id FROM wp_term_taxonomy, wp_terms, wp_term_relationships WHERE wp_term_taxonomy.term_id = wp_terms.term_id AND wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id AND wp_term_taxonomy.taxonomy IN ( ‘gd_portfolio_tags’,’gd_portfoliocategory’ ) AND (wp_terms.name LIKE”%renovation%” OR wp_terms.name IN (“renovation”)) ) ) ) AND wp_posts.post_type IN (‘gd_portfolio’) AND (wp_posts.post_status = ‘publish’)
)
ORDER BY wp_posts.post_title asc, wp_geodir_gd_place_detail.is_featured asc, wp_posts.post_date desc, wp_posts.post_title LIMIT 0, 10

So bascially I want to find out where I can add in the OR part of the query above.

Thanks again

dave

Fantastic paolo

Dave

Actually I think this is my own problem.
Please ignore this post for the moment and I will revert back

dave