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@ +
+

+ +
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
ForumSubjectPosted
@messages.forum_name@@messages.subject@@messages.posting_date@
+ No Postings. +
+ +
+ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + +
@messages.forum_name@

SubjectPosted
@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