Guild Mage: Apprentice - 52. Ice Sphere

This is a story of an ordinary boy gaining unusual powers from his nightmares… It all started when Lin Sheng experienced something strange on what he thought was just another normal day. He begins to have recurring dreams that lead him on an incredible journey of discovery as he encounters spine-chilling monsters and elusive secrets.

- Description from Novelupdates

In 1930s Canada, a 16-year-old landlord unlocks a System unlike anything this world has seen—a power that lets him grant supernatural abilities drawn from warriors of another realm. Barbarians, Archers, Wizards… all under his command.

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.