Vbulletin Application Connector

Version 0.2
Bugfix: now it is posible to define active/inactive connectors
ADD: Changing userdata ( email and username )

Version 0.1
init Release

that this hack do?

with this hack you can connect other applications with vbulletin
this hack provide a simple api to create own module, to connect different application with vbulletin, and create common login with it

this addon is the same like com_connector for joomla

example:

you have an CMS or own created application and you want to have common login with vbulletin
so you must creat a class ( = module ) which knows some methods like login/logout
this methods will be called by the connector if the user login into VB
if you want the connector will try to add the user to your application or vbulletin, if the user dont exists
the connect to your application can be created by soap/xmlrpc calls, database connnects, ldap or something else, its your choose

for a little demo i have included a joomla module, which connects to joomla using SOAP calls to get common login with vbulletin ( needs JMSOAP addon for joomla )

demo is on my side: www.c4u.to

if you log in into joomla, you will be automaticaly logged in vbulletin, by com_connector hack for joomla ( which is using VB_SOAP on vbulletin side )
if you login into vbulletin, you will be automaticaly logged in into joomla, by this hack ( using JMSOAP addon on joomla side )

in the next version i will include functions to update/delete users


installation
1. unzip the package, move all files von vb_connector folder to your forumroot
2. install product xml file

the you have new menu in admincp to create connectors
it is posible to use one module more then once

howto create own modules: http://forum.joomla.org/index.php/to...html#msg131894

you can use this tutorial for joomla, difference with joomla is, that you will get all parameters as array, not as object, look at the joomla.class.php file in the package

[leonsio]

you must only remove users, if you update from vbridge

if not, skip this

now go to Connector administration and setup the module ( you must choose the "joomla sql" from the module list

[Langly]

I'm still getting this error if I try to login to vbulletin.

Parse error: parse error, unexpected '{' in /usr/home/domains/www/htdocs/forums/includes/connector/joomla.class.php on line 24

I don't have, nor have the ability to add php v5. Here is my hosts info:

Web Server:  Apache/1.3.33 (Unix) mod_ssl/2.8.22 OpenSSL/0.9.7g PHP/4.3.11

When I try to save in the connector administrator, it says it saves it then it goes to a page with this error on it:

Parse error: parse error, unexpected '{' in /usr/home/domains/www/htdocs/forums/includes/connector/joomla.class.php on line 24

[leonsio]

you are using the wrong module

you should choose "joomla sql" not joomla in the module list

[Langly]

Ok, here is what I did:
1. uploaded vb_connector files to forum directory into their correct directories.
2. uploaded joomla_sql.class.php to the forum root directory
3. added product-connector.xml into vbulletin product manager
4. went to vb connector menu to manage connections and the only option for module I was given was Joomla. Plus, I got an error about 'vbconnectors' table not being present in SQL. I just manually added that table.

What did I miss?

Thanks

[oojacoboo]

Ok, these instructions never end, very confusing. Nonetheless, I am trying to get this isntalled. I assume this is needed for the joomla com_connector to function properly..

I don't know what the install link at the top of the thread does, clueless!
I did everything Langly said above.
I tried to install the product in my vB install and I get the following SQL error...

Database error in vBulletin 3.5.3:

Invalid SQL:

CREATE TABLE IF NOT EXISTS `connectors` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(255) collate latin1_german1_ci default NULL,
`module` varchar(255) collate latin1_german1_ci NOT NULL default 'joomla',
`url` varchar(255) collate latin1_german1_ci NOT NULL default '',
`vb_useradd` tinyint(4) NOT NULL default '0',
`app_useradd` tinyint(4) NOT NULL default '0',
`params` text collate latin1_german1_ci,
`published` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`id`)
);

MySQL Error : 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 'collate latin1_german1_ci default NULL,
`module` varchar(255
Error Number : 1064
Date : Tuesday, January 31st 2006 @ 07:47:34 PM
Script : http://www.xxxxxx.com/forum/admincp/plugin.php
Referrer : http://www.xxxxcom/forum/admincp/plu...?do=productadd
IP Address : xx.xxx.xx.xxx
Username : xxxxxxx
Classname : vb_database

Do I need to run this query in phpmyadmin? When I reattempt I get a column for connectors already present in the user table. So, I removed that field and then I attempt again, and I get this error. Please advise.

What can I replace that with? I am using the following...

Web Server Apache v1.3.34
PHP 4.4.1
MySQL Version 4.0.26-standard

[Langly]

I got the same error as well so I just deleted the 'collate latin1_german1_ci' and that installed fine.

Well, installed fine up to the point where I am at the moment.

[oojacoboo]

langly, if you are using the sql module, you need to put it into the modules folder in your vb forum as well with the standard SOAP module.

Then install this module, not the standard one and be sure its configured properly. The SOAP one gnerates this error, b/c you don't have PHP5 and SOAP enabled on your server.

Thats what I did and everything appears to be working now. About to start working on my integration. I would love some profile integration, I know thats gonna be the roughest thing...

[Langly]

My vbulletin doesn't have a modules folder. My joomla does though. I do not have the ability to put SOAP on my host since they do not have php5. Only php4. I can put it on but it won't do anything.

[oojacoboo]

/forum/includes/connector, its not a modules folder. Sorry for the confusion.

[Langly]

Ok, got that done but when I click on Componants in Joomla all it does is sends me back to the main page in Joomla admin. If I go to menu manager and try to create a Componant link it sets that up. Then I go to my homepage and click on the link I just made and all it does is tell me I have chosen a page that is not there. I'm guessing I'm missing something in Joomla somewhere.