PDA

View Full Version : How to mass reset all custom user titles set by users

scoutz
11-24-2013, 06:14 PM
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.php?p=329174&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.
Max Taxable
11-24-2013, 06:53 PM
I already tried this https://vborg.vbsupport.ru/showpost.php?p=329174&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
11-24-2013, 08:16 PM
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
11-24-2013, 08:45 PM
Try "usertitle" instead of "customtitle" ??

Or try: UPDATE user SET customtitle = ’0′ where customtitle = ’1′
scoutz
11-29-2013, 03:02 AM
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
11-29-2013, 03:13 AM
Well see? Happy Thanksgiving!
Simon Lloyd
11-29-2013, 03:30 AM
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
11-30-2013, 05:33 PM
Well see? Happy Thanksgiving!

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.

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.