function getQueryInfo() { $tables = array('ar' => 'approved_revs_files', 'im' => 'image', 'p' => 'page'); $fields = array('im.img_name AS title', 'ar.approved_sha1 AS approved_sha1', 'ar.approved_timestamp AS approved_ts', 'im.img_sha1 AS latest_sha1', 'im.img_timestamp AS latest_ts'); $conds = array(); $join_conds = array('im' => array('LEFT OUTER JOIN', 'ar.file_title=im.img_name'), 'p' => array('LEFT OUTER JOIN', 'im.img_name=p.page_title')); # # ALLFILES: list all approved pages # also includes $this->mMode == 'invalid', see formatResult() # if ($this->mMode == 'allapproved') { $conds['p.page_namespace'] = NS_FILE; // get everything from approved_revs table # # UNAPPROVED # } elseif ($this->mMode == 'unapproved') { $tables['c'] = 'categorylinks'; $join_conds['c'] = array('LEFT OUTER JOIN', 'p.page_id=c.cl_from'); $join_conds['im'] = array('RIGHT OUTER JOIN', 'ar.file_title=im.img_name'); $perms = ApprovedRevs::getPermissions(); // if all files are not approvable then need to find files matching // page and category permissions if (!in_array(NS_FILE, array_keys($perms['Namespace Permissions']))) { list($ns, $cat, $pg) = ApprovedRevs::getApprovabilityStringsForDB(); $pageCatConditions = array(); if ($cat !== '') { $pageCatConditions[] = "c.cl_to IN ({$cat})"; } if ($pg !== '') { $pageCatConditions[] = "p.page_id IN ({$pg})"; } // if there were any page or category conditions, add to $conds if (count($pageCatConditions) > 0) { $conds[] = '(' . implode(' OR ', $pageCatConditions) . ')'; } } $conds['ar.file_title'] = null; $conds['p.page_namespace'] = NS_FILE; # # INVALID PERMISSIONS # } elseif ($this->mMode == 'invalid') { $tables['c'] = 'categorylinks'; $join_conds['c'] = array('LEFT OUTER JOIN', 'p.page_id=c.cl_from'); $join_conds['im'] = array('LEFT OUTER JOIN', 'ar.file_title=im.img_name'); $perms = ApprovedRevs::getPermissions(); if (in_array(NS_FILE, array_keys($perms['Namespace Permissions']))) { // if all files approvable should break out of this...since none can be // invalid if they're all approvable $conds[] = 'p.page_namespace=1 AND p.page_namespace=2'; // impossible condition, hack } else { list($ns, $cat, $pg) = ApprovedRevs::getApprovabilityStringsForDB(); if ($cat !== '') { $conds[] = "p.page_id NOT IN (SELECT DISTINCT cl_from FROM categorylinks WHERE cl_to IN ({$cat}))"; } if ($pg !== '') { $conds[] = "p.page_id NOT IN ({$pg})"; } } $conds['p.page_namespace'] = NS_FILE; # # NOTLATEST # } else { // Name/Title both exist, sha1's don't match OR timestamps don't match $conds['p.page_namespace'] = NS_FILE; $conds[] = "(ar.approved_sha1!=im.img_sha1 OR ar.approved_timestamp!=im.img_timestamp)"; } return array('tables' => $tables, 'fields' => $fields, 'join_conds' => $join_conds, 'conds' => $conds, 'options' => array('DISTINCT')); }
/** * (non-PHPdoc) * @see QueryPage::getSQL() */ function getQueryInfo() { $tables = array('ar' => 'approved_revs', 'p' => 'page', 'pp' => 'page_props'); $fields = array('p.page_id AS id', 'ar.rev_id AS rev_id', 'p.page_latest AS latest_id'); $join_conds = array('p' => array('JOIN', 'ar.page_id=p.page_id'), 'pp' => array('LEFT OUTER JOIN', 'ar.page_id=pp_page')); $bannedNSCheck = '(p.page_namespace NOT IN (' . implode(',', ApprovedRevs::$bannedNamespaceIds) . '))'; # # ALLPAGES: all approved pages # also includes $this->mMode == 'invalid', see formatResult() # if ($this->mMode == 'all') { $conds = $bannedNSCheck; // get everything from approved_revs table // keep default: $conds = "$namespacesString (pp_propname = 'approvedrevs' AND pp_value = 'y')"; # # UNAPPROVED # } elseif ($this->mMode == 'unapproved') { $tables['c'] = 'categorylinks'; $join_conds['p'] = array('RIGHT OUTER JOIN', 'ar.page_id=p.page_id'); // override $join_conds['c'] = array('LEFT OUTER JOIN', 'p.page_id=cl_from'); list($ns, $cat, $pg) = ApprovedRevs::getApprovabilityStringsForDB(); $conds = $ns === '' ? '' : "(p.page_namespace IN ({$ns})) OR "; $conds .= $cat === '' ? '' : "(c.cl_to IN ({$cat})) OR "; $conds .= $pg === '' ? '' : "(p.page_id IN ({$pg})) OR "; $conds .= "(pp_propname = 'approvedrevs' AND pp_value = 'y')"; $conds = "ar.page_id IS NULL AND ({$conds}) AND {$bannedNSCheck}"; # # INVALID PERMISSIONS # } else { if ($this->mMode == 'invalid') { $tables['c'] = 'categorylinks'; $join_conds['p'] = array('LEFT OUTER JOIN', 'ar.page_id=p.page_id'); // override $join_conds['c'] = array('LEFT OUTER JOIN', 'p.page_id=cl_from'); list($ns, $cat, $pg) = ApprovedRevs::getApprovabilityStringsForDB(); $conds = ""; $conds .= $ns === '' ? '' : "(p.page_namespace NOT IN ({$ns})) AND "; $conds .= $cat === '' ? '' : "(p.page_id NOT IN (SELECT DISTINCT cl_from FROM categorylinks WHERE cl_to IN ({$cat}))) AND "; $conds .= $pg === '' ? '' : "(p.page_id NOT IN ({$pg})) AND "; $conds .= "(pp_propname IS NULL OR NOT (pp_propname = 'approvedrevs' AND pp_value = 'y'))"; $options = array('DISTINCT' => true); # # NOTLATEST # } else { // gets pages in approved_revs table that // (a) are not the latest rev // (b) satisfy ApprovedRevs::$permissions // $tables['c'] = 'categorylinks'; // $join_conds['c'] = array( 'LEFT OUTER JOIN', 'p.page_id=cl_from' ); // $conds = "p.page_latest != ar.rev_id AND ($conds)"; $conds = "p.page_latest != ar.rev_id AND {$bannedNSCheck}"; // gets everything in the approved_revs table that is not latest rev } } $return = array('tables' => $tables, 'fields' => $fields, 'join_conds' => $join_conds, 'conds' => $conds, 'options' => array('DISTINCT')); return $return; }