After doing some researching and finding videos showing how to re-solder the cable and stuff, I stumble upon this page:
http://support.apple.com/kb/TS1713?viewlocale=en_US
And thought it was worth a shot going to the apple store here in Pasadena. So I made an appointment and in about 15 minutes I got a new magsafe adapter at no cost. 🙂
Here’s a shot of the new one:
