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 |
anyone?
is there a support ticket system here or anything? thx |
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.
|
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. |
hi again
how about a sql query that I could ran in the vb maintenance area? :o |
Untested but follow these steps in order:
|
Loco did you ever figure this out , ive got the same problem and that SQL Query didnt seem to work
|
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. |
Untested but follow these steps in order:
|
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 :) |
All times are GMT. The time now is 10:34 AM. |
Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.