public function DeleteByOccurenceIds($occurenceIds)
{
if (!empty($occurenceIds)) {
$sql = 'DELETE FROM ' . $this->GetTable() . ' WHERE occurrence_id IN (' . implode(',', $occurenceIds) . ')';
// execute query
parent::DeleteQuery($sql);
}
}
public function DeleteByPrefix($opt_prefix)
{
if (!empty($opt_prefix)) {
$sql = "DELETE FROM " . $this->GetTable() . " WHERE option_name LIKE '" . $opt_prefix . "%'";
// execute query
return parent::DeleteQuery($sql);
} else {
return false;
}
}
protected function GetTableOptions()
{
return parent::GetTableOptions() . ',' . PHP_EOL . ' KEY site_alert_created (site_id,alert_id,created_on)';
}
