Script that checks for double, triple topics?

[Biology Forums]

Does anyone have a script that checks threads throughout the database that might be doubles?

[margarett]

How do you identify a topic as duplicate of another? Same subject? Same subject and body? What about replies?

I guess you can use a mod which identifies similar topics to the one you're viewing

[Biology Forums]

Could, but with forums greater than 100K threads, it becomes a disaster.

What I'd like the script to do is go through the topic title column and find exact thread titles, list them, and their link, then allow me as the admin to make the determination.

[margarett]

I see
Anyway it will never be an easy or quick computation as it needs to iterate throughout the messages table (topic titles are not stored in topics table, the topic subject is the subject of the first post in it )

[Illori]

What I'd like the script to do is go through the topic title column and find exact thread titles, list them, and their link, then allow me as the admin to make the determination.

if you export that topics table and make a list in excel 2 columns one being the topic subject and the topic id [assuming both in the same table] then do a sort in excel on the subject column then you have your list to look through. not as easy as it could be but better then nothing.

[Biology Forums]

thanks for the suggestions