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

[Travis-Mc]

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.

 

[Chris D]

No. They would have to manually watch things.

 

[Travis-Mc]

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

 

[Chris D]

This should work but please back up your database first in case anything goes wrong, also you may wish to adjust the values slightly:

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.

 

[Travis-Mc]

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!