Edit Subject
Posted by Chris Brown
Edit Subject July 28, 2008 10:47AM |
Registered: 15 years ago Posts: 154 |
Good Morning...
When I edit a thread subject, and there is already some posts, the thread subject changes, but not the Re: Subjects.
Is there a way to do this? 'Cause sometimes, I need to change a subject, example:
Original:
TOMORROW: Meeting
-Re: TOMORROW: Meeting
-Re: TOMORROW: Meeting
-Re: TOMORROW: Meeting
-Re: TOMORROW: Meeting
-Re: TOMORROW: Meeting
Changed:
TODAY: Meeting
-Re: TOMORROW: Meeting
-Re: TOMORROW: Meeting
-Re: TOMORROW: Meeting
-Re: TOMORROW: Meeting
-Re: TOMORROW: Meeting
Thanks...
Christian
When I edit a thread subject, and there is already some posts, the thread subject changes, but not the Re: Subjects.
Is there a way to do this? 'Cause sometimes, I need to change a subject, example:
Original:
TOMORROW: Meeting
-Re: TOMORROW: Meeting
-Re: TOMORROW: Meeting
-Re: TOMORROW: Meeting
-Re: TOMORROW: Meeting
-Re: TOMORROW: Meeting
Changed:
TODAY: Meeting
-Re: TOMORROW: Meeting
-Re: TOMORROW: Meeting
-Re: TOMORROW: Meeting
-Re: TOMORROW: Meeting
-Re: TOMORROW: Meeting
Thanks...
Christian
Re: Edit Subject July 28, 2008 10:58AM |
Admin Registered: 19 years ago Posts: 8,532 |
Yes. Go into all the reply messages and change the subject accordingly.
The idea of also updating the reply messages that have "Re: <original subject>" is on my idea list already. But it has no high priority to be implemented.
Maurice Makaay
Phorum Development Team
my blog linkedin profile secret sauce
The idea of also updating the reply messages that have "Re: <original subject>" is on my idea list already. But it has no high priority to be implemented.
Maurice Makaay
Phorum Development Team
my blog linkedin profile secret sauce
Re: Edit Subject July 28, 2008 11:31AM |
Registered: 15 years ago Posts: 154 |
Re: Edit Subject July 28, 2008 11:36AM |
Registered: 17 years ago Posts: 1,301 |
If you are willing to do the phpmyadmin work you could run this SQL code:
Replace YOUR_NEW_SUBJECT with the new subject (ie. "Re: TODAY: Meeting"),
Replace YOUR_MESSAGE_ID with the message id of the first message (ie. with the new subject "TODAY: Meeting").
Replace YOUR_OLD_SUBJECT with the old subject (ie. "Re: TOMORROW: Meeting").
Now run the query. This will update all of the sub messages with the new subject line.
Joe Curia (aka Azumandias)
Modules: l0Admin Mass Email00000000l000000Automatic Time Zones000ll.l00000Enhanced Custom Profiles0.00Google Calendar0000l.l000000Post Previews
000000000Admin Security Suite000000000000Check Modules for Upgrades0000External Authentication000000Group Auto-Email00000.00000Private Message Alerts
000000000Attachment Download Counter0000Custom Attachment Icons000ll.ll00Favorite Forums000000.00000Highlighted Search Terms0000Self-Delete Posts Option
000000000Attachment Watermarks0l00000000Custom Language Database00l.l.0Forum Lockdown00000.00000Ignore Forums0000000000000Threaded Tree View
000000000Automatic Message Pruning00.llll.00Easy Color Scheme Manager0l.l00Forum Subscriptions0000lll000Moderated User Group
Templates:lGeneric Integration000000000 0000Simple Rounded000000 00000000Tabbed Emerald
UPDATE YOUR_MESSAGES_TABLE SET subject = 'YOUR_NEW_SUBJECT' WHERE thread = YOUR_MESSAGE_ID AND subject = 'YOUR_OLD_SUBJECT';Replace YOUR_MESSAGES_TABLE with the name of your messages table.
Replace YOUR_NEW_SUBJECT with the new subject (ie. "Re: TODAY: Meeting"),
Replace YOUR_MESSAGE_ID with the message id of the first message (ie. with the new subject "TODAY: Meeting").
Replace YOUR_OLD_SUBJECT with the old subject (ie. "Re: TOMORROW: Meeting").
Now run the query. This will update all of the sub messages with the new subject line.
Joe Curia (aka Azumandias)
Modules: l0Admin Mass Email00000000l000000Automatic Time Zones000ll.l00000Enhanced Custom Profiles0.00Google Calendar0000l.l000000Post Previews
000000000Admin Security Suite000000000000Check Modules for Upgrades0000External Authentication000000Group Auto-Email00000.00000Private Message Alerts
000000000Attachment Download Counter0000Custom Attachment Icons000ll.ll00Favorite Forums000000.00000Highlighted Search Terms0000Self-Delete Posts Option
000000000Attachment Watermarks0l00000000Custom Language Database00l.l.0Forum Lockdown00000.00000Ignore Forums0000000000000Threaded Tree View
000000000Automatic Message Pruning00.llll.00Easy Color Scheme Manager0l.l00Forum Subscriptions0000lll000Moderated User Group
Templates:lGeneric Integration000000000 0000Simple Rounded000000 00000000Tabbed Emerald
Re: Edit Subject July 28, 2008 07:00PM |
Registered: 15 years ago Posts: 154 |
Sorry, only registered users may post in this forum.