listoutput; * * @param $bool Boolean */ function setListoutput( $bool ) { $this->listoutput = $bool; } /** * 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. * @return array * @since 1.18 */ function getQueryInfo() { return null; } /** * For back-compat, subclasses may return a raw SQL query here, as a string. * This is stronly deprecated; getQueryInfo() should be overridden instead. * @return string */ function getSQL() { /* Implement getQueryInfo() instead */ throw new MWException( "Bug in a QueryPage: doesn't implement getQueryInfo() nor getQuery() properly" ); } /** * 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. * @return array * @since 1.18 */ function getOrderFields() { return array( 'value' ); } /** * 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() * @return bool * @since 1.18 */ function usesTimestamps() { return false; } /** * Override to sort by increasing values * * @return Boolean */ function sortDescending() { return true; } /** * 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. * * @return Boolean */ function isExpensive() { global $wgDisableQueryPages; return $wgDisableQueryPages; } /** * 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. * @return Boolean * @since 1.18 */ public function isCacheable() { return true; } /** * Whether or not the output of the page in question is retrieved from * the database cache. * * @return Boolean */ function isCached() { global $wgMiserMode; return $this->isExpensive() && $wgMiserMode; } /** * Sometime we dont want to build rss / atom feeds. * * @return Boolean */ function isSyndicated() { return true; } /** * 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. * @param $skin Skin * @param $result object Result row * @return mixed String or false to skip * * @param $skin Skin object * @param $result Object: database row */ abstract function formatResult( $skin, $result ); /** * The content returned by this function will be output before any result * * @return String */ function getPageHeader() { return ''; } /** * 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). * * @return Array */ function linkParameters() { return array(); } /** * Some special pages (for example SpecialListusers) 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. */ function tryLastResult() { return false; } /** * Clear the cache and save new results * * @param $limit Integer: limit for SQL statement * @param $ignoreErrors Boolean: whether to ignore database errors */ function recache( $limit, $ignoreErrors = true ) { if ( !$this->isCacheable() ) { return 0; } $fname = get_class( $this ) . '::recache'; $dbw = wfGetDB( DB_MASTER ); $dbr = wfGetDB( DB_SLAVE, array( $this->getName(), __METHOD__, 'vslow' ) ); if ( !$dbw || !$dbr ) { return false; } if ( $ignoreErrors ) { $ignoreW = $dbw->ignoreErrors( true ); $ignoreR = $dbr->ignoreErrors( true ); } # Clear out any old cached data $dbw->delete( 'querycache', array( 'qc_type' => $this->getName() ), $fname ); # Do query $res = $this->reallyDoQuery( $limit, false ); $num = false; if ( $res ) { $num = $dbr->numRows( $res ); # Fetch results $vals = array(); while ( $res && $row = $dbr->fetchObject( $res ) ) { if ( isset( $row->value ) ) { if ( $this->usesTimestamps() ) { $value = wfTimestamp( TS_UNIX, $row->value ); } else { $value = intval( $row->value ); // @bug 14414 } } else { $value = 0; } $vals[] = array( 'qc_type' => $this->getName(), 'qc_namespace' => $row->namespace, 'qc_title' => $row->title, 'qc_value' => $value ); } # Save results into the querycache table on the master if ( count( $vals ) ) { if ( !$dbw->insert( 'querycache', $vals, __METHOD__ ) ) { // Set result to false to indicate error $num = false; } } if ( $ignoreErrors ) { $dbw->ignoreErrors( $ignoreW ); $dbr->ignoreErrors( $ignoreR ); } # Update the querycache_info record for the page $dbw->delete( 'querycache_info', array( 'qci_type' => $this->getName() ), $fname ); $dbw->insert( 'querycache_info', array( 'qci_type' => $this->getName(), 'qci_timestamp' => $dbw->timestamp() ), $fname ); } return $num; } /** * Run the query and return the result * @param $limit mixed Numerical limit or false for no limit * @param $offset mixed Numerical offset or false for no offset * @return ResultWrapper * @since 1.18 */ function reallyDoQuery( $limit, $offset = false ) { $fname = get_class( $this ) . "::reallyDoQuery"; $dbr = wfGetDB( DB_SLAVE ); $query = $this->getQueryInfo(); $order = $this->getOrderFields(); if ( $this->sortDescending() ) { foreach ( $order as &$field ) { $field .= ' DESC'; } } if ( is_array( $query ) ) { $tables = isset( $query['tables'] ) ? (array)$query['tables'] : array(); $fields = isset( $query['fields'] ) ? (array)$query['fields'] : array(); $conds = isset( $query['conds'] ) ? (array)$query['conds'] : array(); $options = isset( $query['options'] ) ? (array)$query['options'] : array(); $join_conds = isset( $query['join_conds'] ) ? (array)$query['join_conds'] : array(); if ( count( $order ) ) { $options['ORDER BY'] = implode( ', ', $order ); } if ( $limit !== false ) { $options['LIMIT'] = intval( $limit ); } if ( $offset !== false ) { $options['OFFSET'] = intval( $offset ); } $res = $dbr->select( $tables, $fields, $conds, $fname, $options, $join_conds ); } else { // Old-fashioned raw SQL style, deprecated $sql = $this->getSQL(); $sql .= ' ORDER BY ' . implode( ', ', $order ); $sql = $dbr->limitResult( $sql, $limit, $offset ); $res = $dbr->query( $sql, $fname ); } return $dbr->resultObject( $res ); } /** * Somewhat deprecated, you probably want to be using execute() */ function doQuery( $offset = false, $limit = false ) { if ( $this->isCached() && $this->isCacheable() ) { return $this->fetchFromCache( $limit, $offset ); } else { return $this->reallyDoQuery( $limit, $offset ); } } /** * Fetch the query results from the query cache * @param $limit mixed Numerical limit or false for no limit * @param $offset mixed Numerical offset or false for no offset * @return ResultWrapper * @since 1.18 */ function fetchFromCache( $limit, $offset = false ) { $dbr = wfGetDB( DB_SLAVE ); $options = array (); if ( $limit !== false ) { $options['LIMIT'] = intval( $limit ); } if ( $offset !== false ) { $options['OFFSET'] = intval( $offset ); } if ( $this->sortDescending() ) { $options['ORDER BY'] = 'qc_value DESC'; } else { $options['ORDER BY'] = 'qc_value ASC'; } $res = $dbr->select( 'querycache', array( 'qc_type', 'qc_namespace AS namespace', 'qc_title AS title', 'qc_value AS value' ), array( 'qc_type' => $this->getName() ), __METHOD__, $options ); return $dbr->resultObject( $res ); } public function getCachedTimestamp() { if ( is_null( $this->cachedTimestamp ) ) { $dbr = wfGetDB( DB_SLAVE ); $fname = get_class( $this ) . '::getCachedTimestamp'; $this->cachedTimestamp = $dbr->selectField( 'querycache_info', 'qci_timestamp', array( 'qci_type' => $this->getName() ), $fname ); } return $this->cachedTimestamp; } /** * This is the actual workhorse. It does everything needed to make a * real, honest-to-gosh query page. */ function execute( $par ) { global $wgUser, $wgOut, $wgLang, $wgRequest; if ( !$this->userCanExecute( $wgUser ) ) { $this->displayRestrictionError(); return; } if ( $this->limit == 0 && $this->offset == 0 ) { list( $this->limit, $this->offset ) = $wgRequest->getLimitOffset(); } $dbr = wfGetDB( DB_SLAVE ); $this->setHeaders(); $wgOut->setSyndicated( $this->isSyndicated() ); if ( $this->isCached() && !$this->isCacheable() ) { $wgOut->setSyndicated( false ); $wgOut->addWikiMsg( 'querypage-disabled' ); return 0; } // TODO: Use doQuery() // $res = null; if ( !$this->isCached() ) { $res = $this->reallyDoQuery( $this->limit, $this->offset ); } else { # Get the cached result $res = $this->fetchFromCache( $this->limit, $this->offset ); if ( !$this->listoutput ) { # Fetch the timestamp of this update $ts = $this->getCachedTimestamp(); if ( $ts ) { $updated = $wgLang->timeanddate( $ts, true, true ); $updateddate = $wgLang->date( $ts, true, true ); $updatedtime = $wgLang->time( $ts, true, true ); $wgOut->addMeta( 'Data-Cache-Time', $ts ); $wgOut->addInlineScript( "var dataCacheTime = '$ts';" ); $wgOut->addWikiMsg( 'perfcachedts', $updated, $updateddate, $updatedtime ); } else { $wgOut->addWikiMsg( 'perfcached' ); } # If updates on this page have been disabled, let the user know # that the data set won't be refreshed for now global $wgDisableQueryPageUpdate; if ( is_array( $wgDisableQueryPageUpdate ) && in_array( $this->getName(), $wgDisableQueryPageUpdate ) ) { $wgOut->addWikiMsg( 'querypage-no-updates' ); } } } $this->numRows = $dbr->numRows( $res ); $this->preprocessResults( $dbr, $res ); $wgOut->addHTML( Xml::openElement( 'div', array( 'class' => 'mw-spcontent' ) ) ); # Top header and navigation if ( $this->shownavigation ) { $wgOut->addHTML( $this->getPageHeader() ); if ( $this->numRows > 0 ) { $wgOut->addHTML( '
' . wfShowingResults( $this->offset, $this->numRows ) . '
' ); # Disable the "next" link when we reach the end $paging = wfViewPrevNext( $this->offset, $this->limit, $this->getTitle( $par ), wfArrayToCGI( $this->linkParameters() ), ( $this->numRows < $this->limit ) ); $wgOut->addHTML( '' . $paging . '
' ); } else { # No results to show, so don't bother with "showing X of Y" etc. # -- just let the user know and give up now $wgOut->addHTML( '' . wfMsgHtml( 'specialpage-empty' ) . '
' ); $wgOut->addHTML( Xml::closeElement( 'div' ) ); return; } } # The actual results; specialist subclasses will want to handle this # with more than a straight list, so we hand them the info, plus # an OutputPage, and let them get on with it $this->outputResults( $wgOut, $this->getSkin(), $dbr, # Should use a ResultWrapper for this $res, $this->numRows, $this->offset ); # Repeat the paging links at the bottom if ( $this->shownavigation ) { $wgOut->addHTML( '' . $paging . '
' ); } $wgOut->addHTML( Xml::closeElement( 'div' ) ); return $this->numRows; } /** * Format and output report results using the given information plus * OutputPage * * @param $out OutputPage to print to * @param $skin Skin: user skin to use * @param $dbr Database (read) connection to use * @param $res Integer: result pointer * @param $num Integer: number of available result rows * @param $offset Integer: paging offset */ protected function outputResults( $out, $skin, $dbr, $res, $num, $offset ) { global $wgContLang; if ( $num > 0 ) { $html = array(); if ( !$this->listoutput ) { $html[] = $this->openList( $offset ); } # $res might contain the whole 1,000 rows, so we read up to # $num [should update this to use a Pager] for ( $i = 0; $i < $num && $row = $dbr->fetchObject( $res ); $i++ ) { $line = $this->formatResult( $skin, $row ); if ( $line ) { $attr = ( isset( $row->usepatrol ) && $row->usepatrol && $row->patrolled == 0 ) ? ' class="not-patrolled"' : ''; $html[] = $this->listoutput ? $line : "