Re: Display Forum Topics where Forum Posts contain keywords
Yeah, ive actually implemented that already, but it just searches the forum topic.
Brajesh says
Hi Mark,
Thanks for the comment. As far as I see buddypress provides no way for searching/listing forum posts on search page. So, In my guess, It’s not going to be easy. Though, If you are familiar with bbpress you can override buddypress forum search and make it happen .
SQL: SELECT
post.post_id,
post.topic_id,
topic.topic_title,
post.post_text
FROM bb_posts post
LEFT JOIN bb_topics topic
ON topic.topic_id = post.topic_id
WHERE topic_title LIKE ‘%searchterms%’ OR post_text LIKE ‘%searchterms%’;