2 # Copyright (C) 2004 Brion Vibber, lcrocker, Tim Starling,
3 # Domas Mituzas, Ashar Voultoiz, Jens Frank, Zhengzhu.
5 # http://www.mediawiki.org/
7 # This program is free software; you can redistribute it and/or modify
8 # it under the terms of the GNU General Public License as published by
9 # the Free Software Foundation; either version 2 of the License, or
10 # (at your option) any later version.
12 # This program is distributed in the hope that it will be useful,
13 # but WITHOUT ANY WARRANTY; without even the implied warranty of
14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 # GNU General Public License for more details.
17 # You should have received a copy of the GNU General Public License along
18 # with this program; if not, write to the Free Software Foundation, Inc.,
19 # 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
20 # http://www.gnu.org/copyleft/gpl.html
24 * @subpackage SpecialPage
30 require_once("QueryPage.php");
33 * This class is used to get a list of user. The ones with specials
34 * rights (sysop, bureaucrat, developer) will have them displayed
35 * next to their names.
38 * @subpackage SpecialPage
40 class ListUsersPage
extends QueryPage
{
41 var $requestedGroup = '';
42 var $requestedUser = '';
49 * Show a drop down list to select a group as well as a user name
53 function getPageHeader( ) {
56 // Various variables used for the form
57 $action = htmlspecialchars( $wgScript );
58 $title = Title
::makeTitle( NS_SPECIAL
, 'Listusers' );
59 $special = htmlspecialchars( $title->getPrefixedDBkey() );
62 $out = '<form method="get" action="'.$action.'">' .
63 '<input type="hidden" name="title" value="'.$special.'" />' .
64 'Group: <select name="group">' .
66 // get all group names and id
67 $dbr = & wfGetDB( DB_SLAVE
);
68 $group = $dbr->tableName( 'group' );
69 $sql = "SELECT group_id, group_name FROM $group;";
70 $result = $dbr->query($sql);
72 // we want a default empty group
73 $out.= '<option value=""></option>';
75 // build the dropdown list menu using datas from the database
76 while($agroup = $dbr->fetchObject( $result )) {
77 $selected = ($agroup->group_id
== $this->requestedGroup
) ?
" selected " : "" ;
78 $out.= '<option value="'.$agroup->group_id
.'" '.$selected.'>'.$agroup->group_name
.'</option>';
82 $out .= 'User: <input type="text" name="username" /> ';
84 // OK button, end of form.
85 $out .= '<input type="submit" /></form>';
86 // congratulations the form is now build
91 $dbr =& wfGetDB( DB_SLAVE
);
92 /* system showing possible actions for users
93 $user = $dbr->tableName( 'user' );
94 $user_rights = $dbr->tableName( 'user_rights' );
95 $userspace = Namespace::getUser();
96 return "SELECT ur_rights as type, $userspace as namespace, user_name as title, " .
97 "user_name as value FROM $user LEFT JOIN $user_rights ON user_id = ur_user";
99 /** Show groups instead */
100 $user = $dbr->tableName( 'user' );
101 $group = $dbr->tableName( 'group' );
102 $user_groups = $dbr->tableName( 'user_groups' );
104 $userspace = Namespace::getUser();
105 $sql = "SELECT group_name as type, $userspace AS namespace, user_name AS title, user_name as value " .
106 "FROM $user LEFT JOIN $user_groups ON user_id =ug_user " .
107 "LEFT JOIN $group ON ug_group = group_id ";
109 if($this->requestedGroup
!= '') {
110 $sql .= "WHERE group_id= '$this->requestedGroup' ";
111 if($this->requestedUser
!= '') {
112 $sql .= "AND user_name = '$this->requestedUser' ";
115 if($this->requestedUser
!='') {
116 $sql .= "WHERE user_name = '$this->requestedUser' ";
123 function sortDescending() {
127 function formatResult( $skin, $result ) {
129 $name = $skin->makeLink( $wgContLang->getNsText($result->namespace) . ':' . $result->title
, $result->title
);
130 if( '' != $result->type
) {
132 $skin->makeLink( wfMsgForContent( 'administrators' ), $result->type
) .
142 function wfSpecialListusers() {
143 global $wgUser, $wgOut, $wgLang, $wgRequest;
145 list( $limit, $offset ) = wfCheckLimits();
147 $slu = new ListUsersPage();
150 * Get some parameters
152 $slu->requestedGroup
= $wgRequest->getVal('group');
153 $slu->requestedUser
= $wgRequest->getVal('username');
155 return $slu->doQuery( $offset, $limit );