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 = '';
47 function isSyndicated() { return false; }
50 * Show a drop down list to select a group as well as a user name
54 function getPageHeader( ) {
57 // Various variables used for the form
58 $action = htmlspecialchars( $wgScript );
59 $title = Title
::makeTitle( NS_SPECIAL
, 'Listusers' );
60 $special = htmlspecialchars( $title->getPrefixedDBkey() );
63 $out = '<form method="get" action="'.$action.'">' .
64 '<input type="hidden" name="title" value="'.$special.'" />' .
65 'Group: <select name="group">' .
67 // get all group names and id
68 $dbr = & wfGetDB( DB_SLAVE
);
69 $group = $dbr->tableName( 'group' );
70 $sql = "SELECT group_id, group_name FROM $group;";
71 $result = $dbr->query($sql);
73 // we want a default empty group
74 $out.= '<option value=""></option>';
76 // build the dropdown list menu using datas from the database
77 while($agroup = $dbr->fetchObject( $result )) {
78 $selected = ($agroup->group_id
== $this->requestedGroup
) ?
" selected " : "" ;
79 $out.= '<option value="'.$agroup->group_id
.'" '.$selected.'>'.$agroup->group_name
.'</option>';
83 $out .= 'User: <input type="text" name="username" /> ';
85 // OK button, end of form.
86 $out .= '<input type="submit" /></form>';
87 // congratulations the form is now build
92 $dbr =& wfGetDB( DB_SLAVE
);
93 /* system showing possible actions for users
94 $user = $dbr->tableName( 'user' );
95 $user_rights = $dbr->tableName( 'user_rights' );
96 $userspace = Namespace::getUser();
97 return "SELECT ur_rights as type, $userspace as namespace, user_name as title, " .
98 "user_name as value FROM $user LEFT JOIN $user_rights ON user_id = ur_user";
100 /** Show groups instead */
101 $user = $dbr->tableName( 'user' );
102 $group = $dbr->tableName( 'group' );
103 $user_groups = $dbr->tableName( 'user_groups' );
105 $userspace = Namespace::getUser();
106 $sql = "SELECT group_name as type, $userspace AS namespace, user_name AS title, user_name as value " .
107 "FROM $user LEFT JOIN $user_groups ON user_id =ug_user " .
108 "LEFT JOIN $group ON ug_group = group_id ";
110 if($this->requestedGroup
!= '') {
111 $sql .= "WHERE group_id= '$this->requestedGroup' ";
112 if($this->requestedUser
!= '') {
113 $sql .= "AND user_name = '$this->requestedUser' ";
116 if($this->requestedUser
!='') {
117 $sql .= "WHERE user_name = '$this->requestedUser' ";
124 function sortDescending() {
128 function formatResult( $skin, $result ) {
130 $name = $skin->makeLink( $wgContLang->getNsText($result->namespace) . ':' . $result->title
, $result->title
);
131 if( '' != $result->type
) {
133 $skin->makeLink( wfMsgForContent( 'administrators' ), $result->type
) .
143 function wfSpecialListusers() {
144 global $wgUser, $wgOut, $wgLang, $wgRequest;
146 list( $limit, $offset ) = wfCheckLimits();
148 $slu = new ListUsersPage();
151 * Get some parameters
153 $slu->requestedGroup
= $wgRequest->getVal('group');
154 $slu->requestedUser
= $wgRequest->getVal('username');
156 return $slu->doQuery( $offset, $limit );