Remove timestamp from "delete Duplacate Threads"

[davio33]

I get a lot of duplicate threads when using the rssbot.

The "Delete Duplicate Threads" tool only works on threads with the same author, title, and timestamp. These threads will have the same author and title, but becuase the time stamp is different, the tool has no effect on them.

Is there a way to get the "Delete Duplicate Threads" to ignore the timestamps?

[kh99]

I think you'd have to edit the code. in admincp/misc.php around line 1386 is this:

$deletethreads = $db->query_read("
	SELECT *
	FROM " . TABLE_PREFIX . "thread
	WHERE title = '" . $db->escape_string($thread['title']) . "' AND
		forumid = $thread[forumid] AND
		postusername = '" . $db->escape_string($thread['postusername']) . "' AND
		dateline = $thread[dateline] AND
		threadid > $thread[threadid]
");

I think if you delete the line in red it should ignore the timestamp. (Edit - You can't comment it out with // because it's in the middle of a string)

[davio33]

Thank you, that seems to have done the trick. I appreciate your help

[Dr Jeeni]

Nice solution if you would like run it on specific forums then check here