Annoying thread subscriptions.
 

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.

User CP > Edit Options > Default Thread Subscription Mode

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

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

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.