Alan Niven (pictured), the former manager of Guns N Roses, is pulling back the curtain on his time with one of rock's most infamous bands