From c12fd5d434c9a3cda6bedb2d450243b278cd5dcb Mon Sep 17 00:00:00 2001
From: Graham Eames <grahamje@users.sourceforge.net>
Date: Mon, 12 Dec 2005 21:58:14 +0000
Subject: Clean up and abstract the code for listing warned users

git-svn-id: file:///svn/phpbb/trunk@5329 89ea8834-ac86-4346-8a33-228a782c2dd0
---
 phpBB/includes/functions_admin.php | 30 ++++++++++++++++++++++++++++++
 1 file changed, 30 insertions(+)

(limited to 'phpBB/includes/functions_admin.php')

diff --git a/phpBB/includes/functions_admin.php b/phpBB/includes/functions_admin.php
index 967f76d40e..3991d228e7 100644
--- a/phpBB/includes/functions_admin.php
+++ b/phpBB/includes/functions_admin.php
@@ -2007,6 +2007,36 @@ function view_log($mode, &$log, &$log_count, $limit = 0, $offset = 0, $forum_id
 	return;
 }
 
+/**
+* Lists warned users
+*/
+function view_warned_users(&$users, &$user_count, $limit = 0, $offset = 0, $sort_by = 'user_warnings DESC')
+{
+	global $db;
+
+	$sql = 'SELECT user_id, username, user_warnings
+		FROM ' . USERS_TABLE . "
+		WHERE user_warnings > 0
+		ORDER BY	$sort_by";
+	$result = $db->sql_query_limit($sql, $limit, $offset);
+
+	$users = $db->sql_fetchrowset($result);
+	$db->sql_freeresult($result);
+
+	$sql = 'SELECT count(user_id) AS user_count
+		FROM ' . USERS_TABLE . '
+		WHERE user_warnings > 0';
+
+	$result = $db->sql_query($sql);
+
+	$row = $db->sql_fetchrow($result);
+	$db->sql_freeresult($result);
+
+	$user_count =  $row['user_count'];
+
+	return;
+}
+
 if (class_exists('auth'))
 {
 	/**
-- 
cgit v1.2.1