UBB.Dev
Posted By: drkknght sql command to make everyone visible - 12/24/2007 1:29 AM
is there a sql command that will make every account visible in the who's online panel? (i know they can turn it right back... just wondering)
Posted By: sirdude Re: sql command to make everyone visible - 12/24/2007 6:44 AM
specify the threads version and you'll prolly get the answer wink
Posted By: drkknght Re: sql command to make everyone visible - 12/24/2007 6:46 AM
hahah, sorry 7.2
Posted By: AllenAyres Re: sql command to make everyone visible - 12/31/2007 11:51 PM
UPDATE ubbt_USER_PROFILE SET USER_VISIBLE_ONLINE_STATUS = 'yes'

will do it smile
Posted By: drkknght Re: sql command to make everyone visible - 01/02/2008 8:07 AM
thats it!

thanks doubleA smile
Posted By: AllenAyres Re: sql command to make everyone visible - 01/02/2008 5:52 PM
You're welcome - if you don't want them to become invisible just edit that selection out of the profile template.
Posted By: drkknght Re: sql command to make everyone visible - 01/02/2008 10:58 PM
yeah, i did that first, but then had a few stragglers i needed to ... visify! smile
Posted By: drkknght Re: sql command to make everyone visible - 01/17/2008 3:36 AM
so now i have run that sql command AND commented the option out of the template ...but, on occasion, i'll still see in my who's online list "...and 1 invisible"

by the time i click on the page to check, they're apparently gone (quick lil suckers!)

is there any command to find out who was able to break my invisibility policy?
© UBB.Developers