Index: openacs-4/packages/dotlrn/www/spam.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/www/spam.xql,v diff -u -r1.10 -r1.11 --- openacs-4/packages/dotlrn/www/spam.xql 28 May 2018 13:29:57 -0000 1.10 +++ openacs-4/packages/dotlrn/www/spam.xql 29 May 2018 08:56:41 -0000 1.11 @@ -4,10 +4,7 @@ - select :from as from_addr, - :sender_first_names as sender_first_names, - :sender_last_name as sender_last_name, - parties.email, + select parties.email, CASE WHEN acs_objects.object_type = 'user' @@ -39,9 +36,7 @@ where person_id = parties.party_id) ELSE '' - END as last_name, - '$safe_community_name' as community_name, - '$community_url' as community_url + END as last_name from acs_rels, parties, acs_objects