3 * Implements Special:PopularPages
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 most viewed pages
27 * @ingroup SpecialPage
29 class PopularPagesPage
extends QueryPage
{
32 return "Popularpages";
35 function isExpensive() {
36 # page_counter is not indexed
39 function isSyndicated() { return false; }
42 $dbr = wfGetDB( DB_SLAVE
);
43 $page = $dbr->tableName( 'page' );
46 "SELECT 'Popularpages' as type,
47 page_namespace as namespace,
52 "WHERE page_is_redirect=0 AND page_namespace";
54 global $wgContentNamespaces;
55 if( empty( $wgContentNamespaces ) ) {
56 $where .= '='.NS_MAIN
;
57 } else if( count( $wgContentNamespaces ) > 1 ) {
58 $where .= ' in (' . implode( ', ', $wgContentNamespaces ) . ')';
60 $where .= '='.$wgContentNamespaces[0];
63 return $query . $where;
66 function formatResult( $skin, $result ) {
67 global $wgLang, $wgContLang;
68 $title = Title
::makeTitle( $result->namespace, $result->title
);
69 $link = $skin->linkKnown(
71 htmlspecialchars( $wgContLang->convert( $title->getPrefixedText() ) )
75 array( 'parsemag', 'escape'),
76 $wgLang->formatNum( $result->value
)
78 return wfSpecialList($link, $nv);
85 function wfSpecialPopularpages() {
86 list( $limit, $offset ) = wfCheckLimits();
88 $ppp = new PopularPagesPage();
90 return $ppp->doQuery( $offset, $limit );