sortDescending() ? "DESC" : "") . " LIMIT {$offset}, {$limit}"; } # 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. function isExpensive( ) { global $wgDisableQueryPages; return $wgDisableQueryPages; } # 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. function formatResult( $skin, $result ) { return ""; } # This is the actual workhorse. It does everything needed to make a # real, honest-to-gosh query page. function doQuery( $offset, $limit ) { global $wgUser, $wgOut, $wgLang, $wgRequest; global $wgMiserMode; $sname = $this->getName(); $fname = get_class($this) . "::doQuery"; $sql = $this->getSQL( $offset, $limit ); $wgOut->setSyndicated( true ); if ( $this->isExpensive() ) { $type = wfStrencode( $sname ); $recache = $wgRequest->getBool( "recache" ); if( $recache ) { # Clear out any old cached data $res = wfQuery( "DELETE FROM querycache WHERE qc_type='$type'", DB_WRITE, $fname ); # Save results into the querycache table $maxstored = 1000; $res = wfQuery( "INSERT INTO querycache(qc_type,qc_namespace,qc_title,qc_value) " . $this->getSQL() . $this->getOrderLimit( 0, $maxstored ), DB_WRITE, $fname ); } if( $wgMiserMode || $recache ) { $sql = "SELECT qc_type as type, qc_namespace as namespace,qc_title as title, qc_value as value FROM querycache WHERE qc_type='$type'"; } if( $wgMiserMode ) { $wgOut->addWikiText( wfMsg( "perfcached" ) ); } } $res = wfQuery( $sql . $this->getOrderLimit( $offset, $limit ), DB_READ, $fname ); $num = wfNumRows($res); $sk = $wgUser->getSkin( ); $top = wfShowingResults( $offset, $num); $wgOut->addHTML( "
{$top}\n" );
# often disable 'next' link when we reach the end
if($num < $limit) { $atend = true; } else { $atend = false; }
$sl = wfViewPrevNext( $offset, $limit , $wgLang->specialPage( $sname ), "" ,$atend );
$wgOut->addHTML( "
{$sl}
{$sl}
\n" ); } # Similar to above, but packaging in a syndicated feed instead of a web page function doFeed( $class = "" ) { global $wgFeedClasses; global $wgOut, $wgLanguageCode, $wgLang; if( isset($wgFeedClasses[$class]) ) { $feed = new $wgFeedClasses[$class]( $this->feedTitle(), $this->feedDesc(), $this->feedUrl() ); $feed->outHeader(); $sql = $this->getSQL( 0, 50 ); $res = wfQuery( $sql, DB_READ, "QueryPage::doFeed" ); while( $obj = wfFetchObject( $res ) ) { $item = $this->feedResult( $obj ); if( $item ) $feed->outItem( $item ); } wfFreeResult( $res ); $feed->outFooter(); return true; } else { return false; } } # Override for custom handling. If the titles/links are ok, just do feedItemDesc() function feedResult( $row ) { if( !isset( $row->title ) ) { return NULL; } $title = Title::MakeTitle( IntVal( $row->namespace ), $row->title ); if( $title ) { if( isset( $row->timestamp ) ) { $date = $row->timestamp; } else { $date = ""; } $comments = ""; if( $title ) { $talkpage = $title->getTalkPage(); $comments = $talkpage->getFullURL(); } return new FeedItem( $title->getText(), $this->feedItemDesc( $row ), $title->getFullURL(), $date, $this->feedItemAuthor( $row ), $comments); } else { return NULL; } } function feedItemDesc( $row ) { $text = ""; if( isset( $row->comment ) ) { $text = htmlspecialchars( $row->comment ); } else { $text = ""; } if( isset( $row->text ) ) { $text = "" . htmlspecialchars( wfMsg( "summary" ) ) . ": " . $text . "
\n