Index: openacs-4/packages/forums/forums.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/forums.info,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/forums/forums.info	3 Jun 2002 16:39:56 -0000	1.5
+++ openacs-4/packages/forums/forums.info	22 Jun 2002 20:58:04 -0000	1.6
@@ -33,6 +33,7 @@
             <file type="data_model" db_type="oracle" path="sql/oracle/forums-notifications-init.sql"/>
             <file type="data_model" db_type="oracle" path="sql/oracle/forums-tree-create.sql"/>
             <file type="data_model_create" db_type="postgresql" path="sql/postgresql/forums-create.sql"/>
+            <file type="data_model_drop" db_type="postgresql" path="sql/postgresql/forums-drop.sql"/>
             <file type="data_model_create" db_type="postgresql" path="sql/postgresql/forums-forums-create.sql"/>
             <file type="data_model_drop" db_type="postgresql" path="sql/postgresql/forums-forums-drop.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/forums-forums-package-create.sql"/>
@@ -42,7 +43,9 @@
             <file type="data_model" db_type="postgresql" path="sql/postgresql/forums-messages-package-create.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/forums-messages-package-drop.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/forums-notifications-init.sql"/>
+            <file type="data_model" db_type="postgresql" path="sql/postgresql/forums-notifications-sanitize.sql"/>
             <file type="data_model" db_type="postgresql" path="sql/postgresql/forums-tree-create.sql"/>
+            <file type="data_model" db_type="postgresql" path="sql/postgresql/forums-tree-drop.sql"/>
             <file type="tcl_procs" path="tcl/forums-procs.tcl"/>
             <file type="query_file" path="tcl/forums-procs.xql"/>
             <file type="tcl_procs" path="tcl/forums-security-procs.tcl"/>
@@ -64,7 +67,7 @@
             <file type="content_page" path="www/forum-view.adp"/>
             <file type="content_page" path="www/forum-view.tcl"/>
             <file type="query_file" db_type="oracle" path="www/index-oracle.xql"/>
-            <file type="query_file" path="www/index-postresql.xql"/>
+            <file type="query_file" db_type="postgresql" path="www/index-postgresql.xql"/>
             <file type="content_page" path="www/index.adp"/>
             <file type="content_page" path="www/index.tcl"/>
             <file type="content_page" path="www/master.adp"/>
Index: openacs-4/packages/forums/tcl/forums-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/tcl/forums-procs.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/forums/tcl/forums-procs.xql	30 May 2002 06:25:52 -0000	1.2
+++ openacs-4/packages/forums/tcl/forums-procs.xql	22 Jun 2002 20:58:04 -0000	1.3
@@ -1,47 +1,51 @@
 <?xml version="1.0"?>
 <queryset>
 
-<fullquery name="forum::edit.update_forum">
-<querytext>
-update forums_forums set
-name= :name,
-charter= :charter,
-presentation_type= :presentation_type,
-posting_policy= :posting_policy
-where 
-forum_id= :forum_id
-</querytext>
-</fullquery>
+    <fullquery name="forum::edit.update_forum">
+        <querytext>
+            update forums_forums
+            set name= :name,
+                charter= :charter,
+                presentation_type= :presentation_type,
+                posting_policy= :posting_policy
+            where forum_id = :forum_id
+        </querytext>
+    </fullquery>
 
-<fullquery name="forum::list_forums.select_forums">
-<querytext>
-select forum_id, name, posting_policy, presentation_type
-from forums_forums
-where package_id= :package_id
-order by name
-</querytext>
-</fullquery>
+    <fullquery name="forum::list_forums.select_forums">
+        <querytext>
+            select forum_id,
+                   name,
+                   posting_policy,
+                   presentation_type
+            from forums_forums
+            where package_id = :package_id
+            order by name
+        </querytext>
+    </fullquery>
 
-<fullquery name="forum::get.select_forum">      
-      <querytext>
-      
-        select * from forums_forums where forum_id = :forum_id
-    
-      </querytext>
-</fullquery>
+    <fullquery name="forum::get.select_forum">      
+        <querytext>
+            select *
+            from forums_forums
+            where forum_id = :forum_id
+        </querytext>
+    </fullquery>
 
-<fullquery name="forum::enable.update_forum_enabled_p">
-<querytext>
-update forums_forums set enabled_p='t'
-where forum_id= :forum_id
-</querytext>
-</fullquery> 
+    <fullquery name="forum::enable.update_forum_enabled_p">
+        <querytext>
+            update forums_forums
+            set enabled_p = 't'
+            where forum_id = :forum_id
+        </querytext>
+    </fullquery> 
 
-<fullquery name="forum::disable.update_forum_disabled_p">
-<querytext>
-update forums_forums set enabled_p='f'
-where forum_id= :forum_id
-</querytext>
-</fullquery>
+    <fullquery name="forum::disable.update_forum_disabled_p">
+        <querytext>
+            update forums_forums
+            set enabled_p = 'f'
+            where forum_id = :forum_id
+        </querytext>
+    </fullquery>
  
 </queryset>
Index: openacs-4/packages/forums/tcl/messages-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/tcl/messages-procs.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/forums/tcl/messages-procs.xql	29 May 2002 21:40:10 -0000	1.1
+++ openacs-4/packages/forums/tcl/messages-procs.xql	22 Jun 2002 20:58:04 -0000	1.2
@@ -1,31 +1,30 @@
 <?xml version="1.0"?>
 <queryset>
 
-<fullquery name="forum::message::set_html_p.update_message_html_p">
-<querytext>
-update forums_messages set
-html_p= :html_p
-where 
-message_id= :message_id
-</querytext>
-</fullquery>
+    <fullquery name="forum::message::set_html_p.update_message_html_p">
+        <querytext>
+            update forums_messages
+            set html_p = :html_p
+            where message_id = :message_id
+        </querytext>
+    </fullquery>
 
-<fullquery name="forum::message::edit.update_message">
-<querytext>
-update forums_messages set
-subject= :subject,
-content= :content,
-html_p= :html_p
-where message_id= :message_id
-</querytext>
-</fullquery>
+    <fullquery name="forum::message::edit.update_message">
+        <querytext>
+            update forums_messages
+            set subject = :subject,
+                content = :content,
+                html_p = :html_p
+            where message_id = :message_id
+        </querytext>
+    </fullquery>
 
-<fullquery name="forum::message::set_state.update_message_state">
-<querytext>
-update forums_messages set
-state= :state
-where message_id= :message_id
-</querytext>
-</fullquery>
+    <fullquery name="forum::message::set_state.update_message_state">
+        <querytext>
+            update forums_messages
+            set state = :state
+            where message_id = :message_id
+        </querytext>
+    </fullquery>
 
 </queryset>
Index: openacs-4/packages/forums/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/Attic/index-postgresql.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/forums/www/index-postgresql.xql	22 Jun 2002 20:58:04 -0000	1.1
@@ -0,0 +1,27 @@
+<?xml version="1.0"?>
+
+<queryset>
+    <rdbms><type>postgresql</type><version>7.1</version></rdbms>
+
+    <fullquery name="select_forums">
+        <querytext>
+            select forums_forums_enabled.*,
+                   (select count(*)
+                    from forums_messages
+                    where forums_messages.forum_id = forums_forums_enabled.forum_id
+                    and 1 = tree_level(forums_messages.tree_sortkey)) as n_threads,
+                   to_char(acs_objects.last_modified, 'Mon DD YYYY HH24:MI:SS') as last_modified
+            from forums_forums_enabled,
+                 acs_objects
+            where forums_forums_enabled.package_id = :package_id
+            and (
+                    forums_forums_enabled.posting_policy = 'open'
+                 or forums_forums_enabled.posting_policy = 'moderated'
+                 or 't' = acs_permission__permission_p(:user_id, forums_forums_enabled.forum_id, 'forum_read')
+                )
+            and forums_forums_enabled.forum_id = acs_objects.object_id
+            order by forums_forums_enabled.name
+        </querytext>
+    </fullquery>
+
+</queryset>
Fisheye: Tag 1.3 refers to a dead (removed) revision in file `openacs-4/packages/forums/www/index-postresql.xql'.
Fisheye: No comparison available.  Pass `N' to diff?