Spam System Release Notes

by Bill Schneider
The spam system requires the ACS Mail service version 4.1. It is a singleton service and should be mounted on a site node URL like /spam.

In order for spam to be useful, you must link to it from another package. A good place to link to spam is from the admin/groups/one.tcl page:

set sql_query "select member_id as party_id 
     from group_member_map m 
     where group_id = $group_id"

ad_set_client_property spam "sql_query" $sql_query
ad_set_client_property spam "object_id" $group_id

set spam_url "[spam_base]/spam-add"
and in the corresponding template:
<p>
 <a href="@spam_url@">Spam all members</a>
</p>
set spam_url "[spam_base]spam-add?"

If you are using ACS 4.1.x, you will probably need to patch your acs-content PL/SQL package, since there is a PL/SQL function acs_content.new function that doesn't return a value. You can patch your acs-content-create.sql file using this patch:

diff -r1.1.1.1 -r1.2
7c7
< -- $Id: release-notes.html,v 1.1 2001/04/20 20:51:25 donb Exp $
---
> -- $Id: release-notes.html,v 1.1 2001/04/20 20:51:25 donb Exp $
73a74,78
>       if content_id is null then
>               select acs_object_id_seq.nextval into v_content_id from dual;
>       else
>               v_content_id := content_id;
>       end if;
81c86
<           acs_content.new.content_id,
---
>           v_content_id,
86a92
>       return v_content_id;