<?php
+
# Copyright (C) 2004 Brion Vibber, lcrocker, Tim Starling,
# Domas Mituzas, Ashar Voultoiz, Jens Frank, Zhengzhu.
#
+# © 2006 Rob Church <robchur@gmail.com>
+#
# http://www.mediawiki.org/
#
# This program is free software; you can redistribute it and/or modify
#
# You should have received a copy of the GNU General Public License along
# with this program; if not, write to the Free Software Foundation, Inc.,
-# 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
+# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
# http://www.gnu.org/copyleft/gpl.html
/**
*
- * @package MediaWiki
- * @subpackage SpecialPage
+ * @addtogroup SpecialPage
*/
-/**
- *
- */
-require_once('QueryPage.php');
-
/**
* This class is used to get a list of user. The ones with specials
* rights (sysop, bureaucrat, developer) will have them displayed
* next to their names.
*
- * @package MediaWiki
- * @subpackage SpecialPage
+ * @addtogroup SpecialPage
*/
-class ListUsersPage extends QueryPage {
- var $requestedGroup = '';
- var $requestedUser = '';
-
- function getName() {
- return 'Listusers';
- }
- function isSyndicated() { return false; }
- /**
- * Not expensive, this class won't work properly with the caching system anyway
- */
- function isExpensive() {
- return false;
+class UsersPager extends AlphabeticPager {
+
+ function __construct($group=null) {
+ global $wgRequest;
+ $this->requestedGroup = $group != "" ? $group : $wgRequest->getVal( 'group' );
+ $un = $wgRequest->getText( 'username' );
+ $this->requestedUser = '';
+ if ( $un != '' ) {
+ $username = Title::makeTitleSafe( NS_USER, $un );
+ if( ! is_null( $username ) ) {
+ $this->requestedUser = $username->getText();
+ }
+ }
+ parent::__construct();
}
- /**
- * Fetch user page links and cache their existence
- */
- function preprocessResults( &$db, &$res ) {
- $batch = new LinkBatch;
- while ( $row = $db->fetchObject( $res ) ) {
- $batch->addObj( Title::makeTitleSafe( $row->namespace, $row->title ) );
- }
- $batch->execute();
- // Back to start for display
- if( $db->numRows( $res ) > 0 ) {
- // If there are no rows we get an error seeking.
- $db->dataSeek( $res, 0 );
- }
+ function getIndexField() {
+ return 'user_name';
}
- /**
- * Show a drop down list to select a group as well as a user name
- * search box.
- * @todo localize
- */
- function getPageHeader( ) {
- global $wgScript;
-
- // Various variables used for the form
- $action = htmlspecialchars( $wgScript );
- $title = Title::makeTitle( NS_SPECIAL, 'Listusers' );
- $special = htmlspecialchars( $title->getPrefixedDBkey() );
-
- // form header
- $out = '<form method="get" action="'.$action.'">' .
- '<input type="hidden" name="title" value="'.$special.'" />' .
- wfMsgHtml( 'groups-editgroup-name' ) . '<select name="group">';
-
- // get all group names and IDs
- $groups = User::getAllGroups();
-
- // we want a default empty group
- $out.= '<option value=""></option>';
-
- // build the dropdown list menu using datas from the database
- foreach ( $groups as $group ) {
- $selected = ($group == $this->requestedGroup);
- $out .= wfElement( 'option',
- array_merge(
- array( 'value' => $group ),
- $selected ? array( 'selected' => 'selected' ) : array() ),
- User::getGroupName( $group ) );
+ function getQueryInfo() {
+ $conds=array();
+ // don't show hidden names
+ $conds[]='ipb_deleted IS NULL OR ipb_deleted = 0';
+ if ($this->requestedGroup != "") {
+ $conds['ug_group'] = $this->requestedGroup;
+ }
+ if ($this->requestedUser != "") {
+ $conds[] = 'user_name >= ' . wfGetDB()->addQuotes( $this->requestedUser );
}
- $out .= '</select> ';
- $out .= wfMsgHtml( 'specialloguserlabel' ) . '<input type="text" name="username" /> ';
+ list ($user,$user_groups,$ipblocks) = wfGetDB()->tableNamesN('user','user_groups','ipblocks');
- // OK button, end of form.
- $out .= '<input type="submit" value="' . wfMsgHtml( 'allpagessubmit' ) . '" /></form>';
- // congratulations the form is now build
- return $out;
- }
+ $query = array(
+ 'tables' => " $user LEFT JOIN $user_groups ON user_id=ug_user LEFT JOIN $ipblocks ON user_id=ipb_user AND ipb_auto=0 ",
+ 'fields' => array('user_name',
+ 'MAX(user_id) AS user_id',
+ 'COUNT(ug_group) AS numgroups',
+ 'MAX(ug_group) AS singlegroup'),
+ 'options' => array('GROUP BY' => 'user_name'),
+ 'conds' => $conds
+ );
- function getSQL() {
- $dbr =& wfGetDB( DB_SLAVE );
- $user = $dbr->tableName( 'user' );
- $user_groups = $dbr->tableName( 'user_groups' );
-
- // We need to get an 'atomic' list of users, so that we
- // don't break the list half-way through a user's group set
- // and so that lists by group will show all group memberships.
- //
- // On MySQL 4.1 we could use GROUP_CONCAT to grab group
- // assignments together with users pretty easily. On other
- // versions, it's not so easy to do it consistently.
- // For now we'll just grab the number of memberships, so
- // we can then do targetted checks on those who are in
- // non-default groups as we go down the list.
-
- $userspace = NS_USER;
- $sql = "SELECT 'Listusers' as type, $userspace AS namespace, user_name AS title, " .
- "user_name as value, user_id, COUNT(ug_group) as numgroups " .
- "FROM $user ".
- "LEFT JOIN $user_groups ON user_id=ug_user " .
- $this->userQueryWhere( $dbr ) .
- " GROUP BY user_name";
-
- return $sql;
+ wfRunHooks( 'SpecialListusersQueryInfo', array( $this, &$query ) );
+ return $query;
}
- function userQueryWhere( &$dbr ) {
- $conds = $this->userQueryConditions();
- return empty( $conds )
- ? ""
- : "WHERE " . $dbr->makeList( $conds, LIST_AND );
- }
-
- function userQueryConditions() {
- $conds = array();
- if( $this->requestedGroup != '' ) {
- $conds['ug_group'] = $this->requestedGroup;
+ function formatRow( $row ) {
+ $userPage = Title::makeTitle( NS_USER, $row->user_name );
+ $name = $this->getSkin()->makeLinkObj( $userPage, htmlspecialchars( $userPage->getText() ) );
+
+ if( $row->numgroups > 1 || ( $this->requestedGroup && $row->numgroups == 1 ) ) {
+ $list = array();
+ foreach( self::getGroups( $row->user_id ) as $group )
+ $list[] = self::buildGroupLink( $group );
+ $groups = implode( ', ', $list );
+ } elseif( $row->numgroups == 1 ) {
+ $groups = self::buildGroupLink( $row->singlegroup );
+ } else {
+ $groups = '';
}
- if( $this->requestedUser != '' ) {
- $conds['user_name'] = $this->requestedUser;
- }
- return $conds;
+
+ $item = wfSpecialList( $name, $groups );
+ wfRunHooks( 'SpecialListusersFormatRow', array( &$item, $row ) );
+ return "<li>{$item}</li>";
}
- function linkParameters() {
- $conds = array();
- if( $this->requestedGroup != '' ) {
- $conds['group'] = $this->requestedGroup;
- }
- if( $this->requestedUser != '' ) {
- $conds['username'] = $this->requestedUser;
+ function getBody() {
+ if (!$this->mQueryDone) {
+ $this->doQuery();
}
- return $conds;
- }
+ $batch = new LinkBatch;
- function sortDescending() {
- return false;
+ $this->mResult->rewind();
+
+ while ( $row = $this->mResult->fetchObject() ) {
+ $batch->addObj( Title::makeTitleSafe( NS_USER, $row->user_name ) );
+ }
+ $batch->execute();
+ $this->mResult->rewind();
+ return parent::getBody();
}
- function formatResult( $skin, $result ) {
+ function getPageHeader( ) {
+ global $wgScript, $wgRequest;
+ $self = $this->getTitle();
+
+ # Form tag
+ $out = Xml::openElement( 'form', array( 'method' => 'get', 'action' => $wgScript ) ) .
+ '<fieldset>' .
+ Xml::element( 'legend', array(), wfMsg( 'listusers' ) );
+ $out .= Xml::hidden( 'title', $self->getPrefixedDbKey() );
+
+ # Username field
+ $out .= Xml::label( wfMsg( 'listusersfrom' ), 'offset' ) . ' ' .
+ Xml::input( 'username', 20, $this->requestedUser, array( 'id' => 'offset' ) ) . ' ';
+
+ # Group drop-down list
+ $out .= Xml::label( wfMsg( 'group' ), 'group' ) . ' ' .
+ Xml::openElement('select', array( 'name' => 'group', 'id' => 'group' ) ) .
+ Xml::option( wfMsg( 'group-all' ), '' );
+ foreach( User::getAllGroups() as $group )
+ $out .= Xml::option( User::getGroupName( $group ), $group, $group == $this->requestedGroup );
+ $out .= Xml::closeElement( 'select' ) . ' ';
+
+ wfRunHooks( 'SpecialListusersHeaderForm', array( $this, &$out ) );
+
+ # Submit button and form bottom
+ if( $this->mLimit )
+ $out .= Xml::hidden( 'limit', $this->mLimit );
+ $out .= Xml::submitButton( wfMsg( 'allpagessubmit' ) );
+ wfRunHooks( 'SpecialListusersHeader', array( $this, &$out ) );
+ $out .= '</fieldset>' .
+ Xml::closeElement( 'form' );
- $userPage = Title::makeTitle( $result->namespace, $result->title );
- $name = $skin->makeLinkObj( $userPage, htmlspecialchars( $userPage->getText() ) );
+ return $out;
+ }
- if( !isset( $result->numgroups ) || $result->numgroups > 0 ) {
- $dbr =& wfGetDB( DB_SLAVE );
- $result = $dbr->select( 'user_groups',
- array( 'ug_group' ),
- array( 'ug_user' => $result->user_id ),
- 'ListUsersPage::formatResult' );
- $groups = array();
- while( $row = $dbr->fetchObject( $result ) ) {
- $groups[] = User::getGroupName( $row->ug_group );
- }
- $dbr->freeResult( $result );
+ /**
+ * Preserve group and username offset parameters when paging
+ * @return array
+ */
+ function getDefaultQuery() {
+ $query = parent::getDefaultQuery();
+ if( $this->requestedGroup != '' )
+ $query['group'] = $this->requestedGroup;
+ if( $this->requestedUser != '' )
+ $query['username'] = $this->requestedUser;
+ wfRunHooks( 'SpecialListusersDefaultQuery', array( $this, &$query ) );
+ return $query;
+ }
- if( count( $groups ) > 0 ) {
- $name .= ' (' .
- $skin->makeLink( wfMsgForContent( 'administrators' ),
- htmlspecialchars( implode( ', ', $groups ) ) ) .
- ')';
- }
+ /**
+ * Get a list of groups the specified user belongs to
+ *
+ * @param int $uid
+ * @return array
+ */
+ private static function getGroups( $uid ) {
+ $dbr = wfGetDB( DB_SLAVE );
+ $groups = array();
+ $res = $dbr->select( 'user_groups', 'ug_group', array( 'ug_user' => $uid ), __METHOD__ );
+ if( $res && $dbr->numRows( $res ) > 0 ) {
+ while( $row = $dbr->fetchObject( $res ) )
+ $groups[] = $row->ug_group;
+ $dbr->freeResult( $res );
}
+ return $groups;
+ }
- return $name;
+ /**
+ * Format a link to a group description page
+ *
+ * @param string $group
+ * @return string
+ */
+ private static function buildGroupLink( $group ) {
+ static $cache = array();
+ if( !isset( $cache[$group] ) )
+ $cache[$group] = User::makeGroupLinkHtml( $group, User::getGroupMember( $group ) );
+ return $cache[$group];
}
}
* $par string (optional) A group to list users from
*/
function wfSpecialListusers( $par = null ) {
- global $wgRequest;
-
- list( $limit, $offset ) = wfCheckLimits();
-
-
- $slu = new ListUsersPage();
-
- /**
- * Get some parameters
- */
- $groupTarget = isset($par) ? $par : $wgRequest->getVal( 'group' );
- $slu->requestedGroup = $groupTarget;
- $slu->requestedUser = $wgRequest->getVal('username');
-
- return $slu->doQuery( $offset, $limit );
+ global $wgRequest, $wgOut;
+
+ $up = new UsersPager($par);
+
+ # getBody() first to check, if empty
+ $usersbody = $up->getBody();
+ $s = $up->getPageHeader();
+ if( $usersbody ) {
+ $s .= $up->getNavigationBar();
+ $s .= '<ul>' . $usersbody . '</ul>';
+ $s .= $up->getNavigationBar() ;
+ } else {
+ $s .= '<p>' . wfMsgHTML('listusers-noresult') . '</p>';
+ };
+
+ $wgOut->addHTML( $s );
}
-
-?>