Index: openacs-4/packages/forums/lib/forums/forums-chunk.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/lib/forums/forums-chunk.tcl,v
diff -u -r1.10 -r1.11
--- openacs-4/packages/forums/lib/forums/forums-chunk.tcl	15 Jun 2007 11:59:55 -0000	1.10
+++ openacs-4/packages/forums/lib/forums/forums-chunk.tcl	28 Feb 2008 06:51:49 -0000	1.11
@@ -23,7 +23,7 @@
     set unread_or_new_query_clause [db_map unread_or_new_query]
 } else {
     set unread_or_new_query_clause {
-	case when last_post > (current_date - interval '1' day) then 't' else 'f' end as new_p
+	case when last_post > (current_date - interval '1 day') then 't' else 'f' end as new_p
     }
 }
 
Index: openacs-4/packages/forums/www/resources/forums.js
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/resources/forums.js,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/forums/www/resources/forums.js	22 Feb 2008 07:17:42 -0000	1.3
+++ openacs-4/packages/forums/www/resources/forums.js	28 Feb 2008 06:51:49 -0000	1.4
@@ -91,27 +91,32 @@
 }
 
 function getActiveStyleSheet() {
-  var i, a;
-  for (i=0; (a = document.getElementsByTagName("link")[i]); i++) {
-    if (a.getAttribute("rel") &&
-        a.getAttribute("rel").indexOf("style") != -1 &&
-        a.getAttribute("title") &&
-        !a.disabled
-        ) return a.getAttribute("title");
-  }
-  return null;
+//  var i, a;
+//  for (i=0; (a = document.getElementsByTagName("link")[i]); i++) {
+//    if (a.getAttribute("rel") &&
+//        a.getAttribute("rel").indexOf("style") != -1 &&
+//        a.getAttribute("title") &&
+//        !a.disabled
+//        ) return a.getAttribute("title");
+//  }
+//  return null;
+    var a;
+    a = document.getElementById('expand');
+    if (a && a.style.display == 'none')
+	return 'expand';
+    return 'collapse';
 }
 
 function getPreferredStyleSheet() {
-  var i, a;
-  for (i=0; (a = document.getElementsByTagName("link")[i]); i++) {
-    if (a.getAttribute("rel") &&
-        a.getAttribute("rel").indexOf("style") != -1 &&
-        a.getAttribute("rel").indexOf("alt") == -1 &&
-        a.getAttribute("title")
-        ) return a.getAttribute("title");
-  }
-  return null;
+//  var i, a;
+//  for (i=0; (a = document.getElementsByTagName("link")[i]); i++) {
+//    if (a.getAttribute("rel") &&
+//        a.getAttribute("rel").indexOf("style") != -1 &&
+//        a.getAttribute("rel").indexOf("alt") == -1 &&
+//        a.getAttribute("title")
+//        ) return a.getAttribute("title");
+//  }
+  return 'expand';
 }
 
 function createCookie(name,value,days) {
@@ -137,7 +142,7 @@
 
 window.onload = function(e) {
   var cookie = readCookie("style");
-  var title = cookie ? cookie : getPreferredStyleSheet();
+  if (cookie == 'null') var title = getPreferredStyleSheet();
   setActiveStyleSheet(title);
 }
 
@@ -147,6 +152,6 @@
 }
 
 var cookie = readCookie("style");
-var title = cookie ? cookie : getPreferredStyleSheet();
+if (cookie == 'null') var title = getPreferredStyleSheet();
 setActiveStyleSheet(title);
 
Index: openacs-4/packages/forums-portlet/www/forums-portlet-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums-portlet/www/Attic/forums-portlet-oracle.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/forums-portlet/www/forums-portlet-oracle.xql	13 Jan 2005 13:58:18 -0000	1.2
+++ openacs-4/packages/forums-portlet/www/forums-portlet-oracle.xql	28 Feb 2008 06:51:49 -0000	1.3
@@ -12,7 +12,7 @@
             where site_nodes.object_id = forums_forums.package_id) as url,
             forums_forums.forum_id,
             forums_forums.name,
-            case when last_modified > (sysdate - 1) then 't' else 'f' end as new_p
+            case when last_post > (sysdate - 1) then 't' else 'f' end as new_p
             from forums_forums_enabled forums_forums,
             acs_objects
             where acs_objects.object_id = forums_forums.forum_id and 
Index: openacs-4/packages/forums-portlet/www/forums-portlet.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums-portlet/www/forums-portlet.tcl,v
diff -u -r1.15 -r1.16
--- openacs-4/packages/forums-portlet/www/forums-portlet.tcl	4 Jan 2008 17:30:38 -0000	1.15
+++ openacs-4/packages/forums-portlet/www/forums-portlet.tcl	28 Feb 2008 06:51:49 -0000	1.16
@@ -43,7 +43,7 @@
     }
 } else {
 	set unread_or_new_query {
-		case when last_modified > (cast(current_timestamp as date)- 1) then 't' else 'f' end as new_p
+		case when last_post > (cast(current_timestamp as date)- 1) then 't' else 'f' end as new_p
 	}
 }