Simple Machines Community Forum

SMF Support => SMF 2.0.x Support => Topic started by: iMav on August 08, 2012, 09:58:22 AM

Title: clearing all custom titles from the db
Post by: iMav on August 08, 2012, 09:58:22 AM
We are instituting a new policy with custom titles and need to delete/clear all the currently-set ones.

How can this be done easily/quickly?
Title: Re: clearing all custom titles from the db
Post by: Suki on August 08, 2012, 10:02:38 AM
Depends where this custom titles are stored, if you're talking about the user's custom titles then a query on phpmyadmin or similar will do just fine:

UPDATE `your_BD`.`smf_members` SET `usertitle` = '';

This will reset all usertitle fields, just replace the DB name with your own and if you are suing a custom prefix change the smf_ too.