aboutsummaryrefslogtreecommitdiffstats
path: root/mod
diff options
context:
space:
mode:
authorfabrixxm <fabrix.xm@gmail.com>2011-06-18 08:52:51 +0200
committerfabrixxm <fabrix.xm@gmail.com>2011-06-18 08:52:51 +0200
commit4b633d54bb8d868d39039bdf76a2bd97bd1820c9 (patch)
tree99e35acabd3e236a4f2d70ce84c4d97b18a18cbe /mod
parent23931ab719ca30ce0a5de4c04fd3bd83ecc9937f (diff)
downloadvolse-hubzilla-4b633d54bb8d868d39039bdf76a2bd97bd1820c9.tar.gz
volse-hubzilla-4b633d54bb8d868d39039bdf76a2bd97bd1820c9.tar.bz2
volse-hubzilla-4b633d54bb8d868d39039bdf76a2bd97bd1820c9.zip
admin: fix last item date in users list, fix plugins details template
Diffstat (limited to 'mod')
-rw-r--r--mod/admin.php9
1 files changed, 5 insertions, 4 deletions
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,