Index: openacs-4/packages/dotlrn-forums/dotlrn-forums.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-forums/dotlrn-forums.info,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/dotlrn-forums/dotlrn-forums.info 2 Jul 2002 23:02:17 -0000 1.4
+++ openacs-4/packages/dotlrn-forums/dotlrn-forums.info 9 Jul 2002 19:48:46 -0000 1.5
@@ -22,9 +22,9 @@
-
-
-
+
+
+
Fisheye: Tag 1.3 refers to a dead (removed) revision in file `openacs-4/packages/dotlrn-forums/www/user-history-oracle.xql'.
Fisheye: No comparison available. Pass `N' to diff?
Fisheye: Tag 1.3 refers to a dead (removed) revision in file `openacs-4/packages/dotlrn-forums/www/user-history.adp'.
Fisheye: No comparison available. Pass `N' to diff?
Fisheye: Tag 1.3 refers to a dead (removed) revision in file `openacs-4/packages/dotlrn-forums/www/user-history.tcl'.
Fisheye: No comparison available. Pass `N' to diff?
Index: openacs-4/packages/dotlrn-forums/www/user-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-forums/www/user-oracle.xql,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/dotlrn-forums/www/user-oracle.xql 9 Jul 2002 19:48:46 -0000 1.1
@@ -0,0 +1,45 @@
+
+
+
+ oracle8.1.6
+
+
+
+ select forums_messages.message_id,
+ forums_messages.subject,
+ to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date,
+ forums_forums.forum_id,
+ forums_forums.package_id,
+ forums_forums.name as forum_name,
+ (select site_node.url(node_id)
+ from site_nodes
+ where object_id = forums_forums.package_id) as url
+ from forums_messages,
+ forums_forums
+ where forums_messages.user_id = :user_id
+ and forums_messages.forum_id = forums_forums.forum_id
+ order by forums_messages.posting_date desc
+
+
+
+
+
+ select forums_messages.message_id,
+ forums_messages.subject,
+ to_char(forums_messages.posting_date, 'Mon DD YYYY HH24:MI:SS') as posting_date,
+ forums_forums.forum_id,
+ forums_forums.package_id,
+ forums_forums.name as forum_name,
+ (select site_node.url(node_id)
+ from site_nodes
+ where object_id = forums_forums.package_id) as url
+ from forums_messages,
+ forums_forums
+ where forums_messages.user_id = :user_id
+ and forums_messages.forum_id = forums_forums.forum_id
+ order by forum_name,
+ forums_messages.posting_date desc
+
+
+
+
Index: openacs-4/packages/dotlrn-forums/www/user.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-forums/www/user.adp,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/dotlrn-forums/www/user.adp 9 Jul 2002 19:48:46 -0000 1.1
@@ -0,0 +1,104 @@
+
+Forums: Posting history for @user.full_name@
+@context_bar@
+
+
+ Posting history for
+
+ <%
+ if {![permission::permission_p -object_id [acs_magic_object security_context_root] -privilege admin]} {
+ adp_puts [acs_community_member_link -user_id $user(user_id)]
+ } else {
+ adp_puts [acs_community_member_admin_link -user_id $user(user_id)]
+ }
+ %>
+
+
+
+
+
+@dimensional_chunk@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ @messages.forum_name@
|
+
+
+
+ Subject |
+ Posted |
+
+
+
+
+
+
+
+
+
+
+
+ @messages.subject@ |
+ @messages.posting_date@ |
+
+
+
+
+
+
+
+
+
+
+
+
+
Index: openacs-4/packages/dotlrn-forums/www/user.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-forums/www/user.tcl,v
diff -u
--- /dev/null 1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/dotlrn-forums/www/user.tcl 9 Jul 2002 19:48:46 -0000 1.1
@@ -0,0 +1,39 @@
+ad_page_contract {
+
+ Posting History for a User
+
+ @author Ben Adida (ben@openforce)
+ @creation-date 2002-05-29
+ @version $Id: user.tcl,v 1.1 2002/07/09 19:48:46 yon Exp $
+
+} {
+ user_id:integer,notnull
+ {view "date"}
+}
+
+# choosing the view
+set dimensional_list {
+ {
+ view "View:" date {
+ {date "by Date" {}}
+ {forum "by Forum" {}}
+ }
+ }
+}
+
+set query select_messages
+if {[string equal $view forum]} {
+ set query select_messages_by_forum
+}
+
+# Select the postings
+db_multirow messages $query {}
+
+# Get user information
+oacs::user::get -user_id $user_id -array user
+
+set dimensional_chunk [ad_dimensional $dimensional_list]
+
+set context_bar {{Posting History}}
+
+ad_return_template