*I don't have a 3.x board handy or even installed on localhost and just realized this was posted in 3.x forums however this should work fine on 3.x, its untested though so if anything run a quick backup before trying it out.
Edit: After re-reading your initial post I'm going to whip up another version of this as well, perhaps use the same way of updating ALL user titles and ranks (if need be) just like they do when you run the update user titles and ranks (it uses this method though versus a straight query https://www.vbulletin.com/docs/html/...er_programming ) from the admincp but bear with me busy today, Monday's ACK!
03-09-2015, 07:42 PM
Threaded Mode