no more invisible members?

[unplugged]

Once you have updated the database you can rmeovethe option from the useroptions template and if you wanna be rearlly rearlly swish 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
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]

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.