In order to understand the present, we have to look to the past. And there's no past as great as the rise of King Alicorn and the Keepers of Harmony. With love, war, discords, caves, mental institutions-- and, most importantly, the first magical friendship-- it was certainly something Celestia would never forget.
Other stories in the history archives:

The Diary of Diddy Discord
A Slice of ol' Waddle's Life
The Journals of Silas Sombra

This story is based on the Arthurian Legend but it is not imperative that you know everything about it.
In the comments area there will be written links for each new Legend as to how it influences Ponyville as we know it today, and how it is linked to the Arthurian Legends.

Picture courtesy of DreamWings industries (my hand in other words).
Main proofreading done by KartalTheWriter.
Additional proofreading done by Not Worthy and Tyrell the Dragon.
Overview of ideas helped by Samaru163 and KartalTheWriter.

This is a revamped version of the winner of the first Author Support Prompt.

Lost, alone and scared. The three words that sum up Scootaloo's life now that everything has changed. With no cutie mark, no crusaders to back her up, and all of these murders going on around Equestria, how is the older mare going to cope with being the only 'sane' one left in Equestria?

It's so unfair. It's unbearable. And the loss of life keeps growing and growing until there may be no more to tell the tale.

One by One truly is the lonliest number.

Link for artist of picture: http://ponysquare.com/file/pic/photo/2012/05/e65d44baca7b84a925e10daacd3f48a6_500.jpg

Rairty has long since been searching for that one pony who can sweep her off her feet and tell her that he loves her more than every other pony that he has ever met in his life. After her failure at finding her true Prince at the Gala she may have finally found that one pony who is exactly the way she had always dreamed him to be. Her one true love may still be out there somewhere.

Picture by Shepony.deviantart.com.

It's about time somebody heard my tale...our tale. It can get lonely up in space; even more so when you do not appear to have any heart in the first place. I never imagined that as I took my first steps on the moon I would meet a creature so beautiful and....lonely.

The blue pony will have wanted this tale to be heard...somebody needs to save her someday. Can you help her?

'My Daddy told me to write this story you know?...My Daddy's great.'

Many years after Discord was defeated we look back into what his life was like growing up through his own eyes, how he came to be such a monster, and how he saw the world right from the begining.

Other stories in the history archives:
The Legend of Alicorn
A Slice of ol' Waddle's Life
The Journals of Silas Sombra

A big thanks to Enderstorm for doing the new amazing artwork for Diddy. Cute isn't he?

Just to say that Diddy means small. It seemed to be a word some people didn't understand but that's what it means.
A big Thankyou to Tricondon who thus far has pre-read every one of the diary entries

Original story idea and title was Cid Gaius in the Author Support group threads. Thanks for the great storyline to work with Cid.

Pound and Pumpkin Cake come together with other ponies to commemerate the life of a very special pink party pony that everypony knew and loved.

I can't have been the only one who thought that this was what was actually going to be the result of who ate the marzipan marscapone Meringue madness. So I decided to write a sort of alternate ending to the show...

And chucked Poirot in there for a bit of a laugh.

Hope you enjoy, mystery lovers (and lovers of cake of course).

Twilight Sparkle always knew she was brilliant at magic but she didn't realise she was good enough to become a Xiaolin dragon... and a good one at that. Her new friends seem to be confused by her pony demeanour but nevertheless have to put up with their pony friend no matter what, especially with a new few villains to contend with and some strange Shen gong wu to find in the newest of places...

I do not in anyway own Xiaolin Showdown or My Little Pony. I just love them both so much that I decided to see what would happen if they met. Props to Tara Strong who voiced in both. Picture 'Angry Twilight' by Ivan Chan and uniform added by me. Anyways hope you enjoy.

Both Sour Apple and Dream Wings have different reasons for needing to go and stay with ponies in Ponyville.
Sour has to go and spend time with his cousin Apple Jack and her friends despite his instant dislike for every pony around him. Dream Wings on the other hand needs to see a very old friend from Canterlot in order to hide from a creature that she has hidden in fear from every day since she was a young filly. However will these two new ponies be the one thing that manages to split apart the Elements and harmony, and consequentially the kingdom, forever? Or will they be the one thing that can stop the nightmare during daytime?