function devel_rebuild_node_comment_statistics in Devel 6

Same name and namespace in other branches

1. 5 devel.module \devel_rebuild_node_comment_statistics()
2. 7 devel.module \devel_rebuild_node_comment_statistics()

1 call to devel_rebuild_node_comment_statistics()

devel_rebuild_node_comment_statistics_page in ./devel.module

Menu callback. Rebuild node _comment_stats table.

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