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
vBulletin® v3.8.12 by vBS, Copyright ©2000-2024, vBulletin Solutions Inc.