View Single Post
Old 10-23-2009, 04:56 PM
Morgan's Avatar
Morgan Morgan is offline
Join Date: Jul 2006
Posts: 2,255
Geek Article and Review System License Holder GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 

Untested but follow these steps in order:
  1. TRUNCATE TABLE TABLE_PREFIXgaz_subscriptions;
  2. INSERT INTO TABLE_PREFIXgaz_subscriptions (userid, emailformat, newsletter1) SELECT userid, 1, 1 FROM TABLE_PREFIXuser WHERE options & 16;
  3. INSERT INTO TABLE_PREFIXgaz_subscriptions (userid, emailformat, newsletter1) SELECT userid, 1, 0 FROM TABLE_PREFIXuser WHERE NOT options & 16;
This should add everyone to the gaz_subscriptions table and subscribe those to newsletter1 that are set to receive admin emails. You will need to look at the fields in the gaz_subscriptions table to determine what you should use in place of newsletter1 in the above queries, and do queries two and three for each newsletter field. You should also temporarily turn off new registrations while doing this so no one slips through while you are running these queries.
Please use the forums for support, feature requests, and similar such things. Support does not include custom code, custom template edits, or third-party modifications. PMs and emails to me should be for private information only, such as login information. If you PM or email me a support question, chances are good that I'll ignore it. Thanks.
While the work or play is on, it is a lot of fun if while you are doing one you don't constantly feel that you ought to be doing the other. -- Franklin Pierce Adams
Reply With Quote