return $user_config;
}
+ public function userExists($username) {
+ $sql = "SELECT * FROM users WHERE username=?";
+ $query = $this->executeQuery($sql, array($username));
+ $login = $query->fetchAll();
+ if (isset($login[0])) {
+ return true;
+ } else {
+ return false;
+ }
+ }
+
public function login($username, $password) {
$sql = "SELECT * FROM users WHERE username=? AND password=?";
$query = $this->executeQuery($sql, array($username, $password));
public function updatePassword($userId, $password)
{
$sql_update = "UPDATE users SET password=? WHERE id=?";
- $params_update = array($password, $id);
- $this->updateUserConfig($userId, 'password', $password);
+ $params_update = array($password, $userId);
+ $query = $this->executeQuery($sql_update, $params_update);
}
public function updateUserConfig($userId, $key, $value) {
- $sql_update = "UPDATE users_config SET `value`=? WHERE `user_id`=? AND `name`=?";
- $params_update = array($value, $userId, $key);
- $query = $this->executeQuery($sql_update, $params_update);
+ $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) {
$query = $this->executeQuery($sql, $params);
$entry = $query->fetchAll();
- return $entry[0];
+ return isset($entry[0]) ? $entry[0] : null;
}
public function getEntriesByView($view, $user_id, $limit = '') {