Index: openacs-4/packages/download/www/admin/spam-users-2-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/download/www/admin/Attic/spam-users-2-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/download/www/admin/spam-users-2-oracle.xql	10 May 2001 20:51:31 -0000	1.1
+++ openacs-4/packages/download/www/admin/spam-users-2-oracle.xql	13 Aug 2001 21:37:31 -0000	1.2
@@ -7,7 +7,7 @@
       <querytext>
       
         begin
-           :1 := nt.post_request(
+           :1 := acs_mail_nt.post_request(
                 party_from => :user_id,
                 party_to => :to_user_id,
                 expand_group => 'f',
Index: openacs-4/packages/download/www/admin/spam-users-2-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/download/www/admin/Attic/spam-users-2-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/download/www/admin/spam-users-2-postgresql.xql	11 May 2001 05:20:45 -0000	1.2
+++ openacs-4/packages/download/www/admin/spam-users-2-postgresql.xql	13 Aug 2001 21:37:31 -0000	1.3
@@ -4,19 +4,16 @@
    <rdbms><type>postgresql</type><version>7.1</version></rdbms>
 
 <fullquery name="sendmail">      
-      <querytext>
-      FIX ME PLSQL - need acs_notification
+<querytext>
 
-        begin
-           :1 := nt__post_request(
-                party_from => :user_id,
-                party_to => :to_user_id,
-                expand_group => 'f',
-                subject => :subject,
-                message => :msgbody);
-        end;
+select acs_mail_nt__post_request (
+    :user_id,    -- p_party_from
+    :to_user_id, -- p_party_to
+    :subject,    -- p_subject
+    :msgbody     -- p_message
+);
     
-      </querytext>
+</querytext>
 </fullquery>
 
  
Index: openacs-4/packages/download/www/admin/spam-users-2.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/download/www/admin/spam-users-2.tcl,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/download/www/admin/spam-users-2.tcl	20 Apr 2001 20:51:10 -0000	1.1
+++ openacs-4/packages/download/www/admin/spam-users-2.tcl	13 Aug 2001 21:37:31 -0000	1.2
@@ -36,14 +36,12 @@
 set count 0
 foreach to_user_id $userid_list {
     db_exec_plsql sendmail {
-        begin
-           :1 := nt.post_request(
-                party_from => :user_id,
-                party_to => :to_user_id,
-                expand_group => 'f',
-                subject => :subject,
-                message => :msgbody);
-        end;
+        select acs_mail_nt__post_request (
+		    :user_id,    -- p_party_from
+		    :to_user_id, -- p_party_to
+		    :subject,    -- p_subject
+		    :msgbody     -- p_message
+		  );
     }
     incr count
 }