Hack: bb replies as wp comments; using bb API?
-
Wanting to integrate bb and wp more, I hacked up wp’s
comments.phptemplate to get replies in the forum to show up below posts in the wp section of the site too.This currently requires the bbPress Post plugin.
Fairly simple job: find the corresponding topic, get the replies, and output them. My solution should work for you, too, if you have bbPress post installed and activated as a wp plugin. Code’s below.
I want to make it possible to reply to the topic from the wp section of the site if you’re logged in. Obviously I could make queries to insert the post into the database, but I’d like to use the bb API so it can be validated correctly, hooks are called etc. Not sure how I would go about making it accessible. Currently calling any bb functions returns the “undefined function” error; how can I make them available for use?
Paste this in front of the rest of your wp
comments.phptemplate:<?php
function felblogtotopicid( $felpostID ) {
global $table_prefix, $wpdb;
$posts_table = $table_prefix . "bbpress_post_posts";
$topic_id = $wpdb->get_var("SELECT topic_id FROM <code.>$posts_table</.code> WHERE <.code>post_id</.code> = $felpostID LIMIT 1;");
return $topic_id;
}
global $post, $wpdb;
if( $forumtopic = felblogtotopicid( $post->ID ) ) {
$bbprefix = get_option( 'wpbb_bbprefix' );
$replies = $wpdb->get_results( '
SELECT poster_id, post_text, post_time
FROM ' . $bbprefix . 'posts
WHERE topic_id = ' . $forumtopic
);
array_shift( $replies ); //takes off first entry, ie. starting post, and moves the rest back one
//$replies = array of object( poster_id, post_text, post_time ) for each post I think
echo "<ol>n"; //start of list
foreach( $replies as $reply ) {
$poster = get_userdata( $reply->poster_id );
$poster = $poster->user_login;
echo '<li class="thread">' . "n"
. '<div class="reply">' . "n"
. '<div class="poster">' . "n"
. "<strong>" . $poster . "</strong>n"
. "<span> @ " . $reply->post_time . "</span>n"
. "</div>n"
. '<div class="post">' . "n"
. $reply->post_text
. "</div>n"
. "</div>n"
. "</li>n";
}
echo "</ol>n"; //end of list
//$replylink = bb_add_replies_to_topic_link( $forumtopic );
$replylink = get_option( 'wpbb_path' );
echo '<h3><a href="' . $replylink . '">Reply!</a></h3>' . "n";
} else { ?>and paste this at the very back:
<?php } //end else conditional for corresponding topic to blogpost ?>Example here
-
Oh, bizarre. It must have edited it in somehow. Trent, could you take that out in case someone else comes along? My hour’s up.
Excellent!
Erm… hey guys, could you tell me what I’ve done wrong?
I’ve just installed “bbPress Post”, and WordPress is telling me there’s no table called “wp_bbpress_post_options” (which is true). I reckon I should solve this problem before hacking wp’s comments.php template… but how?
ps.: Oh, and you guys are doing a great job here, congratulations
You do need to use that table, but if you installed WP yourself it should also be created when you activate the plugin. Maybe de-activate and re-activate.
However I’m working on a plugin that will do the entire thing (complete integration hopefully) based on a different, IMO much neater system. I don’t want to promise anything before it’s done, but if this plugin doesn’t work for you there’ll be a simpler alternative soon.
De-activated, re-activated and it can’t even feed the database. I’m hacking it now, but I can’t figure the problem out at all… oh well, I’m going to ask the author for help, and I’m sure looking forward to seeing your plugin, fel64
Got a problem on my hands. I’m trying to simplify a lot of things by require’ing bb-load.php and then using the bb API. However bbdb loads with a fatal error if I do this when wordpress has fully loaded, but it works perfectly fine if I require bb-load when the plugin is run.
What I mean is
require( 'path/to/bb-load.php' )works fine if placed anywhere inside the main code of the plugin. If I call it using the wp hookinitit no longer works, nor does calling it by other hooks (that I’ve tried) or through function calls in templates and the like.I went through
wp-settings.phpand require’d bb-load systematically until I found that it only worked once wordpress had loadedgeneral-template.php(line 153). It worked from any point onwards, including afterdo_action('init');(which I don’t understand at all). Using theinithook in my plugin to require it does not work.I suspect this means that the
inithook in wordpress maybe does something or other, then loads plugins, then does something else that stops bb being included, then runs any other funtions registered with the init hook – but my wp mojo is not impressive. I tested this with all other plugins deactivated.The output if bb-load is required too late in the code:
Fatal error: Call to a member function get_row() on a non-object in
xampphtdocsforumsbb-includesfunctions.php on line 1224That makes me think bbdb is not created, but I can’t see why it wouldn’t be.
Can someone help me with this please? I’d much rather use the API than duplicate functions.
Trent, do you think you could point this topic out to one of those people with mighty WP/bb mojo? Just a gentle pointing out or something. Nothing pushy.
You must be logged in to reply to this topic.
