PSA: CW downtime and data loss

[Sorunome]

UPDATE: I forgot to mention that one of our member was thankful enough to send us many of the lost posts via e-mail earlier. He had notifications enabled on almost every topic. As a result, he had the posts via e-mail. I would like to thank CKH4 a lot for this.

However, due to being in a different format, it would take a long while to manually convert them and re-introducing them into the DB would require bumping all post IDs from August 9th to present, which isn't necessarily the most ideal scenario (considering the backlash Omni got for doing this, although in their case it's the entire board that got their IDs bumped, not just 100-300 posts). As a result, it is unclear yet if the posts will be re-added or simply made available as archives in a sub-domain.

Just have an admin post all those as himself and then change the DB to adjust the user IDs and the timestamps, after that re-count all the posts forum-wide, that's how I did it with the yaronet posts

[novenary]

That's effort. Also you need to insert some posts between posts.

[Sorunome]

SMF always sorts by timestamps so it won't even care that the IDs are out-of-order

[novenary]

Oh really ? Well that's nice, but weird since threads are linked lists iirc.

[Sorunome]

Oh really ? Well that's nice, but weird since threads are linked lists iirc.

All the posts are stored in {$dbprefix}messages and from there they link to the topic id they are in.

[novenary]

Yeah but each post has a nextpostid thing.

[Dream of Omnimaga]

SMF always sorts by timestamps so it won't even care that the IDs are out-of-order

Nah it stores by ID because when I once tried to merge two databases, dates were not taken into account when sorting from newest to oldest topic. Unless this changed in SMF 2.0?

On a side note, it seems like CKH4 was not subscribed to everything, so while those posts might get restored, some will most likely remain missing. All staff sub-forum posts will be as well except maybe up to August 4.

[Unicorn]

Darn. At least you recovered some things

[princetonlion.tibd]

Now everyone should suscribe to every topic possible

At least we got some posts back, these weeks are my most active weeks in the history of CW

EDIT
And for the CW IRC log part in post 1, I think lines 1, (25), and 26 matter the most

[brentmaas]

I'm fairly sure he just told him that the site was defaced by the guy, since Brentmaas hadn't been around in a while.

*Veeery late respond lol* It's not that I'm not much around (I'm almost daily online), it's just that the site worked for me like one hour before that.

[Dream of Omnimaga]

Oh I meant prior the attack you didn't post for almost 1 month

[alexgt]

Soooo, what happened??? I completely missed it

[novenary]

Basically pimathbrainiac snapped and deleted the entire contents of the server, luckily we had a backup so we could recover, but it still happened. He could because we forgot to remove his server access when he stepped down as an admin.

[Dream of Omnimaga]

That reminds me, I'm still root admin at http://z9.invisionfree.com/Omnimaga

[Sorunome]

SMF always sorts by timestamps so it won't even care that the IDs are out-of-order

Nah it stores by ID because when I once tried to merge two databases, dates were not taken into account when sorting from newest to oldest topic. Unless this changed in SMF 2.0?
[...]

Yeah maybe it's an SMF 2 thing