A man wakes up only to find that, rather than lazing on his couch, hes in an ancient castle in a fictional world. And top it all off, in the body of one of the world's biggest villains.

While he plans how to spend this oddly realistic dream, using what little he knows of the show to tip things in his favor, he will soon find that not everything follows the script he knows.

Will be adding tags if need br, I like the cover art I have at the moment, may change it later.

I do hope you enjoy this little brain worm of a story!

Twilight Sparkle, the Solar Regent, was frustrated. She’d never had a chance against Nightmare Moon, and now she had to live with the consequences of her failure and the moon goddess on the throne beside her.

Shining Armor, Captain of the Royal Guard, was frustrated. His liege was gone. His marefriend was somewhere doing something. His sister was showing all the early warning signs of one of her infamous breakdowns. Worst of all, everypony was keeping secrets.

Sweetie Drops, Equestrian special agent, was frustrated. Work kept piling up, and there seemed to be more and more monsters to fight every day. She needed help.

Cadance, the Crystal Princess, was frustrated. Being somepony’s snack was beneath her, but needs must.

Tempest Shadow, wanderer, was frustrated. Why did life always insist on kicking her while she was down? If it wanted to maintain even the pretext of fairness, her next destination would be her last.

Luna, the Lunar Diarch, was delighted. Everything had gone perfectly since her return from exile.

There exists in any given location either an inn or bar where the locals meet at the end of a long work day and trade drinks and stories. By the ancient laws of happenstance, the same must be true for areas where the permanent population is exactly one. Now, most would assume it would default to those creatures preferred drinking area in their own house. These people have never been to the only truly lonely place in Equestria. On the border of the unending sea and the badlands there sits an Inn, with a strange bartender. If one comes seeking riches or fame, he will gladly kick you out, stating the only riches here are booze and misery. But if you come for a strong drink and an ear to listen to your problems, then you have found your home.

Rocking the featured box again. Can I get a hoorah? 2/12/19 for those curious.

Commander Shepard remembers firing the crucible. She remembers she had to make an important choice. She remembers good friends, a lover, and plenty of loyal crewmen.

She just can't remember what her choice was. What the threat she was striving so hard to end was. Or what the faces of the most important people in her life look like.

She also has no idea how she wound up in the monster filled forest she's come to call home for the past eight months. Or how she picked up a snarky A.I. making its home in her omni-tool.

Thrust headlong into a strange new world, Solaire of Astora must make amends before he can continue with his mission. Unbeknownst to them all, a shadow from his past approaches.

After years of shame and ridicule, archaeologist and explorer Lyra Heartstrings stumbles across a discovery that validates all her theories and ideas in one fell swoop. Along with her best friend, Bon Bon, and her old classmate Cadance, they find themselves faced with a mystery and marvel that may change everything.

Following the next greatest lead found in the database of an ancient race, another international team is formed. Led by Doctors Carter and Jackson, they strike out to explore another network of Stargates discovered in a galaxy on the edge of the local cluster. In the process, their findings will cause them to question much of what they thought they knew.

The adventures continue and unlikely allies will face dangers new and old as the Legacy of the Ancients continue to unravel in the latest chapter of the universe.

[Co-written by Thunderclap and Shagohad12] Formerly co-written by Grey Cait. [Edited by: Lithl and m2pt5][Cover art: 1, 2 modified + vectors]
Now with a Russian reading by SviMik

"From all of us together, together we’re friends. With the marks of our destinies made one, the journey is without end!"

With those words, Twilight Sparkle accidentally teleported herself, Spike, the rest of her friends, and the elements of Harmony into another world. Trapped as they were for a thousand years, they made do; mingling with the natives, accepting their new-found longevity, and coping with the separation from their home world.

It's been a long ride, not without its bumps. But now, at last, the spell is winding down. The seven of them have gathered in their mansion to say farewell to their new friends and family. And even as the tears are shed and goodbyes made, some part of them is looking forward to returning to Equestria. It's true that everypony they knew is probably long dead (aside from the princesses,) but it's still their home.

There have probably been a number of changes, of course. But it can't be that bad... right?

Cover by fleebites.

The failed invasion of that mad queen, Chrysalis, rocked the changeling community. From the hives nestled outside Equestria, to their kin living in peace within, they watch those colorful ponies eye one another with suspicion and let themselves be swallowed by fear and distrust.

A gamble by Princess Celestia has summoned forth the diplomat to the Seekers, the one changeling who may be able to ease tensions between their races and restore balance. The Bearer of Magic has been summoned after a century of peace.

And, like her mother before her, Princess Twilight Sparkle will answer the call.

Preread by Alto, Cynewulf, and Timaeus.
Cover art by FoughtDragon01, used with permission.

This story is a sequel to Stardust

Times are changing for Equestria as Twilight’s return brings with it news of people and cultures from beyond the peaceful world everypony knows. Aid and volunteers are freely offered to help the besieged humans of Earth because every Equestrian knows that’s what good friends do. Unfortunately, making friends can also have the unintended consequence of making enemies.

When the monsters besieging the humans strike at Equestria with a level of brutality not seen in over a thousand years, the cry for help is sent to all the kingdoms of the world. Honored allies step forth to fulfill ancient treaties and oaths. Enemies, old and new, bury their grievances. An alliance never before seen in Equestria will be created to combat the monsters from the void.

And because of these events, a grim but welcome sibling to the XCOM project is born.

(XCOM/FiM Crossover)
(Sequel to Stardust, which I recommend reading before starting this. Fortitude Amicitia and Broken aren't required reading but are supplemental to the storyline)
(Gore tag for blood and violence)
(Alternate Universe tag because of the divergence from canon that Stardust has caused)
(Uses elements of Season 4)
(Coverart produced by the amazing Carnelian!)
(Many thanks to Arzoo, BradTheBrony, Vandenbz and Setokaiva for prereading!)
(As of 03/07/2016, the prereading team consists of Arzoo, BradTheBrony, Noble Cause and Metallusionsismagic!)
(Complete with it's own TVTropes page as part of the Stardust continuity. Could use some updating!)
(Character tags will be added as chapters are added!)
(Featured 5/12/2014! Thanks folks!)
(Possible spoilers in the comments! BEWARE!)

For many a millennia he has slumbered beneath the earth, his strength recovering from a conflict as old as the sands it was fought upon. For many a millennia he and his people withered away into legends, spoken of by the elderly to their young as nothing more than stories before bed. For many a millennia the world itself forgot about this being, hidden away within a cage of dirt and rock and time.

But now he has awoken to find himself lost in a world nearly unrecognisable, dominated by a species he'd not laid eyes upon for many, many years indeed.

Yet there still lived a select few who knew him personally. To them, he was an old yet dear friend, long believed to have been lost to the cataclysm that cost him his people and his kingdom. Despite all the time that had elapsed and despite all that had happened throughout the years, they still knew his name.

Cyrus Perennem, 'The King Without a Crown'.