News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

clearing all custom titles from the db

Started by iMav, August 08, 2012, 09:58:22 AM

Previous topic - Next topic

iMav

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?

Suki

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.
Disclaimer: unless otherwise stated, all my posts are personal and does not represent any views or opinions held by Simple Machines.

Advertisement: