reset all users custom title

[arthurprs]

after converting my forum from vb to smf i need reset all users custom title,
probably i can do it with mysql query, but im not sure and i don't know what to write on the query =S

thanks.

[Sarge]

Welcome to SMF.

What do you need to reset the members' custom title to?

[arthurprs]

to none (blank),

the ideia is to only elite members and staff to have custom titles

[greyknight17]

Welcome to SMF.

This will reset it for all members, so keep that in mind. Go into phpMyAdmin and click on your database. Then click on the SQL tab and copy paste the following code and run it:

Code Select Expand

UPDATE smf_members SET `usertitle` = '';

[arthurprs]

Thanks, thats it.