All the big stuff is done.
ALL the missing subs have a placeholder. If you see Valadaar and Chaosmark over the next few days, give them a great big thanks. It was mostly through their efforts and database skills that we were able to get to where we are. I owe them a giant debt of gratitude that will be difficult to repay appropriately! Also to everybody else that jumped to the rescue with great attitudes and understanding and critical assistance. This so could have went the other way and I very much appreciate everyone's good will about the event. I have family in so will be out of the area for the next week but when I get back I will recognize everyone that assisted!!
We took the April 14th database as the starting point. Val got us back to that point. He restored the forums to their current glory and all the comments/votes etc. He got us to the point where only the submission table was stuck in April 14th. Then Chaos took over and modified the corrupted table, fixed the submisison titles and knocked out some other ruined data. I took that updated file this morning and popped into the current database. With that update we put in 79 private place holders. That is how many submissions were affected by this entire thing.
Right now, if you lost a sub it will be in your DRAFT - PRIVATE collection of your Citadel Profile. Look for subs that were submitted under 50 days ago as of this post.
I updated all the subs to be plots. Without a placeholder it was a mess and caused issues. It will take two updates to change the main category and sub categories but should work no problem.
If you have your own copy, you should be good to go. If not, Check Dossta's thread
to see if we have it saved. If we do, you can grab the text from google docs
. What we have left
-Update the submission comment counts/votes etc. Basically the stats. Don't be surprised if many stats don't exactly match what is shown. All the data is there! We just need to write some scripts to recount and update it to the sub.