PDA

View Full Version : Vbulletin Application Connector


leonsio
12-15-2005, 10:00 PM
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/topic,21066.msg131894.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

nexialys
12-16-2005, 11:42 AM
good thing, a bridge for logins...

i hope to see a lot of guys releasing addons/connectors soon, so we proove this tool is useful to all!

SLGR
12-16-2005, 12:50 PM
Ηello Leonsio.
Can this work with paFileDB 3?

leonsio
12-16-2005, 12:56 PM
i dont know what paFileDB is and how it works

but the connector should work with all applications which are using cookie based user authentification

if paFileDB use cookie to authentificate ( login ) user, it should work with this connector

( but you must write own module for paFileDB )

croportal
12-16-2005, 02:40 PM
hello i am using xoops. see on my site www.croportal.net

can i make the login for xoops and vbulletin

leonsio
12-16-2005, 02:45 PM
yes it is posible
you must only make module for it
next week i will release an sql based module for joomla
you can take it as example for xoops ( you must chane sql statements )

Acers
12-16-2005, 03:18 PM
looking forward to this :)

Lionel
12-16-2005, 09:39 PM
Does the SOAP work only with PHP 5?

nitro
12-16-2005, 10:28 PM
Jinzora would be a great app to connect vb to. Not sure if I have enough knowledge to create the module to do so. Still has to be worth trying sometime. It looks very interesting.

fluentdesigns
12-17-2005, 12:33 AM
Anyone interested in connecting this to CRE Loaded (oscommerce with multiple contributions pre installed) ?

Lionel
12-17-2005, 03:57 AM
When trying to add the module



Parse error: parse error in /var/www/forums/includes/connector/joomla.class.php on line 25

Warning: Invalid argument supplied for foreach() in /admincp/connector.php on line 196

silurius
12-17-2005, 06:43 PM
Excellent hack idea! *Installed*

I will tip anyone who is willing to help me bridge to Tribe.net, MediaWiki, other vB sites, Infopop and PHPBB (ranked in that order).

The only catch would be, make the code available in this thread for all to enjoy. :)

It would also be great to maintain a running list in this thread of what bridges have and haven't worked, or something.

bashy
12-18-2005, 12:15 PM
Hi

I have installed this, but i get this at the top of my site ?> also i cannot find the product in Product Manager to remove this, any ideas?

Bashy

Tidy
12-18-2005, 09:30 PM
Hey, Can this Work for osCommerce? Thanks

Xtrato
12-18-2005, 11:34 PM
What about Php-Nuke?

leonsio
12-19-2005, 07:23 AM
When trying to add the module



Parse error: parse error in /var/www/forums/includes/connector/joomla.class.php on line 25

Warning: Invalid argument supplied for foreach() in /admincp/connector.php on line 196



the joomla.class.php works only if you use php5

php4 - sql - based joomla module will be released this week

i have allreade created some modules for phpbb/wbblite
this modules are for joomla, but i will port then to vbulletin

leonsio
12-20-2005, 01:22 PM
ups i have found one bug in the application

all modules will be set to inactive after addition


ALTER TABLE `PREFIXconnectors` CHANGE `published` `published` TINYINT( 4 ) DEFAULT '1' NOT NULL


please run this query, after it if you adds a module it will be active

i will fix this bug in the next release



new module added:

joomla_sql

with this module you can connect to joomla over DB-Connects ( also like vbridge )

just download the zip file in the first post and unzip it into /includes/connectors folder

this module supports common login and user synchronisation ( by login )

for the way joomla->vbulletin you must install this component in joomla site
http://forum.joomla.org/index.php/topic,21066.0.html

monodax
01-02-2006, 06:06 PM
Is this possible to use for calling from ASP.NET?
My server is running PHP Version 4.4.0 and my goal is to be able to use the existing user information stored in the VBulletin database on the ASP.NET site obviously which is on a different server.

monotreme
01-03-2006, 09:38 PM
your forum page is works but your main site is unavailable. Please pm me when your main site isb ack so I cn see this hack it looks very interesting to me

SimonVlc
01-05-2006, 11:45 AM
Anyone tried to do this to connect with a Drupal system? Is it possible?

Thanks, Simon.

joomlamoves
01-19-2006, 11:01 AM
hi leonsio

another forum, another thread!!! if i can get this working (and add some CB and LDAP hacks) i wouldn't mind slapping all of this in one place (like joomla forge?).

anyways, the logout of the connector is a little buggy, i get:

Warning: Invalid argument supplied for foreach() in /includes/connector/joomla.class.php on line 107

also, I had to manually set "published" in vb_connector table to 1....

it doesn't log me out either. it DOES log me into joomla if i login to vbulletin.

i will test more on the user updates on each side, as well as useradd.
i need all of this working before i attempt to integrate ldap / cb hacks..

thanks for all your help so far, greatly appreciated....!

leonsio
01-19-2006, 11:06 AM
userdata changes from vbulletin side are not supported by this version

the update will be released this/next week

leonsio
01-20-2006, 01:35 PM
*update*

version 0.2 is online

now it is posible do make connectors enabled/disabled

options to change username/email added

password will be added later, by update of the plugin

joomla (soap) module updated
now it is posible to change username/email and it will be changed in joomla too

joomlamoves
01-20-2006, 04:25 PM
*update*

version 0.2 is online

now it is posible do make connectors enabled/disabled

options to change username/email added

password will be added later, by update of the plugin

joomla (soap) module updated
now it is posible to change username/email and it will be changed in joomla too

I have installed both updates and tested. works great!!! thanks again.

Masiello
01-27-2006, 02:08 PM
EDIT: when the next release module for php4?

Question, not about XOOPS Integration?

leonsio
01-29-2006, 10:47 AM
next release is ~Monday, the actual php4 module is a little bit buggy
it works only if VB and joomla are in the same DB

leonsio
01-30-2006, 11:05 AM
joomla_sql module updated

if you have problems with this module, try to enable ( or disable ) the persistente connection ( mysql ) in your config.php

this should fix the problem, if joomla and vbulletin are in different databases

Langly
01-31-2006, 04:23 AM
I try to import product-connector.xml from the vbulletin Import Product menu. It gives errors when I try to use Connector Administration and save something.

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

BTW, for the URL under that same menu do I use the URL to direct to my mainpage of my site, my forums, my registration or what?

Another thing, when I try to logout my forums it brings me to a page with this error:

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

leonsio
01-31-2006, 05:34 AM
if you dont have php5 installed, you should use joomla_sql module not joomla module

the URL ist the url to joomla ( siteURL in the joomla configuration )

Langly
01-31-2006, 06:03 AM
Ok, I've edited the joomla_sql file and uploaded it to my forum root directory. What do I do next for it to show up and work?

BTW, when you said to remove the users from the Joomla user table, were we also supposed to remove the users from vbulletin user table as well? My Joomla now has 1 user while my vbulletin has 86 users. I deleted them from the vbulletin user table but they are still there.

leonsio
01-31-2006, 06:13 AM
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
01-31-2006, 06:28 AM
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
01-31-2006, 07:36 AM
you are using the wrong module

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

Langly
01-31-2006, 02:41 PM
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
01-31-2006, 05:53 PM
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/plugin.php?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
01-31-2006, 06:15 PM
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
01-31-2006, 06:50 PM
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
01-31-2006, 08:04 PM
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
01-31-2006, 08:05 PM
/forum/includes/connector, its not a modules folder. Sorry for the confusion.

Langly
01-31-2006, 08:50 PM
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.

vietkieu_cz
02-01-2006, 09:14 AM
I've the same problem:
Database error in vBulletin 3.5.3:

Invalid SQL:
ALTER TABLE user ADD `connector_cookies` TEXT NULL;

MySQL Error : Duplicate column name 'connector_cookies'
Error Number : 1060
Date : Wednesday, February 1st 2006 @ 12:13:18 PM
Script : http://localhost/upload/admincp/plugin.php
Referrer : http://localhost/upload/admincp/plugin.php?do=productadd
IP Address : 127.0.0.1
Username : xxx
Classname : vb_database

Can you help me?

Akagi
02-02-2006, 05:26 AM
I've the same problem:


Can you help me?

same, i've got the exact same problem too.
my vb and joomla uses 2 seperate database. using php4

oojacoboo
02-02-2006, 07:42 AM
remove that latin german bit from the xml file then remove the fields that were created in the db and reinstall.

Akagi
02-02-2006, 09:17 AM
i've made the changes to the xml file..

attached is the xml that i imported. it worked indeed.

however, it doesn't seem to have the common login. I can't login to my newly setup joomla using my vbulletin username and password.

What have i done wrong?

For the connector in both joomla and vbulletin, am I supposed to choose add users to app + vbulletin/joomla?

leonsio
02-02-2006, 05:20 PM
the URL to the joomla must be the same that you have added in joomla configuration als path to your joomla installation

its actual a little problem under php4 if joomla and vbulletin are in different databases
i will fix it this weekend

Langly
02-02-2006, 08:54 PM
I did a fresh install of joomla and vbulletin, then:


1. uploaded vb_connector files to forum directory into their correct directories.
2. uploaded joomla_sql.class.php to /forums/includes/connector/ directory
3. added product-connector.xml into vbulletin product manager
4. went to vb connector menu to manage connections and used joomla_sql as the module.
5. I typed in the appropriate server info for the next screen.
6. Saved.


What now? I don't see how joomla knows vbulletin is even there. How do I get the two to start adding users to each other and what URL should I use on Joomla to point to the forums?

Thanks

Masiello
02-04-2006, 10:39 AM
It works simple great for me with only one issue:
If I (or other user) log-out from joomla, remain logged in vbulletin, the log-out from vbulletin works fine, If I log-out from the board It log me out too from joomla...

Is there any way to fix this? :)

(sysop)

Langly
02-04-2006, 03:15 PM
What did you do in joomla to get it to sync users with vbulletin?

Masiello
02-04-2006, 03:20 PM
Sorry I have test it on a fresh installation of joomla and vbulletin, but I think the sync come on the first login after that mod is installed.

Langly
02-04-2006, 03:23 PM
Mine is a fresh install too. See post #46 as to what I've done so far.

Masiello
02-04-2006, 03:29 PM
You don't have to do nothing in Joomla, If you follow the installation step, and i seems to be correct what you do, make sure you have selected joomla.sql.class, the modulo from vbulletin is active, and the url is like that:
Example you have that structure
http://yoursite.com/joomla
http://yoursite.com/joomla/forum (how mine)
or http://yoursite.com/forum

Yuo have entered just a joomla url add to APP and Active module

If you have access to insert mySQL data all it's ok and have to work...
If don't try to user "blank" in Domain name from your vbulletin settings.

sorry my english

leonsio
02-04-2006, 04:24 PM
the users will be synchronisated by first login in joomla or vbulletin

Langly
02-05-2006, 02:14 AM
Odd, I've done everything I said I did in post #46 and mine do not sync. I've logged a user in on Joomla and go to the forums and they are not able to login to vbulletin. Any user that HAS gotten this to work able to check my site out to see what the problem is someplace? Let me know and I'll give you access. I'd really like to use an actual CMS with vbulletin but can't until one can work properly.

Thanks

tuanluu
02-07-2006, 03:21 AM
can this be use to intergrate 4images? I try to use the one that allready intergrate here but, it have error. I have not get support from that lately so I just wonder.

silurius
02-10-2006, 09:38 PM
Anyone have any ideas as to how to connect this to WebCalendar (http://www.k5n.us/dokuwiki/doku.php)?

ronoxQ
02-13-2006, 10:32 PM
What memberlist does it use? For example, I have 90 users on one program, and not that many on vBulletin. Will the ones on the first program gain a vBulletin ID?

Also, there was a problem with the new version's mySQL. Does anybody else have that problem?

MotMann
02-23-2006, 12:57 PM
i try to install and i got the follow message, if i want to upload the "product-connector.xml" in vB.

Datenbankfehler in vBulletin 3.5.4:

Invalid SQL:
ALTER TABLE vb_user ADD `connector_cookies` TEXT NULL;

MySQL-Fehler : Duplicate column name 'connector_cookies'
Fehler-Nr. : 1060
Datum : Thursday, February 23rd 2006 @ 03:52:39 PM
Skript : http://www.forum.tolltoll.de/admincp/plugin.php
Referrer : http://www.forum.tolltoll.de/admincp/plugin.php?do=productadd
IP-Adresse : 210.92.78.65
Benutzername : Super
Klassenname : vb_database

leonsio
02-23-2006, 01:10 PM
open the product file( with notepad ) and delete the line with the SQL satement
then try to import it

MotMann
02-23-2006, 01:40 PM
okey.. i have the wrong file.. there are to many version on the vb Server :(

what i must write in Database Port: ?
the software is on a managed Server.

leonsio
02-23-2006, 02:22 PM
is the port on then mysql running

Xtrato
02-23-2006, 08:04 PM
Will this work with MediaWiki?

pman
02-24-2006, 03:43 AM
Hello Leonsio:

great work with these connectors!

is there a chance this will work with the wrapped mode of com_connector for joomla?

com_connector works great from joomla -> vbridge in wrapped and unwrapped mode. However Vbulletin Application Connector does not work in side on the joomla wrapped mode. Meaning that if I have set my com_connector to use the wrapped mode and click on my "forums" link in the main menu it will take me to the forums BUT if I try to log in through vbulletin it will log me into vbulletin but not to Joomla. Is there a way to make this work?

thanx!

oojacoboo
02-26-2006, 09:47 PM
The docs don't tell you how to setup the settings for each module...

the url in there is confusing as hell. But, I assume it needs to be the module inside your application. So, for Joomla it would be.

http://yoursite.com/components/com_connector/modules/vbulletin.class.php

PLEASE CORRECT ME IF I AM WRONG HERE. I just changed this setting and I am now getting half of the login bit working.

leonsio
02-27-2006, 05:39 AM
which module do you use?

this module is the same like com_connector for joomla

the url is the URL to joomla ( which you have added under lifeSite in the config)
i have allready answered this question some threads before
does you have tryed to use "SEARCH" ??

oojacoboo
02-27-2006, 05:42 AM
leonsio, I have searched and searched until I am blue in the face man. I am trying to tell you, its hard to find this documentation.

I use the SOAP modules now.

I was actually talking about the server url, not the site url. I figured it was as such.

I really have tried to get all the info I can. You say search when you answer these questions, but its not easy to find these answers and you have to read through hundreds of posts to find out any details.

Thanks alot.

leonsio
02-27-2006, 05:57 AM
server url is the url to joomla soap server, like server url by CC and vbulletin module

oojacoboo
02-27-2006, 02:06 PM
Leonsio, that reply typifies your instructions. That means nothing to me. I am sure that makes total sense to you because you wrote the script. However, to someone who is installing this, and doesn't have a clue, that is basically useless.

Does that mean the URL should be to go to the JMSOAP server that is suppose to be placed in the Joomla root folder?

ronoxQ
02-27-2006, 02:10 PM
Still have the problem I had before: can I use an already-existing base of users NOT in vB?

oojacoboo
02-27-2006, 02:14 PM
yes, if you can get the app_useradd function to work properly, which I can't at the moment.

pman
02-27-2006, 02:23 PM
Using Joomla 1.0.7
PHP4.x

com_connector: vbulletin_sql
application connector: joomla_sql

Is there anyone out there that is also using the com_connector for Joomla along with this hack? Is anyone using com_connector in "wrapped" mode.
have you noticed that everything works from joomla but the common loging does NOT work when doing it through vbulletin in wrapped mode?

I have installed com_connector in joomla and it works!
I have installed application connector in vbulletin and it works AS LONG AS I access vbulletin directly NOT through Joomla. When I access vbulletin through com_connector in wrapped mode and log into vbulletin it does NOT log me into joomla. is there a way to fix this?

thank-you!

oojacoboo
02-27-2006, 02:51 PM
pman, thats b/c its using an iframe and it doesn't reload the joomla frame on a login. Or at least I would assume thats the reason.

I did use the sql modules and they worked for a while, until we upgraded mysql to 4.1.x and it broke the connector...

leonsio
03-06-2006, 11:55 AM
attention the joomla module(s) are not compatible with joomla 1.0.8 currently

imported_ToY
03-08-2006, 11:40 AM
attention the joomla module(s) are not compatible with joomla 1.0.8 currently

i was wondering why it wasnt working for me!

any idea when this will be updated?

leonsio
03-10-2006, 06:00 PM
new file jooma.zip attached

this include joomla_soap connector for joomla 1.0.8

you need new version of JMSOAP installed

http://forum.joomla.org/index.php/topic,24185.new.html#new

Paprika
03-11-2006, 07:05 PM
Has anyone ran across a module or whatever for this which allows combined user databases for vBulletin and 4images photo gallery?

I could figure out how to write one and make one myself but I thought I'd check beforehand...


I'll check back but PM me if you know something specific. Thanks!!

Xtrato
03-15-2006, 07:43 PM
Search theres a mod to add it with users; the works.....

Tamrin
03-16-2006, 06:33 PM
This looks exactly what we need.., we have multiple joomla sites and a vbulletin setup and badly want to combine all logins across the various sites..

The question that rises here though is how it treats existing users in both DB's ?, i.e. will it simply overwrite the users from one into another DB, what happens if someone has the same login on joomla as someone else in the forum ?

Starting blank with our user DB's isn't really an option..

leonsio
03-16-2006, 07:22 PM
noone user will be overwritten
it will synchronise user if he dont not exist in the database ( username )

common login works only if all instances are on same domain

cms2.forum.tld
cms2.forum.tld

or forum.domain.tld
cms1.domain.tld
cms2.domain.tld

user synchronisation works allways

fabianv
03-21-2006, 11:48 AM
Ok I have a few questions regarding this awesome concept.

After installing everything seemed to work.. I could login from both sides.

What I'd like to know is how to have stuff like latest threads and who's online and vbulletin polls and stuff in JOOMLA with php4. Where can i download these? Do they exist?

Also.. when I log in with Joomla nomatter which account it is it gives this welcome message. "Welcome, 0" why is that?

Thanks.. hope to get a response from someone soon!
Keep up the good work!

Edit: Also, how can I make it so that the Joomla ''Register'' button links to Vbulletin? I wanna remove the Joomla registration thing completely for the general user

leonsio
03-21-2006, 12:27 PM
http://forum.joomla.org/index.php/topic,37191.0.html

all addons for the connector you can find in this thread

the com_connector/ vbulletin application connector is only API for connect applications: common login, user synchronisation/management


Welcome, 0" why is that?
its joomla 1.0.8 problem see supportforum for joomla

for link register on joomla to vbulletin you must edit mod_register.php file in joomlaroot/modules folder

fabianv
03-21-2006, 06:46 PM
Anyway quite weird.. when I add the module to see whos online in vbulletin its just blank...

and when I add the module for latest threads I get this error:

main(./components/com_connector/connector.class.php): failed to open stream: No such file or directory in /home/fabianv/public_html/portal/modules/mod_vbulletin_recent_posts.php on line 32

Fatal error: main(): Failed opening required './components/com_connector/connector.class.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/fabianv/public_html/portal/modules/mod_vbulletin_recent_posts.php on line 32

Any idea why this is happening?

Raul7
03-23-2006, 03:20 PM
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...



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 any soloution for this? i have an exact same problem :( i have the exact same server setting,
any help is appreciated.
thank you

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 (http://www.xxxxcom/forum/admincp/plugin.php?do=productadd)
IP Address : xx.xxx.xx.xxx
Username : xxxxxxx
Classname : vb_database

RaidenDAWG2
03-25-2006, 12:37 AM
Hey Leonsio, great extension first of all, integrating it on my live site shortly, and I'm loving it personally.

I've found one minor bug with the joomla_sql class (or possibly the vbulletin_sql), not sure which is acting up. I can login/out through Joomla and it logs me in or out of vBulletin, no problems. However, when I do the same through vBulletin, it doesn't log me in or out of Joomla. I've triple checked my settings on both sides, and it doesn't appear to be a glitch there. Any idea what I could do to fix this?

Thanks man,
-RD

leonsio
03-25-2006, 05:12 AM
the connector (sql version ) does not support joomla 1.0.8 at the moment

RaidenDAWG2
03-25-2006, 05:16 AM
That explains it...any ETA on that supporting, or any idea what it would take for me to manually update it to support it?

-RD

Lea Verou
03-25-2006, 11:13 PM
Will it be useful for phpprobid integration?

daklay
03-28-2006, 12:05 AM
Question

Can this be used for Oekaki Poeteo BBS?

3z3k3l
03-29-2006, 11:16 PM
Anyone know how to connect this with Postnuke? I would be willing to throw in some donation money.

NonCompare
04-27-2006, 08:14 AM
So confusing... newbies like me can't get it work! Is there a detailed instructions on how to set it up all, like 1. Do this 2. Then do it...

ronoxQ
04-30-2006, 01:11 AM
Well, I read the tutorial on mod-making.

BUT: I don't exactly get it. Which variables do I have to change to get myself a mod for a certain site?

ronoxQ
05-02-2006, 09:32 PM
BUMP

Anybody who got this to work, please help us out!

BreezeDK
05-06-2006, 11:45 AM
Hi i have a problem when i logout from vBulletin 3.5.4 using PHP5 SOAP version with joomla.


Warning: Invalid argument supplied for foreach() in /includes/connector/joomla.class.php on line 107

Warning: Cannot modify header information - headers already sent by (output started at /home/newansi/joomla/forums/includes/class_core.php:2984) in /includes/connector/joomla.class.php on line 112

Warning: Cannot modify header information - headers already sent by (output started at /home/newansi/joomla/forums/includes/class_core.php:2984) in /includes/connector/joomla.class.php on line 113

Warning: Cannot modify header information - headers already sent by (output started at /home/newansi/joomla/forums/includes/class_core.php:2984) in /includes/connector/joomla.class.php on line 114


i have been looking in the file and it is the following that causes the problem:
function logout()
{
if(is_null($this->__res))
{
return $this->__status;
}
$lifetime = time() - 1800;
// cookies setzen
foreach ( $this->__res->_cookies as $name => $value)
{
setcookie($name, $value[0], $lifetime, $value[1]);
}
// force logout, falls _cookies nicht exestiert
setcookie( "usercookie[username]", " ", $lifetime, "/" );
setcookie( "usercookie[password]", " ", $lifetime, "/" );
setcookie( "usercookie", " ", $lifetime, "/" );

}


I have noted it doesnt happen with my non admin profile.
What could be the problem of this?

paulfletcher
05-11-2006, 06:54 PM
It's not working for me either. I'm pretty new to the Joomla integration, but I need to get it working in a week (deadline). Can anyone tell me what I need to get this working? I just want Joomla and vBulletin to share the userdatabase etc...

Thanks,
Paul

paulfletcher
05-12-2006, 02:30 AM
When I try to install this product on vBulletin 3.5.4 I get this error.

Database error in vBulletin 3.5.4:

Invalid SQL:
ALTER TABLE user ADD `connector_cookies` TEXT NULL;

MySQL Error : Duplicate column name 'connector_cookies'
Error Number : 1060
Date : Thursday, May 11th 2006 @ 11:21:07 PM
Script : http://xyztraining.com/*****(admin folder)/plugin.php
Referrer : http://xyztraining.com/*****(admin folder)/plugin.php?do=productadd
IP Address : ***.**.**.***
Username : Paul Fletcher
Classname : vb_database

Any thoughts?

Also, has anyone actually gotten Joomla to work with vBulletin 100%? User database sharing, and automatic login? Also, could anyone post how I can install the SOAP version? I've tried install the SOAP version, only to get errors, so I had to stick with the vbulletin_sql version.

The System requirements for SOAP... PHP 5, and SOAP extensions, how do I add SOAP extensions? Plus my host is telling me to use ".php5" as the ending... would this work as well.

lol, sorry for all these questions. I hope one of you has the answer.

Thanks,
Paul

ronoxQ
05-14-2006, 03:52 PM
Mods, I'd like to request deleting this mod. It isn't working, and the creator isn't here any more.

LordRayden
05-14-2006, 09:03 PM
HI all,

well paulfletcher, I would say you allready have installed the vBulletin Application Connector, cause your error says “Duplicate column name 'connector_cookies'”.

I'm no programmer, but I think that’s the Problem, I have a working “one side” Integration with the com_connector and vBulletin. As I said “one side”, when I login to Joomla I'm also logged in to vBulletin, same with logout but when I login to vBulletin I'm logged in to vBulleitn only. As far as I know the reason is that in Joomla 1.08 the developers changed a lot so the vBulletin Application Connector in this version is not working anymore and has to be updated.

That’s my information for my system, Joomla 1.08, Vbulletin 3.5.4, PHP4, NO SOAP. I think leonsio is pretty busy and I, also as everyone else, hope to hear from him soon.

Thanks

LordRayden

paulfletcher
05-15-2006, 11:43 AM
Thanks for the information. I've decided to go with BBPixel and their plugin. That will help us meet our deadline.

Have a great day,
Paul

ronoxQ
05-17-2006, 10:01 PM
Where is BBPixel's plugin?

paulfletcher
05-18-2006, 01:05 AM
<a href="http://forum.bbpixel.com/index.php" target="_blank">http://forum.bbpixel.com/index.php</a>

kevinsan
06-02-2006, 09:36 AM
LordRayden

Can you please tell us how you installed VB and Jomla 1.08 on php4? There is no detailed explanation. Thanks.:banana:

Lionel
06-02-2006, 09:45 AM
bbpixels just integrated joomla 1.08 for me. They did a perfect integration, the best I have seen so far.

paulfletcher
06-02-2006, 10:09 AM
Yeah, I can't really tell you how the plugin was installed either. I was under a time crunch and needed not only the plugin installation but template help as well. So I just paid BBPixel to install the plugin and to help us with our templates and database integration. They did a great job in a short timeframe.

Thanks,
Paul

drgonzo120
06-02-2006, 12:56 PM
how does this thing look like? anybody a showcase website ???

paulfletcher
06-03-2006, 12:47 PM
Hey, if your looking for a site that uses Joomla 1.0.8 and vBulletin 3.5.4 that are connected with BBPixel's plugin you can check out our tutorial website.

http://xyztraining.com

Thanks,
Paul

ramone_johnny
06-03-2006, 12:47 PM
phpprobid intergration??????

nicholas
06-07-2006, 01:35 AM
how does this thing look like? anybody a showcase website ???
http://lawdida.com, not yet done but already integrated.

imranbaig
07-13-2006, 03:56 PM
where can I get vbulletin_sql module?
I get lots of error trying to integrate, I got some 4000 vb users and joomla = none, doing a fresh install with joomla.

thanks in advance.

jarod1981?
07-15-2006, 05:11 PM
Hi Guys,

Is there some Bridge for integrated Joomla 1.010 and Vbulletin 3.5.4 please?

This Vbridge isnt' compatible with Vbulletin 3.5.4, right?

Thanks :)

tassoman
07-22-2006, 09:59 AM
I have some problem with mysql 4.0.

I wonder this query doesn't works on < 4.1, wich is equivalent for who is running mysql 4.0 version?

Database error in vBulletin 3.5.4:

Invalid SQL:

CREATE TABLE IF NOT EXISTS `vb_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 : Saturday, July 22nd 2006 @ 01:00:41 PM
Classname : vb_database

puregraf
12-04-2006, 07:45 PM
would this work with vbulletin and phpprobid.com auction program?

thank you

drupalbpo
04-04-2007, 06:57 AM
can this work with drupal5.1?

treelovinhippie
08-20-2007, 03:25 AM
Does this work for v3.6.8?

There are about 3 of these APIs, and it's exactly what I'm after but none of them seem to work for the latest version sadly :(

foxfirediego
10-11-2007, 10:37 AM
wondering the same :s

leonsio
10-11-2007, 10:47 AM
i can not work on this api anymore, because

1. i dont have vbulletin license
2. i dont have any time for it

sorry