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 = '';
43 var $previousResult = false;
44 var $concatGroups = '';
49 function isSyndicated() { return false; }
52 * Show a drop down list to select a group as well as a user name
56 function getPageHeader( ) {
59 // Various variables used for the form
60 $action = htmlspecialchars( $wgScript );
61 $title = Title
::makeTitle( NS_SPECIAL
, 'Listusers' );
62 $special = htmlspecialchars( $title->getPrefixedDBkey() );
65 $out = '<form method="get" action="'.$action.'">' .
66 '<input type="hidden" name="title" value="'.$special.'" />' .
67 'Group: <select name="group">';
69 // get all group names and id
70 $dbr = & wfGetDB( DB_SLAVE
);
71 $group = $dbr->tableName( 'group' );
72 $sql = "SELECT group_id, group_name FROM $group;";
73 $result = $dbr->query($sql);
75 // we want a default empty group
76 $out.= '<option value=""></option>';
78 // build the dropdown list menu using datas from the database
79 while($agroup = $dbr->fetchObject( $result )) {
80 $selected = ($agroup->group_id
== $this->requestedGroup
) ?
' selected ' : '' ;
81 $out.= '<option value="'.$agroup->group_id
.'" '.$selected.'>'.$agroup->group_name
.'</option>';
85 $out .= 'User: <input type="text" name="username" /> ';
87 // OK button, end of form.
88 $out .= '<input type="submit" /></form>';
89 // congratulations the form is now build
94 $dbr =& wfGetDB( DB_SLAVE
);
95 /* system showing possible actions for users
96 $user = $dbr->tableName( 'user' );
97 $user_rights = $dbr->tableName( 'user_rights' );
98 $userspace = Namespace::getUser();
99 return "SELECT ur_rights as type, $userspace as namespace, user_name as title, " .
100 "user_name as value FROM $user LEFT JOIN $user_rights ON user_id = ur_user";
102 /** Show groups instead */
103 $user = $dbr->tableName( 'user' );
104 $group = $dbr->tableName( 'group' );
105 $user_groups = $dbr->tableName( 'user_groups' );
107 $userspace = NS_USER
;
108 $sql = "SELECT group_name as type, $userspace AS namespace, user_name AS title, user_name as value " .
110 "LEFT JOIN $user_groups ON user_id =ug_user " .
111 "LEFT JOIN $group ON ug_group = group_id ";
113 if($this->requestedGroup
!= '') {
114 $sql .= "WHERE group_id= '" . IntVal( $this->requestedGroup
) . "' ";
115 if($this->requestedUser
!= '') {
116 $sql .= "AND user_name = " . $dbr->addQuotes( $this->requestedUser
) . ' ';
119 if($this->requestedUser
!='') {
120 $sql .= "WHERE user_name = " . $dbr->addQuotes( $this->requestedUser
) . ' ';
128 * When calling formatResult we output the previous result instead of the
129 * current one. We need an additional step to flush out the last result.
131 function tryLastResult( ) {
135 function sortDescending() {
139 function appendGroups($group) {
140 $this->concatGroups
.= $group.' ';
143 function clearGroups() {
144 $this->concatGroups
= '';
147 var $previousResult = false;
148 var $concatGroups = '';
150 function formatResult( $skin, $result ) {
154 if($this->previousResult
->title
!= $result->title
&& $this->previousResult
!= false) {
155 // Different username, give back name(group1,group2)
156 $name = $skin->makeLink( $wgContLang->getNsText($this->previousResult
->namespace) . ':' . $this->previousResult
->title
, $this->previousResult
->title
);
157 $name .= $this->concatGroups ?
'('.substr($this->concatGroups
,0,-1).')' : '';
158 $this->clearGroups();
161 if($result->type
!= '') {
162 $this->appendGroups( $skin->makeLink( wfMsgForContent( 'administrators' ), $result->type
) );
165 $this->previousResult
= $result;
173 function wfSpecialListusers() {
176 list( $limit, $offset ) = wfCheckLimits();
178 $slu = new ListUsersPage();
181 * Get some parameters
183 $slu->requestedGroup
= $wgRequest->getVal('group');
184 $slu->requestedUser
= $wgRequest->getVal('username');
186 return $slu->doQuery( $offset, $limit );