diff options
| author | Graham Eames <grahamje@users.sourceforge.net> | 2005-12-14 20:54:54 +0000 |
|---|---|---|
| committer | Graham Eames <grahamje@users.sourceforge.net> | 2005-12-14 20:54:54 +0000 |
| commit | a7dcdb07602f9d1e72cfbcd2c0c02c3dacd06320 (patch) | |
| tree | c89e2094857902d845914d167b54487811487ba3 /phpBB/includes/functions_admin.php | |
| parent | 9acd80748c9e63c049d56f6504810fc28fff96b7 (diff) | |
| download | forums-a7dcdb07602f9d1e72cfbcd2c0c02c3dacd06320.tar forums-a7dcdb07602f9d1e72cfbcd2c0c02c3dacd06320.tar.gz forums-a7dcdb07602f9d1e72cfbcd2c0c02c3dacd06320.tar.bz2 forums-a7dcdb07602f9d1e72cfbcd2c0c02c3dacd06320.tar.xz forums-a7dcdb07602f9d1e72cfbcd2c0c02c3dacd06320.zip | |
Adding the ability to get a list of all users with outstanding warnings
git-svn-id: file:///svn/phpbb/trunk@5333 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/includes/functions_admin.php')
| -rw-r--r-- | phpBB/includes/functions_admin.php | 14 |
1 files changed, 8 insertions, 6 deletions
diff --git a/phpBB/includes/functions_admin.php b/phpBB/includes/functions_admin.php index 3991d228e7..91bc2fa85f 100644 --- a/phpBB/includes/functions_admin.php +++ b/phpBB/includes/functions_admin.php @@ -2010,14 +2010,15 @@ function view_log($mode, &$log, &$log_count, $limit = 0, $offset = 0, $forum_id /** * Lists warned users */ -function view_warned_users(&$users, &$user_count, $limit = 0, $offset = 0, $sort_by = 'user_warnings DESC') +function view_warned_users(&$users, &$user_count, $limit = 0, $offset = 0, $limit_days = 0, $sort_by = 'user_warnings DESC') { global $db; - $sql = 'SELECT user_id, username, user_warnings - FROM ' . USERS_TABLE . " + $sql = 'SELECT user_id, username, user_warnings, user_last_warning + FROM ' . USERS_TABLE . ' WHERE user_warnings > 0 - ORDER BY $sort_by"; + ' . (($limit_days) ? "AND user_last_warning >= $limit_days" : '') . " + ORDER BY $sort_by"; $result = $db->sql_query_limit($sql, $limit, $offset); $users = $db->sql_fetchrowset($result); @@ -2025,14 +2026,15 @@ function view_warned_users(&$users, &$user_count, $limit = 0, $offset = 0, $sort $sql = 'SELECT count(user_id) AS user_count FROM ' . USERS_TABLE . ' - WHERE user_warnings > 0'; + WHERE user_warnings > 0 + ' . (($limit_days) ? "AND user_last_warning >= $limit_days" : ''); $result = $db->sql_query($sql); $row = $db->sql_fetchrow($result); $db->sql_freeresult($result); - $user_count = $row['user_count']; + $user_count = $row['user_count']; return; } |