As I want the migrated users to get email notifications as well per default, I wonder if there's a convenient way to "repopulate" or reset to defauls the phph_user_notifications table for all users.
Is there an SQL command that loops through all users ID's, and generates default notification setting for each user? i.e. each user should have an entry like this in phph_user_notifications.
Code: Select all
item_type item_id user_id method notify notification.type.topic 0 user_id notification.method.email 1 notification.type.post 0 user_id notification.method.email 1