Existing site user integration

Discussion of general topics related to the new version and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
Forum rules
Discussion of general topics related to the new release and its place in the world. Don't discuss new features, report bugs, ask for support, et cetera. Don't use this to spam for other boards or attack those boards!
rain91
Registered User
Posts: 4
Joined: Sun Apr 23, 2006 9:34 pm

Existing site user integration

Post by rain91 »

My question is, will / is there a way to integrate my existing site userbase into a new PHPBB3.x installation. I would actually love to do it w/version 2, but 3 would be my guess to incorporate this feature...

My existing user system is pretty advanced, and tracks a lot of statistic information, I would really like to find a way to allow my users the simplicity of only ONE signup form and not a seperate one for each. My most common question (site is beta) is "why do I have to sign up AGAIN to use the forums after I JUST registered".

Thanks in advance for any insight or answers on this!!

keep up the good work / let open source reign!!

- Z

jacobmp92
Registered User
Posts: 17
Joined: Sat Oct 22, 2005 6:29 pm

Re: Existing site user integration

Post by jacobmp92 »

My guess is that you can just add extra data to the users table or create a new table just like in 2.x.
Signatures, what a nifty feature. Useful for addding spam to every post.
Might as well add my own spam:
http://www.globalmsg.com" target="_blank http://www.evura.com" target="_blank http://www.legicode.com" target="_blank

rain91
Registered User
Posts: 4
Joined: Sun Apr 23, 2006 9:34 pm

Re: Existing site user integration

Post by rain91 »

is there a guide on the creating a new table etc? how / where do i find this? I would love to integrate my existing 2.x version with my site. Will it be a pain in the arse to upgrade to 3.x though if I integrate v2.x?

thanks in advance for info :)

Z

jacobmp92
Registered User
Posts: 17
Joined: Sat Oct 22, 2005 6:29 pm

Re: Existing site user integration

Post by jacobmp92 »

rain91 wrote: is there a guide on the creating a new table etc? how / where do i find this? I would love to integrate my existing 2.x version with my site. Will it be a pain in the arse to upgrade to 3.x though if I integrate v2.x?

thanks in advance for info :)

Z
No guide that I know of, I just hacked up the tables a bit.

If you want to make a new table to synchronize with user data, then you will want the `id` in the users table. Use that id in your new table and add data to it. It sounds complicated, perhaps someone here can explain it better than I can.
Signatures, what a nifty feature. Useful for addding spam to every post.
Might as well add my own spam:
http://www.globalmsg.com" target="_blank http://www.evura.com" target="_blank http://www.legicode.com" target="_blank

User avatar
morbidpaloza
Registered User
Posts: 67
Joined: Sun Jun 18, 2006 10:00 pm
Location: Oklahoma
Contact:

Re: Existing site user integration

Post by morbidpaloza »

I would love to learn how to do that I have tryes to do it on my local install but every time I get a mysql error
001001000100101001011101
001010010111010110100110
011101010001110110011100

Image
My Skined phpBB3 TEST board!

jacobmp92
Registered User
Posts: 17
Joined: Sat Oct 22, 2005 6:29 pm

Re: Existing site user integration

Post by jacobmp92 »

Once you know how to do it, it isn't all that bad, but you have to keep your code optimized. I have a lot of experience with PHP and MySQL optimization, so I just use the method I described, but if you don't have much PHP/MySQL experience, I suggest you just add all of the columns to the end of the users table using phpMyAdmin, and just search for information using SELECT statements.
Signatures, what a nifty feature. Useful for addding spam to every post.
Might as well add my own spam:
http://www.globalmsg.com" target="_blank http://www.evura.com" target="_blank http://www.legicode.com" target="_blank

User avatar
stubbers
Registered User
Posts: 406
Joined: Sat Oct 23, 2004 10:36 pm
Location: LoSt
Contact:

Re: Existing site user integration

Post by stubbers »

I'm planning on doing that with my existing site and integrating the users from phpBB 3.0 into the Mambo system I am running. I'm going to modify that CMS not phpBB3 because phpBB has better user management. THe best way is to allow phpBB to manage registrations and session management and mambo to get session values, etc from phpBB 3.0 modules. I'm not yet sure how I'll do it.

It would be much easier if someone just took the phpBB 3.0 code and created a CMS based on phpBB and a gallery. If anyone ever ends up doing that I reckon they'll get just a little bit of activirty :)

Cheers,
Stubbers

User avatar
naderman
Consultant
Posts: 1727
Joined: Sun Jan 11, 2004 2:11 am
Location: Karlsruhe, Germany
Contact:

Re: Existing site user integration

Post by naderman »

You will be able to write an authentication plugin which connects user accounts from one software with the other.

User avatar
Eelke
Registered User
Posts: 606
Joined: Thu Dec 20, 2001 8:00 am
Location: Bussum, NL
Contact:

Re: Existing site user integration

Post by Eelke »

Will that authentication module (I understand this is something that needs to be custom-made for each third-party system) also take care of session and database synchronization? It's nice that you can authenticate against another system, but it would be nicer if there are standardized ways to synchronize the phpBB user list with that external system and integrate session management so that you get single sign-on. Even nicer would be if you can redirect phpBB's login screen to the third-party system's login screen so you have a unified "login experience" ( ;) ) for your whole site.

In short, I'm aching to see the developer documentation for that authentication module system :)

User avatar
naderman
Consultant
Posts: 1727
Joined: Sun Jan 11, 2004 2:11 am
Location: Karlsruhe, Germany
Contact:

Re: Existing site user integration

Post by naderman »

There is a possibility for an "autologin" function (see auth_apache) which will log the user in automatically if he has an active session on the external system. If you also want to allow session creation the other way around (login to phpBB, create external session) you have to create the external session within the login function of the auth module. Authentication modules do not handle any type of data synchronisation, however you could add this yourself to one of the two login functions so that if a user visits your forum his data will be synchronised. So as you can see this is not a simple "turn a button and it will work" thing but it requires a bit of coding. However I hope that modules for some common external software (e.g. CMS or portal software) will be created soon after the release so people using the same software can use them.

Post Reply