View Full Version : SQL query question
October 11th, 2010, 02:38 PM
Hi, can I use this query without risk to break anything:
SET userid='19734', username='Freddy'
I want to assign some images to another user.
Edit, it worked fine.
October 11th, 2010, 10:59 PM
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..)
October 12th, 2010, 06:18 AM
Thanks Luc, it was for 2.5 and so far as I see there was no need for running maintenance functions.
October 12th, 2010, 12:21 PM
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..
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.