Major Additions - Joomla for vBulletin (IMPORTANT UPDATE) - Bridge to the World's Most Popular CMS

Warning!!! An potential exploit has been found in this modification. The server that hosts vjoomla.com has been attacked several times. It is known to already be severely comprimised so at this time it is unclear whether the vulnerability lies in vJoomla, Joomla itself or the server. Until this is resolved to my satisfaction I am removing this modification. My apologies.


The modification WILL be re-released once this issue is resolved!

vJoomla is an offshoot of Joomla 1.0 that is designed to run in tandem with vbulletin. Unlike the main release it will not run without vbulletin - if you desire a CMS without a forum then use Joomla! instead. vJoomla is identical in most all regards to Joomla!

What vJoomla Does

• Provide a single session, single login interface to Joomla and vbulletin.
• Allows Joomla pages to be skinned by vbulletin's template engine.
• Maps Joomla usergroups to vbulletin usergroups.

What vJoomla Does Not Do

• It does not rewrite your templates for you - so you will need to go in currently and change relative links to images and pages to absolute links. This is most important in the style sheets and in the navbar template. This is something you need to do yourself rather than programmatically since no two sites are likely to be using the same style sheet and the same setup for these links.

Install Instructions

1. Log into your admincp
2. Close your forum
3. If your forums are at the root of your site move them elsewhere - the best location is probably /forum
4. Upload the files from the zip packages to their respective locations. There should be no overwrites.
5. Navigate to the root of your site and run the Joomla installer.
6. Go back to the admincp and install the Joomla product file
7. Now either copy the ./cpstyles, ./clientscript and ./images directory of the forum into the Joomla directory OR create symbolic links to those directories. The contents of the ./images directory of Joomla and vbulletin will need to be merged.

This is release candidate 2.

[ThreeD]

Michael, I hope you know that you will become a legend in the joomla/vbulletin communities when this is final!

[AK47 Nemesis]

Hi, great hack! Probably one of the most wanted ever. I have one problem however so far (Installing this at the moment).

"Either create a symbolic link for images, clientscript and cpstyles in the site root, or copy the contents of those folders to the site root."

How do i create a symbolic link? Where do i place it? What does it do?
As for the other option: My site is www.teamqg.com, so if i place the images content in the root, will it look like this: www.teamqg.com/misc and www.teamqg.com/smilies, since i'm using a skin where the images folder consists out of multiple folders, where one is the default vbulletin one, with misc, buttons, etc.

And will the clientscript content be placed between the other files? Or: www.teamqg.com/clientscript?

One last thing: Does it have to be www.teamqg.com/forum? Since my vBulletin is located at www.teamqg.com/qg...

Thanks in advance,

Hans.

PS: Sorry for all the asking, but i'm kinda noob...

[Tanabe]

I'm willing to beta test it but still to cautious about the error handeling.

PRIVACY NOTICE: This module contains an error handler that will attempt to email vjoomla@gmail.com with a stack trace of the error. The purpose of this is to gather as much information as possible for debugging - a complete stack trace often includes far more information than the error lines that PHP normally displays. When this handler is triggered it also prints out the information it mailed to me on the screen. Any Information that is included as arguments could be passed as part of this stack trace, this can include potentially sensitive information such as database passwords if a database handling class encounters an error. If you wish to test this module and do not wish to have it emailing me with this data comment out line 106 in the file globals.php in the zip package.

This error handler will be removed when the product reaches final.

[AK47 Nemesis]

I did everything it said, replaced all the 'forum' in the files with 'qg', but i get this error:

Database error in vBulletin 3.6.7:

Invalid SQL:
UPDATE user SET joomla_registered = 1 WHERE userid = 1;

MySQL Error : Unknown column 'joomla_registered' in 'field list'
Error Number : 1054
Date : Sunday, May 20th 2007 @ 08:57:36 PM
Script : http://www.teamqg.com/index.php
Classname : vb_database

[Tanabe]

Originally Posted by AK47 Nemesis

I did everything it said, replaced all the 'forum' in the files with 'qg', but i get this error:

Database error in vBulletin 3.6.7:

Invalid SQL:
UPDATE user SET joomla_registered = 1 WHERE userid = 1;

MySQL Error : Unknown column 'joomla_registered' in 'field list'
Error Number : 1054
Date : Sunday, May 20th 2007 @ 08:57:36 PM
Script : http://www.teamqg.com/index.php
Classname : vb_database

Probably because in your config.php file you have the userid number 1 non changeable

[AK47 Nemesis]

That didn't work

Some more details of my setup:
www.teamqg.com = Joomla
www.teamqg.com/qg = vBulletin
vBulletin is in the same database as Joomla, but vBulletin doesn't have a prefix, while Joomla has.
vBulletin had to be located at /forum, which is /qg for me, so i changed all the files which contained /forum to /qg. It might be the vBulletin product which causes the error.

[Michael Morris]

Odd that it would miss that query. In the query manager run (off the top of my head)

ALTER TABLE user ADD 'joomla_registered' tinyint(1)

What this field is for joomla to keep track of which users it has copied (it saves a query on each page load) from vbulletin's user table.

[AK47 Nemesis]

Error:

#1064 - 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 ''joomla_registered' tinyint(1)' at line 1

[Michael Morris]

Try

ALTER TABLE `user` ADD `joomla_registered` TINYINT( 1 ) NOT NULL

[Mrdby]

lets see a demo