Index: openacs-4/packages/forums/www/user-history-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/Attic/user-history-oracle.xql,v
diff -u -N
--- openacs-4/packages/forums/www/user-history-oracle.xql	29 May 2002 21:40:11 -0000	1.1
+++ /dev/null	1 Jan 1970 00:00:00 -0000
@@ -1,16 +0,0 @@
-<?xml version="1.0"?>
-<queryset>
-   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
-
-<fullquery name="select_messages">
-<querytext>
-select message_id, subject, posting_date, forums_forums.forum_id, forums_forums.name as forum_name
-from forums_messages, forums_forums
-where forums_messages.forum_id = forums_forums.forum_id
-and user_id= :user_id
-and package_id = :package_id
-$sql_order_by
-</querytext>
-</fullquery>
-
-</queryset>
Index: openacs-4/packages/forums/www/user-history.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/user-history.adp,v
diff -u -N -r1.2 -r1.3
--- openacs-4/packages/forums/www/user-history.adp	30 May 2002 06:25:52 -0000	1.2
+++ openacs-4/packages/forums/www/user-history.adp	3 Jun 2002 16:33:01 -0000	1.3
@@ -2,28 +2,97 @@
 <property name="title">Forums: Posting History for @user.full_name@</property>
 <property name="context_bar">@context_bar@</property>
 
-You are viewing Forums posting information for <b><%= [acs_community_member_link -user_id $user(user_id)] %></b>.
+<p>
+  You are viewing Forums posting information for
+  <b>
+    <%= [acs_community_member_link -user_id $user(user_id)] %>
+  </b>.
+</p>
 
+<p>
 <center>
 @dimensional_chunk@
 </center>
-<p>
+</p>
 
-<ul>
+<center>
 
-<if @view@ eq date>
+<if @view@ eq "date">
+
+  <table bgcolor="#cccccc" width="95%">
+
+    <tr>
+      <th align="left" width="30%">Forum</th>
+      <th align="left">Subject</th>
+      <th align="left" width="20%">Posted</th>
+    </tr>
+
+<if @messages:rowcount@ gt 0>
 <multiple name="messages">
-<li> <a href="forum-view?forum_id=@messages.forum_id@">@messages.forum_name@</a> - <a href="message-view?message_id=@messages.message_id@">@messages.subject@</a> on <%= [util_AnsiDatetoPrettyDate $messages(posting_date)] %>
+
+  <if @messages.rownum@ odd>
+    <tr bgcolor="#eeeeee">
+  </if>
+  <else>
+    <tr bgcolor="#d9e4f9">
+  </else>
+
+      <td><a href="forum-view?forum_id=@messages.forum_id@">@messages.forum_name@</a></td>
+      <td><a href="message-view?message_id=@messages.message_id@">@messages.subject@</a></td>
+      <td>@messages.posting_date@</td>
+
+    </tr>
+
 </multiple>
 </if>
+<else>
+    <tr>
+      <td colspan="3">
+        <i>No Postings.</i>
+      </td>
+    </tr>
+</else>
 
+  </table>
+
+</if>
+
 <if @view@ eq forum>
+
 <multiple name="messages">
-<h3>Forum: @messages.forum_name@</h3>
+
+  <table bgcolor="#cccccc" width="95%">
+
+    <tr bgcolor="#eeeeee">
+      <th align="left" colspan="2">@messages.forum_name@<br><br></th>
+    </tr>
+
+    <tr>
+      <th align="left">Subject</th>
+      <th align="left" width="20%">Posted</th>
+    </tr>
+
 <group column="forum_name">
-<li> <a href="message-view?message_id=@messages.message_id@">@messages.subject@</a> on <%= [util_AnsiDatetoPrettyDate $messages(posting_date)] %>
+
+  <if @messages.rownum@ odd>
+    <tr bgcolor="#eeeeee">
+  </if>
+  <else>
+    <tr bgcolor="#d9e4f9">
+  </else>
+
+      <td><a href="message-view?message_id=@messages.message_id@">@messages.subject@</a></td>
+      <td>@messages.posting_date@</td>
+
+    </tr>
+
 </group>
+
+  </table>
+  <br>
+
 </multiple>
+
 </if>
 
-</ul>
+</center>
Index: openacs-4/packages/forums/www/user-history.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/user-history.tcl,v
diff -u -N -r1.2 -r1.3
--- openacs-4/packages/forums/www/user-history.tcl	3 Jun 2002 04:39:05 -0000	1.2
+++ openacs-4/packages/forums/www/user-history.tcl	3 Jun 2002 16:33:01 -0000	1.3
@@ -13,8 +13,6 @@
 
 set package_id [ad_conn package_id]
 
-# FIXME: for now this shows all postings everywhere in all forums!
-
 # choosing the view
 set dimensional_list {
     {
Index: openacs-4/packages/forums/www/user-history.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/Attic/user-history.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/forums/www/user-history.xql	3 Jun 2002 16:33:01 -0000	1.1
@@ -0,0 +1,21 @@
+<?xml version="1.0"?>
+
+<queryset>
+
+    <fullquery name="select_messages">
+        <querytext>
+            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.name as forum_name
+            from forums_messages,
+                 forums_forums
+            where forums_messages.user_id = :user_id
+            and forums_messages.forum_id = forums_forums.forum_id
+            and forums_forums.package_id = :package_id
+            $sql_order_by
+        </querytext>
+    </fullquery>
+
+</queryset>