Sennex 1,903 Posted June 16, 2016 Share Posted June 16, 2016 We lost 8 days worth of forum messages. From: 2016-06-08 16:39:51 ->2016-06-16 04:55:04 However, all of the Topic Headers are still there. This is an issue; and could bite me in the ass later (As the resident SQL guy) The reason this is an issue is because Topic Subjects/ headers, are in a seperate table from the actual Posts that we all read in the topics. The Disconnect between the two tables shouldn't ever be an issue, but it could be, if I do not remove the headers. So that being said, I am looking for ANY TOPIC STARTED between the above date ranges. I need to remove them. This includes a lot of popular topics. Sorry I am going to attempt to do this manually, and not automate it, so bear with me. Also, if you notice orphaned records out there (Empty topics with only a subject.) Please post them here with links. Luke 23:34 'And Jesus said, "Father, forgive them, for they don't think it be like it is, but it do." Link to comment Share on other sites More sharing options...
The3rdWalker 1,263 Posted June 16, 2016 Share Posted June 16, 2016 Bart, threads are just data and our memories are forever. You know better than I do, so do what you do best! Thanks for taking the time to do this. i7 7700k, 16GB RAM, GEFORCE 1080, 240GB SSHD, 2TB SSD Link to comment Share on other sites More sharing options...
Sennex 1,903 Posted June 16, 2016 Author Share Posted June 16, 2016 My going rate for side work is $95 an hour. Luke 23:34 'And Jesus said, "Father, forgive them, for they don't think it be like it is, but it do." Link to comment Share on other sites More sharing options...
Sennex 1,903 Posted June 16, 2016 Author Share Posted June 16, 2016 List of threads getting nuked: Ubisoft 'Downgrades' 3660Infinite Warfare Campaign Gameplay 3671The Technomancer 3661Florida Night Club shooting (50 dead) 3662EA Play Conference 2016 3663Titanfall 2 Megathread 3664Xbox One S + Xbox One Scorpio 3665FIFA 17 3666Battlefield 1 Multiplayer Gameplay 3667Skyrim Special Edition [Remastered] 3669Dishonored 2 3668Battlefield 1 Maps 3670Hideo Kojima's Death Stranding 3672French Jihadist murders police couple 3673A BF1 criticism I agree with 3674Pond up and running for the summer 3675The War Within 3676The Legend of Zelda: Breath of the Wild - OfficialGame Trailer 3677DayZ 0.60 now live 3680Jeff Kaplan on Overwatch 3678Windows 10 - worth it? 3679 Luke 23:34 'And Jesus said, "Father, forgive them, for they don't think it be like it is, but it do." Link to comment Share on other sites More sharing options...
lepercolony 275 Posted June 16, 2016 Share Posted June 16, 2016 you're a good dude, that sounds like a lot of work. Link to comment Share on other sites More sharing options...
Sennex 1,903 Posted June 16, 2016 Author Share Posted June 16, 2016 Its partially done DO NOT POST TO ANY OF THE THREADS I MENTIONED ABOVE Luke 23:34 'And Jesus said, "Father, forgive them, for they don't think it be like it is, but it do." Link to comment Share on other sites More sharing options...
Drifter 851 Posted June 16, 2016 Share Posted June 16, 2016 No biggie it's just posts, anything important can be reposted so don't sweat it Link to comment Share on other sites More sharing options...
Sennex 1,903 Posted June 16, 2016 Author Share Posted June 16, 2016 Thanks man. This shit can be maddening! And I don't mean turning me into an NFL announcer So!!!!!!!!!!! Update posted into Original Link. Luke 23:34 'And Jesus said, "Father, forgive them, for they don't think it be like it is, but it do." Link to comment Share on other sites More sharing options...
tronic44 3,628 Posted June 16, 2016 Share Posted June 16, 2016 Great work dude! Like others have said, thanks for going to so much effort with all of this. Link to comment Share on other sites More sharing options...
lepercolony 275 Posted June 16, 2016 Share Posted June 16, 2016 Thanks man. This shit can be maddening! And I don't mean turning me into an NFL announcer ouch. this was so bad i laughed. Link to comment Share on other sites More sharing options...
phil.bottle 1 Posted June 16, 2016 Share Posted June 16, 2016 Karma for me adding two new topics on one day DayZ guys, check out 0.6 And thanks a lot Bart, you the man, what a pain in the arse for you guys, appreciated ; ) Link to comment Share on other sites More sharing options...
J4MES OX4D 9,791 Posted June 16, 2016 Share Posted June 16, 2016 Just hope we ain't lost too many tits and arses in the T&A thread Karma for me adding two new topics on one day DayZ guys, check out 0.6And thanks a lot Bart, you the man, what a pain in the arse for you guys, appreciated ; ) Why you posting from a new account Phil? Don't tell me you've been deleted also Link to comment Share on other sites More sharing options...
phil.bottle 1 Posted June 16, 2016 Share Posted June 16, 2016 This is some spectre level bullshit lol Link to comment Share on other sites More sharing options...
Sennex 1,903 Posted June 16, 2016 Author Share Posted June 16, 2016 It didn't look like the Users Table had been affected. Do I need to look more into that Phil? Luke 23:34 'And Jesus said, "Father, forgive them, for they don't think it be like it is, but it do." Link to comment Share on other sites More sharing options...
phil bottle 9,579 Posted June 16, 2016 Share Posted June 16, 2016 It didn't look like the Users Table had been affected. Do I need to look more into that Phil? Just seems to be the Tapatalk account. On PC right now and no problem. Link to comment Share on other sites More sharing options...
Sennex 1,903 Posted June 16, 2016 Author Share Posted June 16, 2016 Well I have ZERO idea how that interacts, but I will try to look into it later Luke 23:34 'And Jesus said, "Father, forgive them, for they don't think it be like it is, but it do." Link to comment Share on other sites More sharing options...
GazzaGarratt 10,871 Posted June 16, 2016 Share Posted June 16, 2016 Nice job Bart, I'll buy you a beer when i see you next [emoji6] Genuinely though, total legend. Link to comment Share on other sites More sharing options...
Plumbers Crack 4,033 Posted June 16, 2016 Share Posted June 16, 2016 Thanks for all this Bart....and at the same time as putting up with our football on WhatsApp! Thanks to Capn_Underpants for the artwork Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now