public function execute()
{
global $wgUser;
if (!$wgUser->isAllowed('abusefilter-log')) {
$this->dieUsage('You don\'t have permission to view the abuse log', 'permissiondenied');
}
$params = $this->extractRequestParams();
$prop = array_flip($params['prop']);
$fld_ids = isset($prop['ids']);
$fld_filter = isset($prop['filter']);
$fld_user = isset($prop['user']);
$fld_ip = isset($prop['ip']);
$fld_title = isset($prop['title']);
$fld_action = isset($prop['action']);
$fld_details = isset($prop['details']);
$fld_result = isset($prop['result']);
$fld_timestamp = isset($prop['timestamp']);
$fld_hidden = isset($prop['hidden']);
if ($fld_ip && !$wgUser->isAllowed('abusefilter-private')) {
$this->dieUsage('You don\'t have permission to view IP addresses', 'permissiondenied');
}
if ($fld_details && !$wgUser->isAllowed('abusefilter-log-detail')) {
$this->dieUsage('You don\'t have permission to view detailed abuse log entries', 'permissiondenied');
}
$result = $this->getResult();
$this->addTables('abuse_filter_log');
$this->addFields('afl_timestamp');
$this->addFieldsIf(array('afl_id', 'afl_filter'), $fld_ids);
$this->addFieldsIf('afl_user_text', $fld_user);
$this->addFieldsIf('afl_ip', $fld_ip);
$this->addFieldsIf(array('afl_namespace', 'afl_title'), $fld_title);
$this->addFieldsIf('afl_action', $fld_action);
$this->addFieldsIf('afl_var_dump', $fld_details);
$this->addFieldsIf('afl_actions', $fld_result);
$this->addFieldsIf('afl_deleted', $fld_hidden);
if ($fld_filter) {
$this->addTables('abuse_filter');
$this->addFields('af_public_comments');
$this->addJoinConds(array('abuse_filter' => array('LEFT JOIN', 'af_id=afl_filter')));
}
$this->addOption('LIMIT', $params['limit'] + 1);
$this->addWhereRange('afl_timestamp', $params['dir'], $params['start'], $params['end']);
$db = $this->getDB();
$notDeletedCond = SpecialAbuseLog::getNotDeletedCond($db);
$this->addWhereIf(array('afl_user_text' => $params['user']), isset($params['user']));
$this->addWhereIf(array('afl_filter' => $params['filter']), isset($params['filter']));
$this->addWhereIf($notDeletedCond, !SpecialAbuseLog::canSeeHidden());
$title = $params['title'];
if (!is_null($title)) {
$titleObj = Title::newFromText($title);
if (is_null($titleObj)) {
$this->dieUsageMsg(array('invalidtitle', $title));
}
$this->addWhereFld('afl_namespace', $titleObj->getNamespace());
$this->addWhereFld('afl_title', $titleObj->getDBkey());
}
$res = $this->select(__METHOD__);
$count = 0;
foreach ($res as $row) {
if (++$count > $params['limit']) {
// We've had enough
$this->setContinueEnumParameter('start', wfTimestamp(TS_ISO_8601, $row->afl_timestamp));
break;
}
$entry = array();
if ($fld_ids) {
$entry['id'] = intval($row->afl_id);
$entry['filter_id'] = intval($row->afl_filter);
}
if ($fld_filter) {
$entry['filter'] = $row->af_public_comments;
}
if ($fld_user) {
$entry['user'] = $row->afl_user_text;
}
if ($fld_ip) {
$entry['ip'] = $row->afl_ip;
}
if ($fld_title) {
$title = Title::makeTitle($row->afl_namespace, $row->afl_title);
ApiQueryBase::addTitleInfo($entry, $title);
}
if ($fld_action) {
$entry['action'] = $row->afl_action;
}
if ($fld_result) {
$entry['result'] = $row->afl_actions;
}
if ($fld_timestamp) {
$entry['timestamp'] = wfTimestamp(TS_ISO_8601, $row->afl_timestamp);
}
if ($fld_details) {
$vars = AbuseFilter::loadVarDump($row->afl_var_dump);
if ($vars instanceof AbuseFilterVariableHolder) {
$entry['details'] = $vars->exportAllVars();
} else {
$entry['details'] = array_change_key_case($vars, CASE_LOWER);
}
}
if ($fld_hidden) {
$entry['hidden'] = $row->afl_deleted;
}
if ($entry) {
$fit = $result->addValue(array('query', $this->getModuleName()), null, $entry);
if (!$fit) {
$this->setContinueEnumParameter('start', wfTimestamp(TS_ISO_8601, $row->afl_timestamp));
break;
}
}
}
$result->setIndexedTagName_internal(array('query', $this->getModuleName()), 'item');
}
public function execute()
{
$user = $this->getUser();
$errors = $this->getTitle()->getUserPermissionsErrors('abusefilter-log', $user);
if (count($errors)) {
$this->dieUsageMsg($errors[0]);
return;
}
$params = $this->extractRequestParams();
$prop = array_flip($params['prop']);
$fld_ids = isset($prop['ids']);
$fld_filter = isset($prop['filter']);
$fld_user = isset($prop['user']);
$fld_ip = isset($prop['ip']);
$fld_title = isset($prop['title']);
$fld_action = isset($prop['action']);
$fld_details = isset($prop['details']);
$fld_result = isset($prop['result']);
$fld_timestamp = isset($prop['timestamp']);
$fld_hidden = isset($prop['hidden']);
$fld_revid = isset($prop['revid']);
if ($fld_ip && !$user->isAllowed('abusefilter-private')) {
$this->dieUsage('You don\'t have permission to view IP addresses', 'permissiondenied');
}
if ($fld_details && !$user->isAllowed('abusefilter-log-detail')) {
$this->dieUsage('You don\'t have permission to view detailed abuse log entries', 'permissiondenied');
}
// Match permissions for viewing events on private filters to SpecialAbuseLog (bug 42814)
if ($params['filter'] && !(AbuseFilterView::canViewPrivate() || $user->isAllowed('abusefilter-log-private'))) {
// A specific filter parameter is set but the user isn't allowed to view all filters
if (!is_array($params['filter'])) {
$params['filter'] = array($params['filter']);
}
foreach ($params['filter'] as $filter) {
if (AbuseFilter::filterHidden($filter)) {
$this->dieUsage('You don\'t have permission to view log entries for private filters', 'permissiondenied');
}
}
}
$result = $this->getResult();
$this->addTables('abuse_filter_log');
$this->addFields('afl_timestamp');
$this->addFields('afl_rev_id');
$this->addFields('afl_deleted');
$this->addFields('afl_filter');
$this->addFieldsIf('afl_id', $fld_ids);
$this->addFieldsIf('afl_user_text', $fld_user);
$this->addFieldsIf('afl_ip', $fld_ip);
$this->addFieldsIf(array('afl_namespace', 'afl_title'), $fld_title);
$this->addFieldsIf('afl_action', $fld_action);
$this->addFieldsIf('afl_var_dump', $fld_details);
$this->addFieldsIf('afl_actions', $fld_result);
if ($fld_filter) {
$this->addTables('abuse_filter');
$this->addFields('af_public_comments');
$this->addJoinConds(array('abuse_filter' => array('LEFT JOIN', 'af_id=afl_filter')));
}
$this->addOption('LIMIT', $params['limit'] + 1);
$this->addWhereRange('afl_timestamp', $params['dir'], $params['start'], $params['end']);
$db = $this->getDB();
$notDeletedCond = SpecialAbuseLog::getNotDeletedCond($db);
if (isset($params['user'])) {
$u = User::newFromName($params['user']);
if ($u) {
// Username normalisation
$params['user'] = $u->getName();
$userId = $u->getId();
} elseif (IP::isIPAddress($params['user'])) {
// It's an IP, sanitize it
$params['user'] = IP::sanitizeIP($params['user']);
$userId = 0;
}
if (isset($userId)) {
// Only add the WHERE for user in case it's either a valid user (but not necessary an existing one) or an IP
$this->addWhere(array('afl_user' => $userId, 'afl_user_text' => $params['user']));
}
}
$this->addWhereIf(array('afl_filter' => $params['filter']), isset($params['filter']));
$this->addWhereIf($notDeletedCond, !SpecialAbuseLog::canSeeHidden($user));
$title = $params['title'];
if (!is_null($title)) {
$titleObj = Title::newFromText($title);
if (is_null($titleObj)) {
$this->dieUsageMsg(array('invalidtitle', $title));
}
$this->addWhereFld('afl_namespace', $titleObj->getNamespace());
$this->addWhereFld('afl_title', $titleObj->getDBkey());
}
$res = $this->select(__METHOD__);
$count = 0;
foreach ($res as $row) {
if (++$count > $params['limit']) {
// We've had enough
$ts = new MWTimestamp($row->afl_timestamp);
$this->setContinueEnumParameter('start', $ts->getTimestamp(TS_ISO_8601));
break;
}
if (SpecialAbuseLog::isHidden($row) && !SpecialAbuseLog::canSeeHidden($user)) {
continue;
}
$canSeeDetails = SpecialAbuseLog::canSeeDetails($row->afl_filter);
$entry = array();
if ($fld_ids) {
$entry['id'] = intval($row->afl_id);
$entry['filter_id'] = '';
if ($canSeeDetails) {
$entry['filter_id'] = $row->afl_filter;
}
}
if ($fld_filter) {
$entry['filter'] = $row->af_public_comments;
}
if ($fld_user) {
$entry['user'] = $row->afl_user_text;
}
if ($fld_ip) {
$entry['ip'] = $row->afl_ip;
}
if ($fld_title) {
$title = Title::makeTitle($row->afl_namespace, $row->afl_title);
ApiQueryBase::addTitleInfo($entry, $title);
}
if ($fld_action) {
$entry['action'] = $row->afl_action;
}
if ($fld_result) {
$entry['result'] = $row->afl_actions;
}
if ($fld_revid && !is_null($row->afl_rev_id)) {
$entry['revid'] = '';
if ($canSeeDetails) {
$entry['revid'] = $row->afl_rev_id;
}
}
if ($fld_timestamp) {
$ts = new MWTimestamp($row->afl_timestamp);
$entry['timestamp'] = $ts->getTimestamp(TS_ISO_8601);
}
if ($fld_details) {
$entry['details'] = array();
if ($canSeeDetails) {
$vars = AbuseFilter::loadVarDump($row->afl_var_dump);
if ($vars instanceof AbuseFilterVariableHolder) {
$entry['details'] = $vars->exportAllVars();
} else {
$entry['details'] = array_change_key_case($vars, CASE_LOWER);
}
}
}
if ($fld_hidden) {
$val = SpecialAbuseLog::isHidden($row);
if ($val) {
$entry['hidden'] = $val;
}
}
if ($entry) {
$fit = $result->addValue(array('query', $this->getModuleName()), null, $entry);
if (!$fit) {
$ts = new MWTimestamp($row->afl_timestamp);
$this->setContinueEnumParameter('start', $ts->getTimestamp(TS_ISO_8601));
break;
}
}
}
$result->setIndexedTagName_internal(array('query', $this->getModuleName()), 'item');
}
function getQueryInfo()
{
$conds = $this->mConds;
$info = array('tables' => array('abuse_filter_log', 'abuse_filter'), 'fields' => '*', 'conds' => $conds, 'join_conds' => array('abuse_filter' => array('LEFT JOIN', 'af_id=afl_filter')));
if (!$this->mForm->canSeeHidden()) {
$db = $this->mDb;
$info['conds'][] = SpecialAbuseLog::getNotDeletedCond($db);
}
return $info;
}