• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Change individual video ownership of a single category

Mike Fara

Active member
#1
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
#2
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.

Code:
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
#4
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.