diff options
| author | Dries Buytaert <dries@buytaert.net> | 2006-02-22 10:05:06 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2006-02-22 10:05:06 +0000 |
| commit | cb05945caf65030cb3f9906dbbc78c648ca27406 (patch) | |
| tree | 022065445cc863f1ad1b30e1ce36f94fea298b33 | |
| parent | 3603fe1bd8e3370c0ae86b557f2a08c77fd48efb (diff) | |
| download | brdo-cb05945caf65030cb3f9906dbbc78c648ca27406.tar.gz brdo-cb05945caf65030cb3f9906dbbc78c648ca27406.tar.bz2 | |
- Patch #47699 by wtanaka: performance improvement.
| -rw-r--r-- | modules/comment.module | 2 | ||||
| -rw-r--r-- | modules/comment/comment.module | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/modules/comment.module b/modules/comment.module index 133badfe8..855ed2e81 100644 --- a/modules/comment.module +++ b/modules/comment.module @@ -170,7 +170,7 @@ function comment_block($op = 'list', $delta = 0) { } function theme_comment_block() { - $result = db_query_range(db_rewrite_sql('SELECT c.nid, c.* FROM {comments} c INNER JOIN {node} n ON n.nid = c.nid WHERE n.status = 1 AND c.status = %d ORDER BY c.timestamp DESC', 'c'), COMMENT_PUBLISHED, 0, 10); + $result = db_query_range(db_rewrite_sql('SELECT c.nid, c.subject, c.cid, c.timestamp FROM {comments} c INNER JOIN {node} n ON n.nid = c.nid WHERE n.status = 1 AND c.status = %d ORDER BY c.timestamp DESC', 'c'), COMMENT_PUBLISHED, 0, 10); $items = array(); while ($comment = db_fetch_object($result)) { $items[] = l($comment->subject, 'node/'. $comment->nid, NULL, NULL, 'comment-'. $comment->cid) .'<br />'. t('%time ago', array('%time' => format_interval(time() - $comment->timestamp))); diff --git a/modules/comment/comment.module b/modules/comment/comment.module index 133badfe8..855ed2e81 100644 --- a/modules/comment/comment.module +++ b/modules/comment/comment.module @@ -170,7 +170,7 @@ function comment_block($op = 'list', $delta = 0) { } function theme_comment_block() { - $result = db_query_range(db_rewrite_sql('SELECT c.nid, c.* FROM {comments} c INNER JOIN {node} n ON n.nid = c.nid WHERE n.status = 1 AND c.status = %d ORDER BY c.timestamp DESC', 'c'), COMMENT_PUBLISHED, 0, 10); + $result = db_query_range(db_rewrite_sql('SELECT c.nid, c.subject, c.cid, c.timestamp FROM {comments} c INNER JOIN {node} n ON n.nid = c.nid WHERE n.status = 1 AND c.status = %d ORDER BY c.timestamp DESC', 'c'), COMMENT_PUBLISHED, 0, 10); $items = array(); while ($comment = db_fetch_object($result)) { $items[] = l($comment->subject, 'node/'. $comment->nid, NULL, NULL, 'comment-'. $comment->cid) .'<br />'. t('%time ago', array('%time' => format_interval(time() - $comment->timestamp))); |