![]() |
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 ';' |
All times are GMT. The time now is 12:32 AM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|