General developer forum

determining recipient user id in individual blog posts

 
Picture of nim rod
determining recipient user id in individual blog posts
 

Hi to all, i'm working on a notification plugin for the oublog component.
the idea is sending "new blog post" notifications to relevant users.
for a blog that is defined as "individual blog" how would i query the Db to find which users should be notified?
 can determine wether a blog is set to "individual"  with

 select individual from mdl_oublog  where  id = my_blog_id
and i can cross link mdl_oublog_posts and mdl_oublog_instances to find which user posted but
do i find the recipient,  the user that is allowed to view that individual post? (typically that would be either a teacher or a student)


Thanks  and sorry if that's a newbe question, i am rather new to moodle..

 

 




 
Average of ratings: -