Index: openacs-4/packages/download/www/admin/spam-users.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/download/www/admin/spam-users.xql,v
diff -u -r1.1 -r1.1.4.1
--- openacs-4/packages/download/www/admin/spam-users.xql	10 May 2001 20:51:31 -0000	1.1
+++ openacs-4/packages/download/www/admin/spam-users.xql	6 Dec 2002 11:31:28 -0000	1.1.4.1
@@ -3,7 +3,13 @@
 
 <fullquery name="user_select">      
       <querytext>
-      select u.email, u.user_id, u.user_name from ($sql_query) u
+      select u.email, 
+             u.user_id, 
+             u.last_name || ', ' || u.first_names as user_name 
+        from cc_users u, user_preferences up
+        where u.user_id in ([join $user_id_list ,]) and
+              u.user_id = up.user_id and
+              up.dont_spam_me_p = 'f'
       </querytext>
 </fullquery>