diff options
| author | Dries Buytaert <dries@buytaert.net> | 2006-01-22 07:26:33 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2006-01-22 07:26:33 +0000 |
| commit | b6b98bb60d7cf985766ebadee22875f9b409c2bb (patch) | |
| tree | 3bb2456612126b2701568546bcb5276751de484b | |
| parent | 25f13a64c407103b2c07d3c6bf68ccecdd5b99ec (diff) | |
| download | brdo-b6b98bb60d7cf985766ebadee22875f9b409c2bb.tar.gz brdo-b6b98bb60d7cf985766ebadee22875f9b409c2bb.tar.bz2 | |
- Patch #44101 by Cvbge: deleting a comment creates incorrect entry in node_comment_statistics.
| -rw-r--r-- | modules/comment.module | 4 | ||||
| -rw-r--r-- | modules/comment/comment.module | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/modules/comment.module b/modules/comment.module index 4d2488b26..c8063cbc0 100644 --- a/modules/comment.module +++ b/modules/comment.module @@ -1676,12 +1676,12 @@ function _comment_update_node_statistics($nid) { // comments exist if ($count > 0) { $last_reply = db_fetch_object(db_query_range('SELECT cid, name, timestamp, uid FROM {comments} WHERE nid = %d AND status = %d ORDER BY cid DESC', $nid, COMMENT_PUBLISHED, 0, 1)); - db_query("UPDATE {node_comment_statistics} SET comment_count = %d, last_comment_timestamp = %d, last_comment_name = '%s', last_comment_uid = %d WHERE nid = %d", $count, $last_reply->timestamp, $last_reply->uid ? NULL : $last_reply->name, $last_reply->uid, $nid); + db_query("UPDATE {node_comment_statistics} SET comment_count = %d, last_comment_timestamp = %d, last_comment_name = '%s', last_comment_uid = %d WHERE nid = %d", $count, $last_reply->timestamp, $last_reply->uid ? '' : $last_reply->name, $last_reply->uid, $nid); } // no comments else { - db_query("UPDATE {node_comment_statistics} SET comment_count = %d, last_comment_timestamp = %d, last_comment_name = '%s', last_comment_uid = %d WHERE nid = %d", 0, NULL, 0, 0, $nid); + db_query("UPDATE {node_comment_statistics} SET comment_count = 0, last_comment_timestamp = created, last_comment_name = '', last_comment_uid = uid FROM {node} WHERE {node_comment_statistics}.nid = {node}.nid AND {node}.nid = %d", $nid); } } diff --git a/modules/comment/comment.module b/modules/comment/comment.module index 4d2488b26..c8063cbc0 100644 --- a/modules/comment/comment.module +++ b/modules/comment/comment.module @@ -1676,12 +1676,12 @@ function _comment_update_node_statistics($nid) { // comments exist if ($count > 0) { $last_reply = db_fetch_object(db_query_range('SELECT cid, name, timestamp, uid FROM {comments} WHERE nid = %d AND status = %d ORDER BY cid DESC', $nid, COMMENT_PUBLISHED, 0, 1)); - db_query("UPDATE {node_comment_statistics} SET comment_count = %d, last_comment_timestamp = %d, last_comment_name = '%s', last_comment_uid = %d WHERE nid = %d", $count, $last_reply->timestamp, $last_reply->uid ? NULL : $last_reply->name, $last_reply->uid, $nid); + db_query("UPDATE {node_comment_statistics} SET comment_count = %d, last_comment_timestamp = %d, last_comment_name = '%s', last_comment_uid = %d WHERE nid = %d", $count, $last_reply->timestamp, $last_reply->uid ? '' : $last_reply->name, $last_reply->uid, $nid); } // no comments else { - db_query("UPDATE {node_comment_statistics} SET comment_count = %d, last_comment_timestamp = %d, last_comment_name = '%s', last_comment_uid = %d WHERE nid = %d", 0, NULL, 0, 0, $nid); + db_query("UPDATE {node_comment_statistics} SET comment_count = 0, last_comment_timestamp = created, last_comment_name = '', last_comment_uid = uid FROM {node} WHERE {node_comment_statistics}.nid = {node}.nid AND {node}.nid = %d", $nid); } } |