Posted by JimK on May 14, 2006 at 3:07pm
I've found snippets and used them to make "Blog list by title" page (lists the titles in date order, but can't figure out how to get it to list the Username and date with it) and Blog list by user" (just lists names of those who have blogs). What I can't figure out is:
1. How to make the standard blog found under the user's profile list on one or two pages all the blogs they have done in order (instead of only one blog entry navigated by that annoying "next page" thing). eg http://www.cpnhelp.org/?q=blog/jim_k
2. How to make the Blog-by-user page snippet also list the titles and dates for each. eg http://www.cpnhelp.org/?q=blogs_by_user
Snippet used:
<?php
$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>';
?>3. How to make the Blog-by-Title/Date page also state the username and date on the page. eg http://www.cpnhelp.org/?q=blog_list
Snippet used:
<?php
/**
* the following displays a list of the X most recent weblog titles
* and links to the full weblogs. If you want to increase/reduce
* the number of titles displayed..simply change $listlength value
*
* This php snippet works with drupal 4.6.
*
*/
$listlength="200";
$output = node_title_list(db_query_range(db_rewrite_sql("SELECT n.nid, n.title, n.created FROM {node} n WHERE n.type = 'blog' AND n.status = 1 ORDER BY n.created DESC"), 0, $listlength));
print $output;
?>Any help on any of these vastly appreciated.