Mass Prefix Change?

[cravendale]

Hi,

Is there a tool or as I was looking for, an SQL query to mass change all threads within a specific forum to a specified prefix
without having to do all the posts manually?

thanks

[Lynne]

Did you try a search? I seem to recall a modification to mass change prefixes.

[cravendale]

There is this...
Change Threads' Prefix Inline
https://vborg.vbsupport.ru/showthread.php?t=227861&highlight=prefix

But it will only allow working per page rather than mass.
Even changing per page is going to take a long time.

Can see any other mod for vB 4 that will do this?

[Lynne]

That is the one I was thinking of. Otherwise, you would need to query your database. Something like:

UPDATE thread SET prefixid=xxxx WHERE forumid=yyyy AND prefixid=zzzzzz

(Never tried - try on a backup database first and be sure to backup your live site before doing it there.)