I revived it with black spray paint and added a new shade. I first tried it with a black shade, which looked great but blocked most of the light from the bulb, making the lamp useless for reading. A white shade is much more practical.
I attached the lamp to the wall and hid the cord in a plastic channel painted to match the wall.
The lamp normally snugs up to the wall, but I can swing it out if needed.