Problem with User ID after 4Images import
I just did the import of my 4Images gallery to photopost.
The problem now is, that the User IDs are a complete mess.
We had vBulletin and the 4Images gallery as two seperate Homepages with sepereate registrations. Of our 8000 Users in the vbulletin only 400 wanted to use the 4Images gallery and registered there with their vbulletin nickname.
Now I have the following situation:
User ID in Database: 377
User ID in Database: 22
So after the import in Photopost, all the pictures who were uploaded from the User "Vivalranger" (ID:22) were connectet with the User which has the ID:22 in the vBulltetin forum. But that is not the correct User...
I hope, I managed to explain the problem.
What can I do about this?
- would it be possible to manually change all the 400 UserIDs in 4Images to the corresponding UserID of the vbulletin forum. Or will the DB get messed up if freely change the UserIDs? (and besides that it is a hell lot of work)
- would it be possible to modify the import script so that it compares the usernames and assigns the correct ID corresponding to a Username match?
Hoping that you can help me or at least give me some advice...