RowdyFan42 Posted November 5, 2007 Share Posted November 5, 2007 C'mon Rowdy, use your skills and find a way! It may be possible to write a SQL query that finds any post with a certain keyword (or one of a list of keywords, such as "Ledger" or "Star Ledger" or "nj.com", etc.) and moves the entire thread into a new, hidden forum. (Said query can be tweaked to deal with the Post, the Bergen Record, TSN, etc.) Getting them out of public view should be enough to satisfy the lawyers. From there, they can be manually reviewed and taken care of as necessary. Link to comment Share on other sites More sharing options...
El Diablo Posted November 5, 2007 Share Posted November 5, 2007 Cmon lets get a 1000 monkeys working on it right away ... Link to comment Share on other sites More sharing options...
sammyk Posted November 5, 2007 Share Posted November 5, 2007 (edited) It may be possible to write a SQL query that finds any post with a certain keyword (or one of a list of keywords, such as "Ledger" or "Star Ledger" or "nj.com", etc.) and moves the entire thread into a new, hidden forum. (Said query can be tweaked to deal with the Post, the Bergen Record, TSN, etc.) Getting them out of public view should be enough to satisfy the lawyers. From there, they can be manually reviewed and taken care of as necessary. Edited November 5, 2007 by sammyk Link to comment Share on other sites More sharing options...
njdevils_info Posted November 5, 2007 Share Posted November 5, 2007 It may be possible to write a SQL query that finds any post with a certain keyword (or one of a list of keywords, such as "Ledger" or "Star Ledger" or "nj.com", etc.) and moves the entire thread into a new, hidden forum. (Said query can be tweaked to deal with the Post, the Bergen Record, TSN, etc.) Getting them out of public view should be enough to satisfy the lawyers. From there, they can be manually reviewed and taken care of as necessary. Link to comment Share on other sites More sharing options...
DevilMinder Posted November 5, 2007 Author Share Posted November 5, 2007 I don't do dangerous! And NJ0.com gets mentioned a lot. Is there a way to tweak that? star+ledger+Staff work ? Link to comment Share on other sites More sharing options...
Devilish34 Posted November 5, 2007 Share Posted November 5, 2007 I just edited about 20 of my own hope that helps Link to comment Share on other sites More sharing options...
CRASHER Posted November 5, 2007 Share Posted November 5, 2007 Wow, that's more absurd then the stuff WWE does and I don't see how they can make you have to do something that happened BEFORE a cease order?? Bah, I'm just glad my brother in law works for the Daily News Link to comment Share on other sites More sharing options...
sammyk Posted November 5, 2007 Share Posted November 5, 2007 I don't do dangerous! And NJ0.com gets mentioned a lot. Is there a way to tweak that? star+ledger+Staff work ? Link to comment Share on other sites More sharing options...
RowdyFan42 Posted November 5, 2007 Share Posted November 5, 2007 Sammy, I think DM means that he wants to minimize the number of false positives. Link to comment Share on other sites More sharing options...
sammyk Posted November 5, 2007 Share Posted November 5, 2007 Ah, I guess I misread that Oh well. Link to comment Share on other sites More sharing options...
threestars Posted November 5, 2007 Share Posted November 5, 2007 If you are in need of willing minions to help out with the monotonous post editing, I am willing to volunteer my services. Link to comment Share on other sites More sharing options...
Devilish34 Posted November 5, 2007 Share Posted November 5, 2007 If you are in need of willing minions to help out with the monotonous post editing, I am willing to volunteer my services. It wouldn't take too long if ppl just checked their own and fixed it themselves. Esp since I'm sure going back to last season should be far enough maybe Link to comment Share on other sites More sharing options...
squishyx Posted November 5, 2007 Share Posted November 5, 2007 It wouldn't take too long if ppl just checked their own and fixed it themselves.Esp since I'm sure going back to last season should be far enough maybe I think the problem is that its just a few select posters with years of dedicated postings. Yeah obviously if you have posted one or 2 or even 50 articles in the past if you could go back and fix it up I think thats implied. But we are talking about helping with the few thousand posts made by a few people because it would be tedious for any person to go through them all. Link to comment Share on other sites More sharing options...
sammyk Posted November 5, 2007 Share Posted November 5, 2007 I think the problem is that its just a few select posters with years of dedicated postings. Yeah obviously if you have posted one or 2 or even 50 articles in the past if you could go back and fix it up I think thats implied. But we are talking about helping with the few thousand posts made by a few people because it would be tedious for any person to go through them all. Most are likely by Rock and SC. SC still posts here so maybe he can do his own and DM can do Rock's? Link to comment Share on other sites More sharing options...
squishyx Posted November 5, 2007 Share Posted November 5, 2007 Most are likely by Rock and SC. SC still posts here so maybe he can do his own and DM can do Rock's? It's still a ton to sort through. I went through some of my old ones, i did about 1 per minutes. Even at twice that speed, its still about like 16 hours worth of work just opening and editing threads. Link to comment Share on other sites More sharing options...
Devilish34 Posted November 5, 2007 Share Posted November 5, 2007 (edited) I think the problem is that its just a few select posters with years of dedicated postings. Yeah obviously if you have posted one or 2 or even 50 articles in the past if you could go back and fix it up I think thats implied. But we are talking about helping with the few thousand posts made by a few people because it would be tedious for any person to go through them all. Every little bit helps ----------------- DONE Edited November 5, 2007 by Devilish34 Link to comment Share on other sites More sharing options...
NJDevs4978 Posted November 5, 2007 Share Posted November 5, 2007 Another question...why is it only the Ledger that's pressing action against the site? If anything I'd think the Post or other newspapers would whine and moan too (especially since we make fun of the Post ten times more than the Ledger ). Link to comment Share on other sites More sharing options...
DevilMinder Posted November 5, 2007 Author Share Posted November 5, 2007 I just got an interesting link sent to me. It would appear the Star Ledger is probably just the start of our problems. http://www.nytimes.com/2007/11/05/business...and&emc=rss Link to comment Share on other sites More sharing options...
Devils731 Posted November 5, 2007 Share Posted November 5, 2007 Another question...why is it only the Ledger that's pressing action against the site? If anything I'd think the Post or other newspapers would whine and moan too (especially since we make fun of the Post ten times more than the Ledger ). Link to comment Share on other sites More sharing options...
Weekes Head Posted November 5, 2007 Share Posted November 5, 2007 I just got an interesting link sent to me. It would appear the Star Ledger is probably just the start of our problems. http://www.nytimes.com/2007/11/05/business...and&emc=rss Link to comment Share on other sites More sharing options...
squishyx Posted November 5, 2007 Share Posted November 5, 2007 I just got an interesting link sent to me. It would appear the Star Ledger is probably just the start of our problems. http://www.nytimes.com/2007/11/05/business...and&emc=rss Link to comment Share on other sites More sharing options...
njdevils_info Posted November 6, 2007 Share Posted November 6, 2007 DM, those "UPDATE" commands can be very easily changed to "SELECT" commands, and then using a program like phpMyAdmin (which should be provided by your Web Hosting) you can view all of the results before you go ahead and change anything. Of course those queries can be tweaked by adding commands like WHERE `body` LIKE "%nj.com%" AND `body` LIKE "%Rich Chere%" Please let me know if I can be of any further help. Anything that uses MySQL can be easily manipulated, its just a matter of tweaking the command to eliminate as many false positives as possible. Oh, and always always always make a backup of the database before you do anything! words of advice from someone whose made this mistake in the past! Link to comment Share on other sites More sharing options...
njdevils_info Posted November 6, 2007 Share Posted November 6, 2007 You can also do commands like WHERE (`body` LIKE "%<a href="http://nj.com/%" OR `body` LIKE "%<a href="http://www.nj.com/%") AND (`body` LIKE "%Rich Chere%" OR `body` LIKE "%Other Common Writer%") Link to comment Share on other sites More sharing options...
sammyk Posted November 6, 2007 Share Posted November 6, 2007 Geeks to the rescue! Weird, my brother in law just told me to use such commands to change all the prices on my website so it actually looks familiar! Link to comment Share on other sites More sharing options...
NJD Jester Posted November 6, 2007 Share Posted November 6, 2007 Just wanted to point out that I read the posts on articles by Chere, (N)Єverson and Gulitti today but not the actual articles. Had they been posted in this forum, I would have read them. But I really don't have the time to leave this site and read them elsewhere. Oh well... <JESTER> Link to comment Share on other sites More sharing options...
Recommended Posts