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;
}
