_forum_topics_read

Versions

4.6

_forum_topics_read($term, $uid)

Code

modules/forum.module, line 640

<?php
function _forum_topics_read($term, $uid) {
  // Calculate the number of topics the user has read. Assume all entries older
  // than NODE_NEW_LIMIT are read, and include the recent posts that user has
  // read.
  $sql = "SELECT COUNT(n.nid) FROM {node} n INNER JOIN {term_node} r ON n.nid = r.nid AND r.tid = %d WHERE n.created <= %d AND n.status = 1 AND n.type = 'forum'";
  $sql = db_rewrite_sql($sql);
  $ancient = db_result(db_query($sql, $term, NODE_NEW_LIMIT));
  $sql = "SELECT COUNT(n.nid) FROM {node} n INNER JOIN {history} h ON n.nid = h.nid AND h.uid = %d INNER JOIN {term_node} r ON n.nid = r.nid AND r.tid = %d WHERE n.status = 1 AND n.type = 'forum' AND n.created > %d";
  $sql = db_rewrite_sql($sql);
  $recent = db_result(db_query($sql, $uid, $term, NODE_NEW_LIMIT));

  return $ancient + $recent;
}
?>

Login or register to post comments