http://api.drupal.org/api/drupal/modules!comment!comment.module/function...
This acts on node deletion:
case 'delete':
db_query('DELETE FROM {comments} WHERE nid = %d', $node->nid);
db_query('DELETE FROM {node_comment_statistics} WHERE nid = %d', $node->nid);
break;
however, it doesn't fire hook_comment() to tell other modules the comment has been deleted.
Comments