diff options
| author | Dries Buytaert <dries@buytaert.net> | 2004-12-11 11:41:17 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2004-12-11 11:41:17 +0000 |
| commit | d61e7a663ed78f7ed27ea9c6819df7160e07e654 (patch) | |
| tree | 92e1bea8ed6cd1c6ef9af911b9351fecc8f7c669 | |
| parent | 55205138796b6f9c0b8914053b569ed1e71186b2 (diff) | |
| download | brdo-d61e7a663ed78f7ed27ea9c6819df7160e07e654.tar.gz brdo-d61e7a663ed78f7ed27ea9c6819df7160e07e654.tar.bz2 | |
- Bugfix: make sure to update the node_comment_statistics table when a node is updated.
| -rw-r--r-- | modules/comment.module | 5 | ||||
| -rw-r--r-- | modules/comment/comment.module | 5 |
2 files changed, 8 insertions, 2 deletions
diff --git a/modules/comment.module b/modules/comment.module index b2c523ccd..72f954b45 100644 --- a/modules/comment.module +++ b/modules/comment.module @@ -252,7 +252,10 @@ function comment_nodeapi(&$node, $op, $arg = 0) { } break; case 'insert': - db_query('INSERT INTO {node_comment_statistics} (nid, cid, last_comment_timestamp, last_comment_name, last_comment_uid, comment_count) VALUES (%d,0,%d,NULL,%d,0)', $node->nid, $node->created, $node->uid); + db_query('INSERT INTO {node_comment_statistics} (nid, cid, last_comment_timestamp, last_comment_name, last_comment_uid, comment_count) VALUES (%d, 0, %d, NULL, %d, 0)', $node->nid, $node->created, $node->uid); + break; + case 'update': + db_queryd('UPDATE {node_comment_statistics} SET last_comment_timestamp = %d WHERE nid = %d AND cid = 0', $node->changed, $node->nid); break; case 'delete': db_query('DELETE FROM {comments} WHERE nid = %d', $node->nid); diff --git a/modules/comment/comment.module b/modules/comment/comment.module index b2c523ccd..72f954b45 100644 --- a/modules/comment/comment.module +++ b/modules/comment/comment.module @@ -252,7 +252,10 @@ function comment_nodeapi(&$node, $op, $arg = 0) { } break; case 'insert': - db_query('INSERT INTO {node_comment_statistics} (nid, cid, last_comment_timestamp, last_comment_name, last_comment_uid, comment_count) VALUES (%d,0,%d,NULL,%d,0)', $node->nid, $node->created, $node->uid); + db_query('INSERT INTO {node_comment_statistics} (nid, cid, last_comment_timestamp, last_comment_name, last_comment_uid, comment_count) VALUES (%d, 0, %d, NULL, %d, 0)', $node->nid, $node->created, $node->uid); + break; + case 'update': + db_queryd('UPDATE {node_comment_statistics} SET last_comment_timestamp = %d WHERE nid = %d AND cid = 0', $node->changed, $node->nid); break; case 'delete': db_query('DELETE FROM {comments} WHERE nid = %d', $node->nid); |