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