$id_user = intval($this->getLastId($sequence));
$sql = 'INSERT INTO users_config ( user_id, name, value ) VALUES (?, ?, ?)';
- $params = array($id_user, 'pager', '10');
+ $params = array($id_user, 'pager', PAGINATION);
$query = $this->executeQuery($sql, $params);
$sql = 'INSERT INTO users_config ( user_id, name, value ) VALUES (?, ?, ?)';
- $params = array($id_user, 'language', 'en_EN.UTF8');
+ $params = array($id_user, 'language', LANG);
+ $query = $this->executeQuery($sql, $params);
+
+ $sql = 'INSERT INTO users_config ( user_id, name, value ) VALUES (?, ?, ?)';
+ $params = array($id_user, 'theme', DEFAULT_THEME);
$query = $this->executeQuery($sql, $params);
return TRUE;
return $user;
}
- public function updatePassword($id, $password)
+ public function updatePassword($userId, $password)
{
$sql_update = "UPDATE users SET password=? WHERE id=?";
$params_update = array($password, $id);
- $query = $this->executeQuery($sql_update, $params_update);
+ $this->updateUserConfig($userId, 'password', $password);
+ }
+
+ public function updateUserConfig($userId, $key, $value) {
+ $config = $this->getConfigUser($userId);
+
+ if (!isset ($user_config[$key])) {
+ $sql = "INSERT INTO users_config (`value`, `user_id`, `name`) VALUES (?, ?, ?)";
+ }
+ else {
+ $sql = "UPDATE users_config SET `value`=? WHERE `user_id`=? AND `name`=?";
+ }
+
+ $params = array($value, $userId, $key);
+ $query = $this->executeQuery($sql, $params);
}
private function executeQuery($sql, $params) {
return $entries;
}
+ public function updateContent($id, $content, $user_id) {
+ $sql_action = 'UPDATE entries SET content = ? WHERE id=? AND user_id=?';
+ $params_action = array($content, $id, $user_id);
+ $query = $this->executeQuery($sql_action, $params_action);
+ return $query;
+ }
+
public function add($url, $title, $content, $user_id) {
$sql_action = 'INSERT INTO entries ( url, title, content, user_id ) VALUES (?, ?, ?, ?)';
$params_action = array($url, $title, $content, $user_id);