Index: openacs-4/contrib/packages/irc-logger/tcl/irc-logger-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/irc-logger/tcl/irc-logger-procs-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/contrib/packages/irc-logger/tcl/irc-logger-procs-postgresql.xql	31 Jan 2003 06:27:32 -0000	1.2
+++ openacs-4/contrib/packages/irc-logger/tcl/irc-logger-procs-postgresql.xql	10 Mar 2003 20:27:32 -0000	1.3
@@ -6,12 +6,48 @@
     <version>7.1</version>
   </rdbms>
 
+  <fullquery name="irc::logger::rotate_logs.get_parent_id">
+    <querytext>
+      select etp__get_folder_id(:package_id)
+    </querytext>
+  </fullquery>
+
+  <fullquery name="irc::logger::rotate_logs.etp_logs">
+    <querytext>
+      select i1.item_id, i1.tree_sortkey, coalesce((
+      	select tree_sortkey 
+      	from cr_items i2 
+      	where i2.tree_sortkey > i1.tree_sortkey 
+      	and i2.parent_id = :parent_id 
+        and i2.name <> 'index'
+        and $i2_select_criteria
+      	order by i2.tree_sortkey limit 1), (
+      	select i2.tree_sortkey 
+      	from cr_items i2
+      	where i2.parent_id = :parent_id
+        and i2.name <> 'index'
+        and $i2_select_criteria
+      	order by i2.tree_sortkey limit 1)) as next_sortkey
+      from cr_items i1
+      where i1.parent_id = :parent_id 
+      and i1.name <> 'index'
+      and $i1_select_criteria
+      order by i1.tree_sortkey;
+    </querytext>
+  </fullquery>
+
   <fullquery name="irc::logger::update_log.page_create">
     <querytext>
       select etp__create_page(:parent_package_id, :date, :date, :content_type)
     </querytext>
   </fullquery>
 
+  <fullquery name="irc::logger::update_log.create_extlink">
+    <querytext>
+      select etp__create_extlink(:parent_package_id, :log_url, :link_label, :link_description);
+    </querytext>
+  </fullquery>
+
   <fullquery name="dom::xpathFunc::irc::logger::user_link.get_user">
     <querytext>
       select u.user_id, p.first_names || ' ' || p.last_name as name