user registration options CHANGED

[Wordplay]

i changed my users registration option from them not subscribing to threads automatically when posting a reply to them subscribing without e-mail notification.

but this will only count for new registers, is there a way to change it so it works for all already registered users?

[Marco van Herwaarden]

They can set it themself in their UserCP, alternativly you could run a query to set this for all users.

[Wordplay]

what query would i have to run to set it for all users?

[Marco van Herwaarden]

[sql]UPDATE user set autosubscribe = -1;[/sql]

This will set all user to not auto-subscribe, regardless of their current setting.

PS if you are using a table prefix, add this in front of "user".

[Wordplay]

sorry but i'm query illiterate. i know how to run the query but what do you mean add this infront of "user" and i want them to autosubscribe but without e-mail notification. so would that be "= 1;

[kall]

Isn't that available as an automatic query in the AdminCP?

[Marco van Herwaarden]

Originally Posted by kall

Isn't that available as an automatic query in the AdminCP?

Hmm you're right, all there.

I allways tend to forget the already buildin queries.

[Wordplay]

i can't run queries in my admincp, it says:

"You are not authorized to execute SQL queries"

[kall]

Originally Posted by Wordplay

i can't run queries in my admincp, it says:

"You are not authorized to execute SQL queries"

Edit includes/config.php and put your userid in the relevant field. Search for sql if you can't understand that.

[Wordplay]

you mean the "DATABASE NAME"? well i already have something there, but if that were wrong, then my entire board wouldn't work right? so it must be correct. so what userid should i change and where?