Integration with vBulletin - vBulletin PhpFoX Integration

This modification was brought to you by
KXDesign

http://www.kxdesign.com/

~Modification name
vBulletin PhpFoX Integration

~Modification description
This plugin allows you to integrate your PhpFoX site with vBulletin!

Original thread: http://forums.phpfox.com/showthread.php?t=22717

~Modification options

• Enable No avatar image?
• Main Menu Color
• Display country in profile?
• Display state?
• Use separate avatar for forum?
• Show age?

~Modification info
File uploads: 12
File edits: 0
Templates: 4
Template edits: 1
Plugins: 12
SQL Queries: 0
Phrases: 13
Settings: 6
Hooks: 0

Install time: 1 minute
Install level: Easy

~Modification installation

Step 1: Modify .htaccess file

This step is for those that installed phpFoX Konsort with the Rewrite mode enabled. With your FTP client or hosts file manager navigate to your phpFoX websites root directory.

Open the file .htaccess. It should look something like this (Note: The example below is not an exact replica of how your .htaccess file will look like, we are mainly focusing on the RewriteCond):

RewriteEngine On
 
RewriteCond %{REQUEST_URI} !^/file/.*
RewriteCond %{REQUEST_URI} !^/install/.*
RewriteCond %{REQUEST_URI} !^/design/.*
RewriteCond %{REQUEST_URI} !^/plugins/.*
RewriteRule ^index.php(/.*)$ /index.php?do=$1 [L]
 
RewriteCond %{REQUEST_URI} !^/file/.*
RewriteCond %{REQUEST_URI} !^/install/.*
RewriteCond %{REQUEST_URI} !^/design/.*
RewriteCond %{REQUEST_URI} !^/plugins/.*
RewriteCond %{REQUEST_URI} !^/index.php
RewriteCond %{REQUEST_URI} !^/robots.txt
RewriteCond %{REQUEST_URI} !^/favicon.ico
RewriteRule ^(.*)$ /index.php?do=/$1 [L]

To get this plug-in properly working you will have to add the following line of code twice in the .htaccess file above each of the RewriteRule inserts:

RewriteCond %{REQUEST_URI} !^/forums/.*

Your .htaccess file would then look like:

RewriteEngine On
 
RewriteCond %{REQUEST_URI} !^/file/.*
RewriteCond %{REQUEST_URI} !^/install/.*
RewriteCond %{REQUEST_URI} !^/design/.*
RewriteCond %{REQUEST_URI} !^/plugins/.*
RewriteCond %{REQUEST_URI} !^/forums/.*
RewriteRule ^index.php(/.*)$ /index.php?do=$1 [L]
 
RewriteCond %{REQUEST_URI} !^/file/.*
RewriteCond %{REQUEST_URI} !^/install/.*
RewriteCond %{REQUEST_URI} !^/design/.*
RewriteCond %{REQUEST_URI} !^/plugins/.*
RewriteCond %{REQUEST_URI} !^/index.php
RewriteCond %{REQUEST_URI} !^/robots.txt
RewriteCond %{REQUEST_URI} !^/favicon.ico
RewriteCond %{REQUEST_URI} !^/forums/.*
RewriteRule ^(.*)$ /index.php?do=/$1 [L]

Step 2: Install vBulletin

Our first step will be to install vBulletin. We can not go into great detail on how to install vBulletin, however you can check out their great documentation here.Before you attempt to install vBulletin there are some factors you will need to take note of:

* When you upload their product it must be placed in a folder and the name of the folder must be forums. This folder must be placed in your phpFoX websites root directory. Proper layout would be: http:///www.yoursite.com/forums/
* The vBulletin tables must be placed in the same database as phpFoX.
* phpFoX should be installed with a database table prefix. By default this prefix is phpfox_. If you did not install phpFoX with a table prefix you will have to install vBulletin with a table prefix.
* This plug-in was not developed to work under a sub-domain environment yet,for that you have to wait for v3. (Example: http://forums.yoursite.com/)
* During the install of vBulletin you will be asked to add an Admin User. This user will shortly be deleted by our integration and replaced with your main phpFoX Admin account.

Step 3: Edit config.php file.

Edit the config.php file in the vbulletin folder and change the name from forums to whatever the vBulletin subfolder is called in the PhpFoX directory.

Step 4: File uploads

Upload the whole vbulletin folder to the phpFoX plugins folder.

Step 5: Importing

Notice: Read this step thoroughly before attempting to import any data.

For those that already have phpFoX running and just installed vBulletin you will have to do the step Import phpFoX Users.

For those that already have vBulletin running and just installed phpFoX you will have to do the step Import vBulletin Users.

Import phpFoX Users
Run the import file through your web browser by entering the URL into your browser address bar (if you have followed our example, type in http://www.domain.com/plugins/vbulle...all/import.php, naturally substituting 'domain.com' for your web address.)

Import vBulletin Users
Run the import file through your web browser by entering the URL into your browser address bar (if you have followed our example, type in http://www.domain.com/plugins/vbulle.../vb_import.php, naturally substituting 'domain.com' for your web address.)

Step 6: Integration and edits

Now lets log into your vBulletin Admin control panel. Note that it will not work to log into your site using the phpFoX login forum. You will have to use the vBulletin login form. (Example: http://www.yoursite.com/forums/index.php). Note that you will need to log into vBulletin with your phpFoX Admin account, which is the same account you log into your phpFoX site.

Follow the next steps below:

Update Forums Cache

Go to: Forums & Moderators >> Forum Manager >> Then edit the forum called Main Category. Save that forum without making any changes.

Update Forums Counters

Go to: Maintenance >> Update Counters Then rebuild the following:

Rebuild Thread Information

and

Rebuild Forum Information

Enable Plug-In System

Go to: vBulletin Options >> vBulletin Options >> Plugin/Hook System

Change the setting:

Enable Plugin/Hook System

To Yes

Importing the plugin

Go to: Plugins & Products >> Manage Products >> Add/Import Product

Look for the block Import Product and then for EITHER upload the XML file from your computer browse for the XML file product-konsort.xml which was part of the package you downloaded from phpFoX. Then click on the import button.

Template edit (Optional)

Go to: Styles & Templates >> Style Manager >> Edit Template (on all your styles) >> Open template header

Remove the part of code between the logo comments.


~Modification changelog

• 2.5.0 - First vB.org Release
• 2.5.1 -
  1. Remember me fix,could not login if remember wasn't checked
  2. vb_import.php fixed if you didn't prefix vBulletin
  3. Remember me now is integrated as well
  4. Option install steps updated
  5. Spacers are now not overwritten
  6. Overall import files are neater
  7. Logging in was remade completely,we god rid of the login.php

~Modification copyright
This may not be distributed,released or claimed as your work without author's permission.

[remyline]

I keep trying this and it tells me:

Step 2) Connect to the database

Attempting to attach to database

Connection succeeded! The database already exists.

You have already installed vBulletin; do you wish to upgrade?
Click here if you would like to see options for clearing the existing contents of your database.

I haven't installed VBulletin. Is there any VBulletin tables that have the same name as PHPFOX has?

[remyline]

Have done this before without any problems. This time tho on Godady servers. VBulletin 3.8.5 Phpfox 1.6.21 and ZIkis Plugin 2.5.1

This is the error it shows:

Database error in vBulletin :

Invalid SQL:

SELECT *
FROM phpfox_datastore
WHERE title IN ('','options','bitfields','attachmentcache','forum cache','usergroupcache','stylecache','languagecach e','products',
'pluginlist','cron','profilefield','loadcache','no ticecache','userstats','birthdaycache','maxloggedi n','iconcache','eventcache','mailqueue');

MySQL Error : Table 'bigfabepits.phpfox_datastore' doesn't exist
Error Number : 1146
Request Date : Thursday, March 11th 2010 @ 11:55:04 AM
Error Date : Thursday, March 11th 2010 @ 11:55:04 AM
Script : http://www.mysite.com/forums/
Referrer :
IP Address : 66.249.71.237
Username :
Classname : vB_Database
MySQL Version :

[Verionia]

Will this work with vbulletin 4.0?

[AllinJac]

Originally Posted by mykkal

Ziki,

I installed facebook connect which actually doesn't interfere with vbulletin or facebook. But it doesn't create the facebook users for phpfox. Only in vbulletin.

I need help fixing this. I noticed you asked that we come to you for any plugins that use or affect the login process.

It's a great plugin. https://vborg.vbsupport.ru/showthread.php?t=198499
How do I fix this so that the users are created in phpfox as well as vbulletin? Especially because the vbulletin/phpfox integration plugin uses vbulletin to authenticate.
_____________

@Mykal...

Are you having any problems with Facebook Connect?

I was using it an had a hard time with it as it was real buggy...

I just switched to YAFB Yet Another Facebook Bridge and wow is it sooooo much better.

You can actually INVITE your facebook friends right from the USER CP!!!

Check it out I am sure you will be glad you did!

EDIT:

By the way if you are running 3.8.x you can still use the 4.0 Version of YAFB as it works on both 4.0 and 3.8.x

[Mark Fortune]

Does this mod make sense to add to VB4? I think VB4 accomplishes everything that phpfox does and more. You'll have a lot of redundancy.

[AllinJac]

Originally Posted by Mark Fortune

Does this mod make sense to add to VB4? I think VB4 accomplishes everything that phpfox does and more. You'll have a lot of redundancy.

That would actually be neat if someone had the time to do this..

Go over what features and abilities that PHPFox has:

VS.

vBulletin 4.2x

See if it does make sense or not for everyone...

Thanks!

[CrystaStarLight]

Originally Posted by AllinJac

That would actually be neat if someone had the time to do this..

Go over what features and abilities that PHPFox has:

VS.

vBulletin 4.2x

See if it does make sense or not for everyone...

Thanks!

I haven't seen the ability to customize profiles like PHP Fox has. They have the ability to change almost every part of the page to a different color of background picture, and for people to pick which modules they want on their profile page, and to be able to move the modules around. If their is a Vb mod for that I'd like to know.

[FRANKTHETANK 2]

ok i have installed this. or tried to 6 times for far, and no matter what i do, it wont work. whats does this code mean and what should i try?Im trying to run the import.

Warning: require_once(../../../forums/includes/config.php) [function.require-once]: failed to open stream: No such file or directory in /home/;;;;;;/public_html/#####/plugin/vbulletin/install/import.php on line 9

Fatal error: require_once() [function.require]: Failed opening required '../../../forums/includes/config.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/#####/public_html/include/plugin/vbulletin/install/import.php on line 9

[randy17875]

Originally Posted by Extreme24

When I try to login through the forums I get the following Firefox error:



Actually the same thing happens when I login through phpFox.

I'm seeing this same error and though a link was provided to solve this in this thread, there seems to be no access to the info at the link. Was this problem ever solved?

[randy17875]

Originally Posted by FRANKTHETANK 2

ok i have installed this. or tried to 6 times for far, and no matter what i do, it wont work. whats does this code mean and what should i try?Im trying to run the import.

Warning: require_once(../../../forums/includes/config.php) [function.require-once]: failed to open stream: No such file or directory in /home/;;;;;;/public_html/#####/plugin/vbulletin/install/import.php on line 9

Fatal error: require_once() [function.require]: Failed opening required '../../../forums/includes/config.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/#####/public_html/include/plugin/vbulletin/install/import.php on line 9

Dunno if you solved this or not, but I would guess that you are installing with the short URL enabled tru Phpfox. Saw the same issue and resolved it by turning off short url's until I completed that step.