Mass change topic titles

[thatjustit]

Hello,
I have very many topics where I have to change their names/titles, but I'd like to do it with changing post names/titles in that topics automatically, too. I can make it by moving the topic and checking to change all posts title. But I have to move the topic two times (second one to move it back). It takes a lot of time if I have several hunderd of threads to change.
Is there any way to do it faster or automatically. Currently I have changed topic names, but old posts names in that topic.
Regards,

[Illori]

there is not really any shortcut in this process sorry.

[Adish - (F.L.A.M.E.R)]

When you view the topics in the board, double click in the space besides the topic name. It will allow you to change the topic name straight away.

[Illori]

i am having issues testing this on my 2.0 RC4 test install, but on 1.1.12 it only changed the name of the op but not in each reply which i think is what the op here wants.

[CapadY]

I don't exactly understand what you want to change but is it an option to use a SQL query ? In that case you can change a real lot of titles in only one run.

[thatjustit]

@Illori is right about what I want to do. I mean I want to mass change topics and replies in that topic titles. I'm not sure that mysql queries could fix that, hmm.
And @(F.L.A.M.E.R) solution isn't working for me on that 2.0RC4 installation.

[Kindred]

you can't do it via any admin tool...   you would have to build SQL UPDATE statements...

[thatjustit]

Could you give me any tutorial or short how-to then, please?

[Kindred]

http://dev.mysql.com/doc/refman/5.1/en/update.html


the table is smf_messages

[thatjustit]

Thanks, I hope I will make it work.

[Kindred]

reminder....


ALWAYS take a backup of your mySQL database before performing any edits directly in the db!