From 4b633d54bb8d868d39039bdf76a2bd97bd1820c9 Mon Sep 17 00:00:00 2001 From: fabrixxm Date: Sat, 18 Jun 2011 08:52:51 +0200 Subject: admin: fix last item date in users list, fix plugins details template --- mod/admin.php | 9 +++++---- 1 file changed, 5 insertions(+), 4 deletions(-) (limited to 'mod') diff --git a/mod/admin.php b/mod/admin.php index 3b5315ad5..1ae0490e8 100644 --- a/mod/admin.php +++ b/mod/admin.php @@ -408,12 +408,12 @@ function admin_page_users(&$a){ $a->set_pager_itemspage(100); } - $users = q("SELECT `user` . * , `contact`.`name` , `contact`.`url` , `contact`.`micro` , `lastitem`.`changed` AS `lastitem_date` + $users = q("SELECT `user` . * , `contact`.`name` , `contact`.`url` , `contact`.`micro` , `lastitem`.`lastitem_date` FROM ( - SELECT `item`.`changed` , `item`.`uid` + SELECT MAX(`item`.`changed`) as `lastitem_date`, `item`.`uid` FROM `item` - GROUP BY `uid` - ORDER BY `item`.`changed` + WHERE `item`.`type` = 'wall' + GROUP BY `item`.`uid` ) AS `lastitem` , `user` LEFT JOIN `contact` ON `user`.`uid` = `contact`.`uid` WHERE `user`.`verified` =1 @@ -534,6 +534,7 @@ function admin_page_plugins(&$a){ '$title' => t('Administration'), '$page' => t('Plugins'), '$toggle' => t('Toggle'), + '$settings' => t('Settings'), '$baseurl' => $a->get_baseurl(), '$plugin' => $plugin, -- cgit v1.2.3