[mtha]

Originally Posted by Dan1113

I have a 4images gallery with almost 500 users and of course, those users are not in the same order as on the message board...is there any alternative to getting 4images to just use the vB database? Something I could do so that the users are matched up in some other way, so that vB user ID # 35 doesn't take over gallery user ID #35's pictures and such?

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