includes/SpecialListusers.php

   1 <?php
   2 # Copyright (C) 2004 Brion Vibber, lcrocker, Tim Starling,
   3 # Domas Mituzas, Ashar Voultoiz, Jens Frank, Zhengzhu.
   4 #
   5 # http://www.mediawiki.org/
   6 #
   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.
  11 #
  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.
  16 #
  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
  21 /**
  22  *
  23  * @package MediaWiki
  24  * @subpackage SpecialPage
  25  */
  26
  27 /**
  28  *
  29  */
  30 require_once('QueryPage.php');
  31
  32 /**
  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.
  36  *
  37  * @package MediaWiki
  38  * @subpackage SpecialPage
  39  */
  40 class ListUsersPage extends QueryPage {
  41         var $requestedGroup = '';
  42         var $requestedUser = '';
  43         var $previousResult = null;
  44         var $concatGroups = '';
  45
  46         function getName() {
  47                 return 'Listusers';
  48         }
  49         function isSyndicated() { return false; }
  50
  51         /**
  52          * Show a drop down list to select a group as well as a user name
  53          * search box.
  54          * @todo localize
  55          */
  56         function getPageHeader( ) {
  57                 global $wgScript;
  58
  59                 // Various variables used for the form
  60                 $action = htmlspecialchars( $wgScript );
  61                 $title = Title::makeTitle( NS_SPECIAL, 'Listusers' );
  62                 $special = htmlspecialchars( $title->getPrefixedDBkey() );
  63
  64                 // form header
  65                 $out = '<form method="get" action="'.$action.'">' .
  66                                 '<input type="hidden" name="title" value="'.$special.'" />' .
  67                                 wfMsg( 'grouplevels-editgroup-name' ) . '<select name="group">';
  68
  69                 // get all group names and IDs
  70                 $groups =& Group::getAllGroups();
  71
  72                 // we want a default empty group
  73                 $out.= '<option value=""></option>';
  74
  75                 // build the dropdown list menu using datas from the database
  76                 foreach ( $groups as $group ) {
  77                         $selected = ($group->getId() == $this->requestedGroup) ? ' selected ' : '' ;
  78                         $out.= '<option value="'.$group->getId().'" '.$selected.'>'.$group->getExpandedName().'</option>';
  79                 }
  80                 $out .= '</select> ';
  81
  82                 $out .= wfMsg( 'specialloguserlabel' ) . '<input type="text" name="username" /> ';
  83
  84                 // OK button, end of form.
  85                 $out .= '<input type="submit" /></form>';
  86                 // congratulations the form is now build
  87                 return $out;
  88         }
  89
  90         function getSQL() {
  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";
  98         */
  99         /** Show groups instead */
 100                 $user = $dbr->tableName( 'user' );
 101                 $user_groups = $dbr->tableName( 'user_groups' );
 102
 103                 $userspace = NS_USER;
 104                 $sql = "SELECT CONCAT('Listusers ', ug_group) as type, $userspace AS namespace, user_name AS title, user_name as value " .
 105                         "FROM $user ".
 106                         "LEFT JOIN $user_groups ON user_id =ug_user ";
 107
 108                 if($this->requestedGroup != '') {
 109                         $sql .=  "WHERE ug_group = '" . IntVal( $this->requestedGroup ) . "' ";
 110                         if($this->requestedUser != '') {
 111                                 $sql .= "AND user_name = " . $dbr->addQuotes( $this->requestedUser ) . ' ';
 112                         }
 113                 } else {
 114                         if($this->requestedUser !='') {
 115                                 $sql .= "WHERE user_name = " . $dbr->addQuotes( $this->requestedUser ) . ' ';
 116                         }
 117                 }
 118
 119                 return $sql;
 120         }
 121
 122         /**
 123          * When calling formatResult we output the previous result instead of the
 124          * current one. We need an additional step to flush out the last result.
 125          */
 126         function tryLastResult( ) {
 127                 return true;
 128         }
 129
 130         function sortDescending() {
 131                 return false;
 132         }
 133
 134         function appendGroups($group) {
 135                 $this->concatGroups     .= $group.' ';
 136         }
 137
 138         function clearGroups() {
 139                 $this->concatGroups = '';
 140         }
 141 /*
 142         var $previousResult = false;
 143         var $concatGroups = '';
 144 */
 145         function formatResult( $skin, $result ) {
 146                 global $wgContLang;
 147                 $name = false;
 148
 149                 if( is_object( $this->previousResult ) &&
 150                         (is_null( $result ) || ( $this->previousResult->title != $result->title ) ) ) {
 151                         // Different username, give back name(group1,group2)
 152                         $name = $skin->makeLink( $wgContLang->getNsText($this->previousResult->namespace) . ':' . $this->previousResult->title, $this->previousResult->title );
 153                         $name .= $this->concatGroups ? ' ('.substr($this->concatGroups,0,-1).')' : '';
 154                         $this->clearGroups();
 155                 }
 156
 157                 if( is_object( $result ) && $result->type != '') {
 158                         $group = Group::newFromId( intval( strstr( $result->type, ' ' ) ) );
 159                         if ( $group ) {
 160                                 $groupName = $group->getExpandedName();
 161                                 $this->appendGroups( $skin->makeLink( wfMsgForContent( 'administrators' ), $groupName ) );
 162                         }
 163                 }
 164
 165                 $this->previousResult = $result;
 166                 return $name;
 167         }
 168 }
 169
 170 /**
 171  * constructor
 172  */
 173 function wfSpecialListusers() {
 174         global $wgRequest;
 175
 176         list( $limit, $offset ) = wfCheckLimits();
 177
 178         $slu = new ListUsersPage();
 179
 180         /**
 181          * Get some parameters
 182          */
 183         $slu->requestedGroup = $wgRequest->getVal('group');
 184         $slu->requestedUser = $wgRequest->getVal('username');
 185
 186         return $slu->doQuery( $offset, $limit );
 187 }
 188
 189 ?>