List of bloggers

Hi Bèr Kessels!

Thanks for the patch! It's really useful! :-)

I just noticed what I think is a little mistake in this line:

$items[] = l($row->name, 'blog/'.$row->uid)." ".theme('xml_icon', url('blog/'.$row->uid.'/feed'), TRUE);

Which I believe should end like:

$items[] = l($row->name, 'blog/'.$row->uid)." ".theme('xml_icon', url('blog/feed/'.$row->uid), TRUE);

Ah, and BTW, "db_rewrite_sql" didn't work for me... I just cut it off... ;-)

Cheers,
Emiliano.

I made a custom block for this, but it still need a little improvment (add "read more" for example). So I don't know if it's usefull but if anyone care :

$result = db_query("SELECT u.uid, u.name, COUNT(0) AS num FROM {node} n LEFT JOIN {users} u ON u.uid = n.uid WHERE n.type = 'blog' GROUP BY u.uid, u.name ORDER BY u.name ASC");
while ($blog = db_fetch_object($result)) {
     $output .= '<li />'.l($blog->name. ' ('.$blog->num.')', 'blog/'.$blog->uid);
}
return '<ul>'.$output.'</ul>';

I think this is a useful feature. I've coded custom blocks in the past to provide it on my sites.

I was a little afraid (poor PHP) to install the patch (March...), but I have made a block. And it's very nice.

One question only. All the bloggers are shown, but the Admin (user No 1) is on the list and he has no blogs.

What's that?

aaargh.....there is a problem when using PostgreSQL db. After I successfully patch blog.module and enable it in menu, click on it and following sql errors pop up:

warning: pg_query(): Query failed: ERROR:  function count(integer, character varying) does not exist
HINT:  No function matches the given name and argument types. You may need to add explicit type casts. in /web/www/htdocs/iaeste3/includes/database.pgsql.inc on line 45.

user error: 
query: SELECT COUNT(DISTINCT u.uid, u.name) FROM users u LEFT JOIN node n ON n.uid = u.uid WHERE n.type = 'blog' AND n.status =1 ORDER BY n.created DESC  in /web/www/htdocs/iaeste3/includes/database.pgsql.inc on line 62.

warning: pg_query(): Query failed: ERROR:  for SELECT DISTINCT, ORDER BY expressions must appear in select list in /web/www/htdocs/iaeste3/includes/database.pgsql.inc on line 45.

user error: 
query: SELECT DISTINCT u.uid, u.name FROM users u LEFT JOIN node n ON n.uid = u.uid WHERE n.type = 'blog' AND n.status = 1 ORDER BY n.created DESC LIMIT 10 OFFSET 0 in /web/www/htdocs/iaeste3/includes/database.pgsql.inc on line 62

For first one its clear, there is no such fucntion in Postgresql, and second one is typical Postgresql/Mysql error, n.created isn't in select syntax. But if we put it in a select distinct syntax , it isn't DISTINCT anymore, so I get lots of lines with user and all of his blogs, with different time of course. So we must modify query a bit:

SELECT DISTINCT u.name, u.uid, MAX(n.created) as time FROM users u LEFT JOIN node n ON n.uid = u.uid WHERE n.type = 'blog' AND n.status = 1 GROUP BY u.name,u.uid ORDER BY time DESC

It works fine like this :)

Didn't look for first one yet... will when I catch some time.
Cheers!

Sorry, here is a patch for a blog_bloggers_list_2_0.patch :)

I think 'DISTINCT' can be removed from the query in blog_bloggers_list_1.patch. There is already a 'GROUP BY' clause over the same columns.

George Essig

I had just come onto the site to search for precisely this functionality -- this has some GREAT applications for a blog based class site -- I will be applying the patch to the blog module, and using the custom block created above -- I would love to see both a patch for 4.6.3, and this feature in core for 4.7

If you want patches on this tested, I'm happy to do it.

Thanks for your work on this.

bonobo

Closing due to age of issue and the existence of the blogger module,