no more invisible members?
 

I'd like a hack that prohibits anybody and everybody from being able to choose the Invisible on 'Online users' list option in the control panel.

i want everyone who visits my site to have their name in the "users who visited today" section whether they want to be in there or not.

if there's already a hack like this please point me in the right direction and accept my apologies for posting this hack request.

All you have to do is remove the option from the register page templates and the user options template.

Then, run this query:

UPDATE user set invisible=0;

That will set everyone to visible.

Amy

it's not working for me. i run the query as it's written, and i get this error:

Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: UPDATE user set invisible=0;

mysql error: You have an error in your SQL syntax near ';
' at line 1

mysql error number: 1064

Date: Tuesday 22nd of April 2003 01:40:43 PM
Script: http://pcfootball.net/forums/forums/admin/query.php
Referer: http://pcfootball.net/forums/admin/query.php?t=0&

then I take off the semi colon and get this error:

Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /usr/local/etc/httpd/htdocs/forums/admin/query.php on line 29

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/local/etc/httpd/htdocs/forums/admin/query.php on line 33

Query works fine for me in phpmyadmin. Not sure which query hack you are using and cannot debug that for you. Sorry.

Amy

well, since the query is not working for me for whatever reason, I will repeat my request for a hack for this.

The hack will use that query.

amy, you forgot the quotes..

Instead of:[sql]UPDATE user set invisible=0;[/sql]It needs to be:[sql]UPDATE user SET invisible='0';[/sql]

Ok. Looks like some databases are pickier than mine. :D

Amy

I got this error when I tried it:

Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /usr/local/etc/httpd/htdocs/forums/admin/query.php on line 29

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /usr/local/etc/httpd/htdocs/forums/admin/query.php on line 33

no, in myphpadmin, run this

UPDATE user set invisible=0

without ';'