Change individual video ownership of a single category

[Mike Fara]

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]

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.

 

[Mike Fara]

Thanks @Chris D worked perfectly.

 

[Chris D]

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.