Index: openacs-4/packages/robot-detection/robot-detection.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/robot-detection/robot-detection.info,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/robot-detection/robot-detection.info	20 Apr 2001 20:51:22 -0000	1.1
+++ openacs-4/packages/robot-detection/robot-detection.info	2 May 2001 20:36:12 -0000	1.2
@@ -23,10 +23,15 @@
             <file type="package_spec" path="robot-detection.info"/>
             <file type="data_model_create" db_type="oracle" path="sql/oracle/robot-detection-create.sql"/>
             <file type="data_model_drop" db_type="oracle" path="sql/oracle/robot-detection-drop.sql"/>
+            <file type="data_model_create" db_type="postgresql" path="sql/postgresql/robot-detection-create.sql"/>
+            <file type="data_model_drop" db_type="postgresql" path="sql/postgresql/robot-detection-drop.sql"/>
             <file type="tcl_init" path="tcl/robot-detection-init.tcl"/>
+            <file type="query_file" path="tcl/robot-detection-init.xql"/>
             <file type="tcl_procs" path="tcl/robot-detection-procs.tcl"/>
+            <file type="query_file" path="tcl/robot-detection-procs.xql"/>
             <file type="content_page" path="www/admin/index.adp"/>
-            <file type="content_page" path="www/admin/index.tcl"/>
+            <file type="content_page"  path="www/admin/index.tcl"/>
+            <file type="query_file" path="www/admin/index.xql"/>
             <file type="content_page" path="www/admin/refresh-robot-list.tcl"/>
             <file type="documentation" path="www/doc/acs-admin-guide.html"/>
             <file type="documentation" path="www/doc/ad-doc.css"/>
Index: openacs-4/packages/robot-detection/tcl/robot-detection-init.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/robot-detection/tcl/robot-detection-init.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/robot-detection/tcl/robot-detection-init.xql	2 May 2001 20:36:38 -0000	1.1
@@ -0,0 +1,13 @@
+<?xml version="1.0"?>
+<queryset>
+
+<fullquery name="robot_detection_id">      
+      <querytext>
+      
+select package_id from apm_packages 
+where package_key = 'robot-detection'
+      </querytext>
+</fullquery>
+
+ 
+</queryset>
Index: openacs-4/packages/robot-detection/tcl/robot-detection-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/robot-detection/tcl/robot-detection-procs.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/robot-detection/tcl/robot-detection-procs.xql	2 May 2001 20:36:38 -0000	1.1
@@ -0,0 +1,60 @@
+<?xml version="1.0"?>
+<queryset>
+
+<fullquery name="ad_replicate_web_robots_db.delete_old_robots_table">      
+      <querytext>
+      
+	    delete from robots
+	
+      </querytext>
+</fullquery>
+
+ 
+<fullquery name="ad_replicate_web_robots_db.insert_new_robot">      
+      <querytext>
+      
+                        insert into robots(robot_id, robot_name, robot_details_url, robot_useragent)
+                        values
+                        (:robot_id, :robot_name, :robot_details_url, :robot_useragent)
+                    
+      </querytext>
+</fullquery>
+
+ 
+<fullquery name="ad_replicate_web_robots_db.num_of_robots">      
+      <querytext>
+      select count(*) from robots
+      </querytext>
+</fullquery>
+
+ 
+<fullquery name="ad_cache_robot_useragents.populate_useragents_cache">      
+      <querytext>
+      select robot_useragent from robots
+      </querytext>
+</fullquery>
+
+ 
+<fullquery name="ad_robot_filter.robot_detection_id">      
+      <querytext>
+      select package_id from apm_packages where package_key = 'robot-detection'
+      </querytext>
+</fullquery>
+
+ 
+<fullquery name="ad_update_robot_list.robot_count">      
+      <querytext>
+      select count(*) from robots
+      </querytext>
+</fullquery>
+
+ 
+<fullquery name="ad_update_robot_list.days_since_last_update">      
+      <querytext>
+      
+		select trunc(current_time - max(coalesce(modified_date, insertion_date))) from robots
+      </querytext>
+</fullquery>
+
+ 
+</queryset>
Index: openacs-4/packages/robot-detection/www/admin/index.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/robot-detection/www/admin/index.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/robot-detection/www/admin/index.xql	2 May 2001 20:37:03 -0000	1.1
@@ -0,0 +1,11 @@
+<?xml version="1.0"?>
+<queryset>
+
+<fullquery name="robots_query">      
+      <querytext>
+      select robot_name, robot_details_url from robots order by robot_name
+      </querytext>
+</fullquery>
+
+ 
+</queryset>