SQL query question

[Ramses]

Hi, can I use this query without risk to break anything:

UPDATE vb3_ppgal_images
SET userid='19734', username='Freddy'
WHERE userid='9397'

I want to assign some images to another user.
Thank you.

Edit, it worked fine.

[Luciano]

Not sure for vbgallery 2.5x but for vbgallery 3 you would also have to go to acp=>vbgallery=>maintenance
and redo nearly all counts. because if the image was the last upload of a user, it will still appear as last image of the former user. same with category etc... (not forgetting in the profile, last upload etc..)
Luc

[Ramses]

Thanks Luc, it was for 2.5 and so far as I see there was no need for running maintenance functions.

[Luciano]

well if the image was not last image of a user and not last upload of a category, then you are correct, there is no need in running maintenance..