Change individual video ownership of a single category

Mike Fara

Active member
Does anyone have any tips on how to do this? I imagine it would require a SQL query at this time. Basically, a bunch of videos were imported for another user and placed into a category for him. These number in the hundreds. I'd like to take my name off as uploader and give that user full credit and control over that content.

Chris D

XenForo developer
Staff member
The fields you would need to change are xengallery_media.username and xengallery_media.user_id.

I would suggest taking a back up first and be prepared to restore that in case any mistakes are made.

UPDATE xengallery_media
SET username = 'DESIRED USERNAME', user_id = 'DESIRED USER_ID'
WHERE category_id = '9999'
Just change the username, user ID and category ID accordingly in the above query. It would change the username and user ID for all media in the specified category.

Chris D

XenForo developer
Staff member
You may want to do some of the Gallery Rebuilds too.

Specifically those that rebuild user counts.

Otherwise, the counts for the two users involved will be wrong.