View Single Post
  #6  
Old 10-09-2009, 02:50 PM
Morgan's Avatar
Morgan Morgan is offline
Administrator
 
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 
Default

Untested but follow these steps in order:
  1. TRUNCATE TABLE TABLE_PREFIXgaz_subscriptions;
  2. INSERT INTO TABLE_PREFIXgaz_subscriptions (userid, emailformat) SELECT userid, 1 FROM TABLE_PREFIXuser;
  3. ACP -> GAZ -> Tools -> Newsletter subscription tools -> Subscribe all users -> Yes for every newsletter that is listed
This should add and subscribe everyone. 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