Mark all forum posts as "read"?

I'm a firm believer in:
Give a man a fish, feed him for a day;
Teach a man to fish, feed him for life.

So...how did you get from:
http://drupal.org/project/issues/search
to:
http://drupal.org/project/issues/search/drupal

...without, of course, simply adding "drupal" in the browser?

I played around with http://drupal.org/project/issues/search but couldn't figure out a way to get to your link without intuitively knowing to type in drupal at the end of my URL.

By the way, I was able to find exactly what I was looking for using your advanced search URL!
http://drupal.org/node/2748
http://drupal.org/node/1762

Most excellent. Thanks!

-----
Walt Esquivel, MBA, MA, Captain - U.S. Marine Corps (Veteran)
President, Wellness Corps, LLC
-----

Okay here is the module in question, the markasread.module. It is really not a big piece of php so all you php gurus may be able to see what does it do wrong in regards to the Drupal 4.7 and its marking as read/unread functionalities.

Here is it:

function markasread_menu($may_cache)
{
   $toreturn = array();
   if (!$may_cache)
   {
      $toreturn[] = array('path' => 'node/markasread',
            'title' => t('mark all content read'),
            'callback' => '_markasread',
            'access' => user_access('access content'),
            'type' => MENU_CALLBACK);
   }

   return $toreturn;
}

function _markasread($tid  = NULL)
{
  global $user;
  if ($user && $user->uid)
  {
      if (!is_null($tid))
      {
        if (is_numeric($tid) && $tid)
         {
            db_query("REPLACE INTO {history} (uid,nid,timestamp)
SELECT '%d',n.nid,UNIX_TIMESTAMP() FROM {node} n
INNER JOIN {term_node} r ON n.nid=r.nid
INNER JOIN {node_comment_statistics} l ON l.nid=n.nid
WHERE (n.created > '%d' OR l.last_comment_timestamp > '%d')
AND r.tid='%d'", $user->uid,NODE_NEW_LIMIT,NODE_NEW_LIMIT,$tid);
            drupal_goto("forum/$tid");
         }
         else
         {
            db_query("REPLACE INTO {history} (uid,nid,timestamp)
SELECT '%d',n.nid,UNIX_TIMESTAMP() FROM {node} n
INNER JOIN {node_comment_statistics} l ON l.nid=n.nid
WHERE (n.created > '%d' OR l.last_comment_timestamp > '%d')",
$user->uid,NODE_NEW_LIMIT,NODE_NEW_LIMIT);
            drupal_goto("forum");
         }
         print theme('page',"All content has been marked read");
      }
   }
   drupal_goto('forum');
}

So, any clues?

Thanks alot!
Daniel

This is in relation to the module markasread available at http://wtanaka.com/drupal/markasread

I unfortunately do not have a PostgreSQL drupal setup at the moment to verify this test but I believe this should work...

I modified the REPLACE INTO query to a switch test for db_type and used a slightly different query for PostgreSQL. Adding a join to the history table for the user will ensure that the INSERT will not attempt to insert duplicate rows. At least that's the theory :)

      switch($GLOBALS['db_type']) {
        case 'mysql':
        case 'mysqli':
          $sql = 'REPLACE INTO {history} (uid,nid,timestamp)'
            .' SELECT %d, n.nid, %d FROM {node} n'
            .($tid ? ' INNER JOIN {term_node} r ON n.nid=r.nid' : '')
            .' INNER JOIN {node_comment_statistics} l ON l.nid=n.nid'
            .' WHERE (n.created > %d'
            .' OR l.last_comment_timestamp > %d)';
          $args = array($user->uid, time(), NODE_NEW_LIMIT, NODE_NEW_LIMIT);
          break;
        case 'pgsql':
          $sql = 'INSERT INTO {history} (uid,nid,timestamp)'
            .' SELECT %d, n.nid, %d FROM {node} n'
            .($tid ? ' INNER JOIN {term_node} r ON n.nid=r.nid' : '')
            .' INNER JOIN {node_comment_statistics} l ON l.nid=n.nid'
            .' LEFT JOIN {history} h ON n.nid=h.nid AND h.uid = %d'
            .' WHERE (n.created > %d'
            .' OR l.last_comment_timestamp > %d)'
            .' AND h.uid IS NULL';
          $args = array($user->uid, time(), $user->uid, NODE_NEW_LIMIT, NODE_NEW_LIMIT);
          break;
      }

I haven't looked at the code yet, but if this still needs to be upgraded to D6, I am more than willing to help.