Comments for each user's blog

ksoonson's Description

In building multiuser blog site, I want to provide an optional block which shows comments of that user's blog and that block is shown only in that user's blog pages. (user can choose whether he/she wants the block be displayed in his/her blog or not also)

And I want to provide a user-defined block which is shown only in that user's blog too.

I found a module where each user can choose their own theme for his/her blog but did not find module with the above features. I think this kind of functionality is essential for multiuser blog.

------

John Hwang's Updates

Well... I'm uploading a patch to the comment.module which displays the recent comments for a user's blog.

This essentially checks if the user is viewing a blog or a node. If the user is viewing a blog it checks for the blog's uid then retrieves 10 most recent comments made on the blog using the following sql statement.

$result = db_query_range(db_rewrite_sql("SELECT c.nid, c.*
                                                    FROM {comments} c
                                                    INNER JOIN {node} n ON c.nid = n.nid
                                                    INNER JOIN {users} u ON n.uid = u.uid
                                                    WHERE c.status = 0
                                                    AND u.uid = $uid
                                                    AND n.status = 1
                                                    AND n.type = 'blog'
                                                    ORDER BY c.timestamp DESC", 'c'), 0, 10);

If the user is viewing a node, it loads the node then retrieves the node uid. It then does pretty much same as the above code.