This is a proof of concept project dealing with Site Alerts in SharePoint Server 2007 (Should work fine in WSS v3 too). The project allows users to manage alerts across sites (in a single site collection) and subscribe/unsubscribe to a site (automatically signing them up for an alert on each unhidden list they have access to in a site). The code is written as an application pages application (layouts directory), and currently creates Daily Alerts for All Events.
These details are provided for information only. No information here is legal advice and should not be used as such.