Mage Academy: I Have Infinite Skill Points - Chapter 294 - Those Who Don’t Know Aren’t Uuilty

I opened my eyes to find myself in another world. For some odd reason, I ended up as a sword. Before my eyes laid a plain full of magic beasts, and so, I launched my body and flew in search of a partner, a wielder (females only). Wait. Absorbing magic stones gets me skills? Oh hell yeah! This be fun! More, more, give me more! Gimme all your magic stones! Okay, yeah no, but I am accepting anything anyone’s willing to give. This tale is one that follows your everyday nerd, normal as could be, save for the fact that he happened to reincarnate as a sword.

Luo Zheng is at the bottom of the Luo Clan hierarchy, despite his family being the founders of a power refining technique that could instantly defeat any opponent.

One night, enraged by unfair treatment from a family steward, Luo Zheng burns the family records. In doing so, the hidden magic in the book engulfs him and Luo Zheng becomes a new skilled fighter. Fleeing his home and despicable clan, Luo Zheng must learn to harness his powers to rescue his younger sister while his own cousins are on his pursuit.

- Description from Novelupdates

I became the childhood friend of the protagonist in a novel. The childhood friend who died from taking drugs.

Young Chen Xiang had a fateful encounter with a goddess & demoness and received their peerless heritage, divine pulses, ultimate martial arts, and transcendent alchemy techniques, which gave him an easy ride in his journey of cultivation.

When hungry, he refines some spirit pills to eat as snack, when lonely he flirts with the goddesses, when bored he teases those martial artists who came to beg for spirit pills, when tired he lets his beautiful wives massage him.

- Description from Novelupdates