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.
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}';![[CinVin] Footer Tweaks (expanded footer)](https://cdn.aliensoup.com/data/resource_icons/0/27.jpg?1637543624){kind=icon}
![[CinVin] Gravatar Tweaks for XenForo 2](https://cdn.aliensoup.com/data/resource_icons/0/25.jpg?1634509088){kind=icon}
![[CinVin] Emoji Tweaks](https://cdn.aliensoup.com/data/resource_icons/0/26.jpg?1635707412){kind=icon}
![[CinVin] Lazy Load YouTube Videos for Xenforo 2](https://cdn.aliensoup.com/data/resource_icons/0/18.jpg?1635219657){kind=icon}