vb.org Archive - vBulletin-WordPress Bridge

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - vBulletin-WordPress Bridge (https://vborg.vbsupport.ru/showthread.php?t=94443)

vBulletin-WordPress Bridge

I have been looking around for a WordPress - vBulletin plug-in and can?t seem to find one. I had time today to look at the WordPress code and tried out some things, and came up with a small hack for a bridge.

This bridge will let you use vBulletin as the main comments area for the blog entry. A copy of the intro blog entry is automatically created in a specific forum you choose, as well as a link back to the original blog entry from the forum. The blog entry will also show the total comments made.

Let me first say that I don?t have any experience in creating plug-ins for WordPress so please don?t ask me to convert this to one. If you plan to make this as an official plug-in or improve on it, please make sure to let me know so I can place a link on this article to yours.

Thanks and I hope you all enjoy it.

Note:

This hack will only work if your WordPress and vBulletin tables are in a single database.
This hack has only been tested on adding entries directly from the admin panel. It has not been tested on xmlrpc clients.
Use at your own risk. I will not be held liable for any loss of data nor problems that you might encounter on your site during the whole process of the mod.Backup your files and database(s) before proceeding.

Database Changes:

I have added a new column in WordPress? posts table to maintian the vBulletin thread id that will be automatically generated for the blog entry. Note that the table name prefix might be different from your WordPress table settings:

Code:

ALTER TABLE `wp_posts` ADD `vb_threadid` INT(10);

Files to Upload:

Save the following as vb3?settings.php and upload it to the Wordpress wp-includes folder:

Code:

<?php

// This just holds the vb variables

$vb_bridge = 1; // 1=on 0=off

$vb_forumid = '2'; // forum id to post copy of article

$vb_userid = '1'; // user id to use for posting the article

$vb_username = 'admin'; // name of the user id

$vb_path = 'http://www.yoursite.com/forum'; //complete url of forums

$vb_dbprefix = 'vb3_'; //vBulletin database prefix

$vb_readmessage = 'Read the full blog entry.'; //message to be used in the forum to link back to the blog entry

?>

$vb_forumid - is the forum id of the blog discussion forum. Usually, this is the ?News? or ?Blog? forum. I advice to to set the permission of this forum to not allow ?New Posts? but allow ?New Replies.? To get the id of the forum, on your vBulletin forums page, click on the forum that you want to assign and check the URL at the address bar. It will appear like ?..forumdisplay.php?f=x? where x is the forum id.
$vb_userid - is the user id you want to assign as the one who will automatically create a new thread in the forum you have chosen.To get the user id, go to your forum?s Member List and click on the member you would like to assign. The URL will appear like ?member.php?u=x? where x is the user id.
$vb_username - is the corresponding username of the user id. Rather than generating a new SQL query to get the username, it is better to just assign the name to this variable.
$vb_path - this is the actual URL of your site?s forum. Note that there is no trailing slash.
$vb_dbprefix - if you specified a table prefix when you installed vBulletin, enter it here.
$vb_dbprefix - This message will appear at the end of the vBulletin post that links back to the blog entry.

Added in v1.1: In the attached files at the right, download postfeed.php and upload it to the root folder of your vB forums (it should be in the same folder where external.php is).

Files to be Modified:

Here comes the slightly harder part. We need to modify some WordPress files. Part of the changes assume that you are using the Kubrick default theme. If you are using a different theme, change the corresponding files accordingly.

wp-includes/comment-functions.php

Replace:

Code:

function get_comments_number( $comment_id ) {

 global $wpdb, $comment_count_cache;

 $comment_id = (int) $comment_id;

 if (!isset($comment_count_cache[$comment_id]))

  $comment_count_cache[$comment_id] =  $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->comments WHERE comment_post_ID = '$comment_id' AND comment_approved = '1'");

 

 return apply_filters('get_comments_number', $comment_count_cache[$comment_id]);

}

With:

Code:

function get_comments_number( $comment_id ) {

 global $wpdb, $comment_count_cache;

  include (ABSPATH . WPINC . '/vb3-settings.php');



 $comment_id = (int) $comment_id;

  if (!isset($comment_count_cache[$comment_id])) {

  if ($vb_bridge){

   $vb_threadid = $wpdb->get_var("SELECT vb_threadid FROM $wpdb->comments WHERE id = '$comment_id'");

   $comment_count_cache[$comment_id] = $wpdb->get_var("SELECT count(*)-1 FROM {$vb_dbprefix}post WHERE threadid = '$vb_threadid'");

  } else {

   $comment_count_cache[$comment_id] = $wpdb->get_var("SELECT COUNT(*) FROM $wpdb->comments WHERE comment_post_ID = '$comment_id' AND comment_approved = '1'");

  }

 }

 return apply_filters('get_comments_number', $comment_count_cache[$comment_id]);

}

Below:

Code:

function comments_popup_link($zero='No Comments', $one='1 Comment', $more='% Comments', $CSSclass='', $none='Comments Off') {

    global $id, $wpcommentspopupfile, $wpcommentsjavascript, $post, $wpdb;

    global $comment_count_cache;

Add:

Code:

    include (ABSPATH . WPINC . '/vb3-settings.php');



 if ($vb_bridge){

  $vb_threadid = $post->vb_threadid;

  if ($vb_threadid == "") {

         echo $none;

         return;

  } else {

   $comment_count_cache[$id] = $wpdb->get_var("SELECT count(*)-1 FROM {$vb_dbprefix}post WHERE threadid = '$vb_threadid'");

  } 

  $number = $comment_count_cache[$id];

  echo '<a  href="'.$vb_path.'/showthread.php?t=' . $vb_threadid .'&goto=newpost">';

   comments_number($zero, $one, $more, $number);

   echo '</a>'; 

   return;

 }

Save file.

Added in v1.1: wp-includes/feed-functions.php

Replace:

Code:

function comments_rss_link($link_text = 'Comments RSS', $commentsrssfilename = '') {

        $url = comments_rss($commentsrssfilename);

        echo "<a href='$url'>$link_text</a>";

}

With:

Code:

function comments_rss_link($link_text = 'Comments RSS', $commentsrssfilename = '') {

        global $post;

        include_once (ABSPATH . WPINC . '/vb3-settings.php');

        if ($vb_bridge){

                $url = $vb_path . '/postfeed.php?t=' . $post->vb_threadid . '&type=rss2';

        } else {                

                $url = comments_rss($commentsrssfilename);

        }

        echo "<a href='$url'>$link_text</a>";

}

Save file.

wp-admin/post.php

Below:

Code:

require_once('admin.php');

Add:

Code:

include_once (ABSPATH . WPINC . '/vb3-settings.php');

Below:

Code:

$result = $wpdb->query($postquery);

Modified in v1.2: Add:

Code:

        // VB Bridge Start

                if ($vb_bridge) {

                        if ($post_title == "") {

                                return;

                        }



                        $saveid = $vb_userid;

                        $savename = $vb_username;



                        $author_name = $wpdb->get_var("SELECT `user_login` FROM $wpdb->users WHERE `id` = '$post_author'"); 

                        

                        if ($author_name != ""){

                                $vb_authorid = $wpdb->get_var("SELECT `userid` FROM " . $vb_dbprefix . "user WHERE `username` = '$author_name'");

                                if ($vb_authorid != ""){

                                        $saveid = $vb_authorid;

                                        $savename = $author_name;

                                }

                        }

                        $curtime = time();

                        $sql = "INSERT INTO `{$vb_dbprefix}thread` 

                                        SET `title`='{$post_title}',`lastpost`='{$curtime}', `forumid`='{$vb_forumid}', `open`='1', `postusername`='{$savename}', `postuserid`='{$saveid}', `lastposter`='{$savename}', `dateline`='{$curtime}', `visible`='1'";

                        $vbresult = $wpdb->query($sql);

                        $vb_threadid = $wpdb->insert_id;

                        

                        if ($excerpt == ""){

                                $moreflag = strpos($content,'<!--more-->');

                                if ($moreflag === false) {

                                        $introtext = $content;

                                } else {

                                        $introtext = substr($content, 0, $moreflag);

                                } 

                                $bbcontent = '[quote'.']'.strip_tags($introtext).'['.'/quote]';

                        } else {

                                $bbcontent = '[quote'.']'.strip_tags($excerpt).'['.'/quote]';

                        }

                        $bbcontent .= '[URL='.get_permalink($post_ID).']['.'b]'.$vb_readmessage.'['.'/b]['.'/URL]';                                

                        $sql = "INSERT INTO `{$vb_dbprefix}post` 

                                        SET `threadid`='{$vb_threadid}', `username`='{$savename}', `userid`='{$saveid}', `title`='{$post_title}', `pagetext`='{$bbcontent}', `ipaddress`='{$REMOTE_ADDR}', `allowsmilie`='1', `iconid`='1',`visible`='1', `dateline`='{$curtime}'";

                        $vbresult = $wpdb->query($sql);

                

                        $sql = "UPDATE `{$vb_dbprefix}forum` SET `threadcount`=`threadcount`+1, `lastpost`='{$curtime}', `lastposter`='{$savename}', `lastthread`='{$post_title}', `lastthreadid`='{$vb_threadid}', `lasticonid`='1' WHERE `forumid`='{$vb_forumid}' LIMIT 1";

                        $vbresult = $wpdb->query($sql);

                

                  $sql = "UPDATE $wpdb->posts SET `vb_threadid`={$vb_threadid} WHERE `ID`='{$post_ID}'";

                        $vbresult = $wpdb->query($sql);

                }        

        // VB Bridge End

Save file.

If you are using the Kubrick default theme, open wp-content/themes/default/comments.php

Replace contents with:

Code:

<?php // Do not delete these lines

 if ('comments.php' == basename($_SERVER['SCRIPT_FILENAME']))

  die ('Please do not load this page directly. Thanks!'); 



        if (!empty($post->post_password)) { // if there's a password

            if ($_COOKIE['wp-postpass_' . COOKIEHASH] != $post->post_password) {  // and it doesn't match the cookie

    ?>

    

    <p class="nocomments">This post is password protected. Enter the password to view comments.<p>

    

    <?php

    return;

            }

        }



  /* This variable is for alternating comment background */

  $oddcomment = 'alt';

?>



<!-- You can start editing here. -->

<p class="postmetadata">Discuss: <?php comments_popup_link('No Comments ?', '1 Comment ?', '% Comments ?'); ?></p>

Save File.

If you are using the Kubrick default theme, open wp-content/themes/default/single.php

Replace:

Code:

       You can <a href="#respond">leave a response</a>, or <a href="<?php trackback_url(true); ?>" rel="trackback">trackback</a> from your own site.

With (note that you are adding the path of the forum):

Code:

       You can <a href="/forum/showthread.php?t=<?php echo( $post->vb_threadid ); ?>&goto=newpost">leave a response</a>, or <a href="<?php trackback_url(true); ?>" rel="trackback">trackback</a> from your own site.

Save file.

If you are using the Kubrick default theme, open wp-content/themes/default/footer.php

Replace:

Code:

and <a href="feed:<?php bloginfo('comments_rss2_url'); ?>">Comments (RSS)</a>.

With:

Code:

Save file.

Lastly, open wp-rss2.php

Replace:

Code:

<wfw:commentRSS><?php echo comments_rss(); ?></wfw:commentRSS>

With (note that you are specifying the complete URL of the forum here):

Code:

<wfw:commentRSS>http://www.yoursite.com/forum/showthread.php?t=<?php echo $post->vb_threadid; ?></wfw:commentRSS>

Save file.

vBulletin Settings:

The RSS feed will not work if you haven't activated RSS External synidcation on your forum. To do this, on your forums admincp, go to vBulletin Options->External Data Provider and check 'Yes' on Enable RSS Syncidcation.

Final Words:

Well, that?s about it! I?m not sure how often I can visit this thread but I hope those who find success in implementing the bridge, can help those who are having problems. Again, if you have suggestions on improving the script, let me know.

Thanks and happy modding! :D

Live Demo: http://www.internettablettalk.com/blog/

Revision History:

v1.2 (12/7/2005):
Uses correct vB user id and user name of the blog author. This will work only if the username of the Wordpress user is exactly the same as the vB username. If not, it uses $vb_userid and $vb_username defined in the settings.

v1.1 (8/19/2005):
Revisions are based on reports by Darth Gill (see discussion). New version includes vB RSS thread parser and a bug fix on vB not displaying recently added blog entry on the forum level. Current revisions are marked in green.

Changes:

Added file to upload: postfeed.php (see Files to Upload section)
New file to modify: wp-includes/feed-functions.php
Fixed reported latest thread bug in wp-admin/post.php. Apply changes in green.

Screenshots:

awesome awesome awesome
Been waiting for something like this... will install later :)

This is really cool stuff, thank you for the hard work and I will talk to my friend who asked me for such a thing to see if this is what he is looking for.

Can this be made for 3.5?

I haven't tried it but it should work. There are no vB code changes in the hack. Changes are all done on the side of WordPress.

really cool- thanks for sharing all of your work! :D

I love it! I have it installed. This is exactly what I was looking for!!!! VERY GOOD. Now you need to make it better! Works great with 3.5. :D

Either Convert HTML into VBCODE or insert it as HTML

OR

Have an option in the plugin to insert into vbulletin only a snippet of the original post - that way forum users are forced to go to the blog.

Quote:

Originally Posted by Darth Gill

Either Convert HTML into VBCODE or insert it as HTML

Yes, I actually too the easy way out and remove the html formatting using a php function. I was actually looking for a good, smart html to bbcode script, but I can't find one. Anyone know how vBulletin does it?

Thanks.

I modified the code to put just 150 chars into the forum as a snippet. You also need to parse out   and " > <, etc... because the strip html function in php doesn't handle this. Just do a ireg_replace('"','\"','string) or something like that....

Brandan

Brandan,

The code right now actually looks for the  tag and only copies the text beofre it. I thought that's a good way to quote the entry.

If you want to add a limit, you can probably add a new variable at vb-settings.php so you can increase/decrease the limit easily.

Thanks.

Thanks rsupido, I changed it back (to use the  tag ... I've noticed a few bugs that could use correction. First of all, when I create a blog entry, it doesn't seem to be making the new thread properly so that it shows up on forum home. (as the latest thread in that forum) and the icon is missing on the forum listing. It only shows up if you edit the thread manually.

Second, the rss feed doesn't display the comments for me properly...

See example:

Regular blog entry: http://blog.5solas.org/2005/08/18/th...rist-has-done/
Feed: http://blog.5solas.org/2005/08/18/th...has-done/feed/

Now I have some comments for this post, but they're not in this feed. Any ideas?

Thanks for a great product!

Wow! Wow! Wow! Wow! Wow! Just plain Wow! :)

I am gonna try and install it on my 3.5 site! Thanks a lot sir! :)

Quote:

Originally Posted by Darth Gill

First of all, when I create a blog entry, it doesn't seem to be making the new thread properly so that it shows up on forum home. (as the latest thread in that forum) and the icon is missing on the forum listing. It only shows up if you edit the thread manually.

I'm not sure I understand the problem. Can you elaborate more on this?

Quote:

Second, the rss feed doesn't display the comments for me properly...

vB doesn't have an RSS parser for posts in a thread, only for recent threads. I'll try to create a thread parser and then revise the WordPress thread RSS link to point to the vB RSS thread parser.

Quote:

Originally Posted by rsuplido

I'm not sure I understand the problem. Can you elaborate more on this?

Yeah, see attached pictures....

In the first one (forumhome), you can see that the latest thread in the forum isn't showing up in the display. In the second one, (5solas.org Blog Listing), you can see that the icon is missing in the display. I think maybe you need to do TWO inserts into vbulletin - one for thread and one for the post - but I may be mistaken.

You can see the forum listing at : http://forums.5solas.org/forumdisplay.php?f=29

Quote:

Originally Posted by resuplido

vB doesn't have an RSS parser for posts in a thread, only for recent threads. I'll try to create a thread parser and then revise the WordPress thread RSS link to point to the vB RSS thread parser.

Sounds good to me! Wow! That would be awesome!

I see what you mean. I'll try to look into it.

New version is now up!

v1.1 (8/19/2005):
Revisions are based on reports by Darth Gill (see discussion). New version includes vB RSS thread parser and a bug fix on vB not displaying recently added blog entry on the forum level. Current revisions are marked in green.

Changes:

Added file to upload: postfeed.php (see Files to Upload section)
New file to modify: wp-includes/feed-functions.php
Fixed reported latest thread bug in wp-admin/post.php. Apply changes in green.

Enjoy.

Wow, thanks for the quick FIX! I've updated my blog, now will the rss fix old blog entries or only new ones... cause I'm not seeing the fix in the older entries....

http://blog.5solas.org/2005/08/18/th...has-done/feed/

You have an error in one of your insert statements into vbulletin... Take out the extra spaces in front of allowsmilies...

Found another bug... See screenshot. First of all the post icon is still not showing up... And second, there are now { BRACKETS } around the poster name...

vB has a bug somewhere that puts spaces in the code tags for really long strings. :(
Please apply the modified change for wp-admin/post.php again Brandan.

The RSS feed will only work on the new ones, sorry. I'll try to look for a work around though.

the new rss feed isn't working for me...

I have posted a test comment, and it didn't work...

Sort of an off-topic question, but if anyone knows the answer, I think it's you.

Can Wordpress integrate with Vbulletin so that the only members who can post articles/leave comments are those that are registered to the forum? Is there already a mod for this?

Yes, this mod only allows the vB registered members to post comments.

Quote:

Originally Posted by rsuplido

Yes, this mod only allows the vB registered members to post comments.

I got this problem:
Warning: main(): Failed opening '' for inclusion (include_path='.:/usr/local/lib/php') in /homepages/28/d109317046/htdocs/xp9/blog/wp-admin/post.php on line 4
And the code from line 1-20 in wp-admin/post.php is

PHP Code:


		
			
<?php

require_once('admin.php');

include_once (ABSPATH . WPINC . '/vb3-settings.php')>

$wpvarstoreset = array('action', 'safe_mode', 'withcomments', 'posts', 'content', 'edited_post_title', 'comment_error', 'profile', 'trackback_url', 'excerpt', 'showcomments', 'commentstart', 'commentend', 'commentorder' );



for ($i=0; $i<count($wpvarstoreset); $i += 1) {

    $wpvar = $wpvarstoreset[$i];

    if (!isset($$wpvar)) {

        if (empty($_POST["$wpvar"])) {

            if (empty($_GET["$wpvar"])) {

                $$wpvar = '';

            } else {

            $$wpvar = $_GET["$wpvar"];

            }

        } else {

            $$wpvar = $_POST["$wpvar"];

        }

    }

}

ok i fixed it its cause the code wasnt right on your site(but it was right here) now when i write something and hit publish it says

PHP Code:


		
			
WordPress database error: [Table 'db122318734.vb3_thread' doesn't exist]

INSERT INTO `vb3_thread` SET `title`='test message',`lastpost`='1124555524', `forumid`='24', `open`='1', `postusername`='blogger', `postuserid`='35', `lastposter`='blogger', `dateline`='1124555524', `visible`='1'



WordPress database error: [Table 'db122318734.vb3_post' doesn't exist]

INSERT INTO `vb3_post` SET `threadid`='8', `username`='blogger', `userid`='35', `title`='test message', `pagetext`='[quote]This is a test for the vbulletin bridge[/quote][URL=http://www.cyberxp9.net/blog/?p=8][b]Read the complete blog entry.[/b][/URL]', `ipaddress`='69.177.28.85', `allowsmilie`='1', `iconid`='1',`visible`='1', `dateline`='1124555524'



WordPress database error: [Table 'db122318734.vb3_forum' doesn't exist]

UPDATE `vb3_forum` SET `threadcount`=`threadcount`+1, `lastpost`='1124555524', `lastposter`='blogger', `lastthread`='test message', `lastthreadid`='8', `lasticonid`='1' WHERE `forumid`='24' LIMIT 1



Warning: Cannot modify header information - headers already sent by (output started at /homepages/28/d109317046/htdocs/xp9/blog/wp-includes/wp-db.php:98) in /homepages/28/d109317046/htdocs/xp9/blog/wp-admin/post.php on line 199

---------------------------------------------------
please answer I see your viewing this thread :nervous:

What's the prefix of your vB tables? Is it vb3? You need to indicate that in the vb3settings.php.

Quote:

Originally Posted by rsuplido

What's the prefix of your vB tables? Is it vb3? You need to indicate that in the vb3?settings.php.

I dont know, how do you find out (in phpmyadmin?)

Quote:

Originally Posted by cyberxp9

---------------------------------------------------
please answer I see your viewing this thread :nervous:

is it possible for me to have no prefix? and If i do how do i edit the settings

Quote:

Originally Posted by cyberxp9

is it possible for me to have no prefix? and If i do how do i edit the settings

sorry i fixed it, exellent hack dude :)

The best way is to open the config.php file in your <forum root folder>/includes. Somewhere in line 90, check what it says as the value of the "$tableprefix: variable. Copy that value in the "$vb_dbprefix" in vb3settings.php.

Quote:

Originally Posted by rsuplido

yah read my before post, exellent hack, I just removed the thing inside the ' ' in the settings and it worked (guess I had no prefix)

rsuplido, my blog still isn't parsing through comments in the rss feeds.... Any ideas why? I double checked everything, and it all looks good.... This is driving me crazy. Everything else is working great now though!

P.S. - I won't be around until Friday of next week to help debug this wonderful hack.

Brandan

Brandan,

I think the postfeed.php file isn't working since you are using vb3.5. I'm attaching a file for you. Rename it to postfeed.php and upload it to the root folder of your forums.

That didn't work for me. Thanks for your effort though... :)

Sorry, it's a more of a trial-and-error for me since I'm not using v3.5. I have attached a new file. Please rename to postfeed.php and upload to your forum root folder.

Also, it seems like you didn't make the change on the wp-includes/feed-functions.php file. Please check.

Aha, I fixed it! I took out the AND $vboptions['externalrss'] out of the conditionals... Thanks! See attached... I'll be back next Friday...

Brandan

That means you haven't activated external RSS in your vB settings (in vB options). Also, it seems like the domain field and URL in the RSS lacks your forum's complete path.

Actually, I did have external RSS activated and I did have the domain field filled out in my VB Options. I noticed it wasn't reading anything out of vboptions it seems! :) I replaced $vboptions[bburl] with http://forums.5solas.org... Thanks for pointing that out. - Brandan

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01943 seconds Memory Usage 1,915KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (19)bbcode_code_printable (2)bbcode_php_printable (10)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: