vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   vBulletin-WordPress Bridge (https://vborg.vbsupport.ru/showthread.php?t=94443)

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

Quote:

Originally Posted by fedoraforum
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

Quote:

Originally Posted by fedoraforum
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

Quote:

Originally Posted by Cheertobi

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

Quote:

Originally Posted by ScruffyDeluxe
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:

Code:

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

       
Quote:

       
       
               
       
       

                       

                       
                               

                                        Originally Posted by The Front Page
                                       
                               

                               
test

                       
                       

               

Read the full blog entry.', 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!


Quote:

Originally Posted by ScruffyDeluxe
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

Quote:

Originally Posted by bang
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:

Quote:


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

Quote:

Originally Posted by ScruffyDeluxe
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....&postcount=147 ?

chanzero 07-12-2006 10:41 PM

Quote:

Originally Posted by BLazeD1
Anyone that can help me with my error - https://vborg.vbsupport.ru/showpost....&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

Code:

$moreflag = strpos($content,'<!--more-->');
I then added the following to the vb3_settings.php file

Code:

$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....&postcount=137

selbmag 07-24-2006 02:06 PM

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

Code:

$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

Quote:

Originally Posted by selbmag
vb_threadid exists - everythign else works just this is the only problem.

i have the same problem...

BLazeD1 07-28-2006 10:29 PM

Quote:

Originally Posted by chanzero
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:
Quote:

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

<font color="Red">FIXED NOW, THANKS.</font>

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.


All times are GMT. The time now is 08:36 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03332 seconds
  • Memory Usage 1,834KB
  • 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
  • (4)bbcode_code_printable
  • (13)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete