Index: openacs-4/packages/ecommerce/www/admin/customer-service/spam-2.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/customer-service/spam-2.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ecommerce/www/admin/customer-service/spam-2.xql	29 Jan 2002 00:16:00 -0000	1.1
@@ -0,0 +1,58 @@
+<?xml version="1.0"?>
+<queryset>
+
+  <partialquery name="mailing_list">
+    <querytext>
+      select user_id, first_names, last_name from cc_users where user_id in ([join $user_id_list ", "])
+    </querytext>
+  </partialquery>
+
+  <partialquery name="null_categories">
+    <querytext>
+      (category_id is null and subcategory_id is null and subsubcategory_id is null)
+    </querytext>
+  </partialquery>
+
+  <partialquery name="null_subcategory">
+    <querytext>
+      (category_id=:mailing_list and subcategory_id is null)
+    </querytext>
+  </partialquery>
+
+  <partialquery name="null_subsubcategory">
+    <querytext>
+      (subcategory_id=[lindex $mailing_list 1] and subsubcategory_id is null)
+    </querytext>
+  </partialquery>
+
+  <partialquery name="subsubcategory">
+    <querytext>
+      subsubcategory_id=[lindex $mailing_list 2]
+    </querytext>
+  </partialquery>
+
+  <partialquery name="null_categories">
+    <querytext>
+      select users.user_id, first_names, last_name from cc_users, ec_cat_mailing_lists where users.user_id=ec_cat_mailing_lists.user_id
+    </querytext>
+  </partialquery>
+
+  <partialquery name="user_class">
+    <querytext>
+      select u.user_id, first_names, last_name from cc_users u, ec_user_class_user_map m where m.user_class_id=:user_class_id and m.user_id=u.user_id
+    </querytext>
+  </partialquery>
+
+  <partialquery name="all_users">
+    <querytext>
+      select user_id, first_names, last_name from cc_users
+    </querytext>
+  </partialquery>
+
+  <partialquery name="last_visit">
+    <querytext>
+      select user_id, first_names, last_name from cc_users where last_visit >= to_date(:start,'YYYY-MM-DD HH24:MI:SS') and last_visit <= to_date(:end,'YYYY-MM-DD HH24:MI:SS')
+    </querytext>
+  </partialquery>
+
+</queryset>
Index: openacs-4/packages/ecommerce/www/admin/customer-service/spam-log-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/customer-service/spam-log-oracle.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ecommerce/www/admin/customer-service/spam-log-oracle.xql	29 Jan 2002 00:16:00 -0000	1.1
@@ -0,0 +1,15 @@
+<?xml version="1.0"?>
+
+<queryset>
+  <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+
+  <fullquery name="get_spam_people">      
+    <querytext>
+      select spam_text, mailing_list_category_id, mailing_list_subcategory_id, mailing_list_subsubcategory_id, user_class_id, product_id, to_char(last_visit_start_date,'YYYY-MM-DD HH24:MI:SS') as full_last_visit_start_date, to_char(last_visit_end_date,'YYYY-MM-DD HH24:MI:SS') as full_last_visit_end_date, to_char(spam_date,'YYYY-MM-DD HH24:MI:SS') as full_spam_date 
+      from ec_spam_log 
+      where (spam_date >= to_date('$start 00:00:00','YYYY-MM-DD HH24:MI:SS') and spam_date <= to_date('$end 23:59:59','YYYY-MM-DD HH24:MI:SS')) 
+      order by spam_date desc
+    </querytext>
+  </fullquery>
+
+</queryset>
\ No newline at end of file
Index: openacs-4/packages/ecommerce/www/admin/customer-service/spam-log-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/customer-service/spam-log-postgresql.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ecommerce/www/admin/customer-service/spam-log-postgresql.xql	29 Jan 2002 00:16:00 -0000	1.1
@@ -0,0 +1,15 @@
+<?xml version="1.0"?>
+
+<queryset>
+  <rdbms><type>postgresql</type><version>7.1</version></rdbms>
+
+  <fullquery name="get_spam_people">      
+    <querytext>
+      select spam_text, mailing_list_category_id, mailing_list_subcategory_id, mailing_list_subsubcategory_id, user_class_id, product_id, to_char(last_visit_start_date,'YYYY-MM-DD HH24:MI:SS') as full_last_visit_start_date, to_char(last_visit_end_date,'YYYY-MM-DD HH24:MI:SS') as full_last_visit_end_date, to_char(spam_date,'YYYY-MM-DD HH24:MI:SS') as full_spam_date 
+      from ec_spam_log 
+      where (spam_date >= to_date('$start 00:00:00','YYYY-MM-DD HH24:MI:SS') and spam_date <= to_timestamp('$end 23:59:59','YYYY-MM-DD HH24:MI:SS')) 
+      order by spam_date desc
+    </querytext>
+  </fullquery>
+
+</queryset>
\ No newline at end of file