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 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, 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 = '';
47 function isSyndicated() { return false; }
50 * Not expensive, this class won't work properly with the caching system anyway
52 function isExpensive() {
57 * Fetch user page links and cache their existence
59 function preprocessResults( &$db, &$res ) {
60 $batch = new LinkBatch
;
61 while ( $row = $db->fetchObject( $res ) ) {
62 $batch->addObj( Title
::makeTitleSafe( $row->namespace, $row->title
) );
66 // Back to start for display
67 if( $db->numRows( $res ) > 0 ) {
68 // If there are no rows we get an error seeking.
69 $db->dataSeek( $res, 0 );
74 * Show a drop down list to select a group as well as a user name
78 function getPageHeader( ) {
81 // Various variables used for the form
82 $action = htmlspecialchars( $wgScript );
83 $title = Title
::makeTitle( NS_SPECIAL
, 'Listusers' );
84 $special = htmlspecialchars( $title->getPrefixedDBkey() );
87 $out = '<form method="get" action="'.$action.'">' .
88 '<input type="hidden" name="title" value="'.$special.'" />' .
89 wfMsgHtml( 'groups-editgroup-name' ) . '<select name="group">';
92 $groups = User
::getAllGroups();
94 // we want a default empty group
95 $out.= '<option value=""></option>';
97 // build the dropdown list menu using datas from the database
98 foreach ( $groups as $group ) {
99 $selected = ($group == $this->requestedGroup
);
100 $out .= wfElement( 'option',
102 array( 'value' => $group ),
103 $selected ?
array( 'selected' => 'selected' ) : array() ),
104 User
::getGroupName( $group ) );
106 $out .= '</select> ';
108 $out .= wfMsgHtml( 'specialloguserlabel' ) . '<input type="text" name="username" /> ';
110 // OK button, end of form.
111 $out .= '<input type="submit" value="' . wfMsgHtml( 'allpagessubmit' ) . '" /></form>';
112 // congratulations the form is now build
117 $dbr =& wfGetDB( DB_SLAVE
);
118 $user = $dbr->tableName( 'user' );
119 $user_groups = $dbr->tableName( 'user_groups' );
121 // We need to get an 'atomic' list of users, so that we
122 // don't break the list half-way through a user's group set
123 // and so that lists by group will show all group memberships.
125 // On MySQL 4.1 we could use GROUP_CONCAT to grab group
126 // assignments together with users pretty easily. On other
127 // versions, it's not so easy to do it consistently.
128 // For now we'll just grab the number of memberships, so
129 // we can then do targetted checks on those who are in
130 // non-default groups as we go down the list.
132 $userspace = NS_USER
;
133 $sql = "SELECT 'Listusers' as type, $userspace AS namespace, user_name AS title, " .
134 "user_name as value, user_id, COUNT(ug_group) as numgroups " .
136 "LEFT JOIN $user_groups ON user_id=ug_user " .
137 $this->userQueryWhere( $dbr ) .
138 " GROUP BY user_name";
143 function userQueryWhere( &$dbr ) {
144 $conds = $this->userQueryConditions();
145 return empty( $conds )
147 : "WHERE " . $dbr->makeList( $conds, LIST_AND
);
150 function userQueryConditions() {
152 if( $this->requestedGroup
!= '' ) {
153 $conds['ug_group'] = $this->requestedGroup
;
155 if( $this->requestedUser
!= '' ) {
156 $conds['user_name'] = $this->requestedUser
;
161 function linkParameters() {
163 if( $this->requestedGroup
!= '' ) {
164 $conds['group'] = $this->requestedGroup
;
166 if( $this->requestedUser
!= '' ) {
167 $conds['username'] = $this->requestedUser
;
172 function sortDescending() {
176 function formatResult( $skin, $result ) {
177 $userPage = Title
::makeTitle( $result->namespace, $result->title
);
178 $name = $skin->makeLinkObj( $userPage, htmlspecialchars( $userPage->getText() ) );
180 if( !isset( $result->numgroups
) ||
$result->numgroups
> 0 ) {
181 $dbr =& wfGetDB( DB_SLAVE
);
182 $result = $dbr->select( 'user_groups',
184 array( 'ug_user' => $result->user_id
),
185 'ListUsersPage::formatResult' );
187 while( $row = $dbr->fetchObject( $result ) ) {
188 $groups[] = User
::getGroupName( $row->ug_group
);
190 $dbr->freeResult( $result );
192 if( count( $groups ) > 0 ) {
194 $skin->makeLink( wfMsgForContent( 'administrators' ),
195 htmlspecialchars( implode( ', ', $groups ) ) ) .
206 * $par string (optional) A group to list users from
208 function wfSpecialListusers( $par = null ) {
209 global $wgRequest, $wgContLang;
211 list( $limit, $offset ) = wfCheckLimits();
214 $slu = new ListUsersPage();
217 * Get some parameters
219 $groupTarget = isset($par) ?
$par : $wgRequest->getVal( 'group' );
220 $slu->requestedGroup
= $groupTarget;
221 $slu->requestedUser
= $wgContLang->ucfirst( $wgRequest->getVal('username') );
223 return $slu->doQuery( $offset, $limit );