Re: bb_query: get topics started within a date range?
BB_Query can’t do this at the moment as far as I can tell. It probably should though.
I’ll make a trac ticket to suggest this.
At the moment you could do two BB_Queries and intersect their results. But that’s pretty poor.
Just be sure if you do use a direct query that you prepare it first. e.g.:
$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);