| 1 |
<?php |
<?php |
| 2 |
// $Id: site_map.module,v 1.29.2.6 2008/02/08 07:21:59 frjo Exp $ |
// $Id: site_map.module,v 1.29.2.7 2009/02/03 14:10:38 frjo Exp $ |
| 3 |
|
|
| 4 |
/** |
/** |
| 5 |
* @file |
* @file |
| 324 |
|
|
| 325 |
$blogs = array(); |
$blogs = array(); |
| 326 |
$blogs[] .= l(t('All blogs'), 'blog') . (variable_get('site_map_show_rss_links', 1) ? ' '. theme('site_map_feed_icon', url('blog/feed')) : ''); |
$blogs[] .= l(t('All blogs'), 'blog') . (variable_get('site_map_show_rss_links', 1) ? ' '. theme('site_map_feed_icon', url('blog/feed')) : ''); |
|
|
|
| 327 |
$sql = "SELECT DISTINCT u.uid, u.name, count(u.uid) AS numitems |
$sql = "SELECT DISTINCT u.uid, u.name, count(u.uid) AS numitems |
| 328 |
FROM {node} n |
FROM {node} n |
| 329 |
INNER JOIN {users} u ON u.uid = n.uid |
INNER JOIN {users} u ON u.uid = n.uid |
| 330 |
WHERE n.type = 'blog' and n.status = 1 |
WHERE n.type = 'blog' AND n.status = 1 |
| 331 |
GROUP BY u.uid |
GROUP BY u.uid |
| 332 |
ORDER BY numitems DESC, u.name"; |
ORDER BY numitems DESC, u.name"; |
| 333 |
$result = db_query_range($sql, 0, 10); |
$result = db_query_range($sql, 0, 10); |
|
|
|
|
|
|
| 334 |
while ($blog = db_fetch_object($result)) { |
while ($blog = db_fetch_object($result)) { |
| 335 |
$blogs[] = l(t("!s's blog", array("!s" => $blog->name)), "blog/$blog->uid") .' ('. $blog->numitems .')'. (variable_get('site_map_show_rss_links', 1) ? ' '. theme('site_map_feed_icon', url("blog/$blog->uid/feed")) : ''); |
$blogs[] = l(t("!s's blog", array("!s" => $blog->name)), "blog/$blog->uid") .' ('. $blog->numitems .')'. (variable_get('site_map_show_rss_links', 1) ? ' '. theme('site_map_feed_icon', url("blog/$blog->uid/feed")) : ''); |
| 336 |
} |
} |
| 538 |
global $locale; |
global $locale; |
| 539 |
$lang_code = $locale; |
$lang_code = $locale; |
| 540 |
} |
} |
| 541 |
$message = variable_get("site_map_message_$lang_code", ''); |
$message = filter_xss_admin(variable_get("site_map_message_$lang_code", '')); |
| 542 |
} |
} |
| 543 |
else { |
else { |
| 544 |
$message = variable_get('site_map_message', ''); |
$message = filter_xss_admin(variable_get('site_map_message', '')); |
| 545 |
} |
} |
| 546 |
|
|
| 547 |
return $message; |
return $message; |