bbPress Support Forums Tag: BB

bbPress Support Forums Tag: BB_Query http://bbpress.org/forums/ bbPress Support Forums Tag: BB_Query en Fri, 09 Jan 2009 01:21:31 +0000 hudatoriq on "Custom query in bbPress. Latest topics from several forums" http://bbpress.org/forums/topic/custom-query-in-bbpress-latest-topics-from-several-forums#post-22039 Sat, 20 Dec 2008 17:02:44 +0000 hudatoriq 22039@http://bbpress.org/forums/ <p>Thank you for your response. I'll take a deeper look into the BB_Query class.</p> <p>After reading this question, do you think of a plan to extend the bbPress live plugin so it can transport the query as well?<br /> I think it's a great idea. Just my opinion :-) </p> sambauers on "Custom query in bbPress. Latest topics from several forums" http://bbpress.org/forums/topic/custom-query-in-bbpress-latest-topics-from-several-forums#post-22025 Sat, 20 Dec 2008 13:55:08 +0000 sambauers 22025@http://bbpress.org/forums/ <p>Not possible using bbPress Live plugin I'm pretty sure. You would have to do separate calls and then merge them somehow.</p> <p>It's probably possible using the BB_Query class inside bbPress though. </p> hudatoriq on "Custom query in bbPress. Latest topics from several forums" http://bbpress.org/forums/topic/custom-query-in-bbpress-latest-topics-from-several-forums#post-21952 Thu, 18 Dec 2008 20:20:23 +0000 hudatoriq 21952@http://bbpress.org/forums/ <p>Hi. I still don't quite familiar with bbPress custom query system. Is there a simple way to pull the latest topics from only specific forums? In WP we can pull posts from several categories using comma separated category IDs in the query. Can bbPress do that?</p> <p>And if there is, is it possible to pull it from WordPress using bbPress_Live php class in bbpress-live plugin?</p> <p>Thank you in advance. </p> mrhoratio on "bb_query: get topics started within a date range?" http://bbpress.org/forums/topic/bb_query-get-topics-started-within-a-date-range#post-16144 Mon, 12 May 2008 05:21:26 +0000 mrhoratio 16144@http://bbpress.org/forums/ <p>Hey Sam, thanks for making a ticket for this. I was able to query for topics within a date from directly from Wordpress as well. Here's something I wrote to merge "super sticky" bbPress topics into the Wordpress loop. It's a bit of hack, but it brings the "Promote to Front Page" functionality of Drupal into Wordpress/bbPress:</p> <pre><code><?php get_header(); ?> <?php //Put Wordpress posts into an array $wp_posts = $posts; if (!is_single()){ //Retrieve first post of previous page (we need this post's date to query bbPress topics $offset=$paged*$posts_per_page+$posts_per_page; $first_post_of_previous_page = get_posts('numberposts=1&offset='.$offset); //First set the start and end dates to limit the query to the bbPress table $startdate=(date('YmdHis',strtotime($first_post_of_previous_page[0]->post_date_gmt))); //If it's the most recent page, set end date to today if ($paged){ $enddate=(date('YmdHis',strtotime($wp_posts[0]->post_date_gmt))); } else { $enddate=gmdate('YmdHis'); } //Retrieve "Super Sticky" topics from bbPress tables //This assumes your bbPress and Wordpress tables are in the same database $bb_topics = $wpdb->get_results("SELECT * FROM bb_topics WHERE topic_sticky = 2 AND topic_start_time BETWEEN $startdate AND $enddate ORDER BY topic_start_time DESC"); //Map bbPress topics to WordPress posts structure foreach($bb_topics as $bb_topic){ $bb_first_post = $wpdb->get_results("SELECT post_text FROM bb_posts WHERE post_position = '1' AND topic_id = $bb_topic->topic_id", ARRAY_A); $bb_post->ID = "forum_topic_".$bb_topic->topic_id; $bb_post->post_author = $bb_topic->topic_poster; $bb_post->post_date = $bb_topic->topic_start_time; $bb_post->post_content = $bb_first_post[0][post_text]; $bb_post->post_title = $bb_topic->topic_title; $bb_post->post_status = "publish"; $bb_post->comment_status = "open"; $bb_post->ping_status = $bb_topic->post_id; $bb_post->post_name = "forums/topic/".$bb_topic->topic_slug; $bb_post->post_type = "post"; $bb_post->comment_count = $bb_topic->topic_posts-1; //add bbPress topic to Wordpress posts array $wp_posts[] = $bb_post; }; //Create function to sort array of posts by date function compare($x, $y){ if ( $x->post_date == $y->post_date ) return 0; else if ( $x->post_date < $y->post_date ) return 1; else return -1; } //Sort array usort($wp_posts,'compare'); } ?> <div id="content-box" class="span-8"> <div id="content-area" class="clearfix"> <?php if ($wp_posts): ?> <?php foreach ($wp_posts as $post): ?> <?php setup_postdata($post); ?> <div class="entry"> <div class="entry-header clearfix"> <div class="info span-2"> <a href="<?php the_permalink(); ?>#comments" class="comment-activity"><?php comments_number('<strong>Post comment</strong>', '<strong>1</strong> Comment', '<strong>%</strong> Comments' );?></a> </div> <div class="content span-6 last"> <h2><a href="<?php the_permalink(); ?>" rel="bookmark" title="Permanent Link to <?php the_title(); ?>"><?php the_title(); ?></a></h2> </div> </div> <div class="entry-content clearfix"> <div class="info span-2 clearfix"> <p><strong><?php the_author() ?></strong><br /> <?php the_time('M j, Y'); ?> </p> <p class="share-this"><?php akst_share_link(); ?></p> <p class="post-comment"><a href="<?php the_permalink(); ?>#respond">Comment</a></p> </div> <div class="content span-6 last clearfix"> <?php the_content('Click to continue'); ?> <p class="entry-tags"><?php the_tags('<strong>Posted in: </strong>', ', ', ''); ?> </p> </div> </div> </div> <?php endforeach; ?> <?php include (TEMPLATEPATH . '/navigation.php'); ?> <?php else : ?> <h2 class="page_header center">Not Found</h2> <div class="entry"> <p class="center">Sorry, but you are looking for something that isn't here.</p> <?php include (TEMPLATEPATH . "/searchform.php"); ?> </div> <?php endif; ?> </div> </div> <?php get_sidebar(); ?> <?php get_footer(); ?></code></pre> sambauers on "bb_query: get topics started within a date range?" http://bbpress.org/forums/topic/bb_query-get-topics-started-within-a-date-range#post-16141 Mon, 12 May 2008 02:23:44 +0000 sambauers 16141@http://bbpress.org/forums/ <p><a href="http://trac.bbpress.org/ticket/879" rel="nofollow">http://trac.bbpress.org/ticket/879</a> </p> sambauers on "bb_query: get topics started within a date range?" http://bbpress.org/forums/topic/bb_query-get-topics-started-within-a-date-range#post-16133 Mon, 12 May 2008 01:20:19 +0000 sambauers 16133@http://bbpress.org/forums/ <p>BB_Query can't do this at the moment as far as I can tell. It probably should though.</p> <p>I'll make a trac ticket to suggest this.</p> <p>At the moment you could do two BB_Queries and intersect their results. But that's pretty poor.</p> <p>Just be sure if you do use a direct query that you prepare it first. e.g.:</p> <pre><code>$startdate="20070602103049"; $enddate="20080212090232"; $query = $bbdb->prepare("SELECT * FROM %s WHERE topic_start_time BETWEEN %s AND %s ORDER BY topic_start_time DESC", $bbdb->topics, $startdate, $enddate); $topics = $bbdb->get_results($query);</code></pre> mrhoratio on "bb_query: get topics started within a date range?" http://bbpress.org/forums/topic/bb_query-get-topics-started-within-a-date-range#post-15959 Sun, 04 May 2008 05:00:30 +0000 mrhoratio 15959@http://bbpress.org/forums/ <p>I did some more digging, and it looks a way to do is to not use BB_query at all, but to use $bbdb->get_results instead:</p> <p><code></p> <p>$startdate="20070602103049";<br /> $enddate="20080212090232";</p> <p>$topics = $bbdb->get_results("SELECT * FROM $bbdb->topics WHERE topic_start_time BETWEEN $startdate AND $enddate ORDER BY topic_start_time DESC");</p> <p></code> </p> mrhoratio on "bb_query: get topics started within a date range?" http://bbpress.org/forums/topic/bb_query-get-topics-started-within-a-date-range#post-15954 Sat, 03 May 2008 17:00:17 +0000 mrhoratio 15954@http://bbpress.org/forums/ <p>How do I use bb_query to fetch all topics that were started within a given date range?</p> <p>Here's an example found an example of a bb_query code on the bbPress blog:</p> <p><code></p> <p>$topic_query = new BB_Query( 'topic',<br /> array(<br /> 'topic_author' => 'mdawaffe',<br /> 'started' => '2007-06',<br /> 'tag' => 'bbpress',<br /> 'order_by' => 'topic_start_time'<br /> )<br /> );<br /> $topic_query->results; // Here's the array of topics the query returned.</p> <p></code></p> <p>This shows how to get topics that where started on June 2007. But what if I wanted to get all topics that were started between June 2, 2007 10:30:49 PM and February 12, 2008 9:02:32 am?</p> <p>I think I may be missing something totally obvious. Any suggestions? I </p> KJTED on "BB_Query class and next version of bbPress?" http://bbpress.org/forums/topic/bb_query-class-and-next-version-of-bbpress#post-9363 Thu, 26 Jul 2007 10:00:40 +0000 KJTED 9363@http://bbpress.org/forums/ <p>I've not forgotten about this. I will post up some code when i've finished. I've just written an insertion class too. </p> KJTED on "BB_Query class and next version of bbPress?" http://bbpress.org/forums/topic/bb_query-class-and-next-version-of-bbpress#post-9053 Wed, 18 Jul 2007 09:15:13 +0000 KJTED 9053@http://bbpress.org/forums/ <p>Hi fel. I'll post up later today the process I went through. I'll get the latest version of the class right now! :) Thanks for the heads up.</p> <p>I've also done some work with CodeIgniter and Flash integration which I'll post a link to later in case anyone does CI development (off topic I know but still valuable). </p> fel64 on "BB_Query class and next version of bbPress?" http://bbpress.org/forums/topic/bb_query-class-and-next-version-of-bbpress#post-9038 Tue, 17 Jul 2007 19:03:11 +0000 fel64 9038@http://bbpress.org/forums/ <p>It <em>is</em> funkin' brilliant. I hope you downloaded the latest release ( <a href="http://trac.bbpress.org/browser/trunk," rel="nofollow">http://trac.bbpress.org/browser/trunk,</a> at the bottom of the page is the Zip Archive link to the latest) because it has a bunch of fixes and changes.</p> <p>Can you detail anything you had to do to make it work, for future people who want to do this stuff? :) </p> KJTED on "BB_Query class and next version of bbPress?" http://bbpress.org/forums/topic/bb_query-class-and-next-version-of-bbpress#post-9033 Tue, 17 Jul 2007 16:52:08 +0000 KJTED 9033@http://bbpress.org/forums/ <p>The BB_Query class is funkin' brilliant! I now have abstraction class to communicate between Flash and bbPress. </p> KJTED on "BB_Query class and next version of bbPress?" http://bbpress.org/forums/topic/bb_query-class-and-next-version-of-bbpress#post-9028 Tue, 17 Jul 2007 14:55:48 +0000 KJTED 9028@http://bbpress.org/forums/ <p>I just noticed I can actually download it from the Roadmap in the development section...</p> <p><a href="http://trac.bbpress.org/ticket/657" rel="nofollow">http://trac.bbpress.org/ticket/657</a></p> <p>Without documentation I guess it'll be a case of figuring it out myself lol.</p> <p>Will the new version of bbPress have any structural changes to the database? I'm hoping I can use this class with the current version of bbPress.</p> <p>:) </p> KJTED on "BB_Query class and next version of bbPress?" http://bbpress.org/forums/topic/bb_query-class-and-next-version-of-bbpress#post-9027 Tue, 17 Jul 2007 14:51:16 +0000 KJTED 9027@http://bbpress.org/forums/ <p>I'm really anxious to get my hands on the BB_Query class because it looks like it'll help me a lot with my quest to integrate Vanilla into a Flash movie clip. Does anyone know when the next version of bbPress will be released as the blog states it will contain the new BB_Query class.</p> <p>Cheers<br /> KJ </p>