From 9012bb868e0d33bca6ca05a910726ae1abb6b06d Mon Sep 17 00:00:00 2001
From: Antoine Musso <hashar@users.mediawiki.org>
Date: Fri, 12 Nov 2004 20:41:24 +0000
Subject: [PATCH] Partially implement
 http://bugzilla.wikipedia.org/show_bug.cgi?id=770 * Group is shown instead of
 rights. * Filter per group. * Search by exact username match

---
 includes/SpecialListusers.php | 99 +++++++++++++++++++++++++++++++++--
 1 file changed, 96 insertions(+), 3 deletions(-)

diff --git a/includes/SpecialListusers.php b/includes/SpecialListusers.php
index f025e1a345..bde94bba73 100644
--- a/includes/SpecialListusers.php
+++ b/includes/SpecialListusers.php
@@ -1,4 +1,23 @@
 <?php
+# Copyright (C) 2004 Brion Vibber, lcrocker, Tim Starling,
+# Domas Mituzas, Ashar Voultoiz, Jens Frank, Zhengzhu.
+#
+# http://www.mediawiki.org/
+# 
+# This program is free software; you can redistribute it and/or modify
+# it under the terms of the GNU General Public License as published by
+# the Free Software Foundation; either version 2 of the License, or 
+# (at your option) any later version.
+# 
+# This program is distributed in the hope that it will be useful,
+# but WITHOUT ANY WARRANTY; without even the implied warranty of
+# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+# GNU General Public License for more details.
+# 
+# You should have received a copy of the GNU General Public License along
+# with this program; if not, write to the Free Software Foundation, Inc.,
+# 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
+# http://www.gnu.org/copyleft/gpl.html
 /**
  *
  * @package MediaWiki
@@ -19,18 +38,86 @@ require_once("QueryPage.php");
  * @subpackage SpecialPage
  */
 class ListUsersPage extends QueryPage {
-
+	var $requestedGroup = '';
+	var $requestedUser = '';
+		
 	function getName() {
 		return "Listusers";
 	}
 
+	/**
+	 * Show a drop down list to select a group as well as a user name
+	 * search box.
+	 * @TODO: localize
+	 */
+	function getPageHeader( ) {
+		global $wgScript;
+		
+		// Various variables used for the form
+		$action = htmlspecialchars( $wgScript );
+		$title = Title::makeTitle( NS_SPECIAL, 'Listusers' );
+		$special = htmlspecialchars( $title->getPrefixedDBkey() );
+
+		// form header
+		$out = '<form method="get" action="'.$action.'">' .
+				'<input type="hidden" name="title" value="'.$special.'" />' .
+				'Group: <select name="group">' .
+
+		// get all group names and id
+		$dbr = & wfGetDB( DB_SLAVE );
+		$group = $dbr->tableName( 'group' );
+		$sql = "SELECT group_id, group_name FROM $group;";
+		$result = $dbr->query($sql);
+		
+		// we want a default empty group
+		$out.= '<option value=""></option>';
+		
+		// build the dropdown list menu using datas from the database
+		while($agroup = $dbr->fetchObject( $result )) {
+			$selected = ($agroup->group_id == $this->requestedGroup) ? " selected " : "" ;
+			$out.= '<option value="'.$agroup->group_id.'" '.$selected.'>'.$agroup->group_name.'</option>';
+		}
+		$out .= '</select> ';
+
+		$out .= 'User: <input type="text" name="username" /> ';
+
+		// OK button, end of form.
+		$out .= '<input type="submit" /></form>';
+		// congratulations the form is now build
+		return $out;	
+	}
+	
 	function getSQL() {
 		$dbr =& wfGetDB( DB_SLAVE );
+	/* system showing possible actions for users
 		$user = $dbr->tableName( 'user' );
 		$user_rights = $dbr->tableName( 'user_rights' );
 		$userspace = Namespace::getUser();
 		return "SELECT ur_rights as type, $userspace as namespace, user_name as title, " .
 			"user_name as value FROM $user LEFT JOIN $user_rights ON user_id = ur_user";
+	*/
+	/** Show groups instead */
+		$user = $dbr->tableName( 'user' );
+		$group = $dbr->tableName( 'group' );
+		$user_groups = $dbr->tableName( 'user_groups' );
+		
+		$userspace = Namespace::getUser();
+		$sql = "SELECT group_name as type, $userspace AS namespace, user_name AS title, user_name as value " .
+			"FROM $user LEFT JOIN $user_groups ON user_id =ug_user " .
+			"LEFT JOIN $group ON ug_group = group_id ";
+		
+		if($this->requestedGroup != '') {
+			$sql .=  "WHERE group_id= '$this->requestedGroup' ";
+			if($this->requestedUser != '') {
+				$sql .= "AND user_name = '$this->requestedUser' ";
+			}
+		} else {
+			if($this->requestedUser !='') {
+				$sql .= "WHERE user_name = '$this->requestedUser' ";
+			}	
+		}				
+		
+		return $sql;
 	}
 	
 	function sortDescending() {
@@ -42,7 +129,7 @@ class ListUsersPage extends QueryPage {
 		$name = $skin->makeLink( $wgContLang->getNsText($result->namespace) . ':' . $result->title, $result->title );
 		if( '' != $result->type ) {
 			$name .= ' (' .
-			$skin->makeLink( wfMsgForContent( "administrators" ), $result->type) .
+			$skin->makeLink( wfMsgForContent( 'administrators' ), $result->type) .
 			')';
 		}
 		return $name;
@@ -53,11 +140,17 @@ class ListUsersPage extends QueryPage {
  * constructor
  */
 function wfSpecialListusers() {
-	global $wgUser, $wgOut, $wgLang;
+	global $wgUser, $wgOut, $wgLang, $wgRequest;
 
 	list( $limit, $offset ) = wfCheckLimits();
 
 	$slu = new ListUsersPage();
+	
+	/**
+	 * Get some parameters
+	 */
+	$slu->requestedGroup = $wgRequest->getVal('group');
+	$slu->requestedUser = $wgRequest->getVal('username');
 
 	return $slu->doQuery( $offset, $limit );
 }
-- 
2.20.1