Wikia code/includes/specials/SpecialUnusedimages.php
 | This page is obsolete. It is being retained for archival purposes. It may document extensions or features that are obsolete and/or no longer supported. Do not rely on the information here being up-to-date. The information shown below refers to the now unmaintained 1.16 MediaWiki release. The current stable release number is 1.43.0. |
--- D:\Programming\SVN\mediawiki\branches\REL1_16\phase3\includes\specials\SpecialUnusedimages.php 2011-07-18 22:31:17.766601600 +0100
+++ D:\Programming\SVN\wikia\trunk\includes\specials\SpecialUnusedimages.php 2011-08-17 15:28:16.416015600 +0100
@@ -47,13 +47,13 @@
FROM ((($page AS I LEFT JOIN $categorylinks AS L ON I.page_id = L.cl_from)
LEFT JOIN $imagelinks AS P ON I.page_title = P.il_to)
INNER JOIN $image AS G ON I.page_title = G.img_name)
- WHERE I.page_namespace = ".NS_FILE." AND L.cl_from IS NULL AND P.il_to IS NULL";
+ WHERE I.page_namespace = ".NS_FILE." AND L.cl_from IS NULL AND P.il_to IS NULL AND img_media_type != 'VIDEO'";
} else {
list( $image, $imagelinks ) = $dbr->tableNamesN( 'image','imagelinks' );
return "SELECT 'Unusedimages' as type, 6 as namespace, img_name as title, $epoch as value,
img_user, img_user_text, img_description
- FROM $image LEFT JOIN $imagelinks ON img_name=il_to WHERE il_to IS NULL ";
+ FROM $image LEFT JOIN $imagelinks ON img_name=il_to WHERE il_to IS NULL AND img_media_type != 'VIDEO'";
}
}