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.

[Anyoldname]

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

I definitely did these. Will it hurt if I do them again now?

[Ziki]

I guess no.

[Anyoldname]

Thanks for the reply, I tried them all again, but nothing has changed, still only one user.. Me.
Also, I notice that if I view last post right from the forum index, the thread will still be marked as unread unless I access it by going to the forum, then clicking on the thread title.

Edit: it just updated itself after somebody logged in. Seems to be ok now

[Anyoldname]

Sorry, ignore the edit above, I spoke too soon.
I have to do those last installation steps again every time somebody new registers otherwise the forum stats won't pick them up, and they will still only be picked up after they next login.
The issues in post #9 remain with every new user & every new post until I rebuild the forum counters & thread informaion.

[hollosch]

phpfox2 is in alpha - will this add-on be compatible to this new version, when it's stable ?

[Ziki]

No this is only compatible with 1.6.A version for v2 will be made later.

@Anyoldname

Then enable the plugin on forumhome_complete.It should be listed in more info in Readme,

[Anyoldname]

Brilliant, thanks Ziki! The last registered user now shows. However new posts remain marked unread as new unless you access them by first going to the forum, then clicking the thread title. Looks like a cookies problem, but I can't figure out what it could be.

Edit: Although the latest user is showing correctly, the counter still shows only 4 registered members, when there are now 7.

[Ziki]

Well you can replace the entire content of that plugins with this (from the 2.0.3 version) but it is deprecated code but should fix the problem:

$totalQuery = mysql_query("SELECT COUNT(*) AS count FROM `". App::getT('user') ."`");
$totalFetch = mysql_fetch_array($totalQuery);
$numbermembers = $totalFetch['count'];

$userQuery = mysql_query("SELECT `user`,`id` FROM `". App::getT('user') ."` ORDER BY `signup` DESC");
$userFetch = mysql_fetch_array($userQuery);
$newusername = $userFetch['user'];

$newuserid = $userFetch['id'];

$oSrvLog = &App::getModuleService('Log', 'Log');
$aItem = $oSrvLog->getSiteStat();
$numberregistered = $aItem['online_member'];
$numberguest = ($aItem['online_all']-$aItem['online_member']);
$totalonline = $aItem['online_all'];

Btw what phpfox version are you using?

[Anyoldname]

Great, I'll give that a try. I'm using the latest 2.1.6 phpFox with VB 3.8.0

Many thanks for your help, very much appreciated.

[Anyoldname]

Hi, sorry which file to I put this code into?