bbPress support forums Topic: bb_query: get topics started within a date range?

bbPress support forums Topic: bb_query: get topics started within a date range? http://bbpress.org/forums/ bbPress support forums Topic: bb_query: get topics started within a date range? en Sat, 30 Aug 2008 14:44:56 +0000 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>