private function save_in_db()
{
$condition = 'WHERE user_id=:user_id';
$parameters = array('user_id' => $this->user_id);
$columns = array('autoconnect_key' => $this->key);
self::$querier->update(DB_TABLE_MEMBER, $columns, $condition, $parameters);
}
private function update_failure_info($failure_id)
{
$columns = array('last_connection' => $this->last_connection_date, 'connection_attemps' => $this->connection_attempts);
$condition = 'WHERE id=:id';
$parameters = array('id' => $failure_id);
$this->querier->update(DB_TABLE_INTERNAL_AUTHENTICATION_FAILURES, $columns, $condition, $parameters);
}
/**
* @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();
}
/**
* @desc save a Menu in the database
* @param Menu $menu The Menu to save
* @return bool true if the save have been correctly done
*/
public static function save(Menu $menu)
{
$block_position = $menu->get_block_position();
if (($block = $menu->get_block()) != Menu::MENU_NOT_ENABLED && ($block_position = $menu->get_block_position()) == -1) {
$block_position = self::get_next_position($block);
}
$id_menu = $menu->get_id();
$columns = array('title' => $menu->get_title(), 'object' => serialize($menu), 'class' => get_class($menu), 'enabled' => (int) $menu->is_enabled(), 'block' => $block, 'position' => $menu->get_block_position());
if ($id_menu > 0) {
self::$querier->update(DB_TABLE_MENUS, $columns, 'WHERE id=:id', array('id' => $id_menu));
} else {
$result = self::$querier->insert(DB_TABLE_MENUS, $columns);
$menu->id($result->get_last_inserted_id());
}
return true;
}
