[bobbyh]

A lot of bbPress forums have taken advantage of easy user integration with WordPress. The next step to integrating a WordPress blog and bbPress Forum is to create a bbPress Theme to match your WordPress Theme. bbPress doesn’t ship with built-in support for a sidebar, although I found it trivial to add this with a small plugin. What I really missed was a lightweight way to access WordPress’ wp_list_bookmarks Template Tag function, which lets you display your WordPress Blogroll links.

To add this functionality, I wrote this bbPress List Bookmarks plugin. To install this plugin, download the zip and unzip it to your bbPress server under your /my-plugins folder. The zip should extract to a folder named “list_bookmarks”, so the location of these files should be /my-plugins/list_bookmarks. Then, in your bbPress theme, add a wp_list_bookmarks Template Tag with whatever parameters you want (just like you would when editing a WordPress Theme). You shouldn’t need to hack any of the plugin files to get this to work, although of course you’ll have to edit your bbPress Theme to take advantage of this plugin.

This plugin should work whether or not these WordPress tables are located in the same database as your bbPress tables, as long as your WordPress tables are located in the same database as your integrated user tables.

I’ve tested this plugin on my site, which currently uses bbPress v0.8.2.1 and WordPress v2.2.1. If you use WordPress 2.0 or earlier and you want to use this plugin, you should probably upgrade your WordPress first as wp_list_bookmarks is a new function introduced in WordPress v2.1. I don’t think it should matter what version of bbPress you use.

This plugin ships with a database class called bbwpdb.php that lets us access the WordPress database tables. The bbwpdb.php file is basically a clone of the bbPress /bb-includes/db.php file, edited to let us retrieve WordPress tables. The remaining files are simply three WordPress PHP pages needed (wp-admin/admin-db.php, wp-includes/bookmark-templates.php, and wp-includes/bookmark.php), with slight edits to make it use the bbwpdb database class, instead of the WordPress or bbPress database class. The last file (list_bookmarks.php) just glues everything together.

[M]

People that are attracted to bbPress will be attracted because of its out-of-the-box simplicity and its extensibility.

It’s great… if you want a plugin and you’ve messed around with WordPress for any length of time, you’ll feel right at home. I personally dislike polls… _ck_ obviously doesn’t, and he’s not alone. That’s the beauty of bbPress. These features aren’t crammed down your throat; rather they are completely optional.

Also, I don’t think that bbPress was built to win a popularity contest. It was built with certain things in mind and is continuing in that trend. I think that’s great.

One more thing… those people who were attracted to other forum software solutions (ie, SMF, IPB, vB), wanted something feature-bloated. All kinds of things pouring out of every corner. They wouldn’t be attracted to bbPress unless it became a miniature of what they were already using. And what’s the point in that, eh?

[M]

Stick with the ezSQL format… it’ll be much easier.

Something like this (using foreach instead of while):

$query = "SELECT * FROM $bbdb->menu

WHERE set = 'inactive' ORDER BY order ASC";

$r = $bbdb->get_results( $query );



foreach( $r as $rw ) {

// now mess with $rw

echo $rw->database_row . "<br>n";

}

Something that might be helpful would be to browse the source of the ezSQL class in /wp-includes/wp-db.php

The latest from Justin Vincent, the author

http://www.woyano.com/jv/ezsql

The version used in bbPress and WordPress

https://trac.wordpress.org/browser/trunk/wp-includes/wp-db.php

It might help you… you’d be able to see where mysql_query is begin used, and how to use the ezSQL format best.

I think the reason you’re running into problems with mysql_fetch_array is because it’s already used.

Not sure on that one though… I would have to check.

Also, what might cause an error: $bbdb->query will not return anything at all. $bbdb->get_results needs to be used for multi-dimensional array data, $bbdb->get_row or $bbdb->get_col need to be used for single array data, and $bbdb->get_var needs to be used for non-array/string data. $bbdb->query is used for inserting data, the others are used for retrieving it.

Someone correct me if I’m wrong, but I’m pretty positive that’s how it goes.

ezSQL is lovely. It certainly takes the pain out of MySQL data manipulation.

So I guess that makes the answer to your question “Neither.” $bbdb->get_results should do the trick.

And sorry for the screed.

[_ck_]

Here’s a plugin to extend the topic-views plugin and add a “most-views” view page (ie. view.php?view=most-views)

It does it with a minimum number of mysql calls, just 10 to display an entire page on my setup. You have to hack your views.php template to add the views column, use $topic->views for the view count to use the cached data in memory instead of an extra mysql query for each topic.

function most_views_views( $views ) {

global $views;

$views['most-views'] = 'Topics with the most views';

return $views;

}

add_filter('bb_views', 'most_views_views');



function most_views( $view ) {

global $bbdb, $topics, $view_count;

switch ( $view ) :

case 'most-views' :

$limit = bb_get_option('page_topics');

$where = apply_filters('get_latest_topics_where','');

$most_views = $bbdb->get_results("SELECT topic_id FROM $bbdb->topicmeta WHERE meta_key='views' ORDER BY cast(meta_value as UNSIGNED) DESC LIMIT $limit");

foreach (array_keys($most_views) as $i) {$trans[$most_views[$i]->topic_id] =& $most_views[$i];} $ids = join(',', array_keys($trans));

$topics ="SELECT * FROM $bbdb->topics WHERE topic_id IN ($ids) $where ORDER BY FIELD(topic_id, $ids)";

$topics = $bbdb->get_results($topics);

$view_count  = count($topics);

$topics = bb_append_meta( $topics, 'topic' );

break;

default :

do_action( 'bb_custom_view', $view );

endswitch;

}

add_action( 'bb_custom_view', 'most_views' );

[jamiedavies]

I’ve checked the database table. There’s 53 records with the latest being id=56

[fel64]

I think – if I remember this right – that it’s a known issue caused by the pagination using the total number of accounts ever created instead of the number existing now and that it’s fixed in the latest.

If you have phpMyAdmin, can you check the ID of the latest member? If that ID is 309, bingo.

[_ck_]

Hmm. Well I don’t think it’s an old theme but it might be another plugin hooking topic_last_poster(). I will have to dig.

Also, how many forums + topics are you showing on your front page?

I’ve got 8 forums and 35 topics with roughly 20 unique last poster usernames on the front page.

Not that it really matters, if you are only hitting 11 queries than it’s still quite efficient. What’s funny is it could be single digit queries except that bbpress tests that it exists by hitting the database with a useless query every time it starts.

[fel64]

I’ve applied this plugin and I’ve only got 11 queries on the front page in kakumei, 13 in my theme (with an onlinelist and latest blog post). Are you running the latest? If not, that’s the likely cause.

[fel64]

Thanks for posting it here anyway bugs go on trac for fixing, and this particular one’s already been addressed. I can’t tell if it went into the latest version (.8.2.1) or not but it should be fixed in trunk.

[LMD]

Hi, the error you are reporting appears to be a problem with the bbPress core code, specifically the user ‘capabilities’ class.

Have I understood this correct:

– You are using the latest bbPress version (0.8.2.1) ?

– The error only appeared AFTER you upgraded to the latest Avatar Upload plugin to version (0.6.2)?

– Does the error appear on EVERY page, or just the Avatar Upload template in the profile area?

[_ck_]

Can anyone tell me what the standard number of queries for the front page are on a default install of bbpress?

I think mine are high because of my template hack for the latest reply link. (added: nope, tried removing it and no query reduction)

There has to be a way to cache that and reduce the number of calls by pre-fetching all the links for all the topics to be listed, instead of doing one call at a time…

[Sam Bauers]

Private messaging doesn’t show up because there is nothing in the trunk. There are only tags. If the author just copies the latest tagged version to the trunk then it will show up too.

[fel64]

The newest version is ALWAYS an improvement. A BIG improvement. There is NEVER a situation where you shouldn’t upgrade.

You have a problem and you’re not running the latest version. What do you do? Go upgrade.

You don’t have a problem. You’re not running the latest version. What do you do? GO UPGRADE.

Upgrading might not even fix this problem, it’s not sure. But it does fix several security exploits and adds a bunch of featurs. Go upgrade!

What’s worst is that you’re on a support forum asking for help and you’re not even on the latest version.

If I wasn’t clear … GO UPGRADE

[fel64]

The difference between actions and filters is unclear. In principle, filters are supposed to let you modify data and actions give you a chance to respond to events. This is reflected most in the fact that with a filter, you have to return some data which will be used instead of the data given to you in the first place. For actions, you don’t.

The syntax is this:

do_action('action_name', [$argument1, [$argument 2 [...]]]);

apply_filters('filter_name', [$argument1, [$argument 2 [...]]]);

I don’t recommend making changes to the core, of course. But if you have to, you would change the last line of topic_time() from this:

echo _bb_time_function_return( $time, $args );

to this:

echo apply_filters('template_time', _bb_time_function_return( $time, $args ));

and then change the line in the plugin further up to this:

add_filter('template_time', 'freshness_latestlink', 101);

taking out the // that comment it out. Also, I’m not sure what topic_class*() is?

But yeah, don’t modify the core. Much better to stick to the template change from above.

[fel64]

Ooh. Probably. Nice idea.

<?php

/*

Plugin Name: Freshlink

Description: Turns freshness into a link to the latest post

Author: tisme, fel64

*/

function freshness_latestlink( $fresh ) {

global $topic;

$felgtlpl = get_topic_last_post_link($topic->topic_id);

return "<a href='$felgtlpl'>$fresh</a>";

}



//add_filter('', 'freshness_latestlink', 101);

?>

Unfortunately there doesn’t seem to be a filter for it – only for modifying the actual time, not the text output. Since topic_time() also directly writes to the HTML, you can’t modify it first. You have to change the template, from

<?php topic_time(); ?>

to

<?php echo freshness_latestlink( get_topic_time() ); ?>

[fel64]

> I guess ‘>’ in front of every _paragraph_.

It’s still annoying somewhat annoying . I don’t want to have to scroll through a wall of text looking for new paragraphs. Perhaps >>Quote …. << ? What would also be interesting is the ability to add the name of who you’re quoting. Name>>Quote<< or “Name blah”>>Quote<<? Although that’s starting to get a bit artificial.

It is an option to make this plugin rewrite the posts as they’re being read, but I was worried about the extra server load (although it’s pretty light code) and it’s playing pretty badly with the Allow Images plugin.

I don’t want to keep hosting it on my server, so I’ll take this down the next time I think about it. http://www.loinhead.net/files/felise

http://www.loinhead.net/files/felise.php is a working, non-bb copy of the script so you can test it (note that >>Name[post#] doesn’t work). Ignore the sucky name, I hate naming things and needed something just temporarily

[fel64]

I wrote a plugin to do that. Just upload and activate this.

<?php

/*

Plugin Name: Page &raquo;

Plugin URI:

Description: Adds &raquo; to the end of topic titles, linking to latest post.

Author: fel64

Version: 0.7

Author URI: http://www.loinhead.net/

*/



if (!function_exists('is_tags')) {

function is_tags()

{

return is_tag();

}

}



if (is_front() || is_forum() || is_tags()) {

add_filter('topic_title', 'fel_addlatestlink', 101);

}



function fel_addlatestlink($title)

{

global $topic;

$felgtlpl = get_topic_last_post_link($topic->topic_id);

$title = $title . ' <a href="' . $felgtlpl . '">&nbsp;&raquo;&nbsp;</a>';



return $title;

}

?>

[tisme]

+1 for wider (800px) template.

also, default “Reply” input textarea is too small (get scrolled) and

‘background: url(images/bg.png) #ccc fixed center top;’ makes it somewhat slow.

so far, wp.com forums layout by the Matt Thomas is the best layout of all bb forums I had a chance to see.

nice addition would be to have a link to the “Latest Post” on the front page/forum posts index table — it’s a matter of just a couple of lines to be added to the front-page.php/forum.php — makes a big deal to quickly get on a last post of multi-page posts w/o having to redundantly load a 1st page of the thread.

[Sam Bauers]

Now available in the “Extend” area.

http://bbpress.org/plugins/topic/57

This plugin adds a plugin browser to the administration area of bbPress. Using this browser you can view the latest versions of the plugins available via the official bbPress plugin repository, you can install them and also upgrade them when new versions become available.

Neat-o!

This plugin used to be known as the super secret plugin

Note: the plugin only manages plugins that it has installed, it won’t magically find all your existing plugins. However, re-installing is a trivial exercise through the browser.

[ihatestarbucks]

After over 5000 posts and 3 million unique visitors, I’ve finally made it professional. (or at least one step closer) ihatestarbucks.com is now running bbpress! feel free to drop in and vent your spleen or share your kudos.

[Ziyphr]

I’ve monitored bbPress for some time and plan to use WP for a big site and would need to convert a phpBB(2) forum over to bbPress. What’s the latest on:

1) WP integration – last I heard you had to fiddle with cookie settings and some usernames wouldn’t work on the forum login. I’d be wary of using plugins as this could cause problems upgrading in future.

2) phpBB(2) conversion – is there any script that will convert everything perfectly?

3) future plans – is there a new version in development or is everything on hold for now? (i.e. should I just go and install the current version or wait another month or two)

4) private forums – an essential feature for me is to have a staff board that is 100% secure. Again I didn’t really want to rely on a plugin for this and last time I think I read it wasn’t secure because of an RSS problem.

5) lastly – is bbPress compatibility high on the list when new versions of WordPress are released? (i.e. could a new WP break by forum?)

Cheers.

[kjted]

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.

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).

[fel64]

It is funkin’ brilliant. I hope you downloaded the latest release ( https://trac.bbpress.org/browser/trunk, at the bottom of the page is the Zip Archive link to the latest) because it has a bunch of fixes and changes.

Can you detail anything you had to do to make it work, for future people who want to do this stuff?

[fel64]

YES! The newest version is ALWAYS really new. REALLY new. There is NEVER a situation where you shouldn’t upgrade.

You have a problem and you’re not running the latest version. What do you do? Go upgrade.

You don’t have a problem. You’re not running the latest version. What do you do? GO UPGRADE.

Upgrading might not even fix this problem, it’s not sure. But it does fix several security exploits and adds a bunch of featurs. Go upgrade!

What’s worst is that you’re on a support forum asking for help and you’re not even on the latest version. You clearly haven’t tried everything before making other people take time to help you. Then you’re advised to upgrade … GO UPGRADE already.

If I wasn’t clear … GO UPGRADE

[_ck_]

If you can access rss xml from flash (which I believe you can) just grab it from the rss feed (/forum/rss.php). You can tell the rss to send you almost anything you want, latest, specific sub-forums, etc.