vb.org Archive - Integration with vBulletin - Complete Wordpress/Vbulletin Bridge

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

- Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)

- - Integration with vBulletin - Complete Wordpress/Vbulletin Bridge - Share Users And Postings (https://vborg.vbsupport.ru/showthread.php?t=134521)

This plugin looks like a 5 star plugin! Thanks for making it available.

I am using WP 2.0.7 and the VBridge 2.0.4. I followed the install instructions step by step. I am using VB for comments as well.

Each time I attempt a WP login, I am redirected to VB Forum main page. I have tested in different browsers and cleared cookies etc. Any suggestions?

Thanks.

Hy,

I have absolutly no idea where I have to put this code...

Quote:

Find this code (or similar code indicating the comment section of your template):

<?php wp_link_pages(); ?>
<!-- <?php comments_popup_link(__('0 Comments'), __('1 Comments'), __('% Comments')); ?>

And replace with this:

<?php
#### Vbridge Replacement code for comments

if ($vbridge[id] > 0) {
?>
<div class="comments">
<?php
if(is_single()) {
if (is_array($vbridge[replies])) {
?>
<br /><br />
<h3 id="comments">Comments:</h3>
<ol class="commentlist">
<?php
foreach ($vbridge[replies] as $reply) {
?>

<li class="<?php echo $oddcomment; ?>" id="comment-<?php comment_ID() ?>">
<?php echo $vbridge[vb_parser]->do_parse($reply->pagetext, false, true); ?>
<small class="commentmetadata">
    <img src="<?php bloginfo('stylesheet_directory'); ?>/images/comment_arr.gif" alt="" />

by <cite> <a href=<?php echo get_option('vbb_VBURL') ?>/member.php?u=<?php echo $reply->userid ?>><?php echo $reply->username; ?></a></cite>
</small><br />
</li>

<?php /* Changes every other comment to a different class */
if ('alt' == $oddcomment) $oddcomment = '';
else $oddcomment = 'alt';

}
}
?>
</ol>
<?php
}
?>
<a href=<?php echo get_option('vbb_VBURL') ?>/showthread.php?t=<?php echo $vbridge[id] ?>>(<?php echo intval($vbridge[count]) ?>) comments</a> | <a href=<?php echo get_option('vbb_VBURL') ?>/newreply.php?do=newreply&noquote=1&t=<?php echo $vbridge[id] ?>>Add your comments</a>
</div>
<?php
}
##End Vbridge Replacement
?>

You can also now link authors usernames to their VB profile page. Wherever you see the code:

<?php the_author() ?>

You can replace that with something like:

<?php
if ($vbridge[id] > 0) {
?>
<a href=<?php echo get_option('vbb_VBURL') ?>/member.php?u=<?php echo $vbridge[thread_starter] ?>><?php the_author() ?></a>

<?php
}
else {
the_author();
}
?>

Quote:

Originally Posted by stha n (Post 1179681)

I have exactly the same problem. I followed the steps in the readme, and i could only get my admin user mapper. Whenever any other user tries to enter the site admin, it gets redirected to the forum main page, but only when Auto-Integrate is on. If it is off, the user simply gets to the login page, but doesn't have a correct user.

I am getting the following error

Code:

WordPress database error: [Unknown column 'vb_threadid' in 'field list']

UPDATE wp_posts set vb_threadid = 3082 WHERE ID = 5





Warning: Cannot modify header information - headers already sent by (output started

The thread does get created in my forum but the above error is generated. I am wondering if in the VBBRIDGE plugin options I have something set wrong. My forum is installed in a subdomain of my site > http://discussion.socalskateparks.com
Should the relative path be / or just blank?

Any help would be appreciated.

Quote:

Originally Posted by stha n (Post 1179681)

I am using WP 2.0.7 and the VBridge 2.0.4.

First, you need to be using 2.05, the latest version.

Quote:

Originally Posted by soulplayer (Post 1179799)

Hy,

I have absolutly no idea where I have to put this code...

In your template files, there is code for the comment section of the template. GENERALLY it looks something like:

Code:

<?php wp_link_pages(); ?>

<!-- <?php comments_popup_link(__('0 Comments'), __('1 Comments'), __('% Comments')); ?>

Please read the readme a bit closer. :)

I read it, but I did not found anything that looks like that... Using 2.1 Wordpress.

In which files do I find those comment options? I edited the "comment.php" but it doesn't work...

Quote:

<?php
/* Don't remove these lines. */
add_filter('comment_text', 'popuplinks');
foreach ($posts as $post) { start_wp();
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?php echo get_settings('blogname'); ?> - <?php echo sprintf(__("Comments on %s"), the_title('','',false)); ?></title>

<meta http-equiv="Content-Type" content="<?php bloginfo('html_type'); ?>; charset=<?php echo get_settings('blog_charset'); ?>" />
<style type="text/css" media="screen">
@import url( <?php bloginfo('stylesheet_url'); ?> );
body { margin: 3px; }
</style>

</head>
<body id="commentspopup">

<h1 id="header"><a href="" title="<?php echo get_settings('blogname'); ?>"><?php echo get_settings('blogname'); ?></a></h1>

<h2 id="comments"><?php _e("Comments"); ?></h2>

<p><a href="<?php echo get_settings('siteurl'); ?>/wp-commentsrss2.php?p=<?php echo $post->ID; ?>"><?php _e("<abbr title=\"Really Simple Syndication\">RSS</abbr> feed for comments on this post."); ?></a></p>

<?php if ('open' == $post->ping_status) { ?>
<p><?php _e("The <acronym title=\"Uniform Resource Identifier\">URI</acronym> to TrackBack this entry is:"); ?> <em><?php trackback_url() ?></em></p>
<?php } ?>

<?php
// this line is WordPress' motor, do not delete it.
$comment_author = (isset($_COOKIE['comment_author_' . COOKIEHASH])) ? trim($_COOKIE['comment_author_'. COOKIEHASH]) : '';
$comment_author_email = (isset($_COOKIE['comment_author_email_'. COOKIEHASH])) ? trim($_COOKIE['comment_author_email_'. COOKIEHASH]) : '';
$comment_author_url = (isset($_COOKIE['comment_author_url_'. COOKIEHASH])) ? trim($_COOKIE['comment_author_url_'. COOKIEHASH]) : '';
$comments = $wpdb->get_results("SELECT * FROM $wpdb->comments WHERE comment_post_ID = $id AND comment_approved = '1' ORDER BY comment_date");
$commentstatus = $wpdb->get_row("SELECT comment_status, post_password FROM $wpdb->posts WHERE ID = $id");
if (!empty($commentstatus->post_password) && $_COOKIE['wp-postpass_'. COOKIEHASH] != $commentstatus->post_password) { // and it doesn't match the cookie
echo(get_the_password_form());
} else { ?>

<?php if ($comments) { ?>
<ol id="commentlist">
<?php foreach ($comments as $comment) { ?>
<li id="comment-<?php comment_ID() ?>">
<?php comment_text() ?>
<p><cite><?php comment_type(__('Comment'), __('Trackback'), __('Pingback')); ?> <?php _e("by"); ?> <?php comment_author_link() ?> — <?php comment_date() ?> @ <a href="#comment-<?php comment_ID() ?>"><?php comment_time() ?></a></cite></p>
</li>

<?php } // end for each comment ?>
</ol>
<?php } else { // this is displayed if there are no comments so far ?>
<p><?php _e("No comments yet."); ?></p>
<?php } ?>

<?php if ('open' == $commentstatus->comment_status) { ?>
<h2><?php _e("Leave a comment"); ?></h2>
<p><?php _e("Line and paragraph breaks automatic, e-mail address never displayed, <acronym title=\"Hypertext Markup Language\">HTML</acronym> allowed:"); ?> <code><?php echo allowed_tags(); ?></code></p>

<form action="<?php echo get_settings('siteurl'); ?>/wp-comments-post.php" method="post" id="commentform">
<p>
<input type="text" name="author" id="author" class="textarea" value="<?php echo $comment_author; ?>" size="28" tabindex="1" />
<label for="author"><?php _e("Name"); ?></label>
<input type="hidden" name="comment_post_ID" value="<?php echo $id; ?>" />
<input type="hidden" name="redirect_to" value="<?php echo wp_specialchars($_SERVER["REQUEST_URI"]); ?>" />
</p>

<p>
<input type="text" name="email" id="email" value="<?php echo $comment_author_email; ?>" size="28" tabindex="2" />
<label for="email"><?php _e("E-mail"); ?></label>
</p>

<p>
<input type="text" name="url" id="url" value="<?php echo $comment_author_url; ?>" size="28" tabindex="3" />
<label for="url"><?php _e("<acronym title=\"Uniform Resource Identifier\">URI</acronym>"); ?></label>
</p>

<p>
<label for="comment"><?php _e("Your Comment"); ?></label>
<br />
<textarea name="comment" id="comment" cols="70" rows="4" tabindex="4"></textarea>
</p>

<p>
<input name="submit" type="submit" tabindex="5" value="<?php _e("Say It!"); ?>" />
</p>
<?php do_action('comment_form', $post->ID); ?>
</form>
<?php } else { // comments are closed ?>
<p><?php _e("Sorry, the comment form is closed at this time."); ?></p>
<?php }
} // end password check
?>

<div><strong><a href="javascript:window.close()"><?php _e("Close this window."); ?></a></strong></div>

<?php // if you delete this the sky will fall on your head
}
?>


<?php //} ?>
<p class="credit"><?php timer_stop(1); ?> <?php echo sprintf(__("<cite>Powered by <a href=\"http://wordpress.org\" title=\"%s\"><strong>Wordpress</strong></a></cite>"),__("Powered by WordPress, state-of-the-art semantic personal publishing platform.")); ?></p>
<?php // Seen at http://www.mijnkopthee.nl/log2/archi...3/05/28/esc(18) ?>
<script type="text/javascript">

</script>
</body>
</html>

Quote:

<?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"><?php _e("This post is password protected. Enter the password to view comments."); ?><p>

<?php
return;
}
}

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



<?php if ($comments) : ?>
<h3 id="comments"> <?php
#### Vbridge Replacement code for comments

if ($vbridge[id] > 0) {
?>
<div class="comments">
<?php
if(is_single()) {
if (is_array($vbridge[replies])) {
?>
<br /><br />
<h3 id="comments">Comments:</h3>
<ol class="commentlist">
<?php
foreach ($vbridge[replies] as $reply) {
?>

<li class="<?php echo $oddcomment; ?>" id="comment-<?php comment_ID() ?>">
<?php echo $vbridge[vb_parser]->do_parse($reply->pagetext, false, true); ?>
<small class="commentmetadata">
    <img src="<?php bloginfo('stylesheet_directory'); ?>/images/comment_arr.gif" alt="" />

by <cite> <a href=<?php echo get_option('vbb_VBURL') ?>/member.php?u=<?php echo $reply->userid ?>><?php echo $reply->username; ?></a></cite>
</small><br />
</li>

<?php /* Changes every other comment to a different class */
if ('alt' == $oddcomment) $oddcomment = '';
else $oddcomment = 'alt';

}
}
?>
</ol>
<?php
}
?>
<a href=<?php echo get_option('vbb_VBURL') ?>/showthread.php?t=<?php echo $vbridge[id] ?>>(<?php echo intval($vbridge[count]) ?>) comments</a> | <a href=<?php echo get_option('vbb_VBURL') ?>/newreply.php?do=newreply&noquote=1&t=<?php echo $vbridge[id] ?>>Add your comments</a>
</div>
<?php
}
##End Vbridge Replacement
?>op “<?php the_title(); ?>”</h3>

<ol class="commentlist">

<?php foreach ($comments as $comment) : ?>

<li class="<?php echo $oddcomment; ?>" id="comment-<?php comment_ID() ?>">
<cite><?php
if ($vbridge[id] > 0) {
?>
<a href=<?php echo get_option('vbb_VBURL') ?>/member.php?u=<?php echo $vbridge[thread_starter] ?>><?php the_author() ?></a>

<?php
}
else {
the_author();
}
?></cite> zegt:
<?php if ($comment->comment_approved == '0') : ?>
<em>Uw reactie wacht op goedkeuring.</em>
<?php endif; ?>
<br />

<small class="commentmetadata"><a href="#comment-<?php comment_ID() ?>" title=""><?php the_date() ?> om <?php comment_time() ?></a> <?php edit_comment_link('e','',''); ?></small>

<?php comment_text() ?>

</li>

<?php /* Changes every other comment to a different class */
if ('alt' == $oddcomment) $oddcomment = '';
else $oddcomment = 'alt';
?>

<?php endforeach; /* end for each comment */ ?>

</ol>

<?php else : // this is displayed if there are no comments so far ?>

<?php if ('open' == $post-> comment_status) : ?>


<?php else : // comments are closed ?>

<p class="nocomments">Reacties zijn gesloten.</p>

<?php endif; ?>
<?php endif; ?>

<?php if ('open' == $post-> comment_status) : ?>

<h3 id="respond">Laat een reactie achter</h3>

<?php if ( get_option('comment_registration') && !$user_ID ) : ?>
<p>Je moet <a href="<?php echo get_option('siteurl'); ?>/wp-login.php?redirect_to=<?php the_permalink(); ?>">ingelogd</a> zijn om een reactie te plaatsen.</p>
<?php else : ?>

<form action="<?php echo get_option('siteurl'); ?>/wp-comments-post.php" method="post" id="commentform">

<?php if ( $user_ID ) : ?>

<p>Ingelogd als <a href="<?php echo get_option('siteurl'); ?>/wp-admin/profile.php"><?php echo $user_identity; ?></a>. <a href="<?php echo get_option('siteurl'); ?>/wp-login.php?action=logout" title="<?php _e('Log out of this account') ?>">Uitloggen »</a></p>

<?php else : ?>

<p><input type="text" name="author" id="author" value="<?php echo $comment_author; ?>" size="22" tabindex="1" />
<label for="author"><small><?php _e('Name')?> <?php if ($req) _e('(required)'); ?></small></label></p>

<p><input type="text" name="email" id="email" value="<?php echo $comment_author_email; ?>" size="22" tabindex="2" />
<label for="email"><small>Email (wordt niet gepubliceerd) <?php if ($req) _e('(required)'); ?></small></label></p>

<p><input type="text" name="url" id="url" value="<?php echo $comment_author_url; ?>" size="22" tabindex="3" />
<label for="url"><small>Website</small></label></p>

<?php endif; ?>



<p><textarea name="comment" id="comment" cols="100%" rows="10" tabindex="4"></textarea></p>

<p><input name="submit" type="submit" id="submit" tabindex="5" value="Verstuur reactie" />
<input type="hidden" name="comment_post_ID" value="<?php echo $id; ?>" />
</p>
<?php do_action('comment_form', $post->ID); ?>

</form>

<?php endif; // If registration required and not logged in ?>

<?php endif; // if you delete this the sky will fall on your head ?>

It will not be in comments.php.. It depends on the theme you have. Generally, they reside in the index.php, single.php, and page.php files (some themes do not have single.php or page.php)

Quote:

Originally Posted by miloheckport (Post 1180457)

I am getting the following error

Code:

WordPress database error: [Unknown column 'vb_threadid' in 'field list']

UPDATE wp_posts set vb_threadid = 3082 WHERE ID = 5





Warning: Cannot modify header information - headers already sent by (output started

Anyone have an idea why this could be happening?

I do not think it will work with a sub domain sorry.

EDIT -

Although it may if you follow this part of the directions in the lead thread:

I did the best I could in determining your forums file path with the script. There may be certain script setups that cannot find the file path properly, in which case you may get errors that the script cannot find or open /config.php. If this is the case, please HARDCODE your ABSOLUTE path to the forum in vbridge.php.

To do this find all instances of,

Code:

chdir($_SERVER['DOCUMENT_ROOT'] . get_option('vbb_VBRPATH'));

And replace the code with:

Code:

chdir('/your/absolute/path/tothe/vbulletin/directory');

Obviously, change the path to your absolute FILE (not URL) path.

When I write to the blog in WordPress I get the error but the post in my forum does get created that is why I thought it was something in my WordPress VBBridge configuration. I was really stoked and feel like it is close to working..

Here is the entire error output

WordPress database error: [Unknown column 'vb_threadid' in 'field list']
UPDATE wp_posts set vb_threadid = 3091 WHERE ID = 7

Warning: Cannot modify header information - headers already sent by (output started at /home/.dahliadryer/scsp/discussion.socalskateparks.com/news/wp-includes/wp-db.php:121) in /news/wp-includes/pluggable.php on line 275

It sounds to me like the activation did not take affect. Are you sure your using the 2.05 version of this plugin?

I have 2.05 installed. I did try making the change to vbridge.php but still got the same error.

The error is there because the table was not created which makes me wonder if you activated it correctly? You will need to deactivate and activate the plugin. The vb_threadid column is created upon activation.

I deactived the plugin and then activated it and still the same problem . I checked the table and the column was not created. Should I add the column manually?

I added the column and all is good..

I know that there are some issues with the activate/deactivate method in WP. I was hoping it was addressed in 2.1 but maybe not. The problem is, it uses AJAX when you click the activation. Sometimes the method caches so the script is never actually run. Anyway, glad you got it working.

Thanks for your help and now I just need to work on the wordpress templates and import all of my old CuteNews into WordPress. I must say VBulletin has to be one of the best software products out there and thanks to people like you it gets better and better...

Quote:

Originally Posted by miloheckport (Post 1181241)

Great! Now click install ;)

This mod looks GREAT!

I was about to go with Expression Engine for one of my new sites, and was kind of bummed about it since it doesn't integrate with VB, but after seeing this mod, I'm re-thinking things.

Nice work!

Hey there. I am using VB 362 , wp 2.1 and the newest release of your mod. I am just trying to share users between vb and wp. I installed the plug in, and went to adjust the forum info (even though I dont want it for the comments feature). I didn't test it and turned on auto integrate. as soon as I did that, every page I go to is blank in WP. I removed the mod and it works fine again. I put the mod back in and all pages are blank. Any idea where I went wrong? Thanks!

Jamie

Yeah, you turned auto-integrate on... I am not sure how more clear I could have made it that to NOT do that until you test it. ;)

Ok, my first question would be, can you edit your MySQL tables manually?

Quote:

Originally Posted by Jafo232 (Post 1181694)

Yes...I am bad at reading directions ;) . I just wanted to use the user sharing so I figured it wasn't necessary. I can edit the tables.

Ok, open the wp-options table and find the option with the option name vbb_VBION. Make the option value (in the option_value column) 0. So set the option to the number zero.

Activate the plugin, and TEST before you auto-integrate.

Quote:

Originally Posted by Jafo232 (Post 1181705)

I got it fixed but now when I do a test post and click publish it just goes to a blank page...Any ideas?

When I deactivate the mod and do a test post it works. I am not sure where the issue is. Thanks again!

Quote:

Originally Posted by jglass38 (Post 1181755)

When I deactivate the mod and do a test post it works. I am not sure where the issue is. Thanks again!

Umm, so it is working?

Quote:

Originally Posted by Jafo232 (Post 1181779)

Umm, so it is working?

It is not. When the mod is enabled and I try to do a test post, it just goes to a blank page and no post is made. With the mod disabled it works fine.

When I reenabled the mod just now at the top of the page I see:

WordPress database error: [Duplicate column name 'vb_threadid']
ALTER TABLE wp_posts ADD vb_threadid INT(10)

Quote:

Originally Posted by jglass38 (Post 1181831)

It seems like people were having the same problem with the other mod that you based this on. I didn't see that there was ever a resolution to the problem. I assume its not finding the vbulletin forum to make the post but I looked through all the config and everything looks good.

Quote:

Originally Posted by jglass38 (Post 1181940)

The error is normal when you activate, deactivate, then re-activate. Means nothing.

I think the issue here is, you did not enter the correct setting under the options.

Quote:

Originally Posted by Jafo232 (Post 1181948)

The error is normal when you activate, deactivate, then re-activate. Means nothing.

I think the issue here is, you did not enter the correct setting under the options.

Can you point me in the right direction? For VB User ID I have Id 1 which is the administrator account. For VB username I have administrator. For VB forum ID i have the id of the forum I want as the default (6). For url I have http://domain.com/forum (have also tried it with just http://domain.com and for relative path /forum . Database prefix is empty per the config.php file. Auto integrate is off, post to forum is on.

There may be a more descriptive error message in your servers error log.

Quote:

Originally Posted by Jafo232 (Post 1181952)

There may be a more descriptive error message in your servers error log.

Where would I find that? Its a virtual hosted server.

I am also curious how it would post to a forum without authentication of some type. The forum is locked down to just administrators posting.

Quote:

Originally Posted by jglass38 (Post 1181953)

Where would I find that? Its a virtual hosted server.

I am not sure, it depends on the host. Many hosts give you access to the error logs via a control panel. Some give you direct access (example, linux running apache: /var/log/httpd/error_log).

Just to follow up on the issue jglass38 was having. We tinkered with it via IM and found out the issue was because his forum was locked down tight to not allow anyone except admins and moderators in. Unregistered users need to be able to at least see the forum home page. If your forum goes right to the login page from your index.php page, then this plug-in will not work.

Edited his permission scheme, and all seemed to work out.

Quote:

Originally Posted by Jafo232 (Post 1182031)

I can't say enough about how great Jafo was to work with me on this through IM last night. He went above and beyond! Great mod and great coder! Thanks again...

Jamie

it's not working in 3.6.0 !!

when I login to my WP admin page, it goes automatically to my forum ..

It's really a GREAT plugin ..

Please,, any helps?

Quote:

Originally Posted by X Quiz (Post 1183235)

it's not working in 3.6.0 !!

when I login to my WP admin page, it goes automatically to my forum ..

It's really a GREAT plugin ..

Please,, any helps?

Well first thing I would say is, upgrade to 3.6.4, your vulnerable.

Second, you don't login to the wp admin page. You login via the forum.

Then you go to the wp-admin index page. Some servers may require that you check the remember me box depending on how they handle sessions.

I have been messing with this tonight, attempting to get it to work with subdomains (changing all the paths in vbbridge.php to the actual path to my site). I only want to use the mod for user integration. I am also trying this out on WordPress MU, so that might be where the error is coming into play. But I figured I'd post just to see if maybe there is just something else I am missing that might be a relatively easy fix... Here is the error I am receiving:

Quote:

Fatal error: Cannot redeclare update_category_cache() (previously declared in /home/*****/*****/members.60degreev6.com/wp-includes/functions.php:593) in /home/*****/*****/60degreev6.com/includes/functions_gallery.php on line 682

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02565 seconds Memory Usage 1,906KB 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 (5)bbcode_code_printable (20)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (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: