SQL Query to Set Subscriptions To None
 

I asked this over at vbulletin.com...no responses...so I'd come to where all the guys who know SQL are, vb.org!

"I run a vb 3.0.3 forum. We have had the original default registration setting at subscribe, but don't send e-mail notification. After seeing this I changed the defaults, but we still have quite a few subscriptions from the past. Now I just see this as an annoying problem that took up database space, so I recently emptied the SQL table of all its subscriptions data.

Now I'd like to kill the actual problem. I would like to use an SQL Query to set all of my users to No Subscription setting. I know this is in the vb3_users table, under the autosubscribe column, and the proper setting to "No subscription" is the value "-1".

I'm not very good with SQL in general, so I was wondering if anybody could help me out by giving me the SQL Query I would need to set the users to No subscription? Any help is appreciated!"

Translation:
SQL Query that will set all users to No Subscription status

[sql]UPDATE vb3_users SET autosubscripe ="-1"[/sql]

should be the correct query based on the specifications of your post.

Thank you!
Just needed a slight tweak and it worked fine.

[SQL]UPDATE vb3_user SET autosubscribe ="-1"[/SQL]