krohnathlonman
06-29-2005, 05:18 PM
Anybody know of a way to make something like the mass prune tool only have it MERGE the threads? I've seen the inline mod tools but its still too slow for me. I have alot of similiarly named threads that I'd like to be able to make the merging of topics easier without having to track them down.
UPDATE post SET threadid = THREAD_ID WHERE title LIKE '%THREAD_TITLE%'
DELETE FROM thread WHERE title LIKE '%THREAD_TITLE%' AND threadid <> "THREAD_ID"
got the main queries I need... going to create a form and stuff for it... gotta track down things like rebuilding counts etc which is sorta in the inline mod tools.
UPDATE post SET threadid = THREAD_ID WHERE title LIKE '%THREAD_TITLE%'
DELETE FROM thread WHERE title LIKE '%THREAD_TITLE%' AND threadid <> "THREAD_ID"
got the main queries I need... going to create a form and stuff for it... gotta track down things like rebuilding counts etc which is sorta in the inline mod tools.