Five hundred years after the Discord's first defeat, a lone unicorn scientist makes an interesting discovery. Across Canterlot, over the last few centuries, accident rates have increased in the area around the Royal Palace. His work is ridiculed by his peers, but comes to the attention of the Princesses, who know exactly what is happening: Discord is waking up. With Luna and Celestia, he concocts a plan to stop the Lord of Chaos forever.

===
Cover art butchered from UnderwoodART's render of the stained glass in S02E01.
This story is based on S1/S2 (Discord was never released and reformed) and sits within my Soot-Covered World canon, but is stand-alone. No knowledge of the other books is required.

All thanks to ascendant, NoeCarrier, turol, KMCA, Caliaponia and billymorph for their prereading and editing over the life of this story.

After a horrible accident, Luna is forced to resort to drastic measures in order to save Twilights life. While unconscious, Twilight meets a powerful stallion who claims to be responsible for death, sleep, and all other states of unconsciousness. He turns out to have quite a tale to spin for her, and what he reveals may well be the undoing of one thousand years of harmony.

And so, the rewrite has begun.

Discord knows many things, has powers that can make heads flip and worlds turn upside down with a snap of his fingers, but if he's turned to stone again if Twilight can break her friends free from his influence, he was going to need an heir. Before his secondary loss, which he knew would eventually be inevitable, he chooses someone from another world, a young man named Charles, to take his stead and be the next Lord of Chaos. But with a new life comes a new body, and it's hard to be a menacing, chaotic deity when you're turned into a young draconequus colt.

This is a story requested by LordOfChoas.

Almost every brony that has ever been in Fimfiction.net has seen a 'HiE as pony' story.

They usually are fairly predictable, with a few plot twists perhaps, but the general pattern is similar.

A mystical force/accident sends a completely unprepared human into the land of the ponies, and he must then undergo a journey of self discovery/destiny, as a human OR pony.

So what happens when a human is actually prepared with all the knowledge he'd need from the first two seasons of the show? And when Equestria isn't quite as predictable as he hoped?

This is that tale.

Writer: JustAnotherEarthPony
Editor: I'mMrNoobHeadFU1

This story is a sequel to Foreign Nationals of Unusual Importance

A Twin Canterlots story—second in the Cook’s Tour series

What’s the reward for a job well done? Another job. Cookie Pusher, the junior diplomat keeping an eye on Sunset Shimmer and her friends, has pleased his superiors with his diligence and competence. Deciding he’s ready for bigger and better things—and not wanting to brief in yet more people about the portal—they assign him a new task: travel through the portal as chargé d’affaires en pied to open diplomatic relations with Equestria.

Takes place about twelve months after “Through the Mirror” and six months after “Rainbow Rocks”—early in season six.

Reviewed 16 July 2017 by Singularity Dream.

Once upon a time there was a doubter and a rationalist. There was no one at work more ruthless than him. He had no friends, he really wanted to be strong and independent, but suddenly he was hit by a train. How can he survive in a new world unknown to him, and also in the body of a mare hated by everyone?

This story is a sequel to A Dragon's Memorial

Spike had watched them fade but they were not gone. The Elements of Harmony, long since taken back from the tree to fight off one of Equestria's enemies, now sit dormant in Spike's everfree cave. Though Equestria has ever been the peace loving center of harmony it has never been short on enemies and now that the six mares that were its greatest defence have passed away it is only a matter of time until these enemies decide to strike.

Now Spike must do his part to ensure the safety of the nation that raised him.

Decades after her ascension, an upsetting revelation brings Twilight Sparkle to distance herself from her old mentor and dive back into what she knows best: research.

Not everypony agrees with the results of her work, however, and conflict becomes inevitable.

For thousands of years, mules have used their mystical martial arts to protect the very ponies who despise them, but when the scandalous "Cakegate" photos reveal Princess Celestia for the confection-snarfing tyrant she truly is, the mules decide it's time for a regime change. It's time to assassinate Princess Celestia!

Featured on Equestria Daily on 6/11/2012, Star-5 Story.

This story is a sequel to If You Came to Conquer

Princess Nightmare Moon had tried to keep it secret. She had suppressed her power, feigned ignorance, played the outdated fool at every opportunity. She should have known that something like this would happen. A threat that would reveal her, whether she played dumb or not.

If she had to reveal herself, then at least she could protect Equestria in the process. She nocked the arrow. The bow felt so flimsy, but she could not risk him absorbing a spell. She laced magic across the arrow and the string and the air, enough to make it fly faster and aim smoother. She sighted him easily; Tirek was a large target. Now he only had to turn around. An arrow to the spine would kill him simply and instantly, no matter how much magic he had absorbed.

Once he was dead, the hard part would come: explaining herself to Celestia.

Prereading thanks; Meta Four, Blank!, Yami Vizzini, and especially Craine

Russian translation by Doof
Chinese Translation by Dreams Set Free

Comments contain spoilers.