function devel_rebuild_node_comment_statistics

File

./devel.module, line 2121

Code

function devel_rebuild_node_comment_statistics() {
    // Empty table
    db_truncate('node_comment_statistics')->execute();
    // TODO: DBTNG. Ignore keyword is Mysql only? Is only used in the rare case when
    // two comments on the same node share same timestamp.
    $sql = "\n    INSERT IGNORE INTO {node_comment_statistics} (nid, last_comment_timestamp, last_comment_name, last_comment_uid, comment_count) (\n      SELECT c.nid, c.timestamp, c.name, c.uid, c2.comment_count FROM {comments} c\n      JOIN (\n        SELECT c.nid, MAX(c.timestamp) AS timestamp, COUNT(*) AS comment_count FROM {comments} c WHERE status = %d GROUP BY c.nid\n      ) AS c2 ON c.nid = c2.nid AND c.timestamp = c2.timestamp\n    )";
    db_query($sql, COMMENT_PUBLISHED);
    // Insert records into the node_comment_statistics for nodes that are missing.
    $query = db_select('node', 'n');
    $query->leftJoin('node_comment_statistics', 'ncs', 'ncs.nid = n.nid');
    $query->addField('n', 'changed', 'last_comment_timestamp');
    $query->addField('n', 'uid', 'last_comment_uid');
    $query->addField('n', 'nid');
    $query->addExpression('0', 'comment_count');
    $query->addExpression('NULL', 'last_comment_name');
    $query->isNull('ncs.comment_count');
    db_insert('node_comment_statistics', array(
        'return' => Database::RETURN_NULL,
    ))->from($query)
        ->execute();
}