X-Git-Url: http://git.heureux-cyclage.org/?a=blobdiff_plain;f=includes%2FSpecialLonelypages.php;h=326ae54dbf3747bf38b07f513b760f7e54235925;hb=741360fb3df2ad2b62f523ddced2eb75ee5b94ce;hp=0c026e22a848298131919a1e002577d5170e035f;hpb=ac549401d4ddaf655ec47cd1e66092fdc83ab30b;p=lhc%2Fweb%2Fwiklou.git diff --git a/includes/SpecialLonelypages.php b/includes/SpecialLonelypages.php index 0c026e22a8..326ae54dbf 100644 --- a/includes/SpecialLonelypages.php +++ b/includes/SpecialLonelypages.php @@ -1,32 +1,57 @@ tableNames( 'cur', 'links' ) ); + extract( $dbr->tableNames( 'page', 'pagelinks' ) ); + + return + "SELECT 'Lonelypages' AS type, + page_namespace AS namespace, + page_title AS title, + page_title AS value + FROM $page + LEFT JOIN $pagelinks + ON page_namespace=pl_namespace AND page_title=pl_title + WHERE pl_namespace IS NULL + AND page_namespace=".NS_MAIN." + AND page_is_redirect=0"; - return "SELECT 'Lonelypages' as type, cur_namespace AS namespace, cur_title AS title, cur_title AS value " . - "FROM $cur LEFT JOIN $links ON cur_id=l_to ". - "WHERE l_to IS NULL AND cur_namespace=0 AND cur_is_redirect=0"; } } +/** + * Constructor + */ function wfSpecialLonelypages() { list( $limit, $offset ) = wfCheckLimits(); - + $lpp = new LonelyPagesPage(); - + return $lpp->doQuery( $offset, $limit ); }