How do I update subscription mode for all users?

[kobescoresagain]

I would like to make it so that all users get an email nightly of posts on the site. What can I do to change this? I know enough about mysql to do it there, if someone tells me the field to change. Or is there a way to do it through the modcp or admincp?

[Kirk Y]

There used to be a hack that mailed all your users about the posts on the site. You could use this query to automatically email users when a reply is posted in a thread they're subscribed to.

UPDATE user SET autosubscribe = 2