+ public function isInstalled() {
+ $sql = "SELECT username FROM users WHERE id=?";
+ $query = $this->executeQuery($sql, array('1'));
+ $hasAdmin = $query->fetchAll();
+
+ if (count($hasAdmin) == 0)
+ return FALSE;
+
+ return TRUE;
+ }
+
+ public function install($login, $password) {
+ $sql = 'INSERT INTO users ( username, password ) VALUES (?, ?)';
+ $params = array($login, $password);
+ $query = $this->executeQuery($sql, $params);
+
+ return TRUE;
+ }
+
+ private function getConfigUser($id) {
+ $sql = "SELECT * FROM users_config WHERE user_id = ?";
+ $query = $this->executeQuery($sql, array($id));
+ $result = $query->fetchAll();
+ $user_config = array();
+
+ foreach ($result as $key => $value) {
+ $user_config[$value['name']] = $value['value'];
+ }
+
+ return $user_config;
+ }
+
+ public function login($username, $password) {
+ $sql = "SELECT * FROM users WHERE username=? AND password=?";
+ $query = $this->executeQuery($sql, array($username, $password));
+ $login = $query->fetchAll();
+
+ $user = array();
+ if (isset($login[0])) {
+ $user['id'] = $login[0]['id'];
+ $user['username'] = $login[0]['username'];
+ $user['password'] = $login[0]['password'];
+ $user['name'] = $login[0]['name'];
+ $user['email'] = $login[0]['email'];
+ $user['config'] = $this->getConfigUser($login[0]['id']);
+ }
+
+ return $user;
+ }
+
+ public function updatePassword($id, $password)
+ {
+ $sql_update = "UPDATE users SET password=? WHERE id=?";
+ $params_update = array($password, $id);
+ $query = $this->executeQuery($sql_update, $params_update);
+ }
+