Updates indexing tables when a node is added, updated, or commented on.
$nid: A node ID.
$uid: The node or comment author.
$changed: The node updated timestamp or comment timestamp.
function _tracker_add($nid, $uid, $changed) {
$node = db_query('SELECT nid, status, uid, changed FROM {node} WHERE nid = :nid', array(
':nid' => $nid,
))
->fetchObject();
// Adding a comment can only increase the changed timestamp, so our
// calculation here is simple.
$changed = max($node->changed, $changed);
// Update the node-level data.
db_merge('tracker_node')
->key(array(
'nid' => $nid,
))
->fields(array(
'changed' => $changed,
'published' => $node->status,
))
->execute();
// Create or update the user-level data, first for the user posting.
db_merge('tracker_user')
->key(array(
'nid' => $nid,
'uid' => $uid,
))
->fields(array(
'changed' => $changed,
'published' => $node->status,
))
->execute();
// Update the times for all the other users tracking the post.
db_update('tracker_user')
->condition('nid', $nid)
->fields(array(
'changed' => $changed,
'published' => $node->status,
))
->execute();
}