class WithoutInterwikiPage extends PageQueryPage {
private $prefix = '';
- function getName() {
- return 'Withoutinterwiki';
+ function __construct( $name = 'Withoutinterwiki' ) {
+ parent::__construct( $name );
+ }
+
+ function execute( $par ) {
+ global $wgRequest;
+ $this->prefix = Title::capitalize( $wgRequest->getVal( 'prefix', $par ), NS_MAIN );
+ parent::execute( $par );
}
function getPageHeader() {
function sortDescending() {
return false;
}
+
+ function getOrderFields() {
+ return array( 'page_namespace', 'page_title' );
+ }
function isExpensive() {
return true;
return false;
}
- function getSQL() {
- $dbr = wfGetDB( DB_SLAVE );
- list( $page, $langlinks ) = $dbr->tableNamesN( 'page', 'langlinks' );
- $prefix = $this->prefix ? 'AND page_title' . $dbr->buildLike( $this->prefix , $dbr->anyString() ) : '';
- return
- "SELECT 'Withoutinterwiki' AS type,
- page_namespace AS namespace,
- page_title AS title,
- page_title AS value
- FROM $page
- LEFT JOIN $langlinks
- ON ll_from = page_id
- WHERE ll_title IS NULL
- AND page_namespace=" . NS_MAIN . "
- AND page_is_redirect = 0
- {$prefix}";
- }
-
- function setPrefix( $prefix = '' ) {
- $this->prefix = $prefix;
+ function getQueryInfo() {
+ $query = array (
+ 'tables' => array ( 'page', 'langlinks' ),
+ 'fields' => array ( 'page_namespace AS namespace',
+ 'page_title AS title',
+ 'page_title AS value' ),
+ 'conds' => array ( 'll_title IS NULL',
+ 'page_namespace' => NS_MAIN,
+ 'page_is_redirect' => 0 ),
+ 'join_conds' => array ( 'langlinks' => array (
+ 'LEFT JOIN', 'll_from = page_id' ) )
+ );
+ if ( $this->prefix ) {
+ $dbr = wfGetDb( DB_SLAVE );
+ $query['conds'][] = 'page_title ' . $dbr->buildLike( $this->prefix, $dbr->anyString() );
+ }
+ return $query;
}
-
-}
-
-function wfSpecialWithoutinterwiki() {
- global $wgRequest;
- list( $limit, $offset ) = wfCheckLimits();
- // Only searching the mainspace anyway
- $prefix = Title::capitalize( $wgRequest->getVal( 'prefix' ), NS_MAIN );
- $wip = new WithoutInterwikiPage();
- $wip->setPrefix( $prefix );
- $wip->doQuery( $offset, $limit );
}