MyBB Community Forums

Full Version: How to reset custom titles to group default ?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
How to reset custom titles to group default ?

i didnt disable it at the begining. now i disabled custom title but who previously changed still has custom title. i want to reset all titles to group defaults . how
Not sure how to do it on mass but you can edit individuals through the modcp, with the profile editor.
choose the option to revert to default and update profile.
(2011-05-06, 10:53 PM)adbrad Wrote: [ -> ]Not sure how to do it on mass but you can edit individuals through the modcp, with the profile editor.
choose the option to revert to default and update profile.

this would be very dump

just tell me what sql query i should execute. it would be a lot more faster.

i guess any forum developer could tell me the sql query.
Actually not all forum admins are knoledgeable with sql just look round the site you'll see lots of threads asking for sql queries.
Never assume anything.
(2011-05-06, 11:19 PM)adbrad Wrote: [ -> ]Actually not all forum admins are knoledgeable with sql just look round the site you'll see lots of threads asking for sql queries.
Never assume anything.

wow i cant belive. this is a very simple task. just reset all user custom titles to default.
UPDATE mybb_users SET usertitle="";
(2011-05-06, 11:37 PM)dragonexpert Wrote: [ -> ]
UPDATE mybb_users SET usertitle="";

thanks a lot

i am also myself a website developer and i am using mssql


i know these kind of things are too easy for who know them even a bit

and solved my problem Cool