The Arcive of vBulletin Modifications Site.

Anyway to get rid of a feature AFTER someone purchased it? · **Released**: 02-14-2005

Hi.

I'm having a problem: someone purchased the "Bold username" feature before I disabled it. And the "Bold Username" is strictly reserved for Mods and Admins. I was wondering if there's anyway to get rid of it? I have access to phpMyAdmin, if that's needed.

pic16f84 · #2 03-01-2005, 10:03 PM

We are having a similar problem we allow users to change there colour but do not want them to be able to use the colour RED as this is used by Admin / Mods we have had a few users do this and have had to ask them to remove or change the colour is there a way Admin and change this (without changing the users password and logging in as them)

Link14716 · #3 03-03-2005, 08:47 PM

Quote:

Originally Posted by Blootix

Hi.

I'm having a problem: someone purchased the "Bold username" feature before I disabled it. And the "Bold Username" is strictly reserved for Mods and Admins. I was wondering if there's anyway to get rid of it? I have access to phpMyAdmin, if that's needed.

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.

Quote:

Originally Posted by pic16f84

We are having a similar problem we allow users to change there colour but do not want them to be able to use the colour RED as this is used by Admin / Mods we have had a few users do this and have had to ask them to remove or change the colour is there a way Admin and change this (without changing the users password and logging in as them)

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.

Hornstar · #4 11-08-2005, 09:38 PM

Quote:

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