Question about userid

[-Chef-]

I did a complete switchover of my site. My previous site was phpBB2 + PhotoPost and I have switched to vB3 + vBaGallery.

After I imported phpBB into vB and PP into vBaGallery I have one problem. My userid in phpBB was "2". My new userid in vB is obviously "1". I did the "associate user" thing on my forum import.

My userid for imported images is still "2" in the gallery. I am pretty sure that I can just edit the "userid" field in the "adv_gallery_images" database table and change it from "2" to "1" since the username field and everything else is correct.

Now my question/request. Could somone please write me the small query that will change the "userid" field in the "adv_gallery_images" table so that if it is "2" it will change it to "1"? I am pretty sure it would just be a simple query but I am quite clueless to this. If I have to I can manually edit each image entry and change it but I was hoping someone here could help me out and save me 100+ individual changes for all my images.

Thanks!

[ConqSoft]

UPDATE adv_gallery_images SET userid = 1 WHERE userid = 2

Something like that.

[rbl]

Chef, were you the only user?

Not quite that easy as you would have to move all of the images since they are placed in a folder associated with your userid.

[-Chef-]

Originally Posted by Brian

Not quite that easy as you would have to move all of the images since they are placed in a folder associated with your userid.

That is not really a problem because I can just copy/paste all the images in my FTP proggy from one folder to the other.

I am the only user that had this issue. It is only because of the fact that I had imported from phpBB2 where userid-1 is Anonamous and installing admin is default userid-2. So, all my imported images are under userid-2 in my PP imported gallery.
It's not a huge deal as this only disrupts me and not any of my users. I may just do a manual FTP upload of my own images....needed to clean up anyway.

Shouldn't be too hard to do then if you just run the query mentioned above and then move all of the images in the 2 folder to the 1 folder.

[-Chef-]

Worked like a charm. Ran that query then moved all the images in "files/2" over to "files/1" and all is right in the world.

Thanks ConqSoft for the query and thanks Brian for the advice.