The Unrivaled Tang Sect - Chapter 2.4: Skydream Iceworm

Fate, a gatekeeper who had been working for the castle, is beset by a few burdens.

Cheng Yin likes her deskmate Chen Yan for a long time, but she never dared to confess her love for him, and the phrase ‘I like you’ is a secret hidden in her heart, but she can’t help but blurt it out from time to time…
Cheng Yin: “Chen Yan, I’ll whisper something to you.”
Chen Yan always leans over quite cooperatively, “What?”
The words came to her lips, Cheng Yin blushed and changed it into: “Your pants are unzipped.”
Chen Yan: “?”
Later, this kind of useless whispering has become more frequent, and Chen Yan listened again without moving a bit: ” Speak.”
The day of the party, Cheng Yin drink for the first time, Chen Yan became two in front of her eyes, she grabbed the person with both hands, want to try to catch the real Chen Yan, only to have her hand caught, he lowered his head in her ear and said: ” Let me whisper to you.”
Cheng Yin: “…… what?”
Such bad behavior, she thought it was something bad, Cheng Yin checked her pants and made sure the zipper was closed before she lean over.
The man’s breath blew softly in her ear, laced with a bit of the smell of wine.
“I like you.”

- Description from Novelupdates

Jack Wilson spent his life in a hospital bed — betrayed by his family, forgotten by the world, and kept alive only by the one person he trusted.Then that person put a knife in his chest.He wakes up somewhere else entirely. In a body that can stand. That can fight. That hasn't seen daylight in years.He's inside Savage Awakening, a fantasy VR world he escaped into during every waking hour of his illness.Except it isn't a game anymore.Jack reawakens in the body of a third-rate villain.A Noble Vampire with magic powerful enough to reshape kingdoms — and a hidden curse called A Villain's Fate that guarantees he dies before the story ends.But Jack isn't the Vampire.... He wouldn't die because of some measly 'Villains Fate'Jack knows this world better than anyone alive. He knows every death flag, every hidden mechanic, every secret the game's creators buried in the lore.He also knows the true villain isn't him.The question is whether a man who never had a future can survive long enough to steal one.

Talented in Magecraft but useless in physical combat?