FUDforum: How To » "Show E-Mail" off for all users?

Home » FUDforum » How To » "Show E-Mail" off for all users?

Show: Today's Messages :: Polls :: Message Navigator

"Show E-Mail" off for all users? [message #26436]

Thu, 21 July 2005 21:48

maxel

Messages: 18
Registered: July 2005

Karma: 0

Junior Member

Hi !

I've converted from another forumsoftware to Fudforum. Now i have the problem that the "Show "E-Mail" option is enabled for all users by default. Not good to avoid spam mails..

I want to set it to off for all my active users. Is there an sql script which i can use?

Maxel

Report message to a moderator

Re: "Show E-Mail" off for all users? [message #26438 is a reply to message #26436]

Thu, 21 July 2005 21:59

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

UPDATE "users table" SET users_opt=users_opt&~1;

FUDforum Core Developer

Report message to a moderator

Re: "Show E-Mail" off for all users? [message #26442 is a reply to message #26438]

Thu, 21 July 2005 22:06

maxel

Messages: 18
Registered: July 2005

Karma: 0

Junior Member

This generates an error message:

Quote:

mysql> UPDATE "users table" SET users_opt=users_opt&~1;
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '"users table" SET users_opt=users_opt&~1' at line 1

Report message to a moderator

Re: "Show E-Mail" off for all users? [message #26445 is a reply to message #26442]

Thu, 21 July 2005 22:07

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

I hoped it would be obvious, but you need to change "users table" with the name of the users table... probably fud26_users unless you chose a different database prefix.

FUDforum Core Developer

Report message to a moderator

Re: "Show E-Mail" off for all users? [message #26447 is a reply to message #26436]

Thu, 21 July 2005 22:13

maxel

Messages: 18
Registered: July 2005

Karma: 0

Junior Member

ok, i've checked what the name of the table is but still an error:

Quote:

| fud26_thread_notify |
| fud26_thread_rate_track |
| fud26_thread_view |
| fud26_title_index |
| fud26_user_ignore |
| fud26_users |
+-------------------------+
server:/# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 4194 to server version: 4.0.24_Debian-10-log

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use fudforum
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> UPDATE "fud26_users" SET users_opt=users_opt&~1;
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '"fud26_users" SET users_opt=users_opt&~1' at line 1

Report message to a moderator