Index: openacs-4/packages/notifications/notifications.info =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/notifications.info,v diff -u -r1.24.2.7 -r1.24.2.8 --- openacs-4/packages/notifications/notifications.info 12 Jan 2005 07:17:40 -0000 1.24.2.7 +++ openacs-4/packages/notifications/notifications.info 8 Apr 2005 18:43:54 -0000 1.24.2.8 @@ -8,14 +8,14 @@ t notifications - + OpenACS Email notifications management 2003-11-07 OpenACS Provides an API for packages to provide subscription based email notifications and handle replies. Used by forums, bug-tracker, etc. The currently prefered package for email notifications. - + Index: openacs-4/packages/notifications/tcl/notification-request-procs.tcl =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/tcl/notification-request-procs.tcl,v diff -u -r1.7.4.1 -r1.7.4.2 --- openacs-4/packages/notifications/tcl/notification-request-procs.tcl 17 Jun 2004 21:11:22 -0000 1.7.4.1 +++ openacs-4/packages/notifications/tcl/notification-request-procs.tcl 8 Apr 2005 18:43:54 -0000 1.7.4.2 @@ -62,6 +62,15 @@ return [expr { [db_string request_count {}] > 0 }] } + ad_proc -public request_count { + {-type_id:required} + {-object_id:required} + } { + returns number of notification requests for this type and object + } { + return [db_string request_count {} -default 0] + } + ad_proc -public delete { {-request_id:required} } { Index: openacs-4/packages/notifications/tcl/notification-request-procs.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/tcl/notification-request-procs.xql,v diff -u -r1.4 -r1.4.4.1 --- openacs-4/packages/notifications/tcl/notification-request-procs.xql 16 Jan 2003 13:53:10 -0000 1.4 +++ openacs-4/packages/notifications/tcl/notification-request-procs.xql 8 Apr 2005 18:43:54 -0000 1.4.4.1 @@ -21,4 +21,13 @@ + + + select count(*) + from notification_requests + where type_id = :type_id + and object_id = :object_id + + +