How do I use bb_query to fetch all topics that were started within a given date range?
Here’s an example found an example of a bb_query code on the bbPress blog:
$topic_query = new BB_Query( ‘topic’,
array(
‘topic_author’ => ‘mdawaffe’,
‘started’ => ‘2007-06’,
‘tag’ => ‘bbpress’,
‘order_by’ => ‘topic_start_time’
)
);
$topic_query->results; // Here’s the array of topics the query returned.
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?
I think I may be missing something totally obvious. Any suggestions? I
Did you replace the sample php file?
I know its more secure but I find my attach rate is MUCH higher if the user enters their own password rather than has a forum generate one for them.
Does anyone know an easy way to do this, I mean I can just go in and hack it myself but I wasn’t sure if there was a mod or anything to allow this.
The config.php referred to is probably actually bb-config.php. That threw me at first.
Thanks for the feedback edwinfoo. The history behind this suggestion is that I am a very active contributor on “Geni.com” forum (they use bbpress).
The forum mob tends to end up in flamewars due to the moderators not being able recognize even simple “ad hominem” flame baits and step in in time. Threads gets hijacked and flamewars breaks loose across several threads and all the moderate contributors suffer as a consequence.
There are some clever trollers creating sock-puppets and repeatedly throwing small baits on certain targeted users. When the targeted user eventually snaps, he is the one that unfairly gets blocked.
I neither think a thread creator should be able to “edit” other contributors posts, only “flag” them as either “irrelevant” or “flamebait” and by that”hide” the text of the offensive/irrelevant post, not the fact that there is a post. Basically like putting a big fat stamp over it. The offender would then have to dispute the matter via PM with the thread owner or forum moderator.
Further there could be a “3 flagged posts in 1 thread blocks offender automatically from further posts to that specific thread”
I try to install bbpress but no success..can someone help me to solve this problem?
Here is the url : http://bbpress.addyourbid.com
Thanks
I just did some fiddling in the bbPress functions.php file located in the bb-includes directory. I may have found a possible fix:
On line 167, look for this code:
$q = 0;
Then delete or comment out everything except for the semicolon at the end:
;
This seems to make topics that are stuck to the front page appear in the forum as well.
Warning: I’m not well-versed in php, so I’m not sure if this will break anything in bbPress. If there’s a more elegent solution, please post it.
I just did some fiddling in the bbPress functions.php file located in the bb-includes directory. I may have found a possible fix:
On line 167, look for this code:
$q['sticky'] = 0;
Then delete or comment out everything except for the semicolon at the end:
;
This seems to make topics that are stuck to the front page appear in the forum as well.
Warning: I’m not well-versed in php, so I’m not sure if this will break anything in bbPress. If there’s a more elegent solution, please post it.
Ah, it looks like there is another thread about this problem:
Stick to front removes topic from forum?
However, there’s not solution yet. Strange.
Hey bobby, thanks! I didn’t notice the “Stick topic (to front)” link before.
However, there is a bug. If you click the “to front” link, the topic appears as a Sticky on the Latest Discussions list, but it disappears from the forum it was originally assigned. Seems like it should show up in both places. I did a test where I made a forum with one post in it. I made it Sticky on the front page. On the front page of bbPress, it shows the number of topics as “1” in that forum. However when you forum title, it doesn’t display any topic. Instead it takes you to a New Topic form.
I agree. It’d be great to have categories, or at least the ability to allow moderators to assign editor “tags” to topics which only moderators can edit. For example, you could assign a topic the tag or category named “Front Page”. That way, you can create a bbPress template/theme that shows the Editor’s Picks.
I reproduced this error with FF, so it must just be my server. I’ll try upgrading to the latest version of bbpress and see if this fixes the problem…
I figured this out by accident after not finding much in the forums about it, so I thought I’d post it fresh.
In wordpress, we use <?php bloginfo('template_url'); ?> to go straight to your template directory (i.e. “http://mysite.com/wp-content/themes/mytheme”).
In bbPress, to go yout theme directory (i.e. “http://mysite.com/bb-templates/mytheme”), you use <?php bb_option('template_uri'); ?>
Clarification – when bbadmin tries to login after integration, the response is that bbadmin does not exist. I think this is because bbadmin credentials created by the bbPress installation are not stored in the WPMU users table. Of course, it wouldn’t exist. But bbPress doesn’t copy over those credentials or look at both tables to authenticate.
I’m using bbPress 0.902 and WPMU 1.3.3. Integrating the bbPress with the user database works, but then I can’t access the bbPress admin console anymore. Here’s what happens:
1. install bbPress without integration and in the process create an admin account bbadmin.
2. The bbadmin account works, I can access the bbPress admin screens, etc.
3. Change the integration settings to point to the WPMU users table. I do NOT do the cookie integration as this is problematic with the new password hashing.
4. bbPress immediately logs bbadmin out. I can login with WPMU user accounts, but none of them can access the bbPress admin console. More importantly, the bbadmin account can’t login anymore.
I’ve replicated this problem 7 times.
The bottom line is that I can’t use the db integration feature at all.
Question – how can I integrate the WPMU users and still access the bbPress admin console?
“bb_current_time is in the functions file inside bb-includes directory. But you probably should touch that otherwise when you update bbpress, it will break again.
“
Tell me about it — I’ve already hacked another core file which has to be re-tweaked every upgrade…
BTW isn’t this a bug really?
Thanks for the news
.
But isn’t it a beta script to import phpbb3 to a bbpress ?
I have <?php login_form(); ?>
When at the home page of BBpress when I click logout it doesn’t log out. Actually it does but it shows like I’m still logged in. When I click on a different forum it shows that I’m logged out. When I click to the home page of the forum it shows that I’m logged in.
Thanks.
kiaspeed2.com/forum/ is the site
bb_current_time is in the functions file inside bb-includes directory. But you probably should touch that otherwise when you update bbpress, it will break again. 
The SQL I used was just an interval clause…i.e. if I was going to import my current forums I would use something like:
SELECT ID, Body, DateCreated – interval ‘9 30’ hour_minute FROM current_forum_whatever
This takes the date field and drops 9.5 hours off, coincidentally, my time zone.
You could probably adapt this to an ‘update’ statement to change what’s already in your database, eg:
UPDATE bb_topics SET DateCreated=(SELECT DateCreated – interval ‘9 30’ hour_minute);
I haven’t tested it but it probably wouldn’t be too far wrong.
Having just read the thread over here, I went and rechecked that my WordPress “secret” setting as listed in /wp-admin/options.php matched the setting in my bbPress admin-stettings-wp-integration screen and found that somehow they no longer matched. My best guess is that in the database “update” with the 2.5.1 upgrade of WP, it regenerated the database secret, thus killing the integration.
Import/Export is being improved as part of a Google Summer of Code project. We will hopefully have some results from that to share by the end of it.
The basic idea is to create export plugins for other forum software which can export to a standard format. Then we will have one importer to import that standard format into bbPress.
Me too >.< I thought it was just me… heh
Hello people, I use bbpress but I don`t know how can I use in posts backticks…
On thinking about it a bit further, I went back to my SQL posts and kludged a statement which removes 9.5 hours from the various date fields that populate the bbpress database.
On restoring everything back, it’s ok now.