1. 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

Discussion in 'Media Gallery Support' started by Mike Fara, Jan 22, 2015.

  1. Mike Fara

    Mike Fara 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.
  2. Chris D

    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.
    Mike Fara likes this.
  3. Mike Fara

    Mike Fara Member

  4. Chris D

    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.

Share This Page