/** * @param $user_id * @param $removed_perm */ public static function removePerm($user_id, $removed_perm) { $original = UserRoleModel::getPerms($user_id); $being_removed = array_search($removed_perm, $original); unset($original[$being_removed]); $database = DatabaseFactory::getFactory()->getConnection(); $sql = "UPDATE users SET perms = :new WHERE user_id = :user_id"; $query = $database->prepare($sql); $query->execute(array(':new' => json_encode($original), ':user_id' => $user_id)); }
/** * Remove A user permission * @param $user_id * @param $removed_perm */ public static function removePerm($user_id, $removed_perm) { if (self::$removePermQuery === null) { self::$removePermQuery = DatabaseFactory::getFactory()->getConnection()->prepare("UPDATE users SET perms = :new WHERE user_id = :user_id"); } $original = UserRoleModel::getPerms($user_id); $being_removed = array_search($removed_perm, $original); unset($original[$being_removed]); self::$removePermQuery->execute(array(':new' => json_encode($original), ':user_id' => $user_id)); Session::add('feedback_positive', 'Removed that permission!'); }