UBB.threads PHP Forum Software Community Forums UBB.threads 6 Version 6 Support Make all users visable?

Hello!

I've had this question answered before, but it's been a while and the post is gone.

I am looking to run a query that would mark all the users as visable on the who's online screen and also have visable as the default.

Also, just to throw this in here .... I am having some issues with the "Legend" on my main page. Have tried editing the template, but it will NOT move. Suggestions?
http://www.mbtgd2.com/wwwthreads/ubbthreads.php?Cat=0

Thanks!

UPDATE w3t_Users SET U_Visible = 'yes'

Thanks!!!

Nice one. <img src="https://www.ubbcentral.com/boards/images/graemlins/smile.gif" alt="" /> Is there a query that would list users who have this function turned off in their profile?

SELECT U_Username
FROM w3t_Users
WHERE U_Visible = 'no'

Many thanks, I'm compiling a list of useful queries which are very useful to us newbie Admins. <img src="https://www.ubbcentral.com/boards/images/graemlins/wink.gif" alt="" />

Might be a useful idea to make such options available from the CP in Threads, without the need to log in to PHPMyAdmin. Just my two cents...

YOu can do that from the Database interface in the Control Panel - phpMyAdmin isn't needed to run queries. And you can save queries for future use.

Other useful queries can be found here.