Need help , character ruined due to bad ui

For some reason it is very easy to irreversibly sell your weapon by moving to the right , one would expect that selection would stay in the inventory , however the main weapon is selected and sold.
I have leveled up my character in dex and faith to be able to use this weapon(Sacraments sin 16dex 16faith).
I need help reverting my inventory as i am unable to progress the game without a weapon, chances are very slim that i will find that weapon again , maybe in the future but i am unable to progress the game now.
I hope that i get some resolution regarding this issua as i am currently not playing the game , my only option is to start a new character because i cannot respec this one , and all other weapons are not scaling with faith/dex hybrid

I don’t think you can do much to get it back at the moment, since the realms saves are separate from character saves.

So you can try to have it drop again by exploring regions or you can make a new realm to progress easily or you can make a new character.

Other than that you can temporarily change weapon to dagger, double dagger or spear (which use dex stats) until you drop a weapon that suits you.

Yeah guess i am done with this game as i dont wanna start from beggining.
I cannot progress the game with daggers as i will do low dmg.
Finding the item is extremely unlikely
I messed up the stat distribution and there is no respecing currently

My Stats are a mess too, but it is sure that re-spec is on the way, we’ll just need a bit of patience.