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;