annebaneriddle

[annebaneriddle]

"Started as a question, ended as a fact when I found out I'm the only one that has my back" 😭😭😭😭

"Climbing up this mountain, climbing up twice, hoping that I'll make it this time, but I'm so done with hoping" This Mountain, Faouzia.

[annebaneriddle]

Hold up, I think I got this.

How to recover fic deleted from AO3 that’s NOT on the Wayback machine

Sharing this because I just found out about this and it blew my mind.

The short version of it is: The Wayback Machine is not the only backup/archive of AO3 content out there. It’s just the most user-friendly and immediately browsable.

THIS database on Archive.org contains most AO3 fics as text files, including plenty that are not Waybacked: https://archive.org/details/AO3_final_location

What you’ll need: A browser for .sqlite3 files such as DB Browser for SQLite, an archive manager (e.g. WinRar or 7zip), good internet download speeds, and potentially a LOT of free GBs in storage space.

Not needed but heavily recommended: A download manager such as HTTP Downloader (so you don’t lose the entire download the second your internet stutters).

1. Click here to get to the archive’s files. It’s going to look something like this:

ao3_current.sqlite3 and ao3_old_files.sqlite3 are metadata files. The .zip files contain fic, most of them in simple .txt format. The metadata files tell you which fic is in which zip.

The “current” metadata file is recent backups. The “old” metadata file seems to be fics archived until 2020ish.

2. First, download either ao3_current.sqlite3 or ao3_old_files.sqlite3. Now launch DB Browser for SQlite, then File > Open Database Read-Only > open the sqlite3 file. Now click on the Browse Data tab.

3. It’s going to look like this.

4. The “Filter in any column” field can be used for keyword searches in, well, any column of this table. Be warned, it takes a while to update, give it time, it’s indexing.

5. Here I searched for all fic which gets a hit for the “Avengers” keyword (usually fandom). You can also search for a specific title, author, description, etc.

Let’s try to locate the first fic on the list. Click on the field on the left - row 1, column 1.

On the right you’ll see the full content of that cell. The most important thing here is the start - ao3_01. This means that the fic is located in ao3_old_files_part01.zip.

6. Download ao3_old_files_part01.zip and open it with your archive manager. It’s 5.5 GB. This will take some time.

7. There are multiple ways to find the fic within the zip file. Probably the easiest way is to use your archive manager’s search/find function to locate the fic by keyword - author is a good bet here, or title if it’s unique enough - and extract that. This way you don’t have to extract the entire archive. Be sure to add a wildcard operator (*) on either side of the keyword.

8. Extract the file and you’re done. Note: It will probably be in .txt format, and might be in one giant block of text. Just select-all and paste it to a proper word processor to restore the paragraph formatting.

+ I suppose if you’ve got like a free TB of space you could just skip the metadata step and download all the zip files and unzip them and use a command line search tool for keywords, too. This will work with keywords like title, author and fandom that are part of the file title. The metadata file just contains additional info, like character fields, description, etc.

This isn’t a perfect remedy, there are still fics that got deleted before they could get archived here. But it seems more complete than the stuff on the Wayback Machine on average.

[annebaneriddle]

If I told you I understood any of this, I would be lying. Can anyone please explain to me as if you're explaining to a 5yo?

How to recover fic deleted from AO3 that’s NOT on the Wayback machine

Sharing this because I just found out about this and it blew my mind.

The short version of it is: The Wayback Machine is not the only backup/archive of AO3 content out there. It’s just the most user-friendly and immediately browsable.

THIS database on Archive.org contains most AO3 fics as text files, including plenty that are not Waybacked: https://archive.org/details/AO3_final_location

What you’ll need: A browser for .sqlite3 files such as DB Browser for SQLite, an archive manager (e.g. WinRar or 7zip), good internet download speeds, and potentially a LOT of free GBs in storage space.

Not needed but heavily recommended: A download manager such as HTTP Downloader (so you don’t lose the entire download the second your internet stutters).

1. Click here to get to the archive’s files. It’s going to look something like this:

ao3_current.sqlite3 and ao3_old_files.sqlite3 are metadata files. The .zip files contain fic, most of them in simple .txt format. The metadata files tell you which fic is in which zip.

The “current” metadata file is recent backups. The “old” metadata file seems to be fics archived until 2020ish.

2. First, download either ao3_current.sqlite3 or ao3_old_files.sqlite3. Now launch DB Browser for SQlite, then File > Open Database Read-Only > open the sqlite3 file. Now click on the Browse Data tab.

3. It’s going to look like this.

4. The “Filter in any column” field can be used for keyword searches in, well, any column of this table. Be warned, it takes a while to update, give it time, it’s indexing.

5. Here I searched for all fic which gets a hit for the “Avengers” keyword (usually fandom). You can also search for a specific title, author, description, etc.

Let’s try to locate the first fic on the list. Click on the field on the left - row 1, column 1.

On the right you’ll see the full content of that cell. The most important thing here is the start - ao3_01. This means that the fic is located in ao3_old_files_part01.zip.

6. Download ao3_old_files_part01.zip and open it with your archive manager. It’s 5.5 GB. This will take some time.

7. There are multiple ways to find the fic within the zip file. Probably the easiest way is to use your archive manager’s search/find function to locate the fic by keyword - author is a good bet here, or title if it’s unique enough - and extract that. This way you don’t have to extract the entire archive. Be sure to add a wildcard operator (*) on either side of the keyword.

8. Extract the file and you’re done. Note: It will probably be in .txt format, and might be in one giant block of text. Just select-all and paste it to a proper word processor to restore the paragraph formatting.

+ I suppose if you’ve got like a free TB of space you could just skip the metadata step and download all the zip files and unzip them and use a command line search tool for keywords, too. This will work with keywords like title, author and fandom that are part of the file title. The metadata file just contains additional info, like character fields, description, etc.

This isn’t a perfect remedy, there are still fics that got deleted before they could get archived here. But it seems more complete than the stuff on the Wayback Machine on average.

[annebaneriddle]

I've already seen AUs of Percy being desi, black, and even latino, but you guys are really sleeping on the chance of making an AU with him being maori.

[annebaneriddle]

Does anyone here have the fanfic when i close my eyes and think of you (내게만 봄이 온 것만 같아) by kyeowoolie downloaded? And, if you do, would you please send it to me?

[annebaneriddle]

I'm constantly surprised that you're still my friend after so many years, but I'm forever grateful that you are ❤️

@fighting-god-69

(Because I’m extremely bored I’m gonna start a reblog chain game. I’m gonna regret this ✌️)

Use one sentence to describe the person who @ you

@l1ttleclouds @vtoriacore @rayisalive @bobasis @ithseem @bitchkay @atomsminecraft @jaysquid @sallylovessweets @marsipanic @ihavesinn3d4lot @fempire-kitty and anyone who wants to join 💀

[annebaneriddle]

Yearning Sky

The cold on my face is a baptism,

It stings like a reckoning to God

It's a winter morning and the world is painted in shades not of the air

Watercolor dripping in the atmospheres hair,

Tree branches doused in opaque fire,

Like an altar offering to a sky they can't hold,

Sunrise turning contrails to a foreign gold,

The world on a wire between the beginning and the end

I wonder if the sky covers us in color to make up for letters it can't send

Like someone screaming "I love you" on a cliff face

Thinking of what could never be

We think of the sky as an untouchable place

A personification of the free

We never think that it's watching us, wishing to connect

But to us the sky is just the sky

And so we never suspect

That the maybe sky gets lonely with a yearning to join the world

Trying to talk through the wind

Caress us with its whirls

But we will never know

So we walk on past the sky

As it gazes like a schoolgirl in love

Hovering it's hands over our heads

An indulgence of imagined touch

[annebaneriddle]

WHY SO CUTE??? 😭😭😭

baby foxxian and baby dragonji sleeping shhh

[annebaneriddle]

Lwj would have an overload of cuteness and I don’t blame him for it. Wwx is the cutest, a complete angel.

WWX always so happy when LWJ appears makes me think on reincarnated WWX who remebers all his other life and is so fucking happy when he sees LWJ again after years he almost can't help but jump in happines

LWJ don't remember so "why is this man doing little jumps behind this wall and why is so cute?"

[annebaneriddle]

every single time steve wears a leather jacket it is brown

in endgame it was black indicating he was a bad man (imposter) about to make bad choices. in this essay I will —

[annebaneriddle]

I've just noticed something and I'm totally losing it.

So, he all know how, considering the occidental zodiac signs, Wei Wuxian is a scorpio and Lan Wangji an aquarius.

Whoever follows me for a long time is aware that one of the works I love most is Saint Seiya. I was rewatching it and it came to my mind how Camus's personality reminds me of Lan Wangji and Milo's personality reminds me of Wei Wuxian.

Everyone in the Saint Seiya fandom knows that one of the fandom's most loved ship, if not THE most loved, is Camus x Milo.

Why I'm pointing it out? Because Camus, who is the saint of aquarius, reminds me of Lan Wangji, whose zodiac sign is aquarius, and Milo, who is the saint of scorpio, reminds me of Wei Wuxian, whose zodiac sign is scorpio.

Stupid coincidence? Yes, but now I can't stop making fanfics on my mind of Wei Wuxian and Lan Wangji reincarnating centuries later. Lan Wangji is reincarnated as a French child named Camus, and Wei Wuxian is reincarnated as a Greek child named Milo. Everything is cooperating for the two soulmates not to meet in that reincarnation, but one day they're both taken to Athena's sanctuary to train to become golden saints, and they meet each other again and fall in love all over again.

[annebaneriddle]

My boi just wants a damn break from all that stupid drama, and that's relatable af.

mdzs is so funny because while almost every single one of the main generation is playing some kind of multidimensional chess against each other, lwj was literally just over there vibing, wanting to fuck his husband, raise their son, tend to his rabbits, and kill some evil spirits, like he never asked for any of these shenanigans.

[annebaneriddle]

Accurate af

[annebaneriddle]

cisswap wlw wangxian trainer au!

wy decides to go back to the gym after having her son and meets personal trainer lz

[annebaneriddle]

A headcanon of mine that no one asked for, but that I just can't get out of my head: Mo Xuanyu looking so much like Wei Wuxian because Mo Xuanyu's grandmother, second young maiden Mo's mother, is Wei Changze's older sister.

[annebaneriddle]

*smashes fist on the table* men could and should be drawn in stupid sexy poses too amirite or amirite

(patreon special from a couple months back)

[annebaneriddle]

“No, please, don't take him away. Let's make a deal. I'm not afraid.”