BULK change owners of photos

[schford]

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.

Stuart

[Chuck S]

Well are all the photos owned by the wrong userid is the real question or some?

You could do a query like this

UPDATE pp_photos SET userid=userid+1

You can then use the admin scan database tool to resync usernames.

[schford]

I think its aprox the first 1500 photos that are wrong......what would be the syntax to just run it on those.

thanks

Stuart

[Chuck S]

well not an exact science here on that ha

UPDATE pp_photos SET userid=userid+1 WHERE id < 1501

[schford]

Originally Posted by Chuck S

well not an exact science here on that ha

UPDATE pp_photos SET userid=userid+1 WHERE id < 1501

Thanks :-) actually I know the date when I updated VB so can work out what the last member was to join before that date so can then do the code *grins*

[schford]

Chuck - you are the man *bows*