php forum
php mysql forum
php mysql smarty
 
Topic Options
#316514 - 12/23/07 05:29 PM sql command to make everyone visible
drkknght Offline
Kahuna

Registered: 11/09/00
Posts: 1249
Loc: rob's pad -- where it takes sk...
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)
_________________________
professional discussion killer
due to intelligence limitations, i do not offer support.
my site ~ my boards

Top
#316522 - 12/23/07 10:44 PM Re: sql command to make everyone visible [Re: drkknght]
sirdude Online   content
Enthusiast

Registered: 11/08/03
Posts: 421
Loc: SoCal
specify the threads version and you'll prolly get the answer wink
_________________________

Unfair, Unbalanced, Unmedicated.

Top
#316524 - 12/23/07 10:46 PM Re: sql command to make everyone visible [Re: sirdude]
drkknght Offline
Kahuna

Registered: 11/09/00
Posts: 1249
Loc: rob's pad -- where it takes sk...
hahah, sorry 7.2
_________________________
professional discussion killer
due to intelligence limitations, i do not offer support.
my site ~ my boards

Top
#316545 - 12/31/07 03:51 PM Re: sql command to make everyone visible [Re: drkknght]
AllenAyres Administrator Offline
I type Like navaho

Registered: 03/10/00
Posts: 25366
Loc: Texas
UPDATE ubbt_USER_PROFILE SET USER_VISIBLE_ONLINE_STATUS = 'yes'

will do it smile
_________________________
- Allen wavey
- What Drives You?

Top
#316549 - 01/02/08 12:07 AM Re: sql command to make everyone visible [Re: AllenAyres]
drkknght Offline
Kahuna

Registered: 11/09/00
Posts: 1249
Loc: rob's pad -- where it takes sk...
thats it!

thanks doubleA smile
_________________________
professional discussion killer
due to intelligence limitations, i do not offer support.
my site ~ my boards

Top
#316555 - 01/02/08 09:52 AM Re: sql command to make everyone visible [Re: drkknght]
AllenAyres Administrator Offline
I type Like navaho

Registered: 03/10/00
Posts: 25366
Loc: Texas
You're welcome - if you don't want them to become invisible just edit that selection out of the profile template.
_________________________
- Allen wavey
- What Drives You?

Top
#316558 - 01/02/08 02:58 PM Re: sql command to make everyone visible [Re: AllenAyres]
drkknght Offline
Kahuna

Registered: 11/09/00
Posts: 1249
Loc: rob's pad -- where it takes sk...
yeah, i did that first, but then had a few stragglers i needed to ... visify! smile
_________________________
professional discussion killer
due to intelligence limitations, i do not offer support.
my site ~ my boards

Top
#316623 - 01/16/08 07:36 PM Re: sql command to make everyone visible [Re: drkknght]
drkknght Offline
Kahuna

Registered: 11/09/00
Posts: 1249
Loc: rob's pad -- where it takes sk...
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?
_________________________
professional discussion killer
due to intelligence limitations, i do not offer support.
my site ~ my boards

Top


Moderator:  Gizmo 
Top Posters Last 30 Days
AllenAyres 83
Gizmo 29
sirdude 25
Zarzal 22
blaaskaak 13
willing 7
swebs 6
Who's Online
1 Registered (sirdude), 42 Guests and 7 Spiders online.
Key: Admin, Global Mod, Mod
Shout Box

Latest Posts
Nice Ajax Chat
by sirdude
22 minutes 15 seconds ago
[7.x] UBB.Post Templates v0.1
by sirdude
Today at 12:48 PM
Team UBBDev Rides Again!
by AllenAyres
Yesterday at 10:56 PM
[7.3.x] ubb.links
by AllenAyres
07/03/08 06:15 PM
Changing currency for subscriptions?
by AllenAyres
07/03/08 01:15 PM
Protect users emails
by AllenAyres
07/03/08 11:36 AM
VPS and Newbies
by Gizmo
07/02/08 09:08 PM
New Mods
Protect users emails
by Basil Fawlty
06/29/08 08:44 AM
[7.3.x] Scheduled board close for backup
by blaaskaak
06/26/08 04:01 AM
[7.3+] CustomTag - Audo Embedding
by Gizmo
06/24/08 07:52 PM
[7.3.x] ubb.links
by AllenAyres
06/20/08 11:50 PM
[7.3] Dissallow quotes more then 3 levels deep
by blaaskaak
06/09/08 09:01 AM
Newest Members
ryzilla, M4D, Jer, Kanigo2, Bubba
13302 Registered Users

 

 

 
fusionbb message board php hacks