vBulletin-WordPress Bridge [Archive]

View Full Version : vBulletin-WordPress Bridge

rsuplido

08-15-2005, 10:00 PM

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:

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:

<?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:

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:

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:

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:

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:

function comments_rss_link($link_text = 'Comments RSS', $commentsrssfilename = '') {
$url = comments_rss($commentsrssfilename);
echo "<a href='$url'>$link_text</a>";
}

With:

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:

require_once('admin.php');

Add:

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

Below:

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

Modified in v1.2: Add:

// 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,'');
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 .= '['.'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:

<?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
?>

This post is password protected. Enter the password to view comments.

<?php
return;
}
}

/* This variable is for alternating comment background */
$oddcomment = 'alt';
?>


Discuss: <?php comments_popup_link('No Comments ?', '1 Comment ?', '% Comments ?'); ?>
Save File.

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

Replace:

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

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:

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

With:


Save file.

Lastly, open wp-rss2.php

Replace:

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

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

<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: [url]http://www.internettablettalk.com/blog/ ('.get_permalink($post_ID).')

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:

BigIke

08-16-2005, 05:50 PM

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

Floris

08-16-2005, 07:00 PM

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.

Darth Gill

08-16-2005, 09:50 PM

Can this be made for 3.5?

rsuplido

08-16-2005, 10:00 PM

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.

yoyoyoyo

08-16-2005, 10:36 PM

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

Darth Gill

08-17-2005, 03:20 AM

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.

rsuplido

08-17-2005, 11:26 AM

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.

Darth Gill

08-17-2005, 01:02 PM

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

rsuplido

08-17-2005, 01:07 PM

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.

Darth Gill

08-18-2005, 10:26 PM

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/the-gospel-is-about-what-christ-has-done/
Feed: http://blog.5solas.org/2005/08/18/the-gospel-is-about-what-christ-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!

Lord Brar

08-19-2005, 11:45 AM

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

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

rsuplido

08-19-2005, 12:51 PM

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?

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.

Darth Gill

08-19-2005, 01:24 PM

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

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!

rsuplido

08-19-2005, 01:29 PM

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

rsuplido

08-19-2005, 04:12 PM

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.

Darth Gill

08-19-2005, 04:38 PM

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/the-gospel-is-about-what-christ-has-done/feed/

Darth Gill

08-19-2005, 05:54 PM

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

Darth Gill

08-19-2005, 06:56 PM

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

rsuplido

08-19-2005, 07:37 PM

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.

Darth Gill

08-19-2005, 10:32 PM

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

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

OrangeFlea

08-20-2005, 12:01 PM

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?

rsuplido

08-20-2005, 12:13 PM

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

cyberxp9

08-20-2005, 03:25 PM

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
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"];
}
}
}

cyberxp9

08-20-2005, 03:34 PM

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

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`='This is a test for the vbulletin bridgeRead the complete blog entry. (http://www.cyberxp9.net/blog/?p=8)', `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

cyberxp9

08-20-2005, 04:09 PM

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

rsuplido

08-20-2005, 04:16 PM

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

cyberxp9

08-20-2005, 04:23 PM

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

cyberxp9

08-20-2005, 04:25 PM

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

cyberxp9

08-20-2005, 04:27 PM

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

rsuplido

08-20-2005, 04:31 PM

cyberxp9

08-20-2005, 04:32 PM

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 vb3?settings.php.

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)

Darth Gill

08-20-2005, 11:49 PM

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

rsuplido

08-21-2005, 01:01 AM

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.

Darth Gill

08-21-2005, 03:09 AM

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

rsuplido

08-21-2005, 03:19 AM

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.

Darth Gill

08-21-2005, 09:03 PM

Didn't work... http://forums.5solas.org/postfeed.php?t=2529&type=rss2

Darth Gill

08-21-2005, 09:26 PM

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

rsuplido

08-22-2005, 12:14 AM

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.

Darth Gill

08-22-2005, 01:18 AM

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

thenetbox

08-22-2005, 12:20 PM

Thank you! I'm going to try this with 3.5 :D

cyberxp9

08-22-2005, 12:32 PM

still need help

rsuplido

08-22-2005, 01:27 PM

still need help
Looking at your site, it seems like it's running pretty well. If you look at this test entry:
http://www.cyberxp9.net/blog/?p=15
and click on the "RSS 2.0" link, it tries to run postfeed.php which is correct.

I think the problem on your part is you haven't activated RSS on your forums. To activate it, on your forums admincp, go to vBulletin Options->External Data Provider and check 'Yes' on Enable RSS Syncidcation. That should fix it.

cyberxp9

08-22-2005, 01:45 PM

Looking at your site, it seems like it's running pretty well. If you look at this test entry:
http://www.cyberxp9.net/blog/?p=15
and click on the "RSS 2.0" link, it tries to run postfeed.php which is correct.

I think the problem on your part is you haven't activated RSS on your forums. To activate it, on your forums admincp, go to vBulletin Options->External Data Provider and check 'Yes' on Enable RSS Syncidcation. That should fix it.

still a problem, do you know whats wrong with the rss on wordpress? Try clicking the Entries (RSS) part on the bottom of my blog. Was that updated postfeed that you posted for some other guy only meant for vb 3.50? Or should I get it?

rsuplido

08-22-2005, 01:49 PM

OrangeFlea

08-22-2005, 02:39 PM

Let me ask this regarding the vBulletin integration:

If someone wanted for the comments to be posted exclusively by forum members within the blog itself and not the forum, is that possible? Just like how Sitepoint.com has it, in where members of the message board could post comments inside the blog article and not on the forum.

rsuplido

08-22-2005, 02:46 PM

It seems like you are asking for an integration of the user database. That would be an entirely different hack. This hack aims to have users not register via WordPress at all and just use vBulletin as the main user database. Only the authors are intended to be registered in Wordpress.

I thought that having just one database will be more efficient. Also, a lot of 3rd party commercial programs integrate best with vB, like PhotoPost, ReviewPost, Coppermine, Chat apps, etc.

OrangeFlea

08-22-2005, 03:47 PM

It seems like you are asking for an integration of the user database. That would be an entirely different hack. This hack aims to have users not register via WordPress at all and just use vBulletin as the main user database. Only the authors are intended to be registered in Wordpress.

No, I think you misunderstand. I just want for the comments to appear under the blog article itself, not on a forum, like this: http://www.sitepoint.com/blogs/2005/08/21/state-of-ajax/#comments. Sitepoint uses Wordpress for their blog, by the way. Furthermore, I want the comments, which would be placed under the blog article, to be made by registered members of the vbulletin board.

rsuplido

08-22-2005, 04:01 PM

I can probably create an enhancement to list the comments made in vB. ;) If they want to add a comment, they have to do it in the forums though.

cyberxp9

08-23-2005, 03:27 PM

First, I see that your blog comments RSS is already working:
http://www.cyberxp9.net/forum/postfeed.php?t=170&type=rss2

For the Entries (RSS), no, the change should not have affected it. Actually it works. If you try: http://www.cyberxp9.net/blog/?feed=rss2 you should see the actuall RSS of your blog's entries.
weird dude, it must of took some time to activate hit, thanks a bunch :) xp9

cyberxp9

08-24-2005, 02:07 AM

is it a problem that if I access postfeed directly you get an error?
Database error in vBulletin 3.0.8:

Invalid SQL:
SELECT title
FROM thread
WHERE threadid =
AND visible = 1

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND visible = 1' at line 4

mysql error number: 1064

Date: Tuesday 23rd of August 2005 11:05:30 PM
Script: http://www.cyberxp9.net/forum/postfeed.php?

or get an error like this:
Database error in vBulletin 3.0.8:

Invalid SQL:
SELECT title
FROM thread
WHERE threadid =
AND visible = 1

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND visible = 1' at line 4

mysql error number: 1064

Date: Tuesday 23rd of August 2005 10:57:28 PM
Script: http://www.cyberxp9.net/forum/postfeed.php?t=&type=rss2
Referer:
IP Address: 69.177.28.85

rsuplido

08-24-2005, 03:04 AM

Yes, you need to specify the id of the thread:

..postfeed.php?t=x

where x is the thread id

cyberxp9

08-24-2005, 03:05 AM

Yes, you need to specify the id of the thread:

..postfeed.php?t=x

where x is the thread id

huh? I just change the url? than how come I get this thing
LINK REMOVED DUE TO RETARDS CLICKING ON IT SO I KEPT ON GETTING SENT ERROR EMAILS

rsuplido

08-24-2005, 02:31 PM

You would notice that Wordpress posts that weren't done through the bridge will not allow comments ("Comments Off"). I think you are clicking on those blog entries and thus getting the error. If you look at you latest blog entries, they run pretty well.

Spacefreak

08-28-2005, 03:57 AM

No, I think you misunderstand. I just want for the comments to appear under the blog article itself, not on a forum, like this: http://www.sitepoint.com/blogs/2005/08/21/state-of-ajax/#comments. Sitepoint uses Wordpress for their blog, by the way. Furthermore, I want the comments, which would be placed under the blog article, to be made by registered members of the vbulletin board.This is exactly what I am looking for as well: Comments appear on the blog (Wordpress) , yet utilizes the vBulletin user registration system.

http://www.macnn.com is another site that pulls it off.

Darth Gill

08-28-2005, 10:07 PM

Back from vacation, and I made this change so that I could make drafts and click the "advanced editing" button without creating a new thread. Basically, you should only create a new thread if you publish.

Find in wp-admin/post.php// VB Bridge Start
if ($vb_bridge) {
if ($post_title == "") {
return;
}

and replace it with // VB Bridge Start

if ($vb_bridge && $post_status=="publish") {

chanzero

08-29-2005, 06:14 PM

this is very cool. a couple questions though:

1) after the wp post is written and automatically generates the vb thread & post, am i correct in assuming that editing the wp post will not affect the vb thread/post? i think that would be good for when people rename the post or edit the post, etc

2) does anyone have any experience with wordpress MU (multi-user)? if so, would this hack be just as easy to apply to MU?

Cole2026

09-04-2005, 04:14 AM

sarahsboy18

09-04-2005, 05:04 PM

rsuplido

09-04-2005, 06:14 PM

Would it be possible to set it up so that when I set which forum the post is submitted to based on the post's category in WP?

I have no plans of incorporating that feature. Imagone if there are 100 categories. :( What you can do however is choose a hidden forum and then move the thread manually to to correct forum.

sarahsboy18

09-04-2005, 06:41 PM

I have no plans of incorporating that feature. Imagone if there are 100 categories. :( What you can do however is choose a hidden forum and then move the thread manually to to correct forum.

I understand...

For my particular needs I only have 3 categories and wouldn't have any trouble managing it. Basically what I have done so far is to make sure that my Forum IDs are the same as my Category IDs. What I am trying to do now is force the forumid variable to use submitted category variable instead of the vb3-settings.php forumid.

E.G (from the "post.php" file)

... WHERE `forumid`='{$post_category}' ...

However, I can't seem to figure out which variable is the correct one to pass in the above query. I have tried $post_category, $post_categories, $category_id... I just can't get it to pass... It keeps sending a "0"

Edit:

I did it!... Basically I just moved the hack code down below the category functions in the post.php left the variable as $post_category. And it's working great now. Thanks!

cyberxp9

09-05-2005, 06:17 PM

Would it be possible to set it up so that when I set which forum the post is submitted to based on the post's category in WP?

I have several major sections of my blog that I would like to keep seperated in my forums pages... E.G.

News Category Blog -> News Forum
Product Reviews Blog Category -> Product Reviews Forum

if i click here feed:http://www.cyberxp9.net/blog/?feed=rss2 (thats the link to subscribe to my feed for my blog) It says "feed is not a registered protocol" (in firefox)

rsuplido

09-05-2005, 06:20 PM

take out the "feed:" in the URL. Use this instead: http://www.cyberxp9.net/blog/?feed=rss2

Stachel

09-05-2005, 06:54 PM

Any links to demo blogs?

Darth Gill

09-05-2005, 06:55 PM

You can see mine. I have it integrated with 3.5 also! http://blog.5solas.org

Stachel

09-05-2005, 06:57 PM

Thank you Darth Gill !

cyberxp9

09-05-2005, 09:36 PM

if i click here feed:http://www.cyberxp9.net/blog/?feed=rss2 (thats the link to subscribe to my feed for my blog) It says "feed is not a registered protocol" (in firefox)

still doesnt work, it just shows the xml file :(

The Bad Astrono

09-05-2005, 11:05 PM

deb0

09-06-2005, 12:45 AM

Yeah, me too and I'm in the same situation as you Bad Astrono.

rsuplido

09-06-2005, 01:10 AM

The Bad Astrono

09-06-2005, 04:45 AM

Interesting. I might try that. Thanks!

Would that be visible to users? If they did, say, a View Source on the page? I'd hate for someone to figure out how to access my bulletin board! :-)

cyberxp9

09-06-2005, 09:03 AM

Interesting. I might try that. Thanks!

Would that be visible to users? If they did, say, a View Source on the page? I'd hate for someone to figure out how to access my bulletin board! :-)

Everyone STOP!!!!!!! CLICKING ON THE LINKS I GIVE! they send me database errors.. cause they are errors... if you dont ill just remove them.

rsuplido

09-06-2005, 11:17 AM

Would that be visible to users? If they did, say, a View Source on the page? I'd hate for someone to figure out how to access my bulletin board! :-)

No, it shouldn't be visible. Anything between <?php ... ?> will not be visible when you do a 'view source'. The server parses and executes all the php scripts and renders the page as pure html, without the php scripts.

rsuplido

09-06-2005, 11:35 AM

still doesnt work, it just shows the xml file :(

Well, that's what the RSS feed is. If the XML reneders properly, then it usually means that the feed works. If you want you can check how your feed looks here:

http://www.netimechannel.com/OnlineRssViewer/

Enter "http://www.cyberxp9.net/blog/?feed=rss2" in the feed field and hit on "View Results". On the results, click on the expand icon to see the contents of each entry.

Btw, the "feed:" protocol is for the Mac's Safari RSS viewer.

rsuplido

09-08-2005, 02:52 PM

I finally got my site working. Here's the live demo:

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

cyberxp9

09-08-2005, 09:24 PM

First, I see that your blog comments RSS is already working:
http://www.cyberxp9.net/forum/postfeed.php?t=170&type=rss2

For the Entries (RSS), no, the change should not have affected it. Actually it works. If you try: http://www.cyberxp9.net/blog/?feed=rss2 you should see the actuall RSS of your blog's entries.
PLEASE DELETE THAT LINK AND ALL OTHER LINks THERE CAUSE RETARDS KEEP ON CLICKING IT AND I KEEP ON GETTING ERROR EMAILS, ITS FREAKING ANNOYING!

rsuplido

09-08-2005, 10:09 PM

Well, delete the erring link at post 41 and you'll be ok.

limey

09-09-2005, 03:35 PM

I'm wondering if it would be easy to add a box inside wordpress under your categories posting box that lists your forums. This way you could click which forum you want the post to go in addition to your wordpress categories. This would be helpful for people who don't want to create a one blog forum for all the WP posts.

I think that would be easy to do. SQL the forums > html with form data for the checkboxes.

I'm a newbie when it comes to php/mysql programming, but I know enough thatthis should be doable.

I couldn't find where you were inserting information into the database, but that could be done by using the forumid with the associated checkbox.

Cole2026

09-11-2005, 01:34 PM

Any chance you could give us the ability to not use the forum as a comment system, but use the wordpress system with forum integration?

Thanks

Hmm, I guess the post wasn't seen, anyways, same question.

I just want to use the wordpress comments system, but have that user integration so users can use their forum account to make comments on the wordpress.

cyberxp9

09-13-2005, 07:48 PM

Live Demo: http://www.internett
where did you get that skin on your blog?

Gellpak

09-22-2005, 05:36 AM

Hmm, I guess the post wasn't seen, anyways, same question.

I just want to use the wordpress comments system, but have that user integration so users can use their forum account to make comments on the wordpress.

As I understand it, this already does that. You have to have a user account set up with wordpress to POST an item, but replies are just sent to the forum anyway, which uses the forum accounts.

What I'd like to see is full user integration... i.e. no such thing as wordpress accounts, just permissions in vbb that allow posting in wordpress. No separate user system.

gigaenvy

09-25-2005, 01:43 PM

Do you know if this can be used to pull from a remote vbulletin server? Was thinking of testing this on another domain with WP installed and pulling posts remotely.

Thanks!

rsuplido

09-25-2005, 05:02 PM

Do you know if this can be used to pull from a remote vbulletin server? Was thinking of testing this on another domain with WP installed and pulling posts remotely.

Thanks!

Check out my reply on post #70. Not guaranteed but it might work.

gigaenvy

09-25-2005, 09:51 PM

Check out my reply on post #70. Not guaranteed but it might work.

Thanks...I did a search initially for the word "remote", hence my post. Makes perfect sense since that is how I am publishing posts from my vbulletin forums onto an html page on another web host - domain.

Again...much appreciated for your help.

iliton

09-27-2005, 07:07 PM

What I'd like to see is full user integration...
This all what i need

rsuplido

09-27-2005, 07:15 PM

David_R

09-28-2005, 10:39 AM

Is this not a full version ? I am confused by some posts in this thread.

The Bad Astrono

10-02-2005, 09:32 PM

A workaround is probably to add the database name in the dbprefix variable like:

$vb_dbprefix = 'databasename.vb3_';

Also, in phpmyadmin, give full access to the wordpress user to the vb database. It might work.

I was thinking about this again. Since the vBulletin database is on another server altogether, I have no clue what to put in this variable to make it work (or even if it can work).

Does anyone out there with more experience have an idea? Is there some way to tie together two databases sitting on different computers? I'll add that they are both on the same web host, just on two different machines.

Thanks!

pcoskat

10-15-2005, 08:05 AM

This is a nice hack! It's just what I need, with one minor (haha) problem: my bulletin board is a different database, and on a different server than my blog. My php and DB skills are pretty minimal, so does anyone know how to do this? I would dearly love to have the comments from my blog on my bulletin board!
Uhh oh!

I was all excited about this mod until I read your post.

My blogs are going to be on the same server as my vB, but they will not share the same domain.

Is this going to be a problem... :surprised:

Lord Brar

10-15-2005, 10:03 AM

Uhh oh!

I was all excited about this mod until I read your post.

My blogs are going to be on the same server as my vB, but they will not share the same domain.

Is this going to be a problem... :surprised:

If they are going to share the database then the domain should not be an issue.

Gellpak

10-26-2005, 08:49 PM

I understand that some of you would like to see user integration but why? Users with Wordpress accounts (authors and contributors) are very minimal. Majority of the blog sites probably just has one author. Why integrate the user database to vB then?

With this hack, you should:

1. Create accounts for blog authors in WordPress so they can create blog entries
2. Members register in vBulletin so they can reply

What's so difficult about that?

Oh, it's not, and it's what I'm doing now, but it makes building an admin control panel with everything at your fingertips a bit tougher. It would just be a much more elegant solution... I'm honestly suprised that given the popularity of both these programs that noone has done it already.

chanzero

11-18-2005, 03:18 PM

loving this hack!

anybody have any hints or ideas on how to modify comments in lightpress or K2? i'd really like to try it with them...

99SIVTEC

11-18-2005, 05:44 PM

I love this hack. It's the single best addition to my sites. The ONLY thing I would like to improve is the ability to post html to the forums. I always format my wordpress posts in html, but it posts to the forums in plain text. I have to go in and insert the html by hand into the forum post which isn't a huge deal, but it would be nice if it did it for me.

RyanC

11-18-2005, 08:54 PM

Stupid question, but can you chose which blog entries have threads automatically started in your VB forum? It would be great if only the entries I designate are given a comment area and a thread in by forum...

Thanks!

chanzero

11-19-2005, 05:17 PM

loving this hack!

anybody have any hints or ideas on how to modify comments in lightpress or K2? i'd really like to try it with them...

i mean, modify it to show vb comments if that wasn't clear

and also, anyone have any idea how to possibly modify post pages (not necessarily in lightpress or K2) to show the comment form like a vb quick reply?

muf

12-07-2005, 07:36 PM

In case anyone's interested, I've successfully gotten the bridge to associate WordPress nicknames with vB usernames. The condition for this to work is that your WP nicks *must* correspond with their vB nicks.
Just add this to the bridge block in admin/post.php:
$vb_posterid = $wpdb->get_var("SELECT userid FROM " . $vb_dbprefix . "user WHERE username = '" . $user_nickname . "'");
Then proceed to replace all occurrances (in post.php) of $vb_username with $user_nickname and all occurrances of $vb_userid with $vb_posterid. If no userid can be found for the nickname (WP-vB mismatch), the entry in the database will be set at 0 and the postbit will display the user as "Guest" and with "Posts: n/a". Of course, you add this modification at your own risk, the only guarantee you have is that it *works for me*. It is a little hackish (since I use $vb_posterid while i should abolish the $vb_username and $vb_userid in vb3-settings.php and do it all correctly, blah blah), so if anyone feels it should be done prettier, by all means go ahead.

rsuplido

12-07-2005, 07:38 PM

LOL muf,

I was just doing the same change just now. Really!

Will post ist soon. :D

rsuplido

12-07-2005, 07:53 PM

Posted the new version:

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.

Here's the updated code in post.php:

// 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,'');
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

muf

12-08-2005, 07:15 AM

rsuplido

12-08-2005, 12:55 PM

Nice. But why do you get the username from the database when it is already fetched and ready for use as $user_nickname ? The code looks good but a little complicated :ninja:.

Actually, while they look the same, I wasn't sure if the 'user_nickname' is the same as 'user_login'. Isn't the nickname an alias and can be user defined? I just wanted to make sure.

The code got a bit complicated since I had to check if the wp username corresponds to a vB username. If not, I still use the default username and id defined in the settings.

Thanks.

memobug

12-08-2005, 08:03 PM

This hack will only work if your WordPress and vBulletin tables are in a single database.

What would it take to make this hack work with a Wordpress installation located in another database (on the same server?)

Regards,

Matt

rsuplido

12-09-2005, 02:10 AM

What would it take to make this hack work with a Wordpress installation located in another database (on the same server?)

Matt, check out reply #70 of this thread.

Thanks.

macshrine

12-11-2005, 09:50 PM

Would this work with vB 3.5.2?

chanzero

12-12-2005, 02:39 PM

mikaelweb

12-16-2005, 06:53 AM

Will this one work whit vBulletin 3.5.2

Viks

12-23-2005, 12:45 AM

Rsuplido,
Thank you.

The hack is really excellent addon for vbulletin and increases its funtionality many folds with this bridge and wordpress.

Simply fantastic... I have tried it on my develop forums using vb3.5.1 and it works great!

I have a question.. in case I decide to use other themes instead of the default one then will the edit/changes be the same that I applied to the default theme.. or will it be different??

Viks

rsuplido

12-23-2005, 01:56 AM

Viks,

You shouldn't have to change anything if you change themes.

Viks

12-30-2005, 04:46 PM

Thanks for your reply..
Here.. you are invited to check out my site.. with wordpress integeration.

www.thalforum.ca
Thalforum.ca - It is a patient support forum for Thalassemia (a genetic blood disroder) and I have used wordpress as the article section on the site.

I read today about wordpress 2.0 being released, and I was wondering if anyone here has tried to use wordpress 2.x with vbulletin 3.5.x integreration?

cheers,

V

The Bad Astrono

12-31-2005, 05:55 PM

Well, I'm finally getting around to working on this, and I'm having a problem (probably due to my lack of Db skills).

I moved my website and blog to the same server as the vB board. They use two different databases, which is unavoidable. This means the admin for the two databases have different names. When I try to post, I get an error which says:

WordPress database error: [Access denied for user 'XXX @'localhost' to database 'xx vBdbname xx']
SELECT count(*)-1 FROM vb_forum.post WHERE threadid = '3'

where XXX is my admin name on WordPress, and "xxvBdbnamexx" is the database name for the vB board. It looks to me that the admin for WP cannot talk to the database for vB. I tried adding the WP username to the forum database in DirectAdmin (the panel I use for administration) but it won't allow me to (it forces me to use a prefix for the name specific to the database, so I literally cannot get the same admin name for both databases).

If this makes any sense :-) does anyone have a suggestion?

Thanks.

Lord Brar

01-03-2006, 06:11 AM

Hi,

Any plans to upgrade it for 2.0? This code doesn't work in 2.0 :(

Thanks :)

Viks

01-04-2006, 12:47 AM

Hi,

Any plans to upgrade it for 2.0? This code doesn't work in 2.0 :(

Thanks :)

It does'nt eh!! :ermm:

rsuplido, what do you think? Actually I am pretty happy with 1.5 for now but I know sooner or later the new Ajax features and PLugin Manager feature of wordpress 2.0 is gonna be too hard to resist.

Kindly consider porting the hack to 2.0 with compatibility to vb3.5.x... we'll be very obliged!

Thanks.

Macindy

01-04-2006, 09:11 AM

It does'nt eh!! :ermm:

rsuplido, what do you think? Actually I am pretty happy with 1.5 for now but I know sooner or later the new Ajax features and PLugin Manager feature of wordpress 2.0 is gonna be too hard to resist.

Kindly consider porting the hack to 2.0 with compatibility to vb3.5.x... we'll be very obliged!

Thanks.

Please do so - I waiting on it ;)

fedoraforum

01-09-2006, 06:12 PM

any update for wordpress 2.x? :p

Viks

01-30-2006, 11:21 PM

Hi rsuplido,

any plans to porting this for Wordpress 2.0?

:)

MSC

02-01-2006, 11:31 PM

Hi folks, also waiting for a 2.0 release.

BryceW

02-03-2006, 07:55 AM

Does this work on VB 3.5.3?

Lord Brar

02-03-2006, 09:07 AM

Does this work on VB 3.5.3?

vBulletin version is no problem... it is the wordpress version which is a problem. This mod works with 1.5 and not version 2 of WP. :(

BryceW

02-03-2006, 09:11 AM

vBulletin version is no problem... it is the wordpress version which is a problem. This mod works with 1.5 and not version 2 of WP. :(
Thanks for that Lord Brar, I have been looking around for a copy of WP 1.5.1.3 (or whatever the latest version is) from a secure source, it seems there is no longer a download link to the older versions of WP.

Edit: Ended up finding it from a secure source, here is a link for future searchers: http://static.wordpress.org/archive/

EINS

02-12-2006, 06:49 PM

Hi,

will there be a release for WP 2.0?

EINS

02-14-2006, 08:28 AM

????

WizyWyg

02-15-2006, 09:17 PM

Any updates?

fedoraforum

02-21-2006, 08:49 PM

i got it to work with WP 2 on slashgear.com, let me clean up the code and release it here

EINS

02-22-2006, 05:49 PM

You´re a star!!

Cheertobi

03-02-2006, 08:12 AM

Any news on this one?!

Would be great to get this work with vB3.5.x & WP2.x

Tobi

seek3r

03-13-2006, 03:40 AM

i got it to work with WP 2 on slashgear.com, let me clean up the code and release it here

Any chance you can post your code?

Boinger

03-16-2006, 04:21 PM

is there anyway to integrate the forum header as the wordpress header as well ?

ScruffyDeluxe

04-01-2006, 11:34 PM

i got it to work with WP 2 on slashgear.com, let me clean up the code and release it here

Bump for WP2 version :D

board.trash

04-02-2006, 05:38 AM

Would be great to get this work with vB3.5.x & WP2.x

Tobi

i agree with you :banana:

wordpress is geilomat :P

collegehoopsnet

04-06-2006, 05:47 AM

I need help! I get the following error:

WordPress database error: [Unknown column 'vb_threadid' in 'field list']
UPDATE wp_posts SET `vb_threadid`=2968 WHERE `ID`='43'

Warning: Cannot modify header information - headers already sent by (output started at /home/colleg11/public_html/daily/wp-includes/wp-db.php:98) in /home/colleg11/public_html/daily/wp-admin/post.php on line 220

Despite that error, the post still goes on the blog and the vbulletin board. However, "comments off" always remains, and even going to leave a reply when clicking on the post does not lead the approproate vbulletin thread.

Any help would be appreciated.

collegehoopsnet

04-06-2006, 07:19 PM

never mind, i fixed it..

ScruffyDeluxe

04-08-2006, 07:48 AM

I got a little impatient for an update, so I started hacking this myself into WordPress 2 / vB 3.5.

Everything except the comments RSS feed works so far. Any ideas?

chanzero

04-08-2006, 06:17 PM

hey scruffy will you share see your hack code? maybe the group can work out the RSS too

ScruffyDeluxe

04-09-2006, 04:44 AM

Sure, check the attachment. I used Beyond Compare to find the differences between my hacked files and the originals, so if I missed anything, give me a shout.

moethelawn

04-09-2006, 08:43 AM

Sure, check the attachment. I used Beyond Compare to find the differences between my hacked files and the originals, so if I missed anything, give me a shout.
Scruffy, thanks for changing the code to make it work for WP 2.0!

I did exactly what you had in your instructions, but i end up with this error:

WordPress database error: [Table 'gamerene_wp.user' doesn't exist]
SELECT userid FROM user WHERE username = 'admin'

WordPress database error: [Table 'gamerene_wp.thread' doesn't exist]
INSERT INTO thread SET title='test',lastpost='1144575715', forumid='183', open='1', postusername='moethelawn', postuserid='1', lastposter='moethelawn', dateline='1144575715', visible='1'

WordPress database error: [Table 'gamerene_wp.post' doesn't exist]
INSERT INTO post SET threadid='8', username='moethelawn', userid='1', title='test', pagetext='testRead the full blog entry. (http://www.gamerenegades.com/news/?p=8)', ipaddress='', allowsmilie='1', iconid='1',visible='1', dateline='1144575715'

WordPress database error: [Table 'gamerene_wp.forum' doesn't exist]
UPDATE forum SET threadcount=threadcount+1, lastpost='1144575715', lastposter='moethelawn', lastthread='test', lastthreadid='8', lasticonid='1' WHERE forumid='183' LIMIT 1

Warning: Cannot modify header information - headers already sent by (output started at /home/gamerene/public_html/news/wp-includes/wp-db.php:102) in /home/gamerene/public_html/news/wp-admin/post.php on line 60
I'd thought I'd not change anything if you had some sort of idea what it is that's wrong. Thanks!

ScruffyDeluxe

04-10-2006, 05:46 AM

I'm still a MySQL noob, but it looks like vB and WP are in different databases...?

BLazeD1

04-21-2006, 04:00 AM

installed using your hack ^^^ and very impressed.

please keep us updated of any progress!

endquote

04-27-2006, 10:49 PM

This works well for me VB 3.5.4 and WP 2.0.2. Some bugs:

If you edit the post in WP, it doesn't get edited in VB.
If you delete a post in WP, it doesn't get deleted in VB.
If you click "save" instead of "publish" in WP, it publishes in VB, even though it shouldn't.

The attached version fixes the first problem. It would be great to see the others fixed and the whole thing packaged into a proper WP plugin.

yessir

05-10-2006, 01:38 PM

I would love to see this ported to plugins for 3.5.

ScruffyDeluxe

05-11-2006, 09:00 PM

OK, I just did a bit more to this. I've tested a few different methods of creating blog entries, and these are known to work as expected (the entry's status options were set to 'Draft' unless otherwise stated):Does not create thread (vb_threadid = NULL)
Write entry > Click 'Save and continue editing' button
Write entry > Click 'Save' button

Creates thread
Write entry > Click 'Publish' button
Write entry > Click 'Save and continue editing' button > Click 'Publish' button
Write entry > Click 'Save and continue editing' button > Select 'Publish' entry status > Click 'Save and continue editing' button
Each of the above tests were done on a fresh entry, and just to confirm that no duplicate threads can be created by the same blog entry, I did a rather important check:Updates thread
Edit entry > Select 'Draft' entry status > Click 'Save and continue editing' button > Select 'Publish' entry status > Click 'Save and continue editing' button
Along the way, I removed some parts of the queries which made the first post jump to its chronological place in the thread whenever the blog entry is edited. I've totally ignored the 'Private' post status so far; I hope it doesn't need a whole new bunch of queries.

BLazeD1

05-11-2006, 09:44 PM

Is this an update, or were you just telling us your progress?

Cheers

PS: Anyone notice funny characters come up in the VB forums when you post an image in the WP entry? e.g maxps3.com

Thanks!

OK, I just did a bit more to this. I've tested a few different methods of creating blog entries, and these are known to work as expected (the entry's status options were set to 'Draft' unless otherwise stated):Does not create thread (vb_threadid = NULL)
Write entry > Click 'Save and continue editing' button
Write entry > Click 'Save' button

Creates thread
Write entry > Click 'Publish' button
Write entry > Click 'Save and continue editing' button > Click 'Publish' button
Write entry > Click 'Save and continue editing' button > Select 'Publish' entry status > Click 'Save and continue editing' button
Each of the above tests were done on a fresh entry, and just to confirm that no duplicate threads can be created by the same blog entry, I did a rather important check:Updates thread
Edit entry > Select 'Draft' entry status > Click 'Save and continue editing' button > Select 'Publish' entry status > Click 'Save and continue editing' button
Along the way, I removed some parts of the queries which made the first post jump to its chronological place in the thread whenever the blog entry is edited. I've totally ignored the 'Private' post status so far; I hope it doesn't need a whole new bunch of queries.

fcain

05-28-2006, 06:18 AM

Does WP and VB still have to be on the same server with this hack? I've got the site and the forum on different servers, but I'd like them to connect.

endquote

05-28-2006, 06:47 PM

They need to share the same database, but don't need to have any URLs in common, so they could be at different hostnames or something.

bang

06-14-2006, 10:53 AM

second that, I'd love to see a plugin/product for proper integration of WordPress 2.0.* into vB 3.5/3.6

hadog

06-14-2006, 01:15 PM

Hi
Please help me with this.....

I have vb3.5 up and going and I have wordpress up and going.
Yes I would like to bridge them.
What do you mean "they have to share the same db"
How is this done?
Can I do it and not have a mess on myu hands?

Any help is appreciated

ScruffyDeluxe

06-15-2006, 08:29 PM

This means that WordPress and vBulletin must be installed on the same database. If they are, then you've already overcome a major hurdle :B

GrendelKhan{TSU

06-21-2006, 07:20 AM

second that, I'd love to see a plugin/product for proper integration of WordPress 2.0.* into vB 3.5/3.6

I third fourth and fifth that! :)

BLazeD1

07-04-2006, 08:03 AM

I get this error under each Comments part of the "Manage" tab in WP admin:

WordPress database error: [Unknown column 'vb_threadid' in 'field list']
SELECT vb_threadid FROM wp_comments WHERE id = '454'

Spermy

07-04-2006, 11:43 PM

Will this be updated for 3.5x?

chanzero

07-12-2006, 07:57 PM

Sure, check the attachment. I used Beyond Compare to find the differences between my hacked files and the originals, so if I missed anything, give me a shout.

awesome work scruffy!! thanks!

BLazeD1

07-12-2006, 09:32 PM

Anyone that can help me with my error - https://vborg.vbsupport.ru/showpost.php?p=1021899&postcount=147 ?

chanzero

07-12-2006, 10:41 PM

Anyone that can help me with my error - https://vborg.vbsupport.ru/showpost.php?p=1021899&postcount=147 ?

looks like you missed part of the installation, namely this:

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

selbmag

07-24-2006, 01:20 PM

I have this installed with WP 2 and VB 3.5.4

The only issue I have is saving an edited post creates another thread in VB.

Also I do not use the moreflag in any posts but want to shorten the quote on the forum how do I do this (a complete PHP noob!)

selbmag

07-24-2006, 01:31 PM

OK got around the moreflag problem.

I deleted all references of

$moreflag = strpos($content,'');

I then added the following to the vb3_settings.php file

$moreflag = 500

Which means the first 500 characters are included.

Now just the problem with Saving edited blog entries creatign duplicate threads in VB :(

rsuplido

07-24-2006, 01:36 PM

If it keeps creating a new thread, you must not have added the new column called 'vb_threadid' on the 'wp_posts' table. Check the first step of this hack called 'Database Changes'.

selbmag

07-24-2006, 02:00 PM

vb_threadid exists - everythign else works just this is the only problem.

I am using the file posted by endquote

https://vborg.vbsupport.ru/showpost.php?p=961868&postcount=137

selbmag

07-24-2006, 02:06 PM

To point out my VB and WP databases are seperate but I used

$vb_dbprefix = 'st_vb.'; //vBulletin database prefix

The DBname is st_vb with no prefix present. I gave the VB database user rights on the WP db and vice-versa.

chanzero

07-28-2006, 08:26 PM

vb_threadid exists - everythign else works just this is the only problem.

i have the same problem...

BLazeD1

07-28-2006, 10:29 PM

looks like you missed part of the installation, namely this:

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

Thanks for the reply, but I get:

SQL query:

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

MySQL said:

#1060 - Duplicate column name 'vb_threadid'

chanzero

07-29-2006, 01:47 AM

oh, actually i take it back -- mine is not creating a *new* thread every time, it adds a post to the existing thread!

@ blazeD1: oh ok, my bad

pixelhead

07-29-2006, 08:58 PM

FIXED NOW, THANKS.

Hi all,

when writing a new post I got this error:

Warning: main(/home/whichpco/public_html/wp-includes/vb3-settings.php): failed to open stream: No such file or directory in /home/whichpco/public_html/wp-admin/post.php on line 3

Warning: main(): Failed opening '/home/whichpco/public_html/wp-includes/vb3-settings.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/whichpco/public_html/wp-admin/post.php on line 3

Any ideas? Any help would be appreciated.

P.S. WP - 1.5.1.3, VB - 3.0.8

Thanks for your time.

BryceW

08-03-2006, 01:35 PM

For those of you who didnt see it a few pages back.

THIS WORKS FOR WP 2.0.4 and VB 3.5.4

Endquote posted an update file located here:
https://vborg.vbsupport.ru/showpost.php?p=961868&postcount=137

* BryceW sends Endquote love. Works great :D

YoricksRequiem

08-11-2006, 06:14 PM

Thanks for everyone for the update. This is absolutely awesome.

One thing I'd like to add if it's possible - I'm using Gamerz Post-Ratings for Wordpress (http://www.lesterchan.net/portfolio/programming.php) and I was wondering if there's a way to combine it with the vBulletin ratings, or at least a way to carry it over into the thread.

Any help is appreciated.

spurstalk

08-14-2006, 07:09 PM

Hi, I'm new at this but I just wanted to be clear about something.

So WP and vB have to share the same database for this to work but they can be on different servers/domains?

Is it not possible at all if they are on different servers/domains and also do NOT share the same database?

Thanks in advance.

RyanC

08-17-2006, 08:00 PM

I would be more than willing to finance this project as an actual plugin... Anyone interested?

Deimos

08-22-2006, 10:00 PM

Any chance of getting this working for VB 3.6?

ScruffyDeluxe

08-28-2006, 01:04 AM

OK, I've been running this for a while now, and I'm certain it's worth another beta. From the textfile:

// Changes (+author)

* Editing an entry will also edit the first post in the thread (endquote)
* Editing an entry will not modify the timestamp of the first post in the thread (ScruffyDeluxe)
* Saving a new entry will not publish until the publish button is clicked, or if the post status checkbox is set to publish (SD)
* Any possibility of duplicate threads via changing post status hopefully squashed (SD)
* Entry quote in first post will be shown as posted by the user rather than "The Front Page" (SD)

// Bugs

* If you delete a post in WP, it doesn't get deleted in VB
* More a bug in this textfile than anything - the approximate line numbers change once you edit a file :1

// Ideas

* If you set an entry to draft status after publishing, it should moderate the thread
* Consider an overhaul to WP's comments page to show a thread view

Sorry I haven't popped in here for a while... 'issues'.

Deimos

08-28-2006, 05:53 PM

Can't seem to get it working on VB 3.6 :(

I get this mess

Hello world!
August 28th, 2006

Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!

Posted in Uncategorized | Edit |
Warning: comments_popup_link(/home/deimos/public_html/wp/wp-includes/vb3-settings.php) [function.comments-popup-link]: failed to open stream: No such file or directory in /home/deimos/public_html/wp/wp-includes/comment-functions.php on line 289

Warning: comments_popup_link(/home/deimos/public_html/wp/wp-includes/vb3-settings.php) [function.comments-popup-link]: failed to open stream: No such file or directory in /home/deimos/public_html/wp/wp-includes/comment-functions.php on line 289

Warning: comments_popup_link() [function.include]: Failed opening '/home/deimos/public_html/wp/wp-includes/vb3-settings.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/deimos/public_html/wp/wp-includes/comment-functions.php on line 289

Warning: get_comments_number(/home/deimos/public_html/wp/wp-includes/vb3-settings.php) [function.get-comments-number]: failed to open stream: No such file or directory in /home/deimos/public_html/wp/wp-includes/comment-functions.php on line 230

Warning: get_comments_number(/home/deimos/public_html/wp/wp-includes/vb3-settings.php) [function.get-comments-number]: failed to open stream: No such file or directory in /home/deimos/public_html/wp/wp-includes/comment-functions.php on line 230

Warning: get_comments_number() [function.include]: Failed opening '/home/deimos/public_html/wp/wp-includes/vb3-settings.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/deimos/public_html/wp/wp-includes/comment-functions.php on line 230
1 Comment ?

On the main WP page.

Deimos

08-28-2006, 05:53 PM

And if I try and publish anything, I get

Warning: wp_insert_post(/home/deimos/public_html/wp/wp-includes/vb3-settings.php) [function.wp-insert-post]: failed to open stream: No such file or directory in /home/deimos/public_html/wp/wp-includes/functions-post.php on line 10

Warning: wp_insert_post(/home/deimos/public_html/wp/wp-includes/vb3-settings.php) [function.wp-insert-post]: failed to open stream: No such file or directory in /home/deimos/public_html/wp/wp-includes/functions-post.php on line 10

Warning: wp_insert_post() [function.include]: Failed opening '/home/deimos/public_html/wp/wp-includes/vb3-settings.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/deimos/public_html/wp/wp-includes/functions-post.php on line 10

Warning: Cannot modify header information - headers already sent by (output started at /home/deimos/public_html/wp/wp-includes/functions-post.php:10) in /home/deimos/public_html/wp/wp-includes/pluggable-functions.php on line 272

ScruffyDeluxe

08-29-2006, 05:48 AM

You're missing the vb3-settings file, it seems. Although the latest file I attached has the modification steps, you'll need to check rsuplido's first post in this thread for the missing stuff (don't forget to grab postfeed.php too).

Let me know how it goes - I'm still running this on vB3.5.4 and WP 2.0.2, and it would be a nice surprise to see if it's forward-compatible :p

Kurisu

10-04-2006, 03:57 AM

Anyone got this working with WP 2.0.4 and vB 3.6?

Moment

10-11-2006, 01:10 PM

Anyone got this working with WP 2.0.4 and vB 3.6?
+1 :cross-eyed:

baze22

10-12-2006, 11:14 AM

Anyone got this working with WP 2.0.4 and vB 3.6?

I did this yesterday using the file in this post (https://vborg.vbsupport.ru/showpost.php?p=961868&postcount=137) and in my initial testing it looks like its working as it should.

2 things I had to change:

1. I had the same problem as mentioned above "failed to open stream: No such file or directory" when in fact my vb3-settings file was exactly where it was supposed to be. I even hard coded the path - same error. I don't have an explanation, but I changed the file name to vb36settings.php and the references in the code - it worked fine.

2. Looks like 3.6 changed a table name. In the text file above it had this {$vb_dbprefix}post_parsed and I changed it to this: {$vb_dbprefix}postparsed

After those 2 things it looks to be working fine. My thanks to those who put this together.

baze

baze22

10-12-2006, 11:30 AM

1. I had the same problem as mentioned above "failed to open stream: No such file or directory" when in fact my vb3-settings file was exactly where it was supposed to be. I even hard coded the path - same error. I don't have an explanation, but I changed the file name to vb36settings.php and the references in the code - it worked fine.

I think I figured out what the problem here was. When I created the vb3-settings.php file, I copy/pasted the file name from the instructions at the top of the page. But it isn't the same - you get when you type it in. It is hex char 96 as opposed to the hex char 2D you get when typing it in. Bottom line would probably work if the file name was typed in when saving the file instead of copied & pasted from above. I figured this out when I copied & pasted the filename from above into TextPad and the - showed up as a special character.

baze

thedigitalsin

10-23-2006, 07:50 AM

never mind, got it working

realmadrid

11-06-2006, 12:53 PM

I was wondering if someone could help me. I have 2 issues....I'm trying to set this up. The first issue that Im coming up with is that in wp-admin/post.php I dont see the following code:

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

so I can add the follwing as per instructions... "// VB Bridge Start...etc.etc

2nd thing is that accord to instructions "im supposed to find

......function get_comments_number( $comment_id ) ...... section

I think the closest thing I have to that in the comments-functions.php is

......function get_comments_number( $post_id )....... etc.etc

is this ok to make the change

Thanks

BryceW

11-07-2006, 10:40 AM

Just upgraded WP 2.0.4 to WP 2.0.5 and currently running VB 3.5.4.
I just reapplied the instructions given in this post to the new 2.0.5 files: https://vborg.vbsupport.ru/showpost.php?p=961868&postcount=137

Worked great.

imranbaig

11-20-2006, 09:22 AM

Hi nice hack, With Few modifications to above post. I was able to make it work with wp 2.05 and VBulletin 3.63.
If the author allows I will release this as a plugin.
Thanks regards.

rsuplido

11-20-2006, 10:34 AM

That would be great! Go ahead and release it.

Thanks.

Deimos

11-20-2006, 10:35 AM

Hell yeah! that'd be sweet.

imranbaig

11-20-2006, 10:49 AM

aite let me pick them up all into orderd folders maybe a small readme, I will release it tonight.
Thanks. by the way you can check it here www.mobile-junction.com nothing is added yet just making mods and plugins.
right now making a plugin for vb to send sms for free across 200+ countries using simple phpmail function.

EDIT: There are few things which I need to correct before I can release it :)

rsuplido

11-20-2006, 10:56 AM

looking good. if you get the time, let the article show the trackbacks under it, but let the comments go directly to vB.

imranbaig

11-22-2006, 06:49 AM

I'm almost ready for release, I will copy your instructions, and add changes which i did and supply edited files, which will save lots of time i guess :).
can any body check here www.mobile-junction.com

JustinBr

11-30-2006, 02:37 AM

i just checked it out it looks great so far....

eagerly waiting this release!