dumpLinks.php

Go to the documentation of this file.

<?php
require_once __DIR__ . '/Maintenance.php';

class DumpLinks extends Maintenance {
    public function __construct() {
        parent::__construct();
        $this->addDescription( 'Quick demo hack to generate a plaintext link dump' );
    }

    public function execute() {
        $dbr = $this->getDB( DB_REPLICA );
        $result = $dbr->select( [ 'pagelinks', 'page' ],
            [
                'page_id',
                'page_namespace',
                'page_title',
                'pl_namespace',
                'pl_title' ],
            [ 'page_id=pl_from' ],
            __METHOD__,
            [ 'ORDER BY' => 'page_id' ] );

        $lastPage = null;
        foreach ( $result as $row ) {
            if ( $lastPage != $row->page_id ) {
                if ( $lastPage !== null ) {
                    $this->output( "\n" );
                }
                $page = Title::makeTitle( $row->page_namespace, $row->page_title );
                $this->output( $page->getPrefixedURL() );
                $lastPage = $row->page_id;
            }
            $link = Title::makeTitle( $row->pl_namespace, $row->pl_title );
            $this->output( " " . $link->getPrefixedURL() );
        }
        if ( $lastPage !== null ) {
            $this->output( "\n" );
        }
    }
}

$maintClass = "DumpLinks";
require_once RUN_MAINTENANCE_IF_MAIN;