Previous Thread
Next Thread
Print Thread
Hop To
#40319 04/19/2004 3:18 PM
Joined: Dec 2003
Posts: 30
newbie
newbie
Joined: Dec 2003
Posts: 30
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?


Joe Siegler - Former Infopop Staff
Webmaster: Black Sabbath Online, Dopefish, & 3D Realms
#40320 04/19/2004 9:29 PM
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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="" />

#40321 04/20/2004 1:10 AM
Joined: Dec 2003
Posts: 30
newbie
newbie
Joined: Dec 2003
Posts: 30
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="" />


Joe Siegler - Former Infopop Staff
Webmaster: Black Sabbath Online, Dopefish, & 3D Realms

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
3 members (rootman, Gizmo, Nightcrawler), 562 guests, and 186 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)