2010-03-04, 02:06 PM
Well, luckily I had your mirror site to compare topics/messages with else I would have been screwed.
There is probably an easier way out there to fix the problem, I am however not smart enough to know what it is.
I found an old decemberish backup I think you made of the forums lying around the server...so I pulled the sql dump and opened it in wordpad hehe.
I then made a new dump of the smf_messages and smf_topics table from the current backup from yesterday.
Then I had to do two things....I had to filter through all the smf_topics table and add in everything that was missing in the new table vs the old one...thankfully in all but one topic, nothing had been overwritten (for some reason the database has written data into the same topic number as the one that contained "cheater!!!" and i couldnt get all the posts to show up).
Then I had to go through the whole smf_topics dump and copy/paste all the messages back in by using a 'find' function for the topic headers. Not rocket science, but very time consuming...especially since for whatever reason wordpad was not playing nice in the highlighting dept.
But anyways its here, and I will never prune the forums again!
There is probably an easier way out there to fix the problem, I am however not smart enough to know what it is.
I found an old decemberish backup I think you made of the forums lying around the server...so I pulled the sql dump and opened it in wordpad hehe.
I then made a new dump of the smf_messages and smf_topics table from the current backup from yesterday.
Then I had to do two things....I had to filter through all the smf_topics table and add in everything that was missing in the new table vs the old one...thankfully in all but one topic, nothing had been overwritten (for some reason the database has written data into the same topic number as the one that contained "cheater!!!" and i couldnt get all the posts to show up).
Then I had to go through the whole smf_topics dump and copy/paste all the messages back in by using a 'find' function for the topic headers. Not rocket science, but very time consuming...especially since for whatever reason wordpad was not playing nice in the highlighting dept.
But anyways its here, and I will never prune the forums again!
- Todd DuFore (DMPDesign)
Site Founder
Site Founder