3 * Implements Special:Deadenpages
5 * This program is free software; you can redistribute it and/or modify
6 * it under the terms of the GNU General Public License as published by
7 * the Free Software Foundation; either version 2 of the License, or
8 * (at your option) any later version.
10 * This program is distributed in the hope that it will be useful,
11 * but WITHOUT ANY WARRANTY; without even the implied warranty of
12 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13 * GNU General Public License for more details.
15 * You should have received a copy of the GNU General Public License along
16 * with this program; if not, write to the Free Software Foundation, Inc.,
17 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
18 * http://www.gnu.org/copyleft/gpl.html
21 * @ingroup SpecialPage
25 * A special page that list pages that contain no link to other pages
27 * @ingroup SpecialPage
29 class DeadendPagesPage
extends PageQueryPage
{
32 return "Deadendpages";
35 function getPageHeader() {
36 return wfMsgExt( 'deadendpagestext', array( 'parse' ) );
40 * LEFT JOIN is expensive
44 function isExpensive( ) {
48 function isSyndicated() { return false; }
53 function sortDescending() {
58 * @return string an sqlquery
61 $dbr = wfGetDB( DB_SLAVE
);
62 list( $page, $pagelinks ) = $dbr->tableNamesN( 'page', 'pagelinks' );
63 return "SELECT 'Deadendpages' as type, page_namespace AS namespace, page_title as title, page_title AS value " .
64 "FROM $page LEFT JOIN $pagelinks ON page_id = pl_from " .
65 "WHERE pl_from IS NULL " .
66 "AND page_namespace = 0 " .
67 "AND page_is_redirect = 0";
74 function wfSpecialDeadendpages() {
76 list( $limit, $offset ) = wfCheckLimits();
78 $depp = new DeadendPagesPage();
80 return $depp->doQuery( $offset, $limit );