Annoying thread subscriptions.

[DR_GIGGULS]

Hello.

When I create a thread at my forum, I am automatically subscribed for it. How do I turn this off?
My users will go nuts.

[Lynne]

User CP > Edit Options > Default Thread Subscription Mode

vboptions > User Registration > User Registration Options > Automatic Thread Subscription Mode

[DR_GIGGULS]

How can I change the thread subscription mode for all users?
What query should I execute?

[Lynne]

You can change it in maintenance > execute sql query > automatic query (drop down to what you want) Make sure you have your userid in the Can Execute SQL Query area in your config.php file first.