vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Vbulletin Application Connector (https://vborg.vbsupport.ru/showthread.php?t=103069)

leonsio 12-15-2005 10:00 PM

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

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


PHP Code:

Parse errorparse 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

Quote:

Originally Posted by Lionel
When trying to add the module


PHP Code:

Parse errorparse 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

Code:

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

Quote:

Originally Posted by leonsio
*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.

Code:

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:

Code:

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.

Code:

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:
Code:

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:

Code:

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...

Quote:

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 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.


All times are GMT. The time now is 04:54 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01519 seconds
  • Memory Usage 1,833KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (6)bbcode_code_printable
  • (2)bbcode_php_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete