w/s
[lhc/web/wiklou.git] / includes / specials / SpecialWantedfiles.php
1 <?php
2 /**
3 * Implements Special:Wantedfiles
4 *
5 * Copyright © 2008 Soxred93
6 *
7 * This program is free software; you can redistribute it and/or modify
8 * it under the terms of the GNU General Public License as published by
9 * the Free Software Foundation; either version 2 of the License, or
10 * (at your option) any later version.
11 *
12 * This program is distributed in the hope that it will be useful,
13 * but WITHOUT ANY WARRANTY; without even the implied warranty of
14 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 * GNU General Public License for more details.
16 *
17 * You should have received a copy of the GNU General Public License along
18 * with this program; if not, write to the Free Software Foundation, Inc.,
19 * 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
20 * http://www.gnu.org/copyleft/gpl.html
21 *
22 * @file
23 * @ingroup SpecialPage
24 * @author Soxred93 <soxred93@gmail.com>
25 */
26
27 /**
28 * Querypage that lists the most wanted files
29 *
30 * @ingroup SpecialPage
31 */
32 class WantedFilesPage extends WantedQueryPage {
33
34 function __construct( $name = 'Wantedfiles' ) {
35 parent::__construct( $name );
36 }
37
38 /**
39 * KLUGE: The results may contain false positives for files
40 * that exist e.g. in a shared repo. Setting this at least
41 * keeps them from showing up as redlinks in the output, even
42 * if it doesn't fix the real problem (bug 6220).
43 */
44 function forceExistenceCheck() {
45 return true;
46 }
47
48 function getQueryInfo() {
49 return array (
50 'tables' => array ( 'imagelinks', 'image' ),
51 'fields' => array ( "'" . NS_FILE . "' AS namespace",
52 'il_to AS title',
53 'COUNT(*) AS value' ),
54 'conds' => array ( 'img_name IS NULL' ),
55 'options' => array ( 'GROUP BY' => 'il_to' ),
56 'join_conds' => array ( 'image' =>
57 array ( 'LEFT JOIN',
58 array ( 'il_to = img_name' )
59 )
60 )
61 );
62 }
63 }