no more invisible members?

[XFLBret]

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.

[amykhar]

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

[XFLBret]

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

[amykhar]

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

Amy

[XFLBret]

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

[filburt1]

The hack will use that query.

[Link14716]

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]

[amykhar]

Ok. Looks like some databases are pickier than mine.

Amy

[XFLBret]

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

[LangTuDaTinh]

no, in myphpadmin, run this

UPDATE user set invisible=0

without ';'