The Arcive of vBulletin Modifications Site.

Remove Items · **Released**: 06-13-2006

i disabled 'Username Options' but people still have bolded/colored usernames. How can i remove these from people?

melefire · #2 06-20-2006, 08:49 AM

dosn't any one know??

CMX_CMGSCCC · #3 06-20-2006, 07:33 PM

Right now, u'll have to do a query to remove them. Or use the vbPlaza Maintenance options to "Clear All Display Flags".

At this moment, I dont have time to build the query for you, but there are other examples in this forum about removing the flags for display flags via a query.

-CMX

melefire · #4 06-21-2006, 10:31 AM

i searched and could not find a similar query, could you please point me in the right direction

thanx

CMX_CMGSCCC · #5 06-28-2006, 12:20 PM

Try this query...

To remove Username Bold:

Code:

UPDATE (TABLE_PREFIX)user SET vbp_displayflags = vbp_displayflags & (-1 ^ 1);

To remove Username Italics:

Code:

UPDATE (TABLE_PREFIX)user SET vbp_displayflags = vbp_displayflags & (-1 ^ 2);

To remove Username Underline:

Code:

UPDATE (TABLE_PREFIX)user SET vbp_displayflags = vbp_displayflags & (-1 ^ 4);

Replace (TABLE_PREFIX) with ur table prefix, or delete if u do not have one.

-CMX

melefire · #6 07-01-2006, 05:59 PM

do you know how to remove username fonts?

CMX_CMGSCCC · #7 07-13-2006, 06:34 PM

Code:

UPDATE (TABLE_PREFIX)user SET vbp_namefonttype = '';

-CMX