BULK change owners of photos
Due to a previous error I made whilst upgrading vbulletin (its a long story) all my photos are owned by the wrong users.
Eg all the photos owned by userid 1 should be owned by userid 2 all those owned by userid 50 shoudl be owned by userid 51
Now I am not very technical but I am assuming that in the table pp_photos if I had some sql code which added 1 to the value of userid this might fix the problem...
But how would I then get the correct username displayed?
Could some one help me out with the following
1 - the correct sql to add 1 to evry userid
2 - the way i can make photopost pro put the correct name in to user now userid has changed...
Many thanks in advance.