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]

UPDATE user set autosubscribe = -1;

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]

Isn't that available as an automatic query in the AdminCP?
Hmm you're right, all there. :D

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]

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?

[Zachery]

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?
$canrunquerys = '';

$canrunquerys = '{YOURUSERID}';

[Wordplay]

thanks alot, got it now!