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:UPDATE user set invisible=0;It needs to be:UPDATE user SET invisible='0';

[amykhar]

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

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 ';'

[unplugged]

Once you have updated the database you can rmeovethe option from the useroptions template and if you wanna be rearlly rearlly swish :rolleyes: you can edit the showthread.php and recode the bit where it plays with the invisble users

[XFLBret]

still get an 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

[filburt1]

Yesterday at 10:20 PM Link14716 said this in Post #7 (https://vborg.vbsupport.ru/showthread.php?postid=385803#post385803)
amy, you forgot the quotes..

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

It's not a string so you don't need the quotes; in fact you shouldn't use them.

[Talisman]

I don't know why, but my myphpadmin does that too. Every single time I have to run a query where there are quotes, I get errors ..... no matter whether I use ' or " or /" to mark the strings. So I always have to enter those manually.

(If anyone knows why this happens or what I can try to fix it, please let me know.)

This may be a lousy way of having to go about this, XFLBret, but you could go into the USER table in your database, click on browse, and (manually) sort the table on that INVISIBLE column (descending) to bring them all up top. Then (manually) edit every user record to change all the 1's to 0's for the invisible field.

Depending on the size of your board and how many of your members like to hide, that could be a big job for you. But if you then remove the option from the registration and user CP screens..... nobody can change it back. And that gets you what you wanted.

Good luck with it.

Talis.