UBB.Dev
Posted By: IOGCadam MySql question? - 06/07/2004 7:18 PM
Does any one know the MySQL command to reset everyones name color to the default, which i belive is "Normal"

Also Is it possible via a SQL command to reset everyones titles to what they should be in regard to there post levels? We have had moderators take it apon them selves to give people individulized Titles. Now i can individualy remove these titles but i cant figure out how to get the title they are supposed to have... any suggestions?
Posted By: AKD96 Re: MySql question? - 06/08/2004 12:04 AM
This will change EVERYONE'S name color to default...

Code
<br />UPDATE w3t_Users<br />SET U_Color = ''<br />


Starting with 6.5, admin and mod colors will be handled by stylesheets. I don't know if this is the case for normal users as well.

If you're using < 6.5, to reset titles, go to your admin section and click on "Edit titles" under the "Filters" category. Check the box and click update to reset everyone.
© UBB.Developers