I've tried the MacNally power adapter for $25-$30, and it worked for 6 months. If you have a Mac power adapter (not the new one with the magnet) and it's breaking apart, just use liquid electrical tape. You can get it from Home Depot or probably any hardware store. I'm using red, because that's what was left in stock (but they sell it in black and white as well). It can get a little messy, so put a napkin under it. I would also recommend doing this several times (wait until it dries, and then reapply). The texture is like rubber cement. I will probably wrap it up with white electrical tape after.

If it's really bad like mine, use some wire or a paper clip as a support, but do not solder, you may burn off the insulation of the other wire, and it will create a short. Then use a wooden golf tee as support.

--

Also, I learned how to drill a hole in glass from Martha Sterwart's Living magazine. She saids to use a plastic container and fill with water, but don't submerge all of the glass piece in to the water. Then use a drill, but the photo looks like a dremel bit. Make sure it's a "diamond" one (usually used to drill into metal pieces).