public function getQueryInfo() { global $wgExcludedWantedFiles; $queryInfo = parent::getQueryInfo(); if (!empty($wgExcludedWantedFiles) && is_array($wgExcludedWantedFiles)) { $dbr = wfGetDB(DB_SLAVE); $queryInfo['conds'][] = "il_to not in (" . $dbr->makeList($wgExcludedWantedFiles) . ") "; } return $queryInfo; }
/** * Returns additional query conditions to use when constructing the wanted files SQL. In this case we * are adding: * - the ability to filter out specific files by file name. * - a filter to remove premium video results which do not have image table entries * * @return array */ public function getQueryInfo() { global $wgExcludedWantedFiles; $queryInfo = parent::getQueryInfo(); if (!empty($wgExcludedWantedFiles) && is_array($wgExcludedWantedFiles)) { $dbr = wfGetDB(DB_SLAVE); $queryInfo['conds'][] = "il_to not in (" . $dbr->makeList($wgExcludedWantedFiles) . ") "; } // Ignore any missing images that are actually premium video. Premium video comes from the // video.wikia.com wiki and will not have local image table entries $queryInfo['tables'][] = 'video_info'; $queryInfo['join_conds']['video_info'] = array('LEFT JOIN', array("il_to = video_title", "premium = 1")); $queryInfo['conds'][] = 'video_title IS NULL'; return $queryInfo; }