Skip to:
Content
Pages
Categories
Search
Top
Bottom

Re: Display Forum Topics where Forum Posts contain keywords


markaduffy
Member

@markaduffy

@pcwriter

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%’;

Skip to toolbar