4 * This program is free software; you can redistribute it and/or modify
5 * it under the terms of the GNU General Public License as published by
6 * the Free Software Foundation; either version 2 of the License, or
7 * (at your option) any later version.
9 * This program is distributed in the hope that it will be useful,
10 * but WITHOUT ANY WARRANTY; without even the implied warranty of
11 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 * GNU General Public License for more details.
14 * You should have received a copy of the GNU General Public License along
15 * with this program; if not, write to the Free Software Foundation, Inc.,
16 * 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
17 * http://www.gnu.org/copyleft/gpl.html
22 * @ingroup SpecialPage
24 class DeadendPagesPage
extends PageQueryPage
{
27 return "Deadendpages";
30 function getPageHeader() {
31 return wfMsgExt( 'deadendpagestext', array( 'parse' ) );
35 * LEFT JOIN is expensive
39 function isExpensive( ) {
43 function isSyndicated() { return false; }
48 function sortDescending() {
53 * @return string an sqlquery
56 $dbr = wfGetDB( DB_SLAVE
);
57 list( $page, $pagelinks ) = $dbr->tableNamesN( 'page', 'pagelinks' );
58 return "SELECT 'Deadendpages' as type, page_namespace AS namespace, page_title as title, page_title AS value " .
59 "FROM $page LEFT JOIN $pagelinks ON page_id = pl_from " .
60 "WHERE pl_from IS NULL " .
61 "AND page_namespace = 0 " .
62 "AND page_is_redirect = 0";
69 function wfSpecialDeadendpages() {
71 list( $limit, $offset ) = wfCheckLimits();
73 $depp = new DeadendPagesPage();
75 return $depp->doQuery( $offset, $limit );