How to mass reset all custom user titles set by users
 

I need to reset all user titles to the default name, and erase the custom titles the users put up, because i disabled custom usertitles in all my usergroups. So now I need it to display the user title i put up for each group instead of the custom one they put up. :)

I haven't found anything helpful, I wish there was a simple tool in vb cp to do this. Maybe there is?

I already tried this https://vborg.vbsupport.ru/showpost....74&postcount=2
It didn't work. I updated all user titles after that and nothing.

That is really old, I don't think it works with vb4. :down:

:confused: I'm very lost now.

There is no way that query doesn't work. Did you execute it in AdminCP>Maintenance?Execute SQL Query?

it may have to be styled a little differently for the server you're on, but I doubt it.

I executed that, but not from AdminCP. I did it from PHP MyAdmin.
Didn't work... I don't know what could be wrong.

Try "usertitle" instead of "customtitle" ??

Or try: UPDATE user SET customtitle = ’0′ where customtitle = ’1′

Well, I think it worked now! I checked several profiles and they all seem to have reseted to what is set as default usergroup name.

Thanks!

Well see? Happy Thanksgiving!

If you've disabled custom user titles you should be able to go in to edit the usergroup and set custom title to yes admin set, that way you set the title and they'll all get what you set or what you set individually.

Happy Thanksgiving! :)

Yeah but I have way too many users to go through individually, that would be crazy. Can't even image. I'm very glad this worked.