How to mass reset all custom user titles set by users

[scoutz]

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:

I'm very lost now.

[Max Taxable]

Originally Posted by scoutz

I already tried this https://vborg.vbsupport.ru/showpost....74&postcount=2
It didn't work.

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.

[scoutz]

Originally Posted by Max Taxable

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.

[Max Taxable]

Try "usertitle" instead of "customtitle" ??

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

[scoutz]

Originally Posted by Max Taxable

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!

[Max Taxable]

Well see? Happy Thanksgiving!

[Simon Lloyd]

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.

[scoutz]

Originally Posted by Max Taxable

Well see? Happy Thanksgiving!

Happy Thanksgiving!

Originally Posted by Simon Lloyd

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.

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.