X-Git-Url: https://git.heureux-cyclage.org/?a=blobdiff_plain;f=includes%2FSpecialDeadendpages.php;h=0d94161b67b60b7c1409a96799798a7af3b408d5;hb=b76908589ab7134d3c95c33575ec721dcad89fd0;hp=34105db619dc1480d93ca67aa39c053b25851836;hpb=59c6e92429c1c42c6e06d60e85766901810b338e;p=lhc%2Fweb%2Fwiklou.git diff --git a/includes/SpecialDeadendpages.php b/includes/SpecialDeadendpages.php index 34105db619..0d94161b67 100644 --- a/includes/SpecialDeadendpages.php +++ b/includes/SpecialDeadendpages.php @@ -1,36 +1,65 @@ tableNamesN( 'page', 'pagelinks' ); + return "SELECT 'Deadendpages' as type, page_namespace AS namespace, page_title as title, page_title AS value " . + "FROM $page LEFT JOIN $pagelinks ON page_id = pl_from " . + "WHERE pl_from IS NULL " . + "AND page_namespace = 0 " . + "AND page_is_redirect = 0"; + } } +/** + * Constructor + */ function wfSpecialDeadendpages() { - - list( $limit, $offset ) = wfCheckLimits(); - $depp = new DeadendPagesPage(); - - return $depp->doQuery( $offset, $limit ); + list( $limit, $offset ) = wfCheckLimits(); + + $depp = new DeadendPagesPage(); + + return $depp->doQuery( $offset, $limit ); } -?> +