case 'disable':
$sql = 'UPDATE ' . FILTER_RULE_TABLE . ' SET isactive=0 ' . ' WHERE filter_id=' . db_input($filter->getId()) . ' AND id IN (' . implode(',', db_input($_POST['ids'])) . ')';
if (db_query($sql) && ($num = db_affected_rows())) {
if ($num == $count) {
$msg = 'Selected emails ban status set to disabled';
} else {
$warn = "{$num} of {$count} selected emails ban status set to disabled";
}
} else {
$errors['err'] = 'Unable to disable selected emails';
}
break;
case 'delete':
$i = 0;
foreach ($_POST['ids'] as $k => $v) {
if (($r = FilterRule::lookup($v)) && $r->getFilterId() == $filter->getId() && $r->delete()) {
$i++;
}
}
if ($i && $i == $count) {
$msg = 'Selected emails deleted from banlist successfully';
} elseif ($i > 0) {
$warn = "{$i} of {$count} selected emails deleted from banlist";
} elseif (!$errors['err']) {
$errors['err'] = 'Unable to delete selected emails';
}
break;
default:
$errors['err'] = 'Unknown action - get technical help';
}
}
function getRuleById($id)
{
return FilterRule::lookup($id, $this->getId());
}
}
} elseif ($_POST['disable']) {
$sql = 'UPDATE ' . EMAIL_FILTER_RULE_TABLE . ' SET isactive=0 WHERE filter_id=' . db_input($filter->getId()) . ' AND id IN (' . implode(',', db_input($_POST['ids'])) . ')';
if (db_query($sql) && ($num = db_affected_rows())) {
if ($num == $count) {
$msg = 'Selected emails ban status set to disabled';
} else {
$warn = "{$num} of {$count} selected emails ban status set to disabled";
}
} else {
$errors['err'] = 'Unable to disable selected emails';
}
} elseif ($_POST['delete']) {
$i = 0;
foreach ($_POST['ids'] as $k => $v) {
if (($r = FilterRule::lookup($v)) && $r->delete()) {
$i++;
}
}
if ($i && $i == $count) {
$msg = 'Selected emailes deleted successfully';
} elseif ($i > 0) {
$warn = "{$i} of {$count} selected emails deleted";
} elseif (!$errors['err']) {
$errors['err'] = 'Unable to delete selected emails';
}
} else {
$errors['err'] = 'Unknown action';
}
}
break;
