com_connector ( universal Connector for forums or other applications)

Discuss the universal connector for forums and other applications. (including vBridge )
Locked
leonsio
Joomla! Explorer
Joomla! Explorer
Posts: 355
Joined: Wed Nov 02, 2005 11:20 am
Contact:

com_connector ( universal Connector for forums or other applications)

Post by leonsio » Sat Nov 26, 2005 2:52 pm

com_connector RC1
v. 0.0.8.1 ( bugfix release, no new functions )
bug in the connector administration
v. 0.0.8
updated to joomla 1.0.7
added wrapped mode
v. 0.0.7
updated to joomla 1.0.5
fixed some messages with "warning"
v. 0.0.6
compatibility with new version of VB_SOAP
some bugs by login fixed
v. 0.0.5
cookie store bug in vbulletin module fixed
compatibility with JMSOAP addon, added
v. 0.0.4
added functions to update and delete users
splited modules to own packages
v. 0.0.3
each module has own logout function
fixed bugs in vbulletin_sql module
fixed bug in the connector.php file
v. 0.0.2
vbulletin_Sql module included
select menu in the admintool for the  modules
v. 0.0.1
init release, vbulletin module included


included Modules:

vbulletin ( require php5 and SOAP extension  )
v.1.0.4
cookie fix
v.1.0.3
compatibility with new version of VB_SOAP
v.1.0.2
supports login/logout,
add users to vbulletin/joomla
manage/delete/update users
vbulletin session support
protected users cannot be deleted ( in the config.php )


Online Demo running with vbulletin module (SOAP)

http://www.c4u.to

HOWTOs:

switching from vbridge to com_connector
creating own modules
patching joomla.php file himself


Component Information and description
at the moment are following things supported:
common login
global changing password
global changing username/email
synchronistion of the users ( by first login or registration )

That does i need to run this component?

for this component alone you needs only joomla 1.0.x
it should run with PHP4 und PHP5(tested)

some modules like vbulletin can have own requirements ( vbulletin module needs php5 + SOAP extension )


That does this component do?

this component allow you to connect different applications to joomla over SOAP/XMLRPC, SQL Connects ( other methods are posible too )
You should use this component if you wants to have common login with an aplications ( which based on cookie login (session to, because it use cookie to store a sessionid ;) ))
it is posible to create own moduless to connect any applications

How to install  ( beta versions will use component-installer )

download a package and unzip it
move all files from folder "upload" to your joomla installation
from joomla files was only joomla.php changed ( login/logout function )

run the following querys:

new table: jos_connector

Code: Select all

CREATE TABLE `jos_connectors` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) default NULL,
  `module` varchar(255) NOT NULL default 'vbulletin',
  `url` varchar(255) NOT NULL default '',
  `jos_useradd` tinyint(4) NOT NULL default '0',
  `app_useradd` tinyint(4) NOT NULL default '0',
  `smode` int(11) NOT NULL default '0',
  `params` text,
  `published` tinyint(4) NOT NULL default '0',
  `checked_out` int(11) NOT NULL default '0',
  `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;
new filed in user table

Code: Select all

ALTER TABLE  `jos_users` ADD  `connector_cookies` TEXT;
and code to add component

Code: Select all

INSERT INTO `jos_components` VALUES ('', 'Connector', 'option=com_connector', 0, 0, 'option=com_connector', 'Add Connector', 'com_connector', 0, 'js/ThemeOffice/component.png', 0, '');
How to use
go to "Administration/Components/Connector"
click to "New"

Choose a Module like "vbulletin"

following are exaple data:

Title    : MyFORUM
Module: vbulletin
Access Key: SECRETPASS ( this is need by SOAP applications to secure a access to soap-server )
URL: http://www.myapplication.com/index.php
Server URL: http://www.myapplication.com/server.php?wsdl  ( URL to a server, for example soap or xmlrpc server )

after you have added a data, you can create a menu link

go to Menu config, create on New and select "Connector Item"
in next dialog select you forum and click to save

done ;)

Warning
to use a vbulletin module you must install this extension on you vbulletin -> http://www.vbulletin.org/forum/showthread.php?t=100559



For update from 0.0.x to 0.0.8 please run this query

Code: Select all

ALTER TABLE `jos_connectors` ADD `smod` INT NOT NULL AFTER `app_useradd` ;
You do not have the required permissions to view the files attached to this post.
Last edited by leonsio on Fri Feb 10, 2006 3:07 pm, edited 1 time in total.

quiquedcode
Joomla! Ace
Joomla! Ace
Posts: 1384
Joined: Thu Aug 18, 2005 10:11 pm
Location: San Juan - Argentina
Contact:

Re: com_connector ( universal Connector for forums or other applications)

Post by quiquedcode » Sat Nov 26, 2005 4:11 pm

Great !!!
Hope 2 test it soon...

Will be waiting for news... :D
@kabeza
Freelance Joomla/CodeIgniter Developer
Home: http://www.beza.com.ar

leonsio
Joomla! Explorer
Joomla! Explorer
Posts: 355
Joined: Wed Nov 02, 2005 11:20 am
Contact:

Re: com_connector ( universal Connector for forums or other applications)

Post by leonsio » Sat Nov 26, 2005 8:38 pm

demo board is online

http://www.c4u.to/index.php

link to VB_SOAP extension incl. examples

http://www.vbulletin.org/forum/showthread.php?t=100559

User avatar
flesh_magick
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Mon Oct 31, 2005 3:46 am
Location: Russellville
Contact:

Re: com_connector ( universal Connector for forums or other applications)

Post by flesh_magick » Sat Nov 26, 2005 8:47 pm

Thats awesome! Can't wait to see it for Invision Power Board :P
I make IPB skins!

FEAR ME JOOMLA TEMPLATE MAKERS!!!!

User avatar
kenmcd
Joomla! Champion
Joomla! Champion
Posts: 5672
Joined: Thu Aug 18, 2005 2:09 am
Location: California
Contact:

Re: com_connector ( universal Connector for forums or other applications)

Post by kenmcd » Sat Nov 26, 2005 8:51 pm

leonsio wrote:this extension will be free for non comerzial use
Not open source - too bad.
██ LibreTraining

leonsio
Joomla! Explorer
Joomla! Explorer
Posts: 355
Joined: Wed Nov 02, 2005 11:20 am
Contact:

Re: com_connector ( universal Connector for forums or other applications)

Post by leonsio » Sat Nov 26, 2005 8:54 pm

it is posible to make modules for this connector for any applications

at first time i will release an vbulletin connector ( allready done ) and maybe LMO ( http://www.liga-manager-online.de )

later i will try to make phpbb connector if anyone dont make it bevor i have time for it


invision and wbb1/2 are posible to, but i dont have licence for this forums

leonsio
Joomla! Explorer
Joomla! Explorer
Posts: 355
Joined: Wed Nov 02, 2005 11:20 am
Contact:

Re: com_connector ( universal Connector for forums or other applications)

Post by leonsio » Sat Nov 26, 2005 9:00 pm

kenmcd wrote:
leonsio wrote:this extension will be free for non comerzial use
Not open source - too bad.



Why should it be bad?

I will think still about this point, maybe i will release this under GPL

leonsio
Joomla! Explorer
Joomla! Explorer
Posts: 355
Joined: Wed Nov 02, 2005 11:20 am
Contact:

Re: com_connector ( universal Connector for forums or other applications)

Post by leonsio » Sun Nov 27, 2005 3:26 am

hmm it was a long night...

i can't sleeping so i have done working on an bridge ^^

now i must think a little bit about a kind of licenze and fix some bugs if i will finde any...

after it this component will be released :D

trackpads
Joomla! Apprentice
Joomla! Apprentice
Posts: 16
Joined: Tue Oct 11, 2005 12:11 am

Re: com_connector ( universal Connector for forums or other applications)

Post by trackpads » Sun Nov 27, 2005 4:25 am

Excellent and thanks!!

leonsio
Joomla! Explorer
Joomla! Explorer
Posts: 355
Joined: Wed Nov 02, 2005 11:20 am
Contact:

Re: com_connector ( universal Connector for forums or other applications)

Post by leonsio » Sun Nov 27, 2005 5:03 am

Small correction:

the com_connector component works with PHP4 and dont need soap extension
ir is posible to makes modules which are working with out soap and with xmlrpc or database connects

it is only my vbulletin module which needs php5 and soap extension

i will try to modify actual vbridge components to work as "module" for this component

so that you can try between 2 solutions how to connect your vbulletin forum with joomla :D

EMRhelp
Joomla! Guru
Joomla! Guru
Posts: 510
Joined: Sat Aug 20, 2005 4:12 pm

Re: com_connector ( universal Connector for forums or other applications)

Post by EMRhelp » Sun Nov 27, 2005 5:44 pm

This is exciting news.

Will there be support for Community Builder ?

Whereas vBridge is just for Joomla vBulletin, could your universal Connector connect to many other apps ?

Flash Chat ?
PhotoPost ?
ReviewPost ?
Gallery2 ?

Could you give us some examples of other app connectivity besides forums ?

Are you sure it would be easy to upgrade vBulletin, Joomla, etc with your com_connector ?
Last edited by Anonymous on Sun Nov 27, 2005 6:18 pm, edited 1 time in total.

leonsio
Joomla! Explorer
Joomla! Explorer
Posts: 355
Joined: Wed Nov 02, 2005 11:20 am
Contact:

Re: com_connector ( universal Connector for forums or other applications)

Post by leonsio » Sun Nov 27, 2005 6:37 pm

i have written little API for developers to access own modules with this extension

you must put an class file in /modules folder which have funktions like login/logout/userget/userset, you can fill this methods with your needed code ( it can be a soap call ( favorite ) or database connects )

this all is based on cookies, so you must create an array with cookies, which will be set bei com_connector ( by soap you will get all cookies from client )

leonsio
Joomla! Explorer
Joomla! Explorer
Posts: 355
Joined: Wed Nov 02, 2005 11:20 am
Contact:

Re: com_connector ( universal Connector for forums or other applications)

Post by leonsio » Mon Nov 28, 2005 9:34 am

okay first release is online

licence is open source ;)

at first time is only common login supported ( changing password or other userdata will came later )

User avatar
kenmcd
Joomla! Champion
Joomla! Champion
Posts: 5672
Joined: Thu Aug 18, 2005 2:09 am
Location: California
Contact:

Re: com_connector ( universal Connector for forums or other applications)

Post by kenmcd » Mon Nov 28, 2005 10:13 am

Where is the download?



Edit: OK. I found it at the bottom of the first post in this thread.
Last edited by kenmcd on Mon Nov 28, 2005 10:15 am, edited 1 time in total.
██ LibreTraining

leonsio
Joomla! Explorer
Joomla! Explorer
Posts: 355
Joined: Wed Nov 02, 2005 11:20 am
Contact:

Re: com_connector ( universal Connector for forums or other applications)

Post by leonsio » Mon Nov 28, 2005 10:35 am

as attachement in first post

stefaandk
Joomla! Apprentice
Joomla! Apprentice
Posts: 37
Joined: Thu Oct 13, 2005 12:04 am
Location: Australia
Contact:

Re: com_connector ( universal Connector for forums or other applications)

Post by stefaandk » Mon Nov 28, 2005 11:20 pm

So basically withouth php5 this is a no go?  :-\

leonsio
Joomla! Explorer
Joomla! Explorer
Posts: 355
Joined: Wed Nov 02, 2005 11:20 am
Contact:

Re: com_connector ( universal Connector for forums or other applications)

Post by leonsio » Mon Nov 28, 2005 11:25 pm

stefaandk wrote: So basically withouth php5 this is a no go?   :-\
com_connector dont needs php5

but vbulletin module is written in php5 with soap extension

all new destributions have already php5 binary packages ( rpm )

stefaandk
Joomla! Apprentice
Joomla! Apprentice
Posts: 37
Joined: Thu Oct 13, 2005 12:04 am
Location: Australia
Contact:

Re: com_connector ( universal Connector for forums or other applications)

Post by stefaandk » Mon Nov 28, 2005 11:35 pm

Righto, but my server is Plesk based which is a popular system for virtual hosting.  Plesk is coded in PHP and does not work on PHP5 so doing a server upgrade simply is not an option.

Are you saying that there is a workaround for this?

Ta

leonsio
Joomla! Explorer
Joomla! Explorer
Posts: 355
Joined: Wed Nov 02, 2005 11:20 am
Contact:

Re: com_connector ( universal Connector for forums or other applications)

Post by leonsio » Mon Nov 28, 2005 11:40 pm

it is posible to run plesk/confix .... with php5

you can run php4 and php5 together on one server

some examples http://www.sitepoint.com/blogs/2004/03/ ... -parallel/

p.s. plesk 7.4 is coded in php5 ;)

stefaandk
Joomla! Apprentice
Joomla! Apprentice
Posts: 37
Joined: Thu Oct 13, 2005 12:04 am
Location: Australia
Contact:

Re: com_connector ( universal Connector for forums or other applications)

Post by stefaandk » Tue Nov 29, 2005 12:23 am

Cheers, I'll check it out.

One other quick question, does this system support wrapped mode, as that is kinda essential to me.

leonsio
Joomla! Explorer
Joomla! Explorer
Posts: 355
Joined: Wed Nov 02, 2005 11:20 am
Contact:

Re: com_connector ( universal Connector for forums or other applications)

Post by leonsio » Tue Nov 29, 2005 7:20 am

this system is only one connector
it is better to make own "portal"-style for vbulletin as tu run it in iframe

lstyle like this

http://www.c4u.to/forum/index.php?styleid=14

you must only change a header an a fooder template from the forum and add a quellcode from joomla template
it needs some time, but at the end it looks better als iframe ;)

leonsio
Joomla! Explorer
Joomla! Explorer
Posts: 355
Joined: Wed Nov 02, 2005 11:20 am
Contact:

Re: com_connector ( universal Connector for forums or other applications)

Post by leonsio » Tue Nov 29, 2005 12:12 pm

mod_vbulletin_recent_posts v1.0

http://forum.joomla.org/index.php/topic,21641.0.html

as next addon i will release comment system which store a posts as vbulletin posts

leonsio
Joomla! Explorer
Joomla! Explorer
Posts: 355
Joined: Wed Nov 02, 2005 11:20 am
Contact:

Re: com_connector ( universal Connector for forums or other applications)

Post by leonsio » Wed Nov 30, 2005 12:35 pm

tomorow i will relese new version of the connector and one vbulletin_sql module
to connect to vbulletin over sql ( linke vbridge )

this module only works if joomla and vbulletin are on same server

and it dont need php5 ;)

if you have php5 installed you should use "vbulletin" module

leonsio
Joomla! Explorer
Joomla! Explorer
Posts: 355
Joined: Wed Nov 02, 2005 11:20 am
Contact:

Re: com_connector ( universal Connector for forums or other applications)

Post by leonsio » Wed Nov 30, 2005 2:48 pm

new version is online

some bugs fixed

added vbulletin_sql module to access vbulletin over mysql-connect
this module works like vbridge, but without alter a user table

vbulletin_sql module dont need php5

Avian
Joomla! Intern
Joomla! Intern
Posts: 54
Joined: Wed Sep 21, 2005 2:56 am

Re: com_connector ( universal Connector for forums or other applications)

Post by Avian » Wed Nov 30, 2005 9:00 pm

Can you post the link again to the current version of what we need.

Thanks for making this!  What a huge help!

Avian

leonsio
Joomla! Explorer
Joomla! Explorer
Posts: 355
Joined: Wed Nov 02, 2005 11:20 am
Contact:

Re: com_connector ( universal Connector for forums or other applications)

Post by leonsio » Wed Nov 30, 2005 9:04 pm

Avian wrote: Can you post the link again to the current version of what we need.

Thanks for making this!  What a huge help!

Avian

look at the first post

download file is an attachement
for vbulletin module you needs soap extension and php5
vbulletin_sql works with php4 like vbridge ( this module is experemental )


actual version has a little bug in com_connector (site) module
user will not be redirected to vbulletin, but you can login/logout
i will fix it tomorrow

thepipper
Joomla! Apprentice
Joomla! Apprentice
Posts: 21
Joined: Sat Nov 19, 2005 9:00 pm

Re: com_connector ( universal Connector for forums or other applications)

Post by thepipper » Wed Nov 30, 2005 9:33 pm

I keep getting this error:

Code: Select all

Fatal error: Call to undefined method stdClass::get() in c:\wamp\www\home\components\com_connector\modules\vbulletin_sql.class.php on line 23
I am running this locally.  Here are my settings:

Connector:  Edit

Title: My Forums
Module: VBULLETIN SQL
URL: http://localhost/home/forums/index.php
Add User to Joomla: No
Add User to App: No

Module:  VBULLETIN SQL

Database Host: localhost
Database User: root
Database Pass: (blank)
Database Name: test
VBulletin License Number: xxxxxxxxxx
VBulletin Cookie Prefix: bb

leonsio
Joomla! Explorer
Joomla! Explorer
Posts: 355
Joined: Wed Nov 02, 2005 11:20 am
Contact:

Re: com_connector ( universal Connector for forums or other applications)

Post by leonsio » Wed Nov 30, 2005 9:40 pm

thepipper wrote: I keep getting this error:

Code: Select all

Fatal error: Call to undefined method stdClass::get() in c:\wamp\www\home\components\com_connector\modules\vbulletin_sql.class.php on line 23
I am running this locally.  Here are my settings:

Connector:  Edit

Title: My Forums
Module: VBULLETIN SQL
URL: http://localhost/home/forums/index.php
Add User to Joomla: No
Add User to App: No

Module:  VBULLETIN SQL

Database Host: localhost
Database User: root
Database Pass: (blank)
Database Name: test
VBulletin License Number: xxxxxxxxxx
VBulletin Cookie Prefix: bb
actual version has a little bug in com_connector (site) module
user will not be redirected to vbulletin, but you can login/logout
i will fix it tomorrow

this ist a bug in the redirect funktion ( menu link )
if you go manualy to you forum ( and it is on same domain example localhost  )

you should be logged in your forum

tenaki
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 185
Joined: Sun Nov 13, 2005 9:46 pm

Re: com_connector ( universal Connector for forums or other applications)

Post by tenaki » Wed Nov 30, 2005 10:05 pm

flesh_magick wrote: Thats awesome! Can't wait to see it for Invision Power Board :P
Yes Please make Invision Power Board a priority  :) please

leonsio
Joomla! Explorer
Joomla! Explorer
Posts: 355
Joined: Wed Nov 02, 2005 11:20 am
Contact:

Re: com_connector ( universal Connector for forums or other applications)

Post by leonsio » Wed Nov 30, 2005 10:10 pm

tenaki wrote:
flesh_magick wrote: Thats awesome! Can't wait to see it for Invision Power Board :P
Yes Please make Invision Power Board a priority  :) please
i dont have invision license to make and test a module

look at the vbulletin_sql module  you must change db access in the login, getuser and setuser funktions
and the format of the cookie in the getcookie functions ( vbulletin needs license and cookie prefix, i dont know that invision needs )


Locked

Return to “com_connector - Multi Joomla Bridge”