Topic: Dark Souls Remastered \[т]/

Magical Weapon Smith
Obviously there are various weapon smiths across the game, each specialising in element types or higher quality. For a (dirty) sorcerer such as yourself you need Rickert & if you haven't found this guy yet you'll kick yourself when you realise where he is, not because he's easy to find, more because he's hiding right under your nose-ish - I had been playing for hours before I came across him! He will sell you sorceries (he's not the only source and won't sell you the best ones in the game - they come later from elsewhere), most importantly additional ones for early game so you're not as restricted with number of casts. He is also the man for enchanting/upgrading your weapons (even more so once you give him an ember or two!), being able to turn any normal +5 weapon into a magic type (although you'll need green titanite shards - more in a sec)

If you want to find him; there are plenty of vids on youtube, or head down the stairs at Firelink (the ones to the right of the crestfallen warrior (miserable dude sat opposite the bonfire). Take the lift down and once you exit/go down another small set of stairs, over to the right there's a dead hollow-thing hanging over the edge, walk across and you'll find another sneaky/dangerous looking set of stairs (yes you can easily fall off), walk down and there he is, sat in a cell for the rest of his days.

Weapons
I'm obviously not going to tell you what weapon to use, a lot of it comes down to personal preference - late game when you can get some of the strongest weapons (Moonlight Greatsword is one of the best Intelligence weapons but is far off for you just yet) you'll have a far better understanding of what works/doesn't work for you and you can do a bit of trial and error, early game though is a bit more tricky as nothing scales well as mentioned above.

Now you can either start straight away going about getting stuff for a solid magic/enchanted weapon but conversely you can also look at using either the drake sword or converting another weapon you like into the Raw type - both the drake and Raw weapons have (much) higher base damage, the trade off being that they don't scale against any stats so their effectiveness drops off as you get further into the game. This saves you having to spend too many points on str/dex (you'll need to spend a few to be able to wield whatever weapon you eventually decide on) to cover off the damage deficit from poor Int scaling against 'normal' weapons & essentially buys you time until you can more easily get to the locations/find the items you need to construct a potent magic-basher.

If you want to go straight for a magic/enchanted weapon then you might want to do your google homework as to exactly what weapons to look out for (and ultimately whether they'll work better as magic or enchanted overall - weirdly enchanted often seems to be superior). Two early game suggestions you could look at (and this is by no means an exhaustive list) are;

Claymore - This is one of my favourite weapons in the game mainly from my first playthrough (the RT/Zr attack is epic!). It's versatile as all heck and once enchanted scales against Intelligence wonderfully. You'll almost certainly have to spend some points in Str/Dex to be able to wield it but very worth it. It's found on the other side of the bridge guarded by a certain fire breather (don't believe you're here yet based on what you've said but it's not too far away.

Baldur Side Sword - Dropped by the annoyingly quick knights in the undead parish, this sword has a lot of fans. I like how fast it is but can't get on with the moveset. It also scales well (I believe). Also available not far from where you are.

Embers & upgrading
Obviously loads of sites out there will tell you the full schtick about this, but in basic terms, whether you're going for a Raw, Magic or Enchanted weapon you'll want to start by upgrading the weapon of your choice to 'normal +5' using titanite shards (these are pretty regular drops from the aforementioned Baldur knights in undead parish). From there either Andre (smith near undead parish) can 'modify' your weapon down the Raw path, or Rickert can move you onto the magic path (note it's a different option in the smith menu to change types/upgrade past 5). As you upgrade past +5 note that the titanite requirements become higher (in terms of amounts and the type) and more importantly you'll need coloured titanite for magic/enchanted - both can be farmed quite early too but again, it's more work but that trade-off is up to you.

Wow, is all this really necessary...? Is it really that hard...?
Not as such no, for a large part you'll be able to bash through without too much of a hitch but you are going to come up against some stuff that if you're not prepared will seriously test you. Most people who know you're new to the game will warn you about the Gargoyles, but as a caster should actually destroy them, it's more the Capra demon a little bit afterwards that will ruin your fun - he fights in a room the size of a wardrobe and has two little dogs with him that prevent you getting anything even remotely spell based off and you have to get them down as quickly as possible to stand a chance. I only focused on Intelligence and Attunement first time out but hit a brick wall with this boss as it took me 5-6 hits per dog to kill them which meant the big angry dude with 'compensating for something' swords was free to slice and dice me ad nauseum. There aren't too many other huge hurdles like that, but it's important to note that there are a few magic resistant enemies in the game later so having something like an upgraded raw (or divine for another area) is a great plan B and ensures you're covered against pretty much most types of enemy.