[Tailfeathers]

Originally Posted by mtha

There is NO automatic and safe way to do this, BUT you can try this method (require that you know enough php and SQL in order to do the job)


What you have are:
01 - vB user database with USERSET1 controled by userid (and username), says user.userid and user.username
02 - Album user database with USERSET2, controlled by user_id (and user_name) says 4images_users.user_id and 4images_users.user_name


Step 1:
- Create a new COMPARE table having 3 fields: username, forum_uid, album_uid

Step 2:
- Compare 4images_users.user_name and user.username
if match => fill in the COMPARE table (username, forum_uid, album_uid) for this user.
if not => fillin COMPARE table, with album's username, album_uid, DEFAULTID where DEFAULTID is the ID given for those who does NOT have account in forum or have different username in forum. If you want to assign this to be GUEST, the ID is 0

Do this for ALL ALBUM users

=> you know the id in forum and album for each album user

(if they have the SAME username for both places. if you think email address would be more appropriate, you can compare email instead, or compare both username and email)

Step 3:
Change user_id in album to the new forum's userid based on the above comparision, in the following tables:
4images_comments, 4images_groupmatch, 4images_images, 4images_images_temp, 4images_lightboxes, 4images_users

Step 4:
Test your album and see if everything works correctly (username, login/logout, image's poster)

Step 5: Apply this hack ... and god bless you


good luck.

PS. this will require alot of changes to your database, so Do a FULL BACKUP of your album database first (maybe your files too), and test in a beta version

Finally went to do this and chickened out, lol. Too worried. Maybe someday, it'd be possible to make this an automatic php install thingy or something. I'd probably destroy both my board and gallery trying to do this, hehe...

For now, people will just have to register at both separately, I guess!