After I Maxed All My Weapon Proficiencies - Chapter 25

When he returned to the World of Martial Arts, the game was filled with blood and battles! Chen Kaixin had chased after the footsteps of the one emperor, two empresses, three princes, seven dukes, and thirteen aces for three years, but during the eve of the Sword Among Us tournament in Mount Hua, he was ambushed by evil bastards, and was killed so much that his level dropped to that of a newbie. He completely lost the chance to join the ranks of the powerful players in the game! In great disappointment, Kaixin quit the game and got drunk so that he could forget his sadness, but during that stormy night, Chen Kaixin found that he had actually dreamed for a total of three years, because when he woke up again, he woke up to three years ago, when he was still a student.

- Description from Novelupdates

Lin Xuan was transmigrated to a fantasy world and had a one-night stand with the powerful Ice Empress.

Son of a bitch! I just finished this godawful fantasy novel, and now I'm knee-deep in it – as David, the disgraced son of the Solarian Empire's top general! Talk about some twisted cosmic joke. But hold on a damn minute... maybe this isn't all bad. Armed with the knowledge of that trashy plot, I can become the ultimate shadow player, an overlord perhaps. Screw the damsel-in-distress harem too – it's time to pull the strings and become the real power behind the throne. This isekai might be a steaming pile, but I'm rewriting the ending with a little more... Debauchery (wink wink).