From fbc5260995866c280fbc48bfb7899836f46136f4 Mon Sep 17 00:00:00 2001 From: Thomas Willingham Date: Tue, 12 Mar 2013 02:35:18 +0000 Subject: Get admin/users mostly working. Still need to associate channels with accounts. --- mod/admin.php | 20 +++++--------------- 1 file changed, 5 insertions(+), 15 deletions(-) (limited to 'mod') diff --git a/mod/admin.php b/mod/admin.php index aa3d7b294..e88936cf4 100644 --- a/mod/admin.php +++ b/mod/admin.php @@ -566,20 +566,9 @@ function admin_page_users(&$a){ // FIXME this is borked since there is no more user table - $users = q("SELECT `user` . * , `contact`.`name` , `contact`.`url` , `contact`.`micro`, `lastitem`.`lastitem_date` - FROM - (SELECT MAX(`item`.`changed`) as `lastitem_date`, `item`.`uid` - FROM `item` - WHERE `item`.`type` = 'wall' - GROUP BY `item`.`uid`) AS `lastitem` - RIGHT OUTER JOIN `user` ON `user`.`uid` = `lastitem`.`uid`, - `contact` - WHERE - `user`.`uid` = `contact`.`uid` - AND `user`.`verified` =1 - AND `contact`.`self` =1 - ORDER BY `contact`.`name` LIMIT %d, %d - ", +// $users = q("SELECT `account_email` FROM `account` +// ", + $users =q("SELECT `account_id` , `account_email`, `account_lastlog`, `account_created`, `account_service_class` FROM `account`", intval($a->pager['start']), intval($a->pager['itemspage']) ); @@ -591,6 +580,7 @@ function admin_page_users(&$a){ t('Community/Celebrity Account'), t('Automatic Friend Account') ); + $e['page_flags'] = $accounts[$e['page-flags']]; $e['register_date'] = relative_date($e['register_date']); $e['login_date'] = relative_date($e['login_date']); @@ -617,7 +607,7 @@ function admin_page_users(&$a){ '$unblock' => t('Unblock'), '$h_users' => t('Users'), - '$th_users' => array( t('Name'), t('Email'), t('Register date'), t('Last login'), t('Last item'), t('Account') ), + '$th_users' => array( t('Name'), t('Email'), t('Register date'), t('Last login'), t('Last item'), t('Account'), t('Service Class')), '$confirm_delete_multi' => t('Selected users will be deleted!\n\nEverything these users had posted on this site will be permanently deleted!\n\nAre you sure?'), '$confirm_delete' => t('The user {0} will be deleted!\n\nEverything this user has posted on this site will be permanently deleted!\n\nAre you sure?'), -- cgit v1.2.3 From b48c481b9cb1b1c06634139dc0e6c4c91b83d873 Mon Sep 17 00:00:00 2001 From: Thomas Willingham Date: Fri, 15 Mar 2013 15:25:39 +0000 Subject: Tidy up --- mod/admin.php | 9 ++++----- 1 file changed, 4 insertions(+), 5 deletions(-) (limited to 'mod') diff --git a/mod/admin.php b/mod/admin.php index e88936cf4..be8575e4e 100644 --- a/mod/admin.php +++ b/mod/admin.php @@ -564,10 +564,9 @@ function admin_page_users(&$a){ $a->set_pager_itemspage(100); } -// FIXME this is borked since there is no more user table - -// $users = q("SELECT `account_email` FROM `account` -// ", + +// WEe'll still need to link email addresses to admin/users/channels or some such, but this bit doesn't exist yet. +// That's where we need to be doing last post/channel flags/etc, not here. $users =q("SELECT `account_id` , `account_email`, `account_lastlog`, `account_created`, `account_service_class` FROM `account`", intval($a->pager['start']), intval($a->pager['itemspage']) @@ -607,7 +606,7 @@ function admin_page_users(&$a){ '$unblock' => t('Unblock'), '$h_users' => t('Users'), - '$th_users' => array( t('Name'), t('Email'), t('Register date'), t('Last login'), t('Last item'), t('Account'), t('Service Class')), + '$th_users' => array( t('Email'), t('Register date'), t('Last login'), t('Service Class')), '$confirm_delete_multi' => t('Selected users will be deleted!\n\nEverything these users had posted on this site will be permanently deleted!\n\nAre you sure?'), '$confirm_delete' => t('The user {0} will be deleted!\n\nEverything this user has posted on this site will be permanently deleted!\n\nAre you sure?'), -- cgit v1.2.3