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

MG 1.1 Question about imported media and albums, watching media, and email

Discussion in 'Media Gallery Support' started by Travis-Mc, Apr 7, 2016.

  1. Travis-Mc

    Travis-Mc Member

    I've imported albums from vb3.8 to XFMG. My question is, for the albums that were imported, will creators of the albums automatically be watching their albums like they would if they just created them? I want to make sure they're getting email when people comment on their old pictures.
     
  2. Chris D

    Chris D XenForo Developer Staff Member

    No. They would have to manually watch things.
     
  3. Travis-Mc

    Travis-Mc Member

    Is there a query I could run on the database to make all creators of albums be watching their albums?
     
  4. Chris D

    Chris D XenForo Developer Staff Member

    This should work but please back up your database first in case anything goes wrong, also you may wish to adjust the values slightly:
    Code:
    INSERT IGNORE INTO xengallery_media_watch
        (user_id, media_id, notify_on, send_alert, send_email)
        (
            SELECT user_id, media_id, 'comment' AS notify_on, '1' AS send_alert, '1' AS send_email
            FROM xengallery_media
        )
    This will make it so that everyone who has uploaded media items will be watching their media items for new comments. If a new comment is posted on a media item they will receive an alert and they will receive an email.

    If you require a different behaviour, let me know.
     
  5. Travis-Mc

    Travis-Mc Member

    That is the behavior I'm looking for. I'll be sure to do a backup and give that a try. Thank you very much!
     

Share This Page