XFSImperial
12-17-2004, 11:13 PM
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
"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