This is a class for doing query pages; since they're almost all the same, we factor out some of the functionality into a superclass, and let subclasses derive from it. More...

Inheritance diagram for QueryPage:

[legend]

Collaboration diagram for QueryPage:

[legend]

Public Member Functions
	closeList ()

	doFeed ( $class='', $limit=50)
	Similar to above, but packaging in a syndicated feed instead of a web page.

	doQuery ( $offset=false, $limit=false)
	Somewhat deprecated, you probably want to be using execute()

	execute ( $par)
	This is the actual workhorse.

	feedDesc ()

	feedItemAuthor ( $row)

	feedItemDesc ( $row)

	feedResult ( $row)
	Override for custom handling.

	feedTitle ()

	feedUrl ()

	fetchFromCache ( $limit, $offset=false)
	Fetch the query results from the query cache.

	formatResult ( $skin, $result)
	Formats the results of the query for display.

	getCachedTimestamp ()

	getCacheOrderFields ()
	Return the order fields for fetchFromCache.

	getOrderFields ()
	Subclasses return an array of fields to order by here.

	getPageHeader ()
	The content returned by this function will be output before any result.

	getQueryInfo ()
	Subclasses return an SQL query here, formatted as an array with the following keys: tables => Table(s) for passing to Database::select() fields => Field(s) for passing to Database::select(), may be * conds => WHERE conditions options => options join_conds => JOIN conditions.

	getRecacheDB ()
	Get a DB connection to be used for slow recache queries.

	getSQL ()
	For back-compat, subclasses may return a raw SQL query here, as a string.

	isCacheable ()
	Is the output of this query cacheable? Non-cacheable expensive pages will be disabled in miser mode and will not have their results written to the querycache table.

	isCached ()
	Whether or not the output of the page in question is retrieved from the database cache.

	isExpensive ()
	Is this query expensive (for some definition of expensive)? Then we don't let it run in miser mode.

	isSyndicated ()
	Sometime we don't want to build rss / atom feeds.

	linkParameters ()
	If using extra form wheely-dealies, return a set of parameters here as an associative array.

	openList ( $offset)

	preprocessResults ( $db, $res)
	Do any necessary preprocessing of the result object.

	reallyDoQuery ( $limit, $offset=false)
	Run the query and return the result.

	recache ( $limit, $ignoreErrors=true)
	Clear the cache and save new results.

	setListoutput ( $bool)
	A mutator for $this->listoutput;.

	sortDescending ()
	Override to sort by increasing values.

	tryLastResult ()
	Some special pages (for example SpecialListusers used to) might not return the current object formatted, but return the previous one instead.

	usesTimestamps ()
	Does this query return timestamps rather than integers in its 'value' field? If true, this class will convert 'value' to a UNIX timestamp for caching.

Public Member Functions inherited from SpecialPage
	__construct ( $name='', $restriction='', $listed=true, $function=false, $file='', $includable=false)
	Default constructor for special pages Derivative classes should call this from their constructor Note that if the user does not have the required level, an error message will be displayed by the default execute() method, without the global function ever being called.

	addHelpLink ( $to, $overrideBaseUrl=false)
	Adds help link with an icon via page indicators.

	checkPermissions ()
	Checks if userCanExecute, and if not throws a PermissionsError.

	checkReadOnly ()
	If the wiki is currently in readonly mode, throws a ReadOnlyError.

	displayRestrictionError ()
	Output an error message telling the user what access level they have to have.

	doesWrites ()
	Indicates whether this special page may perform database writes.

	getConfig ()
	Shortcut to get main config object.

	getContext ()
	Gets the context this SpecialPage is executed in.

	getDescription ()
	Returns the name that goes in the \<h1\> in the special page itself, and also the name that will be listed in Special:Specialpages.

	getFinalGroupName ()
	Get the group that the special page belongs in on Special:SpecialPage Use this method, instead of getGroupName to allow customization of the group name from the wiki side.

	getFullTitle ()
	Return the full title, including $par.

	getLanguage ()
	Shortcut to get user's language.

	getLinkRenderer ()

	getLocalName ()
	Get the localised name of the special page.

	getName ()
	Get the name of this Special Page.

	getOutput ()
	Get the OutputPage being used for this instance.

	getPageTitle ( $subpage=false)
	Get a self-referential title object.

	getRequest ()
	Get the WebRequest being used for this instance.

	getRestriction ()
	Get the permission that a user must have to execute this page.

	getSkin ()
	Shortcut to get the skin being used for this instance.

	getTitle ( $subpage=false)
	Get a self-referential title object.

	getUser ()
	Shortcut to get the User executing this instance.

	including ( $x=null)
	Whether the special page is being evaluated via transclusion.

	isIncludable ()
	Whether it's allowed to transclude the special page via {{Special:Foo/params}}.

	isListed ()
	Whether this special page is listed in Special:SpecialPages.

	isRestricted ()
	Can be overridden by subclasses with more complicated permissions schemes.

	listed ( $x=null)
	Get or set whether this special page is listed in Special:SpecialPages.

	maxIncludeCacheTime ()
	How long to cache page when it is being included.

	msg ( $key)
	Wrapper around wfMessage that sets the current context.

	outputHeader ( $summaryMessageKey='')
	Outputs a summary message on top of special pages Per default the message key is the canonical name of the special page May be overridden, i.e.

	prefixSearchSubpages ( $search, $limit, $offset)
	Return an array of subpages beginning with $search that this special page will accept.

	requireLogin ( $reasonMsg='exception-nologin-text', $titleMsg='exception-nologin')
	If the user is not logged in, throws UserNotLoggedIn error.

	run ( $subPage)
	Entry point.

	setContext ( $context)
	Sets the context this SpecialPage is executed in.

	setHeaders ()
	Sets headers - this should be called from the execute() method of all derived classes!

	setLinkRenderer (LinkRenderer $linkRenderer)

	setListed ( $listed)
	Set whether this page is listed in Special:Specialpages, at run-time.

	userCanExecute (User $user)
	Checks if the given user (identified by an object) can execute this special page (as defined by $mRestriction).

Static Public Member Functions
static	getPages ()
	Get a list of query page classes and their associated special pages, for periodic updates.

Static Public Member Functions inherited from SpecialPage
static	getSafeTitleFor ( $name, $subpage=false)
	Get a localised Title object for a page name with a possibly unvalidated subpage.

static	getTitleFor ( $name, $subpage=false, $fragment='')
	Get a localised Title object for a specified special page name If you don't need a full Title object, consider using TitleValue through getTitleValueFor() below.

static	getTitleValueFor ( $name, $subpage=false, $fragment='')
	Get a localised TitleValue object for a specified special page name.

Protected Member Functions
	executeLBFromResultWrapper (ResultWrapper $res, $ns=null)
	Creates a new LinkBatch object, adds all pages from the passed ResultWrapper (MUST include title and optional the namespace field) and executes the batch.

	getDBLimit ( $uiLimit, $uiOffset)
	What is limit to fetch from DB.

	getLimitOffset ()
	Returns limit and offset, as returned by $this->getRequest()->getLimitOffset().

	getMaxResults ()
	Get max number of results we can return in miser mode.

	outputResults ( $out, $skin, $dbr, $res, $num, $offset)
	Format and output report results using the given information plus OutputPage.

	showEmptyText ()
	Outputs some kind of an informative message (via OutputPage) to let the user know that the query returned nothing and thus there's nothing to show.

Protected Member Functions inherited from SpecialPage
	addFeedLinks ( $params)
	Adds RSS/atom links.

	afterExecute ( $subPage)
	Gets called after.

	beforeExecute ( $subPage)
	Gets called before.

	checkLoginSecurityLevel ( $level=null)
	Verifies that the user meets the security level, possibly reauthenticating them in the process.

	getCacheTTL ()

	getGroupName ()
	Under which header this special page is listed in Special:SpecialPages See messages 'specialpages-group-*' for valid names This method defaults to group 'other'.

	getLoginSecurityLevel ()
	Tells if the special page does something security-sensitive and needs extra defense against a stolen account (e.g.

	getRobotPolicy ()
	Return the robot policy.

	getSubpagesForPrefixSearch ()
	Return an array of subpages that this special page will accept for prefix searches.

	prefixSearchString ( $search, $limit, $offset)
	Perform a regular substring search for prefixSearchSubpages.

	setReauthPostData (array $data)
	Record preserved POST data after a reauthentication.

	useTransactionalTimeLimit ()
	Call wfTransactionalTimeLimit() if this request was POSTed.

Protected Attributes
	$cachedTimestamp = null

int	$limit = 0

bool	$listoutput = false
	Whether or not we want plain listoutput rather than an ordered list.

	$numRows
	The number of rows returned by the query.

int	$offset = 0
	The offset and limit in use, as passed to the query() function.

	$shownavigation = true
	Whether to show prev/next links.

Protected Attributes inherited from SpecialPage
IContextSource	$mContext
	Current request context.

	$mIncludable

	$mIncluding

	$mName

	$mRestriction

Additional Inherited Members
Static Protected Member Functions inherited from SpecialPage
static	prefixSearchArray ( $search, $limit, array $subpages, $offset)
	Helper function for implementations of prefixSearchSubpages() that filter the values in memory (as opposed to making a query).

Detailed Description

This is a class for doing query pages; since they're almost all the same, we factor out some of the functionality into a superclass, and let subclasses derive from it.

Definition at line 34 of file QueryPage.php.

Member Function Documentation

◆ closeList()

QueryPage::closeList ( )

Returns: string

Definition at line 748 of file QueryPage.php.

Referenced by outputResults(), and FileDuplicateSearchPage\showList().

◆ doFeed()

QueryPage::doFeed	(		$class = '',
			$limit = 50 )

Similar to above, but packaging in a syndicated feed instead of a web page.

Parameters

string	$class
int	$limit

Returns: bool

Definition at line 766 of file QueryPage.php.

References $limit, $res, feedDesc(), feedResult(), feedTitle(), feedUrl(), SpecialPage\getConfig(), SpecialPage\getOutput(), and reallyDoQuery().

◆ doQuery()

QueryPage::doQuery	(		$offset = false,
			$limit = false )

Somewhat deprecated, you probably want to be using execute()

Parameters

int \| bool	$offset
int \| bool	$limit

Returns: ResultWrapper

Definition at line 444 of file QueryPage.php.

References $offset, fetchFromCache(), isCacheable(), isCached(), and reallyDoQuery().

◆ execute()

QueryPage::execute ( $par )

This is the actual workhorse.

It does everything needed to make a real, honest-to-gosh query page.

Parameters

string $par

Reimplemented from SpecialPage.

Reimplemented in FileDuplicateSearchPage, LinkSearchPage, MIMEsearchPage, SpecialPagesWithProp, UnwatchedpagesPage, WantedPagesPage, and WithoutInterwikiPage.

Definition at line 573 of file QueryPage.php.

References $dbr, $lang, $limit, $out, $res, SpecialPage\displayRestrictionError(), fetchFromCache(), getCachedTimestamp(), SpecialPage\getConfig(), getDBLimit(), SpecialPage\getLanguage(), getLimitOffset(), getMaxResults(), SpecialPage\getName(), SpecialPage\getOutput(), getPageHeader(), SpecialPage\getPageTitle(), getRecacheDB(), SpecialPage\getSkin(), SpecialPage\getUser(), isCacheable(), isCached(), isSyndicated(), linkParameters(), list, SpecialPage\msg(), SpecialPage\outputHeader(), outputResults(), preprocessResults(), reallyDoQuery(), SpecialPage\setHeaders(), showEmptyText(), and SpecialPage\userCanExecute().

◆ executeLBFromResultWrapper()

QueryPage::executeLBFromResultWrapper	(	ResultWrapper	$res,
			$ns = null )

protected

Creates a new LinkBatch object, adds all pages from the passed ResultWrapper (MUST include title and optional the namespace field) and executes the batch.

This operation will pre-cache LinkCache information like page existence and information for stub color and redirect hints.

Parameters

ResultWrapper	$res	The ResultWrapper object to process. Needs to include the title field and namespace field, if the $ns parameter isn't set.
null	$ns	Use this namespace for the given titles in the ResultWrapper object, instead of the namespace value of $res.

Definition at line 862 of file QueryPage.php.

References $batch, $res, and LinkBatch\add().

◆ feedDesc()

QueryPage::feedDesc ( )

Definition at line 844 of file QueryPage.php.

References SpecialPage\msg().

Referenced by doFeed().

◆ feedItemAuthor()

QueryPage::feedItemAuthor ( $row )

Definition at line 833 of file QueryPage.php.

◆ feedItemDesc()

QueryPage::feedItemDesc ( $row )

Definition at line 829 of file QueryPage.php.

◆ feedResult()

QueryPage::feedResult ( $row )

Override for custom handling.

If the titles/links are ok, just do feedItemDesc()

Parameters

object $row

Returns: FeedItem|null

Definition at line 804 of file QueryPage.php.

Referenced by doFeed().

◆ feedTitle()

QueryPage::feedTitle ( )

Definition at line 837 of file QueryPage.php.

References $code, SpecialPage\getConfig(), and SpecialPage\getDescription().

Referenced by doFeed().

◆ feedUrl()

QueryPage::feedUrl ( )

Definition at line 848 of file QueryPage.php.

References SpecialPage\getPageTitle().

Referenced by doFeed().

◆ fetchFromCache()

QueryPage::fetchFromCache	(		$limit,
			$offset = false )

Fetch the query results from the query cache.

Parameters

int \| bool	$limit	Numerical limit or false for no limit
int \| bool	$offset	Numerical offset or false for no offset

Returns: ResultWrapper

Since: 1.18

Definition at line 459 of file QueryPage.php.

References $dbr, $limit, $offset, $options, DB_REPLICA, getCacheOrderFields(), SpecialPage\getName(), sortDescending(), and wfGetDB().

Referenced by doQuery(), and execute().

◆ formatResult()

QueryPage::formatResult	(		$skin,
			$result )

abstract

Formats the results of the query for display.

The skin is the current skin; you can use it for making links. The result is a single row of result data. You should be able to grab SQL results off of it. If the function returns false, the line output will be skipped.

Parameters

Skin	$skin
object	$result	Result row

Returns: string|bool String or false to skip

Reimplemented in SpecialGadgetUsage, ImageQueryPage, WantedQueryPage, AncientPagesPage, BrokenRedirectsPage, DoubleRedirectsPage, FewestrevisionsPage, FileDuplicateSearchPage, LinkSearchPage, ListDuplicatedFilesPage, ListredirectsPage, MediaStatisticsPage, MIMEsearchPage, MostcategoriesPage, MostinterwikisPage, MostlinkedPage, MostlinkedCategoriesPage, MostlinkedTemplatesPage, SpecialPagesWithProp, ShortPagesPage, UncategorizedCategoriesPage, UnusedCategoriesPage, UnusedtemplatesPage, UnwatchedpagesPage, WantedCategoriesPage, and PageQueryPage.

Referenced by outputResults().

◆ getCachedTimestamp()

QueryPage::getCachedTimestamp ( )

Definition at line 502 of file QueryPage.php.

References $cachedTimestamp, $dbr, $fname, DB_REPLICA, SpecialPage\getName(), and wfGetDB().

Referenced by execute().

◆ getCacheOrderFields()

QueryPage::getCacheOrderFields ( )

Return the order fields for fetchFromCache.

Default is to always use "ORDER BY value" which was the default prior to this function.

Returns: array

Since: 1.29

Reimplemented in WantedQueryPage.

Definition at line 498 of file QueryPage.php.

Referenced by fetchFromCache().

◆ getDBLimit()

QueryPage::getDBLimit	(		$uiLimit,
			$uiOffset )

protected

What is limit to fetch from DB.

Used to make it appear the DB stores less results then it actually does

Parameters

int	$uiLimit	Limit from UI
int	$uiOffset	Offset from UI

Returns: int Limit to use for DB (not including extra row to see if at end)

Definition at line 544 of file QueryPage.php.

References $limit, SpecialPage\getConfig(), and getMaxResults().

Referenced by execute().

◆ getLimitOffset()

QueryPage::getLimitOffset ( )

protected

Returns limit and offset, as returned by $this->getRequest()->getLimitOffset().

Subclasses may override this to further restrict or modify limit and offset.

Note: Restricts the offset parameter, as most query pages have inefficient paging

Its generally expected that the returned limit will not be 0, and the returned offset will be less than the max results.

Since: 1.26

Returns: int[] list( $limit, $offset )

Definition at line 524 of file QueryPage.php.

References $limit, $offset, SpecialPage\getConfig(), getMaxResults(), SpecialPage\getRequest(), and list.

Referenced by execute().

◆ getMaxResults()

QueryPage::getMaxResults ( )

protected

Get max number of results we can return in miser mode.

Most QueryPage subclasses use inefficient paging, so limit the max amount we return This matters for uncached query pages that might otherwise accept an offset of 3 million

Since: 1.27

Returns: int

Reimplemented in LinkSearchPage.

Definition at line 563 of file QueryPage.php.

References SpecialPage\getConfig().

Referenced by execute(), getDBLimit(), and getLimitOffset().

◆ getOrderFields()

QueryPage::getOrderFields ( )

Subclasses return an array of fields to order by here.

Don't append DESC to the field names, that'll be done automatically if sortDescending() returns true.

Returns: array

Since: 1.18

Reimplemented in SpecialGadgetUsage, WantedQueryPage, BrokenRedirectsPage, DeadendPagesPage, DoubleRedirectsPage, LinkSearchPage, ListredirectsPage, LonelyPagesPage, MediaStatisticsPage, MIMEsearchPage, SpecialPagesWithProp, ShortPagesPage, UncategorizedPagesPage, UnwatchedpagesPage, and WithoutInterwikiPage.

Definition at line 171 of file QueryPage.php.

Referenced by reallyDoQuery().

◆ getPageHeader()

QueryPage::getPageHeader ( )

The content returned by this function will be output before any result.

Returns: string

Reimplemented in BrokenRedirectsPage, DeadendPagesPage, DoubleRedirectsPage, LonelyPagesPage, MIMEsearchPage, UnusedCategoriesPage, UnusedimagesPage, UnusedtemplatesPage, WantedFilesPage, and WithoutInterwikiPage.

Definition at line 255 of file QueryPage.php.

Referenced by execute().

◆ getPages()

static QueryPage::getPages ( )

static

Get a list of query page classes and their associated special pages, for periodic updates.

DO NOT CHANGE THIS LIST without testing that maintenance/updateSpecialPages.php still works.

Returns: array

Definition at line 66 of file QueryPage.php.

Referenced by QueryAllSpecialPagesTest\__construct(), ApiQueryQueryPage\__construct(), and UpdateSpecialPages\execute().

◆ getQueryInfo()

QueryPage::getQueryInfo ( )

Subclasses return an SQL query here, formatted as an array with the following keys: tables => Table(s) for passing to Database::select() fields => Field(s) for passing to Database::select(), may be * conds => WHERE conditions options => options join_conds => JOIN conditions.

Note that the query itself should return the following three columns: 'namespace', 'title', and 'value'. 'value' is used for sorting.

These may be stored in the querycache table for expensive queries, and that cached data will be returned sometimes, so the presence of extra fields can't be relied upon. The cached 'value' column will be an integer; non-numeric values are useful only for sorting the initial query (except if they're timestamps, see usesTimestamps()).

Don't include an ORDER or LIMIT clause, they will be added.

If this function is not overridden or returns something other than an array, getSQL() will be used instead. This is for backwards compatibility only and is strongly deprecated.

Returns: array

Since: 1.18

Reimplemented in SpecialGadgetUsage, AncientPagesPage, BrokenRedirectsPage, DeadendPagesPage, DoubleRedirectsPage, FewestrevisionsPage, FileDuplicateSearchPage, LinkSearchPage, ListDuplicatedFilesPage, ListredirectsPage, LonelyPagesPage, MediaStatisticsPage, MIMEsearchPage, MostcategoriesPage, MostimagesPage, MostinterwikisPage, MostlinkedPage, MostlinkedCategoriesPage, MostlinkedTemplatesPage, SpecialPagesWithProp, ShortPagesPage, UncategorizedCategoriesPage, UncategorizedImagesPage, UncategorizedPagesPage, UnusedCategoriesPage, UnusedimagesPage, UnusedtemplatesPage, UnwatchedpagesPage, WantedCategoriesPage, WantedFilesPage, WantedPagesPage, WantedTemplatesPage, and WithoutInterwikiPage.

Definition at line 148 of file QueryPage.php.

Referenced by reallyDoQuery().

◆ getRecacheDB()

QueryPage::getRecacheDB ( )

Get a DB connection to be used for slow recache queries.

Returns: IDatabase

Definition at line 382 of file QueryPage.php.

References DB_REPLICA, SpecialPage\getName(), and wfGetDB().

Referenced by execute(), reallyDoQuery(), and ShortPagesPage\reallyDoQuery().

◆ getSQL()

QueryPage::getSQL ( )

For back-compat, subclasses may return a raw SQL query here, as a string.

This is strongly deprecated; getQueryInfo() should be overridden instead.

Exceptions

MWException

Returns: string

Definition at line 158 of file QueryPage.php.

Referenced by reallyDoQuery().

◆ isCacheable()

QueryPage::isCacheable ( )

Is the output of this query cacheable? Non-cacheable expensive pages will be disabled in miser mode and will not have their results written to the querycache table.

Returns: bool

Since: 1.18

Reimplemented in FileDuplicateSearchPage, LinkSearchPage, MIMEsearchPage, and SpecialPagesWithProp.

Definition at line 216 of file QueryPage.php.

Referenced by doQuery(), execute(), and recache().

◆ isCached()

QueryPage::isCached ( )

Whether or not the output of the page in question is retrieved from the database cache.

Returns: bool

Reimplemented from SpecialPage.

Reimplemented in FileDuplicateSearchPage.

Definition at line 226 of file QueryPage.php.

References SpecialPage\getConfig(), and isExpensive().

Referenced by doQuery(), execute(), WantedQueryPage\formatResult(), MostcategoriesPage\formatResult(), MostinterwikisPage\formatResult(), ShortPagesPage\formatResult(), WantedCategoriesPage\formatResult(), and WithoutInterwikiPage\getPageHeader().

◆ isExpensive()

QueryPage::isExpensive ( )

Is this query expensive (for some definition of expensive)? Then we don't let it run in miser mode.

$wgDisableQueryPages causes all query pages to be declared expensive. Some query pages are always expensive.

Returns: bool

Reimplemented from SpecialPage.

Reimplemented in SpecialGadgetUsage, WantedQueryPage, AncientPagesPage, BrokenRedirectsPage, DeadendPagesPage, DoubleRedirectsPage, FewestrevisionsPage, ListDuplicatedFilesPage, ListredirectsPage, LonelyPagesPage, MediaStatisticsPage, MIMEsearchPage, MostcategoriesPage, MostimagesPage, MostinterwikisPage, MostlinkedPage, MostlinkedTemplatesPage, UncategorizedImagesPage, UncategorizedPagesPage, UnusedCategoriesPage, UnusedimagesPage, UnusedtemplatesPage, UnwatchedpagesPage, and WithoutInterwikiPage.

Definition at line 205 of file QueryPage.php.

References SpecialPage\getConfig().

Referenced by isCached().

◆ isSyndicated()

QueryPage::isSyndicated ( )

Sometime we don't want to build rss / atom feeds.

Returns: bool

Reimplemented in WantedQueryPage, AncientPagesPage, BrokenRedirectsPage, DeadendPagesPage, DoubleRedirectsPage, FewestrevisionsPage, FileDuplicateSearchPage, LinkSearchPage, ListDuplicatedFilesPage, ListredirectsPage, LonelyPagesPage, MIMEsearchPage, MostcategoriesPage, MostimagesPage, MostinterwikisPage, MostlinkedPage, MostlinkedCategoriesPage, MostlinkedTemplatesPage, SpecialPagesWithProp, ShortPagesPage, UncategorizedImagesPage, UncategorizedPagesPage, UnusedimagesPage, UnusedtemplatesPage, UnwatchedpagesPage, and WithoutInterwikiPage.

Definition at line 235 of file QueryPage.php.

Referenced by execute().

◆ linkParameters()

QueryPage::linkParameters ( )

If using extra form wheely-dealies, return a set of parameters here as an associative array.

They will be encoded and added to the paging links (prev/next/lengths).

Returns: array

Reimplemented in FileDuplicateSearchPage, LinkSearchPage, and MIMEsearchPage.

Definition at line 277 of file QueryPage.php.

Referenced by execute().

◆ openList()

QueryPage::openList ( $offset )

Parameters

int $offset

Returns: string

Definition at line 741 of file QueryPage.php.

References $offset.

Referenced by outputResults(), and FileDuplicateSearchPage\showList().

◆ outputResults()

QueryPage::outputResults	(	$out,
		$skin,
		$dbr,
		$res,
		$num,
		$offset )

protected

Format and output report results using the given information plus OutputPage.

Parameters

OutputPage	$out	OutputPage to print to
Skin	$skin	User skin to use
IDatabase	$dbr	Database (read) connection to use
ResultWrapper	$res	Result pointer
int	$num	Number of available result rows
int	$offset	Paging offset

Reimplemented in SpecialGadgetUsage, ImageQueryPage, and MediaStatisticsPage.

Definition at line 692 of file QueryPage.php.

References $html, $line, $out, $res, $wgContLang, closeList(), formatResult(), openList(), and tryLastResult().

Referenced by execute().

◆ preprocessResults()

QueryPage::preprocessResults	(		$db,
			$res )

Do any necessary preprocessing of the result object.

Parameters

IDatabase	$db
ResultWrapper	$res

Reimplemented in PageQueryPage, WantedQueryPage, AncientPagesPage, BrokenRedirectsPage, DoubleRedirectsPage, LinkSearchPage, ListDuplicatedFilesPage, ListredirectsPage, MIMEsearchPage, MostcategoriesPage, MostinterwikisPage, MostlinkedPage, MostlinkedCategoriesPage, MostlinkedTemplatesPage, ShortPagesPage, UnusedCategoriesPage, UnwatchedpagesPage, WantedCategoriesPage, and MediaStatisticsPage.

Definition at line 757 of file QueryPage.php.

Referenced by execute().

◆ reallyDoQuery()

QueryPage::reallyDoQuery	(		$limit,
			$offset = false )

Run the query and return the result.

Parameters

int \| bool	$limit	Numerical limit or false for no limit
int \| bool	$offset	Numerical offset or false for no offset

Returns: ResultWrapper

Since: 1.18

Reimplemented in ShortPagesPage.

Definition at line 393 of file QueryPage.php.

References $dbr, $fname, $limit, $offset, $options, $query, $res, $tables, array(), getOrderFields(), getQueryInfo(), getRecacheDB(), getSQL(), and sortDescending().

Referenced by doFeed(), doQuery(), execute(), and recache().

◆ recache()

QueryPage::recache	(		$limit,
			$ignoreErrors = true )

Clear the cache and save new results.

Parameters

int \| bool	$limit	Limit for SQL statement
bool	$ignoreErrors	Whether to ignore database errors

Exceptions

DBError|Exception

Returns: bool|int

Definition at line 304 of file QueryPage.php.

References $e, $fname, $res, $value, DB_MASTER, Wikimedia\Rdbms\IDatabase\delete(), SpecialPage\getName(), Wikimedia\Rdbms\IDatabase\insert(), isCacheable(), reallyDoQuery(), Wikimedia\Rdbms\IDatabase\timestamp(), usesTimestamps(), wfGetDB(), and wfTimestamp().

◆ setListoutput()

QueryPage::setListoutput ( $bool )

A mutator for $this->listoutput;.

Parameters

bool $bool

Definition at line 118 of file QueryPage.php.

Referenced by WantedPagesPage\execute().

◆ showEmptyText()

QueryPage::showEmptyText ( )

protected

Outputs some kind of an informative message (via OutputPage) to let the user know that the query returned nothing and thus there's nothing to show.

Since: 1.26

Definition at line 266 of file QueryPage.php.

References SpecialPage\getOutput().

Referenced by execute().

◆ sortDescending()

QueryPage::sortDescending ( )

Override to sort by increasing values.

Returns: bool

Reimplemented in WantedQueryPage, AncientPagesPage, BrokenRedirectsPage, DeadendPagesPage, DoubleRedirectsPage, FewestrevisionsPage, ListredirectsPage, LonelyPagesPage, LongPagesPage, MostlinkedCategoriesPage, MostlinkedTemplatesPage, MostrevisionsPage, SpecialPagesWithProp, ShortPagesPage, UncategorizedImagesPage, UncategorizedPagesPage, UnusedCategoriesPage, UnusedimagesPage, UnusedtemplatesPage, UnwatchedpagesPage, and WithoutInterwikiPage.

Definition at line 194 of file QueryPage.php.

Referenced by fetchFromCache(), and reallyDoQuery().

◆ tryLastResult()

QueryPage::tryLastResult ( )

Some special pages (for example SpecialListusers used to) might not return the current object formatted, but return the previous one instead.

Setting this to return true will ensure formatResult() is called one more time to make sure that the very last result is formatted as well.

Deprecated: since 1.27

Returns: bool

Definition at line 292 of file QueryPage.php.

Referenced by outputResults().

◆ usesTimestamps()

QueryPage::usesTimestamps ( )

Does this query return timestamps rather than integers in its 'value' field? If true, this class will convert 'value' to a UNIX timestamp for caching.

NOTE: formatRow() may get timestamps in TS_MW (mysql), TS_DB (pgsql) or TS_UNIX (querycache) format, so be sure to always run them through wfTimestamp()

Returns: bool

Since: 1.18

Reimplemented in AncientPagesPage, and UnusedimagesPage.

Definition at line 185 of file QueryPage.php.

Referenced by recache().

Member Data Documentation

◆ $cachedTimestamp

QueryPage::$cachedTimestamp = null

protected

Definition at line 51 of file QueryPage.php.

Referenced by getCachedTimestamp().

◆ $limit

int QueryPage::$limit = 0

protected

Definition at line 42 of file QueryPage.php.

Referenced by doFeed(), execute(), fetchFromCache(), getDBLimit(), getLimitOffset(), FileDuplicateSearchPage\prefixSearchSubpages(), SpecialPagesWithProp\prefixSearchSubpages(), SpecialPagesWithProp\queryExistingProps(), reallyDoQuery(), and ShortPagesPage\reallyDoQuery().

◆ $listoutput

bool QueryPage::$listoutput = false

protected

Whether or not we want plain listoutput rather than an ordered list.

Definition at line 36 of file QueryPage.php.

◆ $numRows

QueryPage::$numRows

protected

The number of rows returned by the query.

Reading this variable only makes sense in functions that are run after the query has been done, such as preprocessResults() and formatRow().

Definition at line 49 of file QueryPage.php.

Referenced by FileDuplicateSearchPage\execute().

◆ $offset

int QueryPage::$offset = 0

protected

The offset and limit in use, as passed to the query() function.

Definition at line 39 of file QueryPage.php.

Referenced by doQuery(), fetchFromCache(), getLimitOffset(), openList(), FileDuplicateSearchPage\prefixSearchSubpages(), SpecialPagesWithProp\prefixSearchSubpages(), SpecialPagesWithProp\queryExistingProps(), reallyDoQuery(), and ShortPagesPage\reallyDoQuery().

◆ $shownavigation

QueryPage::$shownavigation = true

protected

Whether to show prev/next links.

Definition at line 56 of file QueryPage.php.

The documentation for this class was generated from the following file:

includes/specialpage/QueryPage.php

Public Member Functions

Static Public Member Functions

Protected Member Functions

Protected Attributes

Additional Inherited Members

Detailed Description

Member Function Documentation

◆ closeList()

◆ doFeed()

◆ doQuery()

◆ execute()

◆ executeLBFromResultWrapper()

◆ feedDesc()

◆ feedItemAuthor()

◆ feedItemDesc()

◆ feedResult()

◆ feedTitle()

◆ feedUrl()

◆ fetchFromCache()

◆ formatResult()

◆ getCachedTimestamp()

◆ getCacheOrderFields()

◆ getDBLimit()

◆ getLimitOffset()

◆ getMaxResults()

◆ getOrderFields()

◆ getPageHeader()

◆ getPages()

◆ getQueryInfo()

◆ getRecacheDB()

◆ getSQL()

◆ isCacheable()

◆ isCached()

◆ isExpensive()

◆ isSyndicated()

◆ linkParameters()

◆ openList()

◆ outputResults()

◆ preprocessResults()

◆ reallyDoQuery()

◆ recache()

◆ setListoutput()

◆ showEmptyText()

◆ sortDescending()

◆ tryLastResult()

◆ usesTimestamps()

Member Data Documentation

◆ $cachedTimestamp

◆ $limit

◆ $listoutput

◆ $numRows

◆ $offset

◆ $shownavigation