vBulletin Change Thread Prefixes For All Threads In Forum

Kevin

Code Monkey
Staff member
Joined
Mar 20, 2004
Recently I had the need to add a new prefix to an existing vBulletin forum that had hundreds of threads. Manually editing each thread to change the prefix was not an ideal solution.

This query will take care of that for you. :) Replace {prefixID} with the Prefix ID you created and {999} with the forum ID that you want to bulk update.

Code:
update thread set prefixid = '{prefixID}' where forumid='{999}';
 
Top Bottom