I need some help concerning journal notifications. I know a lot of people are looking for a way to send notifications to groups, friends/followers when a post is made to the journal. This is something that has become urgent and I think I have short term solution and wanted to get your thoughts.
My focus is social groups at the moment.
DNN core messaging has a number of tables that get populated when a notification event occurs like when someone joins or starts a group, friend request etc.
How difficult would it be to create a sql script that looks at the journal table for a period of time (hourly, daily, Weekly, monthly) and makes entries into the appropriate core messaging tables that then DNN could handle the distribution of the notification based on the users preference set in their profile. I don't want a user to get a lot of notifications so I want to create a digest based on preference.
Because I am interested in a group notification (only members of the group would receive the notifications) the script would need to look-up all users in the group role and create an entry for each user.
Could anyone help with this sql? I am surprised that someone has not created a module for this :)
Thanks for your thoughts/advice