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