UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support Editing subjects

Is there a way to edit the subject of every post in a thread at once? I get threads where people put objectionable text in the subject, and it's a pain to fix it all if there's like 20 msgs in said thread and everyone has quoted the same subject.

Is there an SQL query or something along those lines that can be run to do it all at once?

You could do it with 1 sql query if you just wanted every subject to be the exact same, ie: "Subject" and not "Re: Subject"

You'd need to know the first post number for the thread and then you could use the following SQL command:

UPDATE w3t_Posts SET B_Subject='New Subject' WHERE B_Main='ThreadNumber'

If you wanted the first post to be "Subject" and all the others to be "Re: Subject" it would take 2 sql commands:

UPDATE w3t_Posts SET B_Subject='Re: Subject' WHERE B_Main='ThreadNumber'

UPDATE w3t_Posts SET B_Subject='Subject' WHERE B_Main='ThreadNumber' AND B_Topic='1'

Make sure you do a db backup before trying either of these <img src="https://www.ubbcentral.com/boards/images/graemlins/wink.gif" alt="" />

Well, it wouldn't be that bad, you change everything to "Re: whatever", and then manually edit the first one to not have the Re: in it. <img src="https://www.ubbcentral.com/boards/images/graemlins/wink.gif" alt="" />