includes/specials/SpecialUnusedimages.php

   1 <?php
   2 /**
   3  * @file
   4  * @ingroup SpecialPage
   5  */
   6
   7 /**
   8  * implements Special:Unusedimages
   9  * @ingroup SpecialPage
  10  */
  11 class UnusedimagesPage extends ImageQueryPage {
  12
  13         function isExpensive() { return true; }
  14
  15         function getName() {
  16                 return 'Unusedimages';
  17         }
  18
  19         function sortDescending() {
  20                 return false;
  21         }
  22         function isSyndicated() { return false; }
  23
  24         function getSQL() {
  25                 global $wgCountCategorizedImagesAsUsed, $wgDBtype;
  26                 $dbr = wfGetDB( DB_SLAVE );
  27
  28                 switch ($wgDBtype) {
  29                         case 'mysql':
  30                                 $epoch = 'UNIX_TIMESTAMP(img_timestamp)';
  31                                 break;
  32                         case 'oracle':
  33                                 $epoch = '((trunc(img_timestamp) - to_date(\'19700101\',\'YYYYMMDD\')) * 86400)';
  34                                 break;
  35                         case 'sqlite':
  36                                 $epoch = 'img_timestamp';
  37                                 break;
  38                         default:
  39                                 $epoch = 'EXTRACT(epoch FROM img_timestamp)';
  40                 }
  41
  42                 if ( $wgCountCategorizedImagesAsUsed ) {
  43                         list( $page, $image, $imagelinks, $categorylinks ) = $dbr->tableNamesN( 'page', 'image', 'imagelinks', 'categorylinks' );
  44
  45                         return "SELECT 'Unusedimages' as type, 6 as namespace, img_name as title, $epoch as value,
  46                                                 img_user, img_user_text,  img_description
  47                                         FROM ((($page AS I LEFT JOIN $categorylinks AS L ON I.page_id = L.cl_from)
  48                                                 LEFT JOIN $imagelinks AS P ON I.page_title = P.il_to)
  49                                                 INNER JOIN $image AS G ON I.page_title = G.img_name)
  50                                         WHERE I.page_namespace = ".NS_FILE." AND L.cl_from IS NULL AND P.il_to IS NULL";
  51                 } else {
  52                         list( $image, $imagelinks ) = $dbr->tableNamesN( 'image','imagelinks' );
  53
  54                         return "SELECT 'Unusedimages' as type, 6 as namespace, img_name as title, $epoch as value,
  55                                 img_user, img_user_text,  img_description
  56                                 FROM $image LEFT JOIN $imagelinks ON img_name=il_to WHERE il_to IS NULL ";
  57                 }
  58         }
  59
  60         function getPageHeader() {
  61                 return wfMsgExt( 'unusedimagestext', array( 'parse' ) );
  62         }
  63
  64 }
  65
  66 /**
  67  * Entry point
  68  */
  69 function wfSpecialUnusedimages() {
  70         list( $limit, $offset ) = wfCheckLimits();
  71         $uip = new UnusedimagesPage();
  72
  73         return $uip->doQuery( $offset, $limit );
  74 }