/**
* {@inheritDoc}
*/
public function dissociate($user_id)
{
try {
$this->querier->delete(DB_TABLE_AUTHENTICATION_METHOD, 'WHERE user_id=:user_id AND method=:method', array('user_id' => $user_id, 'method' => self::AUTHENTICATION_METHOD));
} catch (SQLQuerierException $ex) {
throw new IllegalArgumentException('User Id ' . $user_id . ' is already dissociated with an authentication method [' . $ex->getMessage() . ']');
}
}
/**
* @desc Delete a Menu from the database
* @param mixed $menu The (Menu) Menu or its (int) id to delete from the database
*/
public static function delete($menu)
{
if (!is_object($menu)) {
$menu = self::load($menu);
}
self::disable($menu);
self::$querier->delete(DB_TABLE_MENUS, 'WHERE id=:id', array('id' => $menu->get_id()));
}
private function delete_phpboostcaptcha()
{
$module_id = 'PHPBoostCaptcha';
self::$db_querier->delete(DB_TABLE_CONFIGS, "WHERE name = :name", array('name' => $module_id));
ModulesConfig::load()->remove_module_by_id($module_id);
ModulesConfig::save();
$folder = new Folder(Url::to_rel('/' . $module_id));
if ($folder->exists()) {
$folder->delete();
}
$tables = self::$db_utils->list_tables(true);
if (in_array(PREFIX . 'verif_code', $tables)) {
self::$db_utils->drop(array(PREFIX . 'verif_code'));
}
}
/**
* @desc Deletes a category and items.
* @param int $id Id of the category to delete.
*/
public function delete($id)
{
if (!$this->get_categories_cache()->category_exists($id) || $id == Category::ROOT_CATEGORY) {
throw new CategoryNotFoundException($id);
}
$category = $this->get_categories_cache()->get_category($id);
$this->db_querier->delete($this->table_name, 'WHERE id=:id', array('id' => $id));
//Delete items
$this->db_querier->delete($this->categories_items_parameters->get_table_name_contains_items(), 'WHERE ' . $this->categories_items_parameters->get_field_name_id_category() . '=:id_category', array('id_category' => $id));
$result = PersistenceContext::get_querier()->select_rows($this->table_name, array('id', 'c_order'), 'WHERE id_parent=:id_parent AND c_order > :order', array('id_parent' => $category->get_id_parent(), 'order' => $category->get_order()));
while ($row = $result->fetch()) {
$this->db_querier->update($this->table_name, array('c_order' => $row['c_order'] - 1), 'WHERE id=:id', array('id' => $row['id']));
}
$this->regenerate_cache();
}
private function delete_too_old_failure_attemps()
{
$condition = 'WHERE last_connection < :reset_delay';
$parameters = array('reset_delay' => time() - self::$MAX_AUTHORIZED_ATTEMPTS_RESET_DELAY);
$this->querier->delete(DB_TABLE_INTERNAL_AUTHENTICATION_FAILURES, $condition, $parameters);
}
