"Some are born great, some achieve greatness, and others have greatness thrust upon them."—William Shakespeare.

This story is about the latter. Alan Williams, a man trying to take a peaceful camping trip, finds himself in Equestria. Forcing to accept the idea that the show he has watched is not, in fact, fictional has taken a massive toll on his brain, torn as he is between the awesomeness of the situation as well as it's absurdity. What's worse, it seems he is not the first human to be teleported to Equestria, and now he has some big shoes to fill.

Greatness follows.

[...]To those just finding this 'un, ya found genuine gem. Keep your heads inside the respective chapter-comments. Watch out for spoilers. Buckle your seatbelt, fillies and gentlecolts. It's gonna be a wild ride.--Runcible Spoon

Approved by Twilight's Library

Book 1 of the Harmony for All Trilogy

Some accidents are small, and some endow you with the power of a godly ruler. On the opposite end of things, you lose your wings along with your ability to move celestial bodies, and you can't tell anypony. Why, because what would they think if the princess became a librarian? It's going to be "fine". Celestia just needs to switch back with Twilight before either of their true identities are revealed. All Twilight has to do is hold down the castle, fight off scheming villains, run the country, and worst of all... deal with all the noble ponies.

Rated teen for shenanigans and some more serious parts. Takes place at the end of lesson zero. Please tear this apart with comments. I like criticism. Comment if you have issues, don't leave me with a mystery thumbs down.

Twilight has always been the best there is at magic. She's won dozens of scholarly competitions and tests of skill in Canterlot. But when it comes to the more violent uses for magic, she is essentially clueless.

When she meets a strange unicorn in a seedy bar, he introduces her to a little known sport that will test her knowledge of magic in different ways. That is, of course, if Twilight can't resist its primal lure.

A new restaurant has opened Ponyville with one really interesting attraction. And as we all know, there is one language friends, foes,and all races speak: Dance. Watch as all the ponies and characters you know and love show off their dancing skills (or lack of) in front of everypony!

One-shot.

Featuring: Princess Luna, Celestia, Cadance, Shining Armor, Braeburn, Little Strongheart, Vinyl Scratch, Octavia, Cutie Mark Crusaders, Spitfire, Soarin'.

In combination of "The Birds and the Changelings" and "Know Your Mare"

[youtube=http://www.youtube.com/watch?v=-kISjRO3L2U]

Luna does her best to catch up on the events of the past thousand years and ends up reading even more than Twilight.

One day, an ancient tome slips into her pile of reading material and she reads it eagerly. What she finds there may very well be the discovery of the millennium: The location of the last refuge of the humans.

With the help of Twilight and her friends, the Lunar Princess sets out on an archaeological expedition to find the very last human on the planet of Equus.

And they found one, but why is he forged in a full body armor and claims to not being a human... Well he's not one anymore.

The Changeling Hive located deep beneath the Equestrian Badlands a bustling haven for all Changelings of Equestria.
Life was good; the ponies had forgotten their existence and it would remain that way for another two hundred years.

However, just because they're safe from outside threats, it doesn't mean they're safe from themselves. These stories will follow three young Changelings as they seek out adventure and other ways to kills time.

Their names? Mandible, future captain of the Changeling Royal Guard. Cocoon, future Queen of the Northern Changeling Hive. Finally, we have Thorax, future..... well let's be honest, I don't see much of a future.

{Set Two Hundred Years before Equestria's Crazies}

Princess Celestia asked Twilight to do a census of her new home. Through this process she discovers certain anomalies that she finds strange as a unicorn. There seems to be something missing when it comes to the pegasi, and after much prodding, prying, some spying and begging, she finally gets them to open up. What she discovers is not only shocking (to her, at least), but revealing on pegasi subculture.

Will what she learns change the way she looks at her friends? Will her friendship with them be ruined?

Nah.

Nightfall is over Equestria and the moon shines brightly as Princess Luna protects her subjects. However, a creature comes to Equestria in the night, crash landing inside the Everfree. Its arrival will spark a search for things forgotten and bring terrors into the peaceful land. Luna must put the pieces of a mighty puzzle together to protect her ponies, but enemies are around every corner and allies are few and far in-between.

A new being appears in Equestria only one problem he wakes up in bed with Princess Luna, with no idea how he got there. How will everypony react to him? What will princess Celestia do to the first human to enter their world? Will he be banished when they find out his dark secret? Only time will tell.

This is my first fic so please be patient with me, also comments are appreciated.

Thank you

[Requesting Cover Image!] [A STO crossover]
"We are the Borg. Existence as you know it is over. We will add your biological and technological distinctiveness to our own. Resistance is Futile..."

The Borg, a Cybernetic life-form from the Delta Quadrant is a threat to all life in the Alpha Quadrant. The Federation and The Klingon are in a truce against this odd but dangerous enemy, eventually, The New Romulan Republic gave their best in the military to support the frontlines.

However, the Borg seems to give up, each assault become weak or reduced into lone scout parties of a single cube and few probes or spheres.
Starfleet suspect that the Collective has a new target. Capturing a sphere reveals that the borg has their eyes (or optics) in a planet with unusual radiation but no only that, the natives can BEND that radiation, transforming or change it from harmless amount of it into dangerous but controlable ones, Starfleet Suggest in defending the planet from the Borg but also in secret from the natives, because if its inhabitants fall into the hands of the Borg, the war against said menace can turn into a nightmare.

The Alliance of the three factions sent a fleet to the coordinates of said Borg sphere to create an outpost and defend the planet
...
Mainwhile in Equis, Equestria.

The Princesses, Celestia and Luna, have visions about aliens, fighting against abominables machine for the sake of equestria.
fearful about the visions, The Princesses found in the Ancient Archive about a prophecy... a prophecy of Star Soldiers and the Machine Hive.

"Heroes beyong the skies rise against the hive"
"Blue Explorers of the sea of stars brings logic against the odds"
"Red Warriors of Great Honor brings valor against the Horror"
"Green Soldiers of once Mighty Empire brings salvation against damnation"