Index: openacs-4/packages/edit-this-page/www/etp-publish-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/www/etp-publish-oracle.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/edit-this-page/www/etp-publish-oracle.xql	31 Oct 2001 04:40:30 -0000	1.1
@@ -0,0 +1,21 @@
+<?xml version="1.0"?>
+<queryset>
+
+<fullquery name="set_publish_date">
+<querytext>
+update cr_revisions
+set publish_date = sysdate
+where revision_id = :latest_revision_id
+</querytext>
+</fullquery>
+
+<fullquery name="set_audit_info">
+<querytext>
+update acs_objects
+set modifying_user = :user_id,
+    last_modified = sysdate
+where object_id = :latest_revision_id
+</querytext>
+</fullquery>
+
+</queryset>
Index: openacs-4/packages/edit-this-page/www/etp-publish-postgres.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/www/Attic/etp-publish-postgres.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/edit-this-page/www/etp-publish-postgres.xql	31 Oct 2001 04:40:35 -0000	1.1
@@ -0,0 +1,22 @@
+<?xml version="1.0"?>
+<queryset>
+
+<fullquery name="set_publish_date">
+<querytext>
+update cr_revisions
+set publish_date = now()
+where revision_id = :latest_revision_id
+</querytext>
+</fullquery>
+
+<fullquery name="set_audit_info">
+<querytext>
+update acs_objects
+set modifying_user = :user_id,
+    last_modified = now()
+where object_id = :latest_revision_id
+</querytext>
+</fullquery>
+
+
+</queryset>
Index: openacs-4/packages/edit-this-page/www/etp-publish.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/www/etp-publish.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/edit-this-page/www/etp-publish.xql	24 Sep 2001 17:24:13 -0000	1.1
+++ openacs-4/packages/edit-this-page/www/etp-publish.xql	31 Oct 2001 04:40:41 -0000	1.2
@@ -9,22 +9,4 @@
 </querytext>
 </fullquery>
  
-<fullquery name="set_publish_date">
-<querytext>
-update cr_revisions
-set publish_date = now()
-where revision_id = :latest_revision_id
-</querytext>
-</fullquery>
-
-<fullquery name="set_audit_info">
-<querytext>
-update acs_objects
-set modifying_user = :user_id,
-    last_modified = now()
-where object_id = :latest_revision_id
-</querytext>
-</fullquery>
-
-
 </queryset>
Index: openacs-4/packages/edit-this-page/www/etp-revert-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/www/etp-revert-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/edit-this-page/www/etp-revert-oracle.xql	24 Sep 2001 17:24:13 -0000	1.1
+++ openacs-4/packages/edit-this-page/www/etp-revert-oracle.xql	31 Oct 2001 04:44:07 -0000	1.2
@@ -9,5 +9,25 @@
 end;
 </querytext>
 </fullquery>
+
+<fullquery name="get_item_id">
+<querytext>
+  select item_id
+    from cr_items
+   where parent_id = etp.get_folder_id(:package_id)
+     and name = :name
+</querytext>
+</fullquery>
  
+<fullquery name="get_revision_count">
+<querytext>
+    select count(1) as revision_count
+    from cr_revisions r, cr_items i
+    where r.item_id = i.item_id
+    and i.parent_id = etp.get_folder_id(:package_id)
+    and i.name = :name
+    and r.revision_id > :revision_id
+</querytext>
+</fullquery>
+ 
 </queryset>
Index: openacs-4/packages/edit-this-page/www/etp-revert-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/www/etp-revert-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/edit-this-page/www/etp-revert-postgresql.xql	24 Sep 2001 17:24:13 -0000	1.1
+++ openacs-4/packages/edit-this-page/www/etp-revert-postgresql.xql	31 Oct 2001 04:44:12 -0000	1.2
@@ -10,4 +10,24 @@
 </querytext>
 </fullquery>
 
+<fullquery name="get_item_id">
+<querytext>
+  select item_id
+    from cr_items
+   where parent_id = etp__get_folder_id(:package_id)
+     and name = :name
+</querytext>
+</fullquery>
+ 
+<fullquery name="get_revision_count">
+<querytext>
+    select count(1) as revision_count
+    from cr_revisions r, cr_items i
+    where r.item_id = i.item_id
+    and i.parent_id = etp__get_folder_id(:package_id)
+    and i.name = :name
+    and r.revision_id > :revision_id
+</querytext>
+</fullquery>
+
 </queryset>
Index: openacs-4/packages/edit-this-page/www/etp-revert.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/www/etp-revert.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/edit-this-page/www/etp-revert.xql	24 Sep 2001 17:24:13 -0000	1.1
+++ openacs-4/packages/edit-this-page/www/etp-revert.xql	31 Oct 2001 04:44:17 -0000	1.2
@@ -1,15 +1,6 @@
 <?xml version="1.0"?>
 <queryset>
 
-<fullquery name="get_item_id">
-<querytext>
-  select item_id
-    from cr_items
-   where parent_id = etp_get_folder_id(:package_id)
-     and name = :name
-</querytext>
-</fullquery>
- 
 <fullquery name="set_live_revision">
 <querytext>
   update cr_items
@@ -28,15 +19,4 @@
 </querytext>
 </fullquery>
  
-<fullquery name="get_revision_count">
-<querytext>
-    select count(1) as revision_count
-    from cr_revisions r, cr_items i
-    where r.item_id = i.item_id
-    and i.parent_id = etp_get_folder_id(:package_id)
-    and i.name = :name
-    and r.revision_id > :revision_id
-</querytext>
-</fullquery>
-
 </queryset>