Rebirth in the 60s: A Path to Counterattack - Chapter 44 - 0. I believe

A young man plagued by recurring nightmares finds himself visiting a blind fortune teller, who sends him to a world of martial arts that looks a lot like the wuxia stories he used to read.

In the sky of this world, a tome shines every now and then, revealing the hierarchy of mighty beings that seek power amid troubled times. Determined to unravel the mysteries of his involuntary journey and the secrets of the world he has ended up in, he endeavors to ascend the tome’s rankings, all while looking for a path back home.

Official Chinese blurb

Wandering the jianghu with a blade and wine, where beauties’ grace is filling one’s mind.

A youth, saber on his back and wine gourd at the waist, strides forth, yet the jianghu of his heart seems only more elusive;

With each flipped page of the Tome of Troubled Times, decades of nights soaked in rain pass over the jianghu.

As he suddenly turns to look back, he finds that the mortal world has shattered in his wake.

The first thing my childhood sweetheart's did after becoming a wealthy woman was to ask me to marry her, in my poor and destitute state, went to her family to become the son-in-law.“Marry me, and you can live in luxury cars and mansions as you please.No need for work or household choresPlenty of pocket money every day, amounting to a five-figure sumAnd if you want kids, I'll bear as many as you wish.”But when I became this toy boy, I gradually discovered the sickly yandere and perverted control side of my childhood sweetheart...An accident brought me back to the past, live my life again.This time, facing the temptation of childhood sweethearts, I decisively refused!In this new life, my slogan is, drum up the wallet, and stay away from the rich woman!Me: “Sorry, I am the man you can never get in this life no matter how much money you spend!”

One day, Katsuragi Daichi and his classmates found themselves in a different world. The god who summoned them to another world divided its power and gave it to them, saying that it wanted Daichi and the rest to defeat the Demon King as heroes. However, Daichi alone was given no abilities. And sure enough, Daichi was thrown away and used as a decoy in a demon’s den. Eaten by a demon, Daichi had lost consciousness and thought he had passed away, though when he came to he noticed his statuses had skyrocketed. He had obtained『Revenge of the Resented』. Every time he died, his abnormal ability powered up.

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