public static function getForApp() { global $CFG; $return = array('user' => array(), 'sexos' => array(), 'content_cats' => array(), 'event_cats' => array(), 'hatzalah_phone' => $CFG->hatzalah_phone, 'dsi_phone' => $CFG->dsi_phone); if (!empty(User::$info)) { $return['user'] = User::$info; $status = User::getUserStatus(); $return['user']['status'] = $status[User::$info['site_users_status']]['key']; unset($return['user']['nonce']); unset($return['user']['session_key']); unset($return['user']['ip']); unset($return['user']['awaiting']); unset($return['user']['id']); unset($return['user']['reg_date']); unset($return['user']['last_login']); unset($return['user']['user']); unset($return['user']['pass']); unset($return['user']['site_users_status']); } $sql = 'SELECT * FROM sexos'; $result = db_query_array($sql); if ($result) { foreach ($result as $row) { $return['sexos'][$row['id']] = $row['name']; } } $return['content_cats'] = Content::getTopics(); $return['event_cats'] = Events::getCats(); return $return; }
protected function update(User $user) { $q = $this->db->prepare('UPDATE users SET userType = :userType, userStatus = :userStatus, email = :email, university = :university,firstName =:firstName, lastName = :lastName, passWord = :passWord WHERE id = :id'); $q->execute(array('userType' => $user->getUserType(), 'userStatus' => $user->getUserStatus(), 'email' => $user->getEmail(), 'university' => $user->getUniversity(), 'firstName' => $user->getFirstName(), 'lastName' => $user->getLastName(), 'passWord' => $user->getPassWord(), 'id' => $user->getId())); }