http://bbshowcase.org/forums/ bbPress Showcase Topic: Plug-in Idea: Show bbPress forum topic in Wordpress Loop? en Thu, 24 May 2012 16:40:55 +0000 http://bbshowcase.org/forums/topic/plug-in-idea-show-bbpress-forum-topic-in-wordpress-loop/page/2#post-1552 Sat, 01 Aug 2009 09:44:39 +0000 yesanswer 1552@http://bbshowcase.org/forums/ <p>hi<br /> if i puplish my <a href="http://www.yesanswer.com">feed</a> on bbpress, and i add many text for example in 10 min, can google take it for spamm? </p> http://bbshowcase.org/forums/topic/plug-in-idea-show-bbpress-forum-topic-in-wordpress-loop/page/2#post-353 Thu, 29 May 2008 01:37:00 +0000 exchequer598 353@http://bbshowcase.org/forums/ <p>I'd like to implement this feature too! Have you got it to work? I'm sorry, but I'm a bit new with all this. Please help. Thanks! </p> http://bbshowcase.org/forums/topic/plug-in-idea-show-bbpress-forum-topic-in-wordpress-loop/page/2#post-296 Tue, 06 May 2008 11:49:10 +0000 mrhoratio 296@http://bbshowcase.org/forums/ <p>Looks like I've got something working. The basic idea is to retrieve topics from bbPress tables and merge them into an array of Wordpress posts, which can then be turned into a custom Loop using foreach. </p> <p>The only issue is that the number of posts per page won't match the "Blog pages show at most" in your admin settings, if there are retrieved bbPress topics on that page. Here's what the code looks like:</p> <blockquote> <p><code><br /> &lt;?php</p> <p>//Put Wordpress posts into an array;<br /> $wp_posts = $posts;</p> <p>if (!is_single()){</p> <p> //Retrieve first post of previous page (we need this post's date to query bbPress topics<br /> $offset=$paged*$posts_per_page+$posts_per_page;<br /> $first_post_of_previous_page = get_posts('numberposts=1&#38;offset='.$offset);</p> <p> //First set the start and end dates to limit the query to the bbPress table<br /> $startdate=(date('YmdHis',strtotime($first_post_of_previous_page[0]-&gt;post_date_gmt)));<br /> $enddate=(date('YmdHis',strtotime($wp_posts[0]-&gt;post_date_gmt)));</p> <p> //Retrieve "Super Sticky" topics from bbPress tables.<br /> //This assumes your bbPress and Wordpress tables are in the same database.<br /> $bb_topics = $wpdb-&gt;get_results("SELECT * FROM bb_topics WHERE topic_sticky = 2 AND topic_start_time BETWEEN $startdate AND $enddate ORDER BY topic_start_time DESC");</p> <p> //Map bbPress topics to WordPress posts structure.<br /> foreach($bb_topics as $bb_topic){<br /> $bb_first_post = $wpdb-&gt;get_results("SELECT post_text FROM bb_posts WHERE post_position = '1' AND topic_id = $bb_topic-&gt;topic_id", ARRAY_A);<br /> $bb_post-&gt;ID = "00000".$bb_topic-&gt;topic_id;<br /> $bb_post-&gt;post_author = $bb_topic-&gt;topic_poster;<br /> $bb_post-&gt;post_date = $bb_topic-&gt;topic_start_time;<br /> $bb_post-&gt;post_content = $bb_first_post[0][post_text];<br /> $bb_post-&gt;post_title = $bb_topic-&gt;topic_title;<br /> $bb_post-&gt;post_status = "publish";<br /> $bb_post-&gt;comment_status = "open";<br /> $bb_post-&gt;ping_status = $bb_topic-&gt;post_id;<br /> $bb_post-&gt;post_name = "forums/topic/".$bb_topic-&gt;topic_slug;<br /> $bb_post-&gt;post_type = "post";<br /> $bb_post-&gt;comment_count = $bb_topic-&gt;topic_posts-1;</p> <p> //add bbPress topic to Wordpress posts array.<br /> $wp_posts[] = $bb_post;</p> <p> };</p> <p> //Create function to sort array of posts by date<br /> function compare($x, $y){<br /> if ( $x-&gt;post_date == $y-&gt;post_date )<br /> return 0;<br /> else if ( $x-&gt;post_date &lt; $y-&gt;post_date )<br /> return 1;<br /> else<br /> return -1;<br /> }</p> <p> //Sort array<br /> usort($wp_posts,'compare');<br /> }</p> <p>?&gt;</p> <p></code> </p></blockquote> http://bbshowcase.org/forums/topic/plug-in-idea-show-bbpress-forum-topic-in-wordpress-loop/page/2#post-291 Sun, 04 May 2008 11:26:12 +0000 mrhoratio 291@http://bbshowcase.org/forums/ <p>I tried unsetting $topics, but it just removed all of the topics from the page, since super stickies are also topics.</p> <p>I tried another approach and was able to retrieve the list of super stickies by putting this code in before a bbPress loop:</p> <pre><code>$topics = $bbdb-&gt;get_results(&quot;SELECT * FROM $bbdb-&gt;topics WHERE topic_start_time BETWEEN $startdate AND $enddate ORDER BY topic_start_time DESC&quot;);</code></pre> <p>I was also able to get stickies within a specific date range:</p> <pre><code>$startdate=&quot;20080500223740&quot;; $enddate=&quot;20080502223740&quot;; $topics = $bbdb-&gt;get_results(&quot;SELECT * FROM $bbdb-&gt;topics WHERE topic_sticky = 2 AND topic_start_time BETWEEN $startdate AND $enddate ORDER BY topic_start_time DESC&quot;);</code></pre> <p>This has a couple of issues:</p> <p>1. Query doesn't retrieve the topic's first entry, just topic title.<br /> 2. Pagination is a little weird and doesn't respect what you have set for "Items per page" bbPress admin. </p> <p>I'll try to see if I can work these out. </p> <p>After that, the next step I want to do is to figure out how to run this query within Wordpress. Then, map the topic structure to a post structure (ie "topic_title" becomes "post_title"). Then, merge the query into a Wordpress loop. I suspect there will be pagination issues also in Wordpress. But one step at a time. </p> http://bbshowcase.org/forums/topic/plug-in-idea-show-bbpress-forum-topic-in-wordpress-loop/page/2#post-290 Sat, 03 May 2008 01:13:48 +0000 _ck_ 290@http://bbshowcase.org/forums/ <p>You'd have to do a few plugin tricks but it could be done.</p> <p>Either I'd create a new custom view of just super-stickies (a front page sticky is called a super-sticky I think in bbPress) or I'd probably approach it by adding a variable to the end of a url (ie. forum.com/feed/?onlysticky=1 ) and hook <code>bb_index.php</code> and then "destroy" any regular posts in the list by unsetting $topics.</p> <p>ie. (and this is very rough, completely untested code)<br /> <font color="blue"><br /> function onlysticky() {global $topics; if (isset($_GET['onlysticky'])) {unset($topics);}}<br /> add_action( 'bb_index.php', 'onlysticky');<br /> add_action( 'bb_rss.php', 'onlysticky' );<br /> </font> </p> http://bbshowcase.org/forums/topic/plug-in-idea-show-bbpress-forum-topic-in-wordpress-loop/page/2#post-289 Sat, 03 May 2008 00:54:39 +0000 mrhoratio 289@http://bbshowcase.org/forums/ <p>Ah I see, that would be a great plugin. </p> <p>I was just now tinkering with the bbPress template to make a page that displays only Front Page stickies. Unfortunately, I couldn't figure out how to get it to paginate. </p> <p>Is there a way for bbPress to make an RSS of only Front Page stickies? That way I can use an RSS aggregator plugin to bring it into Wordpress. Or is there a way in Wordpress to query a bbPress database for all the front page stickies, bypassing RSS altogether? </p> http://bbshowcase.org/forums/topic/plug-in-idea-show-bbpress-forum-topic-in-wordpress-loop/page/2#post-288 Sat, 03 May 2008 00:08:47 +0000 _ck_ 288@http://bbshowcase.org/forums/ <p>No the idea was to make a special front page instead of the regular latest discussions that holds the promoted topics with custom summaries for what they are about, including their own RSS feed. It would replace the regular front page. </p> http://bbshowcase.org/forums/topic/plug-in-idea-show-bbpress-forum-topic-in-wordpress-loop/page/2#post-287 Fri, 02 May 2008 20:12:54 +0000 mrhoratio 287@http://bbshowcase.org/forums/ <p>Hey _ck_, I just noticed that bbPress now has a "promote to front page" functionality in the form of a "Stick to front" link in every topic. Here's a couple of threads on the bbPress site which discusses it:</p> <p><a href="http://bbpress.org/forums/topic/stick-to-front-removes-topic-from-forum" rel="nofollow">http://bbpress.org/forums/topic/stick-to-front-removes-topic-from-forum</a><br /> <a href="http://bbpress.org/forums/topic/categories-in-0901" rel="nofollow">http://bbpress.org/forums/topic/categories-in-0901</a></p> <p>There's no support for Wordpress integration with this feature, but perhaps it will come in a future version. </p> http://bbshowcase.org/forums/topic/plug-in-idea-show-bbpress-forum-topic-in-wordpress-loop#post-286 Thu, 01 May 2008 21:01:13 +0000 _ck_ 286@http://bbshowcase.org/forums/ <p>You can get RSS feeds for almost any page in bbPress by putting `/feed/` after it. In fact the front page has two different feeds, one for topics and one for individual posts. You'll probably want the topics one.</p> <p>With some clever programming, even though the feeds might only contain the last 10-20 topics, you can make the front page tool cache them and therefore go back into the hundreds. </p> http://bbshowcase.org/forums/topic/plug-in-idea-show-bbpress-forum-topic-in-wordpress-loop#post-285 Thu, 01 May 2008 12:11:54 +0000 mrhoratio 285@http://bbshowcase.org/forums/ <p>Hey _ck_, I love the RSS feed idea. I'll check Eter RSS out. I'm not totally sure how bbPress feeds work, but I'm assuming I'd need to create an RSS feed in bbPress that always contains every single forum topic, in order for changes to reflect in Wordpress realtime?</p> <p>From my understanding, RSS feeds generally include only the most recent subset of all posts. For example, a bbPress feed might only contain the last 30 recent forum topics. Let's assume I can get Wordpress to aggregate a bbPress feed and mix it into the loop. Does it mean that stories fall out of the Wordpress loop, when they disappear off the bbPress feed (because they are old, not because they are deleted from the forums) as well? </p> <p>So if we go back to our scenario: Ideally, Peggy could go to the front page of the blog and use the pagination links at the bottom to go back several pages and see posts from 2 months ago. On this page, Peggy would still be able to see "promoted" forum topics mixed in with blog posts from 2 months ago, even though the forum topic may have disappeared from the bbPress feed because it's old.</p> <p>I also wonder what the performance issues are with having a feed that contains every single topics. </p> <p>We seem so so close to a solution! </p>