How do I integrate an existing PP installation with an existing Ipb installation?

[petrucci]

Hi to all...

I have a self-running PP 5.03 installation and a self-running IPB 2.0.3 installation, both with their own users database.

I want to integrate PP to the Forum in order to have a unique login system to my users.

I've read that i need to alter user ids in order to have the same one id both in gallery that in forum.

I'm preparing to write the script for doing that.
Can anyone help me to schedule the operation the script have to do?

This is what i've thought:
1. Scan pp_user and retrieve all user ids.
2. Scan ibf_members and retrieve all user ids.
3. Scan for users with same username both in gallery that in forum
3a. If username in unique, just import member details from gallery db to forum db.
3b. If there is same nick in the gallery and in the forum then i have to assign the forum id to the gallery id.
4. Scan pp_comments and pp_photos and change userid field to the new one i have in forum db.

Is that right?
If i'm missing some passage...please let me know...i think this might be useful for other people too

Sorry for my bad english...thanks a lot to everyone who could help me

[Chuck S]

That would be complicated to say the least when you have two databases populated

Basically the script would have to work like this

Load the pp_users table and scan the ibp members table to update the photos and comments tables as well as categories table for personal albums userid's and if a user record is not matched and updated the script would then in turn for that records write the user data to ibp members table retreive the new userid and then update the photopost tables

After all this then you can switch your integration settings.

Not an easy script to design. When starting with a clean slate its easy just to write over the users table to members table

[petrucci]

Thanks Omegatron for your reply...

Well, actually this is the situation:

Gallery:
Registered Users 4,377
Comments/Ratings 11,552

Forum:
Registered Users 4,023

It's not simple, anyway I want to do it...



I write down the script...and I will ask here as i have problems...