bbSync
-
This is a WordPress plugin. It will not work as a plugin in bbPress. WordPress and bbPress must be integrated.
bbSync will integrate WordPress and bbPress pretty thoroughly. Any posts made on the blog will create a new topic on the forums (this supports slugs and anything else that will come). Any replies made to the topic in the forums can be shown under the WP post with <?php felbbreplies(); ?>, and it will show people’s avatars if you use Louisedade’s avatar upload plugin.
You can migrate the old synchronisation from bbPress Post and delete the unnecessary tables (this plugin keeps its data in topicmeta, with the key
wp_posts).Hoping to add stuff later, either when I want it myself or when other people want it. I want feedback if you have it! I eat my own dog food and I’m finding it delicious. Will upload as official plugin when I get access.
bbPress Post and this plugin should not be running at the same time, otherwise you’ll get duplicate topics when you blog. If you get some error about a
call to member function of a non-object, there’s a good chance adding this in the middle of your bbPress’ config.php file will help:global $bbdb;This plugin does need configuring to do anything useful. Head to Options > bbSync and fill things in please.
-
I put this in my template:
<?php if($topic_id = felwptobb( $id ) ) { echo '<a href="' . bbreplylink( $topic_id ) . '">Reply!</a>'; } else { comments_popup_link(' comments', '1 comment', '% comments','',''); } ?>Not at all, it’s a perfectly reasonably question.
fel: ok.. to bad .. im trying figure out the relationships in the DB , seems complex. Why isnt there a wp_tags table?
Will you implement it? or should i try do some coding myself?
Yess .. i did it..
Wrote some lines that gets a posts TAGS .. how do i proceed ?
<?php
//
// Fetch a WP posts tags by Kent
//
$db_type = 'mysql';
$db_host = 'localhost';
$db_name = 'xxxxx';
$db_user = 'xxxxx';
$db_pass = 'xxxxx';
// Just picked one, for testing.
$post_id = "6";
@mysql_connect($db_host,$db_user,$db_pass) or die ("Couldnt connect to database!");
@mysql_select_db($db_name) or die ("Couldnt select the requested MySQL table!");
$fetch_post_tags = mysql_query("
SELECT
wp_posts.ID AS POID,
wp_term_relationships.object_id AS RELID,
wp_term_relationships.term_taxonomy_id AS TAXID,
wp_term_taxonomy.taxonomy AS TAXONO,
wp_term_taxonomy.term_id AS TAX_TERID,
wp_terms.term_id AS TERID,
wp_terms.name AS HOT_TAG_NAME
FROM
wp_posts,
wp_term_relationships,
wp_term_taxonomy,
wp_terms
WHERE
(wp_posts.ID = wp_term_relationships.object_id AND wp_posts.ID = '$post_id')
AND
(wp_term_taxonomy.taxonomy = 'post_tag' AND wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id)
AND
(wp_term_taxonomy.term_id = wp_terms.term_id)
ORDER BY wp_terms.name ASC
") or die ("Cant fetch data!");
if (mysql_num_rows($fetch_post_tags) > 0)
{
$rowid = 1;
echo "<table border="1">";
echo "<caption>WP posts tags</caption>";
echo "<tr style="background-color: #DDEAD5;">";
echo "<th scope="col">Post ID</th><th scope="col">Tag</th></tr>";
while ($blog = mysql_fetch_array($fetch_post_tags))
{
if ($rowid == 1)
{
echo "<tr><th scope="row">" . $blog['POID'] . "</th>";
}
else
{
echo "<tr><th scope="row"> </th>";
}
echo "<td>" . $blog['HOT_TAG_NAME'] . "</td></tr>";
$rowid++;
}
echo "</table>";
}
else
{
echo "Found nothing!";
}
?>Please dont kill me.. im no pro coder..
With the plugin deactivated the database still shows only the two comments and again without the comment_type field filled in.
Is their anything I could provide you with to help you help me
vafaaaan, take a look at the wpdb documentation. It’s mostly the same.
William, no, that’s cool. I’ve got a comment, found the same problem, and trying to figure out where my code is going wrong. But I appreciate all the help you’ve already given me
- The topic ‘bbSync’ is closed to new replies.
