aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/includes/functions_admin.php
diff options
context:
space:
mode:
authorMeik Sievertsen <acydburn@phpbb.com>2009-07-24 11:13:32 +0000
committerMeik Sievertsen <acydburn@phpbb.com>2009-07-24 11:13:32 +0000
commit4739c7ba3957dfe585973dafe7465cb9fd8c6d1f (patch)
treec54ede45cda36fd124bcc69ad95ab2d56a70ceaf /phpBB/includes/functions_admin.php
parentc84d5074c1aef4a1705d4b17472689e8e4a15351 (diff)
downloadforums-4739c7ba3957dfe585973dafe7465cb9fd8c6d1f.tar
forums-4739c7ba3957dfe585973dafe7465cb9fd8c6d1f.tar.gz
forums-4739c7ba3957dfe585973dafe7465cb9fd8c6d1f.tar.bz2
forums-4739c7ba3957dfe585973dafe7465cb9fd8c6d1f.tar.xz
forums-4739c7ba3957dfe585973dafe7465cb9fd8c6d1f.zip
[Feature] Added new functionality to inactive users module:
- Ability to set users per page. - Ability to sort by posts/number of reminders/last reminded date. - Show number of posts and ability to search posts. - Show number of reminders sent to user. - Show date of last reminder sent to user. git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9845 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/includes/functions_admin.php')
-rw-r--r--phpBB/includes/functions_admin.php4
1 files changed, 2 insertions, 2 deletions
diff --git a/phpBB/includes/functions_admin.php b/phpBB/includes/functions_admin.php
index 457fac2458..aeb378953d 100644
--- a/phpBB/includes/functions_admin.php
+++ b/phpBB/includes/functions_admin.php
@@ -2375,7 +2375,7 @@ function view_log($mode, &$log, &$log_count, $limit = 0, $offset = 0, $forum_id
FROM " . LOG_TABLE . " l, " . USERS_TABLE . " u
WHERE l.log_type = $log_type
AND u.user_id = l.user_id
- " . (($limit_days) ? "AND l.log_time >= $limit_days" : '') .
+ " . (($limit_days) ? "AND l.log_time >= $limit_days" : '') .
(!empty($log_operation) ? "AND l.log_operation = '" . $db->sql_escape($log_operation) . "'" : '') . "
$sql_forum
ORDER BY $sort_by";
@@ -2685,7 +2685,7 @@ function view_inactive_users(&$users, &$user_count, $limit = 0, $offset = 0, $li
$offset = ($offset - $limit < 0) ? 0 : $offset - $limit;
}
- $sql = 'SELECT user_id, username, user_regdate, user_lastvisit, user_inactive_time, user_inactive_reason
+ $sql = 'SELECT *
FROM ' . USERS_TABLE . '
WHERE user_type = ' . USER_INACTIVE .
(($limit_days) ? " AND user_inactive_time >= $limit_days" : '') . "