function updateUserDataIntoSession($username) { $db = \Zend_Registry::get('db'); $select = $db->select()->from('user')->where('username=?', $username); $user = $select->query()->fetch(); \Zend_Registry::set('user', $user); \bootstrap::getInstance()->getSession()->user = $user; }
public function buildPrivilegeRights() { # Registry for Database Access $registry = bootstrap::getRegistry(); $this->roles = []; $query = sprintf('SELECT table1.role_id, table2.role_name FROM hybrid_user_rule as table1 JOIN hybrid_roles as table2 ON table1.role_id table2.role_id WHERE table1.user_id = %d', $account->getID()); $statement = $registry->database->query($query); while ($row = $statement->fetch(\PDO::FETCH_ASSOC)) { $this->roles[$row['rule_name']] = helper\Authicate::getPermissions($row['role_id']); } }
public static function removeUserRole($role) { $registry = bootstrap::getRegistry(); $query = sprintf('DELETE FROM hybrid_user_role WHERE hybrid_user = %d', $role); return $registry->database->query($query); }