_forum_topics_unread
modules/forum/forum.module, строка 753
- Версии
- 5 – 6
_forum_topics_unread($term, $uid)
Calculate the number of nodes the user has not yet read and are newer than NODE_NEW_LIMIT.
Код
<?php
function _forum_topics_unread($term, $uid) {
$sql = "SELECT COUNT(n.nid) FROM {node} n INNER JOIN {term_node} tn ON n.nid = tn.nid AND tn.tid = %d LEFT JOIN {history} h ON n.nid = h.nid AND h.uid = %d WHERE n.status = 1 AND n.type = 'forum' AND n.created > %d AND h.nid IS NULL";
$sql = db_rewrite_sql($sql);
return db_result(db_query($sql, $term, $uid, NODE_NEW_LIMIT));
}
?>
Войдите или зарегистрируйтесь, чтобы получить возможность отправлять комментарии