You are definitely at the point where the Drake Sword is about to become completely and utterly useless. Maybe you aren't quite there yet, but yes it is definitely time to start trying to find another weapon. Find a good one you can use temporarily until you get the lightning spear in Sen's Fortress. For Attunement slots, get two. If you have two, don't level it up any more because really all it does is absorbs your souls until you reach a certain tier to get another slot. It isn't worth it at this point, this early in the game. I have the maximum amount on my character, but he's also like level 219. But for somebody using melee, all you'll use it for is a heal spell every now and again (by the way if you don't have the heal miracle equipped, do that ASAP). So yeah I'd say get 2 attunement slots, then work on your endurance to around 40 and strength to... maybe 55. Then wing it. My character is a pyromancer magic user melee attacker. That's the cool thing- you are NEVER tied down in Dark Souls. You can make your character however you want. You don't need to start a new character to be a different 'class.' Just put on different gear. Dark Souls is VERY gear based instead of stat based. Long as you have the stats you need for certain things, you're in good shape.