test please delete

[NickFitz]

How very odd. I can't imagine that many look all the way back in 2006.

And why delete them now after 7 or 8 years?

Could be that they've only just been put on the malware list, and an automated tool admin has removed them?

I'll PM him to ask.

[mudskipper]

And we're back in A&E

[zeitghost]

And we're back in A&E

<-Lizardly.

Nothing too dreadful I hope.

[NickFitz]

In case anybody is interested, I'm using a MySQL database from the TPD spider, when it was crawling about back in 2008, and also have a dump of the thread from the database when I was working on the site in 2010. The site database was a backup sanitised by admin for me to work on, so things like IP addresses or anything else that might identify users in real life in some way were sanitised; but other than that, it's a definitive copy of the thread at the time it was locked.

I've got the TPD spider database on my MacBook in the other room, which I've got up in a Remote Desktop window (though I could use the MySQL client on here, if I could be bothered to switch now I've started doing it this way). I've got the thread in another browser window over here. Having narrowed it down with a binary search, I go page by page checking the last post of each to see if it's off by more than it should be with what I've already identified.

Once I know the first and last missing post IDs I switch to a terminal and use grep on the CSV version of the database dump, matching the first missing post ID at the start of the line and showing x trailing lines. This gives me a quick view of the post contents, so I can spot the domains of the images easily.

For example:

TPD/find deletions$ grep -A20 '^91726' TPDresultset.csv 
91726,4465,91725,"Fortune Green",140,"",1148847661,"[IMG]http://www.example.com/eaglesnest/Larissa/Larissa-04-06_01.jpg[/IMG]",1,0,"192.168.1.1",0,1,0,0,0,0
91727,4465,91726,"Fortune Green",140,"",1148847702,"[IMG]http://www.example.com/eaglesnest/Larissa/Larissa-04-06_02.jpg[/IMG]",1,0,"192.168.1.1",0,1,0,0,0,0
91728,4465,91727,"Fortune Green",140,"",1148847737,"[IMG]http://www.example.com/eaglesnest/Larissa/Larissa-04-06_03.jpg[/IMG]",1,0,"192.168.1.1",0,1,0,0,0,0
91729,4465,91728,"Fortune Green",140,"",1148847770,"[IMG]http://www.example.com/eaglesnest/Larissa/Larissa-04-06_04.jpg[/IMG]",1,0,"192.168.1.1",0,1,0,0,0,0
91730,4465,91729,"Fortune Green",140,"",1148848515,"[IMG]http://www.example.com/eaglesnest/Larissa/Larissa-04-06_09.jpg[/IMG]",1,0,"192.168.1.1",0,1,0,0,0,0
91731,4465,91730,"Fortune Green",140,"",1148848558,"[IMG]http://www.example.com/eaglesnest/Larissa/Larissa-04-06_10.jpg[/IMG]",1,0,"192.168.1.1",0,1,0,0,0,0
91732,4465,91731,"Fortune Green",140,"",1148848590,"[IMG]http://www.example.com/eaglesnest/Larissa/Larissa-04-06_11.jpg[/IMG]",1,0,"192.168.1.1",0,1,0,0,0,0
91733,4465,91732,"Fortune Green",140,"",1148848632,"[IMG]http://www.example.com/eaglesnest/Larissa/Larissa-04-06_12.jpg[/IMG]",1,0,"192.168.1.1",0,1,0,0,0,0
91734,4465,91733,"Fortune Green",140,"",1148848690,"[IMG]http://www.example.com/eaglesnest/Larissa/Larissa-04-06_13.jpg[/IMG]",1,0,"192.168.1.1",0,1,0,0,0,0
91735,4465,91734,"Fortune Green",140,"",1148848722,"[IMG]http://www.example.com/eaglesnest/Larissa/Larissa-04-06_14.jpg[/IMG]",1,0,"192.168.1.1",0,1,0,0,0,0
91736,4465,91735,"Fortune Green",140,"",1148848755,"[IMG]http://www.example.com/eaglesnest/Larissa/Larissa-04-06_15.jpg[/IMG]",1,0,"192.168.1.1",0,1,0,0,0,0
91737,4465,91736,"Fortune Green",140,"",1148848789,"[IMG]http://www.example.com/eaglesnest/Larissa/Larissa-04-06_16.jpg[/IMG]",1,0,"192.168.1.1",0,1,0,0,0,0
91738,4465,91737,"Fortune Green",140,"",1148848823,"[IMG]http://www.example.com/eaglesnest/Larissa/Larissa-04-06_17.jpg[/IMG]",1,0,"192.168.1.1",0,1,0,0,0,0
91739,4465,91738,"Fortune Green",140,"",1148848859,"[IMG]http://www.example.com/eaglesnest/Larissa/Larissa-04-06_18.jpg[/IMG]",1,0,"192.168.1.1",0,1,0,0,0,0
91740,4465,91739,"Fortune Green",140,"",1148848895,"[IMG]http://www.example.com/eaglesnest/Larissa/Larissa-04-06_19.jpg[/IMG]",1,0,"192.168.1.1",0,1,0,0,0,0
91741,4465,91740,"Fortune Green",140,"",1148848931,"[IMG]http://www.example.com/eaglesnest/Larissa/Larissa-04-06_20.jpg[/IMG]",1,0,"192.168.1.1",0,1,0,0,0,0
91742,4465,91741,"Fortune Green",140,"",1148848970,"[IMG]http://www.example.com/eaglesnest/Larissa/Larissa-04-06_21.jpg[/IMG]",1,0,"192.168.1.1",0,1,0,0,0,0
91743,4465,91742,"Fortune Green",140,"",1148849004,"[IMG]http://www.example.com/eaglesnest/Larissa/Larissa-04-06_22.jpg[/IMG]",1,0,"192.168.1.1",0,1,0,0,0,0
91744,4465,91743,"Fortune Green",140,"",1148849039,"[IMG]http://www.example.com/eaglesnest/Larissa/Larissa-04-06_23.jpg[/IMG]",1,0,"192.168.1.1",0,1,0,0,0,0
91745,4465,91744,"Fortune Green",140,"",1148849076,"[IMG]http://www.example.com/eaglesnest/Larissa/Larissa-04-06_24.jpg[/IMG]",1,0,"192.168.1.1",0,1,0,0,0,0
91746,4465,91745,"Fortune Green",140,"",1148850843,"[IMG]http://www.example.com/eaglesnest/Larissa/babes-12-4_18.jpg[/IMG]",1,0,"192.168.1.1",0,1,0,0,0,0

[NickFitz]

Speaking with a little experience, it's a fecking horrid job, though he'll be doing it on a hoist, not crawling about with the damn thing up on ramps.

Changed the tank on the Fiat & the damn thing wouldn't go with 2 gallons in the tank.

Had to put another 2 gallons in to get the pump to prime.

Maybe it's that?

I hope not, as he'll be taking the tank off again for nothing

I'm going to gamble on him knowing what he's doing. I'm sure it's not the first time he's done this

[NickFitz]

And we're back in A&E

[DaveB]

And we're back in A&E

I believe the phrase is "Oh Bugger".

etc.

[NickFitz]

PM sent to admin, asking if he's automated any malware checks recently

[NickFitz]

Finally got around to re-installing the electric blanket. Going to be lovely and warm tonight

[NickFitz]

PM sent to admin, asking if he's automated any malware checks recently

Reply from admin: the site was generating malware warnings due to those links in the FG posts having got onto Google's blacklist, so he had to get rid.

He's hidden the posts at the moment, rather than deleting them, so in principle he can edit them manually and then restore them.

However this will mean things like the 264462 pali will be stolen away from Bunk, and so forth. What's the mood of the TPDenizens? Do we ask for the posts from May 2006 to be restored, or do we accept the situation and continue as we are, onwards and upwards? Speak now, or forever hold your peace