PDA

View Full Version : Remove Items


melefire
06-13-2006, 09:18 PM
i disabled 'Username Options' but people still have bolded/colored usernames. How can i remove these from people?

melefire
06-20-2006, 09:49 AM
dosn't any one know??

CMX_CMGSCCC
06-20-2006, 08: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
06-21-2006, 11:31 AM
i searched and could not find a similar query, could you please point me in the right direction

thanx

CMX_CMGSCCC
06-28-2006, 01:20 PM
Try this query...

To remove Username Bold:

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


To remove Username Italics:

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


To remove Username Underline:

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
07-01-2006, 06:59 PM
do you know how to remove username fonts?

CMX_CMGSCCC
07-13-2006, 07:34 PM
UPDATE (TABLE_PREFIX)user SET vbp_namefonttype = '';


-CMX