[deadlyhifi]

$forum_one_topics = $bbdb->get_results("SELECT * FROM $bbdb->topics WHERE forum_id = $forum_id AND topic_status = 0 AND topic_sticky = 0 ORDER BY topic_id DESC LIMIT $limit OFFSET $offset");

updated to leave out sticky posts from the second loop (added AND topic_sticky = 0 to query).

If you leave out ‘$forum_id = 1;’ it will work on multiple forums.

I’ve done this so that my front page summary shows latest active posts, but my specific forum pages list by topic order.

[whitewall]

Thanks for the very informative reply _ck_,

The reason I got interested in bbPress is not that we are trying to cut corners or find a cheap solution. It’s more like we would like to find a very simple and a lightweight bulletin board without built-in options we actually do not need. And somehow bbPress 0.9 looks much like what we are after.

Our forum has been running on phpBB since 2001 and the software has had it’s well-known problems. We have also tested the vBulletin – we have even the commercial license and have used lots of time and effort to make our other extensions work with it. But at the end vBulletin has too many options and it is too complex for our needs. We don’t need all those options it offers – we need a simple solution which would integrate nicely into our website.

We have already two dedicated servers (actual machines, not virtual ones), one handles the www-stuff (running apache…) and the other serves as the database server. Right now we have only the phpBB running with a couple of scripts of our own so I guess there’s resources more than we need.

The search issue would be solved by using Google’s search, that’s what we use right now with the phpBB but the lack of caching may be an issue.

Maybe we should keep searching the ultimate BB solution for us or try to customize the phpBB3 to fit our needs and figure out some non-WP solution for the WordPress post commenting.

[uk_ca_usa]

Hello, I have several categories, with subforums. When a user clicks on the category they are taken to a page that shows the subforums for that category. I would also like to add a “Latest Discussions” listing that pulls recent posts from that category to this page. Any idea how how this can be done? Thanks.

[chrishajer]

Here’s a good reason from the WordPress release archive:

“None of these are safe to use, except the latest in

the 2.7 series, which is actively maintained.”

If someone was using a version earlier than 2.7.1 and got hacked, the WordPress forums would be all over them to upgrade and telling them getting hacked is their own fault for not staying up to date.

I run 2.7 vs 2.5 because the admin interface is so much better, IMO. I know some people hate it, but any time I use the admin of a WordPress site prior to version 2.7 I look at it and wonder how I got anything done.

I don’t think criticizing people’s choice to run the latest version of WordPress is helpful in getting bbPress on board with supporting it. 2.5 was released back in March 2008 and presumably work on 2.6 started around that time. That’s almost a year now that bbPress has had a chance to get cookie compatible with 2.6 and later. The alpha versions are compatible, but alpha is bleeding edge and unstable for production use. So, saying alpha is cookie compatible doesn’t help either, since that’s not been recommended for production use by anyone. You can look at alpha and see that 1.0 WILL be compatible, but WHEN?

I mean, bbPress docs still mention that it should integrate with the latest version of WordPress in the 2.5 series, and tells you how to deal with running OLDER versions. That’s pretty sad for software that focuses on “ease of integration” with WordPress.

Now, all this aside: I still can’t figure out why people want integrated logins, why they have users that both post to a blog and post in a forum. But, I don’t ask why. You can push the software around however you want. I don’t understand that but I do understand the frustration with not being able to get that to work.

Frustrations two and three:

2. getting bbPress to look like WordPress (that’s integration to many people)

3. setting up permalinks does not work like WordPress (you make the change in WordPress admin and WordPress modifies the .htaccess file. bbPress does not.)

Fix those things and the number of support requests here would be cut in half, possibly more, and we could focus on pointing people to or creating cool plugins to do everything they want to do with bbPress.

[whitewall]

Thanks for the replies.

We have had some performance issues also with phpBB so far, especially with the latest topics and phpBB2’s search system. Also phpBB is too complex for our usage because we need to customize the board for our needs and integrate it into our webzine and other scripts we will use in our website’s next version.

Our combination would be a wordpress installation for a webzine which will be managed by only a small number of our editors but it would be nice to have all our registered users to comment the posts logged in with their accounts.

Then the bulletin board should be readable by all visitors but posting is for only the registered users. We should have our 52 forums categorized in 5 or 6 different groups. And there are also various private forums which should be readable and writeable only by a certain user groups. I guess this is not fully supported by bbPress or it’s plugings yet?

Then we would customize the user profile page and user registration and management system into our own, because there will be paid “VIP” members and free registered users and users should be also categiorized in different groups. Also we have our own solution for the private messaging. I guess all this could be done outside the bbPress.

There are also few scripts of our own such as event calendar, classified ads, galleries etc. which would use the same user management / login system.

So the main usage of bbPress would be handling the forum posting, editing and basic forum stuff and together with WordPress and our own extensions they would make a nice platform for a social networking online community. Maybe some of these customizations and extensions of ours would even be possible to publish as a plugins when they’re ready and working.

We have studied also vBulletin and SMF but so far bbPress seems to be the best bb for our needs.

[johnhiler]

AFAIK, nobody’s worked out the WordPress 2.7/bbPress 0.9.x cookie/signin integration yet. If it comes, I’m betting it will take the form of a user-generated plugin… I don’t get the feeling that it’s on the official roadmap.

I agree that point upgrades to address compatibility would be nice! But I’m pretty sure that bbPress isn’t enough of a priority within Automattic yet to get the resources to make that happen. It sounds like that may happen within the next year tho.

As for the current state of things: I don’t think bbPress 1.0 is stable yet and more importantly, a good number the most popular 0.9 plugins aren’t yet fully compatible with 1.0. But that may change in a few months! In the meantime, I am hoping that bbPress 0.9 cookie/signin compatibility with the latest WordPress versions becomes possible with a plugin.

[johnhiler]

That’s a really high number of posts and pageviews!

My bbPress forum is # 12 on that top100 list. It’s not nearly as large as your phpBB site but I’ll share the scaling problems I’ve come across, in case it’s useful.

Probably the biggest problem I face is that the Google Sitemaps plugin doesn’t scale very well. I believe the most popular Sitemaps plugin regenerates the sitemap upon every publish; this hangs my site every time someone comments on a post. I’m actually exploring the possibilities around upgrading or programming the existing sitemap plugins, to provide a more scalable solution here. But without a good solution here, my content isn’t as Google friendly as it could be.

Also, the Akismet spam solution is decent… but the bbPress moderation management tools aren’t as robust as they are on WordPress. So moderating the spam queue takes a decent amount of time a day, especially as the site has grown larger. If the problem continues to grow, I’ll look into plugin solutions to help out here.

Finally, the account management tools on bbPress aren’t very robust. For example, I get emails every day from users saying they forgot their username, or would like to reset their password. bbPress doesn’t currently have easy ways for users to retrieve a forgotten username or to easily reset their password (they can reset the password, but first they have to put in a username/password and fail a signin attempt). I’m actually working on plugins and theme changes to address this one now, but it currently creates a decent amount of work answering emails from confused users.

My final concern actually is around bbPress 1.0. I am very happy on bbPress 0.9, but version 1.0 is around the corner and seems to be a lot less lightweight than the current version. I’m also concerned about the lack of backwards compatibility with some 0.9 plugins. This wouldn’t be a huge issue, but bbPress 1.0 is currently necessary to ensure cookie/signin compatibility with the latest version of WordPress.

If you are considering bbPress as a standalone forum for a huge site, I’d definitely recommend it – as long as there are plugins for all the features you currently support on your forum.

If you’re considering bbPress in conjunction with WordPress, I’d hold off until bbPress 1.0 comes out of beta and/or a plugin supporting bbPress 0.9/WordPress 2.7 cookie integration comes out.

Just my two cents… hope that helps!

[chrishajer]

This was a discussion of getting bbPress data in WordPress:

https://bbpress.org/forums/topic/heres-how-to-show-bbpress-info-inside-wordpress-without-full-integration

Here is a way to get the latest WordPress posts and use them in bbPress; I imagine you could just do something similar to get with wp_usermeta:

https://bbpress.org/forums/topic/latest-wordpress-stories

[chrishajer]

http://bbshowcase.org/forums/view/top100

There have been a couple performance related discussions on these forums as well:

https://bbpress.org/forums/topic/server-overload

https://bbpress.org/forums/topic/bbpress-faster-than-wordpress

https://bbpress.org/forums/topic/get-latest-topics-performance-problem-and-solution

[_ck_]

Yup “order by rand()” is very handy.

I used it for a mod for WordPress years ago to make a “random” category which is very useful.

It could even be done to make a “random topics” view in bbPress but not sure how useful that would be.

It’s fine for casual use but keep in mind for larger tasks it’s very slow and makes mysql purists shudder.

[deadlyhifi]

and my final correction on the random thing!

$stories = $bbdb->get_results("SELECT post_title, guid FROM site_posts WHERE post_type='post' AND post_status='publish' ORDER BY post_date_gmt DESC LIMIT 0,10");

shuffle($stories);

previous example was getting a random 10 from all posts.

This get’s 10 latest posts, then randomizes them with the ‘shuffle’.

cheers!

[deadlyhifi]

On my version I’m fetching 10 latest rows, randomizing, then displaying 5 stories.

$bbdb->get_results("SELECT post_title, guid FROM site_posts WHERE post_type='post' AND post_status='publish' ORDER BY rand() LIMIT 0,10");

Admittedly, I didn’t make the correct alterations to the previous example. Anyway, it should give people an idea of what to do.

oh, and _ck_ I hadn’t spotted your earlier post – it would have made it a lot easier for me to figure out if I had!

[jmilli]

Greetings,

I just installed BBPress today and was totally psyched because I have heard such great things about the WordPress products.

But . . . I am having major problems:

– New user testing – password doesn’t work. Login failed.

– I created forums and when I select the topic I get a “The requested document was not found on this server.” error.

– When I select a user profile (including mine) I get the same error.

– This is where it is strange and makes me think that maybe I need to reinstall the whole thing. I can’t create a new post. Nowhere does it say “Create post” on the forums.

I did install the Approve User Registration plugin by Aditya Naik, but I deactivated it and I am still having the above problems.

Thoughts?

thanks in advance,

Jeff

[_ck_]

FYI, the if ($i <= 4) { is not needed because you already do a LIMIT on the query.

Related topic:

https://bbpress.org/forums/topic/heres-how-to-show-bbpress-info-inside-wordpress-without-full-integration

[Ipstenu (Mika Epstein)]

FYI, this only lists 4 posts but is FREAKIN AWESOME!

[deadlyhifi]

Just made a query in my forum functions.php to display the 5 latest stories from WordPress. Pretty basic but it may help someone:

// get WP news

function wpnews() {

global $bbdb;

$stories = $bbdb->get_results("SELECT post_title, guid, post_date_gmt FROM wp_posts WHERE post_type='post' AND post_status='publish' ORDER BY post_date_gmt DESC LIMIT 0,4");

foreach ($stories as $story) {

if ($i <= 4) {

echo '<li><a href="' . $story->guid . '">' .$story->post_title . '</a></li>';

$i++;

}

}

}

then call it on your forum with <?php wpnews() ?> and style to suit.

[_ck_]

Good fix, I got distracted after I posted that and never did it myself.

There’s also a border issue on images but I think most themes have that problem and it’s another thing I have to enforce in it’s own stylesheet.

actually, you are causing it here:

#posts .post .content a img {

border: 1px solid #ccc;

}

You may way to limit it to topic pages and not any kind of table like latest-discussions.

[_ck_]

Very well done.

Here’s a demo:

http://bbshowcase.org/forums/?bbtheme=toonewsy

You must have display:block on images inside the #latestdiscussions table.

I’ll have to put an override in the topic icons plugin.

[pierrottorreip]

Hey All,

I posted this here…

http://bbpress.org/plugins/topic/instant-password/

but was wondering if anyone else had the same problem. I set up the instant password plugin and tried to set up a test accound but kept on getting a ‘password is too short’ message – no matter what I type in.

Thanks!

[Burt Adsit]

I’ve got this plugin up to something testable and releaseable. v0.21

---

Description

---

Enable BuddyPress group forum features in bbPress.

BuddyPress has three types of groups. Public, Private and Hidden. In all three cases users must be members of a group to participate in group forum conversations.

These two plugins modify a standard bbPress forum installation to allow BuddyPress group members to carry on discussions in bbPress.

BuddyPress public groups will be read only in bbPress. Anyone wishing to participate in a public group discussion must be a member of that group in bp.

BuddyPress private and hidden groups will be hidden in bbPress. Only members of these groups will see the forums and be able to participate.

BuddyPress group admins and mods have moderator privileges in bbPress. The moderator role is restricted to their group forum.

Read more and download:

http://code.ourcommoninterest.org/2009/02/14/buddypress-group-forums-for-bbpress/

[joemoak]

I have the same question. The latest mod post regarding bbSync said “it’s broken right now.” Any other options?

Ideally, I would like a new WordPress post to create a new forum topic and for all comments to be handled by bbPress. Possible?

[johnhiler]

I haven’t tested this, but at least one person was able to get this plugin to work:

https://bbpress.org/plugins/topic/threaded-posts/

[tfab69fr]

Hi all

After upgrading:

WP2.5 -> 2.7

BBPress 0.9.4 -> 1.0 alpha 6

WP is running badly.

In order to get access to functions of BBPress, I have these lines at the end of wp-config.php:

if ( !defined('BBDB_NAME') )

require_once(ABSPATH.'forum/bb-load.php');

Into the index.php of my WP theme, I wish to display the last topics of the forums, by doing:

<?php

$forums = get_forums();

$topics = get_latest_topics();

$super_stickies = get_sticky_topics();

for ($i=0;$i<3;$i++){

$topic = $topics[$i];

?>

" title="See the message of <?php topic_author();?>"><?php topic_title();

<?php } ?>

The display of the latest messages was working well and still working well after the upgrade, BUT WORDPRESS GETS INTO TROUBLE:

– the css style for the back admin of WP is not working

– the hooks into the plugins are not called anymore (add_action(‘wp_head’, ‘init_js’); where init_js() is never run)

– custom query vars are not detected into the url

Well, when I remove the require_once into the wp-config.php (see below), the trouble disappear.

//if ( !defined('BBDB_NAME') )

//require_once(ABSPATH.'forum/bb-load.php');

How to get it working with the bbpress function without trouble in WP ?

I think this is a very important point for the BBPress integration in WordPress

Thanks

[rossmcd]

I’m creating it myself. I added the karma to the database myself for now until i know i can get it showing up. It’s on my test forum.

[rossmcd]

i haven’t added that part yet. I added Karma to my mysql database with phpadmin, it’s on a test form. I’m trying to retrieve it i can’t figure it out.