[Hornstar]

Originally Posted by Link14716

Well, I believe this query will work if I don't get the column name wrong.

[sql]UPDATE user SET uttstore_boldusername=0 WHERE usergroupid<>5 AND usergroupid<>6 AND usergroupid<>7;[/sql]

I'll probably make it editable in the Admin CP somehow in a future version.


This query will reset a user's username color.

[sql]UPDATE user SET uttstore_usernamecolor='' WHERE userid = X;[/sql]

Change X to the userid of the user whose color you want to reset.

Thanks for that, exactly what i was looking for, however took me a little while to realise that i had to put vb3_user not just user or waht ever your prefix is set when u created the forums.

thanks again