The vB Geek

Go Back   The vB Geek > vB Geek Products > Geek Gazette

Geek Gazette GAZ is a community newsletter management system.

Advertisement
This is an HTML example. Isn't it just wonderful?!?!
  Learn how to remove ads

Reply
 
Thread Tools Display Modes
  #1  
Old 10-04-2009, 03:20 PM
Loco's Avatar
Loco Loco is offline
Senior Member
 
Join Date: Nov 2005
Posts: 132
Geek Article and Review System License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Question imported another db, want to add those users to subscribers

Hello,

I've imported a couple databases with my forum and I want all those users to be subscribers to the newsletter.
I went to

admincp > gaz > tools >subscription tools > Subscribe all users > yes

but it didn't add the 4,000 users I imported (which are now in the registered user group)
do I need to upgrade GAZ or something to get this working, or maybe update another setting?

I have version 2.0.2

Thanks for the help
-Brandon
__________________
..get off my lawn

Last edited by Loco; 10-04-2009 at 03:59 PM..
Reply With Quote
  #2  
Old 10-05-2009, 10:13 PM
Loco's Avatar
Loco Loco is offline
Senior Member
 
Join Date: Nov 2005
Posts: 132
Geek Article and Review System License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

anyone?
is there a support ticket system here or anything?

thx
__________________
..get off my lawn
Reply With Quote
  #3  
Old 10-07-2009, 02:52 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

Nope, no ticket system. The vB import is for vB, not for add-ons, so importing isn't going to change the GAZ database tables. You could uninstall and then reinstall GAZ but that means you would need to reset all your newsletters and issues, or you could code something to add the new users to the gaz_subscriptions database table where a value of one in the newsletterX columns means that the userid in the same row is subscribed to newsletter X.
__________________
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
  #4  
Old 10-07-2009, 11:23 PM
Loco's Avatar
Loco Loco is offline
Senior Member
 
Join Date: Nov 2005
Posts: 132
Geek Article and Review System License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

Hello thanks for the answer

I know the vb importer isn't going to work with gaz, what does this setting do?
admincp > gaz > tools >subscription tools > Subscribe all users > yes
the way I read it is it will subscribe all users

I had thought about uninstalling gaz and reinstalling, this may be the way I go

I'm not much of a coder, so I wouldn't know the first place to look to make my own extension.
__________________
..get off my lawn
Reply With Quote
  #5  
Old 10-09-2009, 02:09 AM
Loco's Avatar
Loco Loco is offline
Senior Member
 
Join Date: Nov 2005
Posts: 132
Geek Article and Review System License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

hi again

how about a sql query that I could ran in the vb maintenance area?
__________________
..get off my lawn
Reply With Quote
  #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
  #7  
Old 10-21-2009, 01:55 PM
Riverwire Riverwire is offline
Junior Member
 
Join Date: Oct 2009
Posts: 2
Geek Gazette License Holder 
Default

Loco did you ever figure this out , ive got the same problem and that SQL Query didnt seem to work
Reply With Quote
  #8  
Old 10-23-2009, 12:00 AM
Loco's Avatar
Loco Loco is offline
Senior Member
 
Join Date: Nov 2005
Posts: 132
Geek Article and Review System License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

I've actually had the flu the last week, so I haven't had time to mess with it.
Could we get a modified version of the query and have all users who have "yes" to receive admin emails, set to subscribe to the newsletter? That would fit my needs better

thanks.
__________________
..get off my lawn
Reply With Quote
  #9  
Old 10-23-2009, 04:56 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, 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
  #10  
Old 10-30-2009, 10:42 PM
Loco's Avatar
Loco Loco is offline
Senior Member
 
Join Date: Nov 2005
Posts: 132
Geek Article and Review System License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

Awesome, thanks for your time Morgan!
I'll reply and update when it works
I'll make a database backup before hand just in case I jack something up.

Thanks again, you're my hero right now
__________________
..get off my lawn
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Does not send out Email to users nuvar Geek Gazette 0 03-29-2010 08:58 AM
Use for French Users OlijO Geek Gazette 6 05-28-2008 03:49 PM
How can Users subscribe? Julian Geek Gazette 8 05-23-2007 06:52 AM
EG - Donation links for users mac27 Add-ons 2 05-10-2007 04:49 PM
Users Other Articles Lizard King Geek Article and Review System 0 11-17-2005 04:40 AM


All times are GMT. The time now is 11:04 AM.


Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.