function _tracker_add

Updates indexing tables when a node is added, updated, or commented on.

Parameters

$nid: A node ID.

$uid: The node or comment author.

$changed: The node updated timestamp or comment timestamp.

File

modules/tracker/tracker.module, line 250

Code

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();
}