Subscribe to newsletters

If you have questions about using mojoPortal, you can post them here.

You may want to first review our site administration documentation to see if your question is answered there.

This thread is closed to new posts. You must sign in to post in the forums.
4/15/2008 3:11:08 PM
Gravatar
Total Posts 7

Subscribe to newsletters

When a user creates a new account I want him/her to subscribe to all (or a set) newsletters by default.
After login the user can unsubscribe.

In the mojoProfile.config it is possible to set default values to custom fields, but not for subscribing to newsletters or adding to some Roles.

How do I configure this ?

4/16/2008 9:35:18 AM
Gravatar
Total Posts 18439

Re: Subscribe to newsletters

I will add an option for this in Web.config in a future release so that you can have the opt in by default. Currently it is not possible.

I do think it is better etiquette not to automatically opt people in but I will make it possible for you.

Best,

Joe

2/7/2012 10:38:56 AM
Gravatar
Total Posts 4

Re: Subscribe to newsletters

Hi,

   I have recently created a Mojoportal website with a couple of forums on it.

   Is there some way I can make all registered users of the website subcribed to the forums?  They can then unsubscribe if they do not want emails from the forums.  I spent quite a lot of time on setting the forums up and I want people to use them. Adding all registered users of the website would kick start people using the forums.   I have about 50 users so far and would not expect there to ever be more than 100. 

Paddy

 

 

 

  

2/7/2012 10:53:21 AM
Gravatar
Total Posts 1203
Proud member of the mojoPortal team

Help support mojoPortal!
Add-on modules

Re: Subscribe to newsletters

You would probably need to construct a SQL statement to update or insert rows into your database. We don't have forums on our own sites so I can't help you out with that one.

If you are a developer and want future users to be auto-subscribed to forums when they register, you could create a User Registered Event Handler to do the same SQL updates/inserts.

Jamie

2/7/2012 11:04:23 AM
Gravatar
Total Posts 4

Re: Subscribe to newsletters

Could you give me a clue as to which table(s) would need to be updated? And where located? Also what tool to use to run the SQL statements?

I am a developer but not a web developer. Familiar with SQL etc

2/7/2012 1:50:45 PM
Gravatar
Total Posts 1203
Proud member of the mojoPortal team

Help support mojoPortal!
Add-on modules

Re: Subscribe to newsletters

I just took a quick look at our mojoPortal database, I think you'll just need to insert rows into mp_forumsubscriptions (one row for each forum ID/user ID combo). What I would personally do is query this table after subscribing myself to a forum or two, just to be sure about the data format. Then you can set up insert statements that draw from a select join of mp_users and mp_forums. Some users might already have subscription rows out there, so you might want to clear all existing subscriptions before starting.

SQL tool will vary according to your platform. We use MySQL and I like HeidiSQL for that. If it's SQL Server you can probably use SQL Server Management Studio or something equivalent. You could also use the delivered SQL Query Tool, although I haven't used that one myself.

As always, double check your work, and most importantly, be sure you have a good backup of your database before you start!

Jamie

You must sign in to post in the forums. This thread is closed to new posts.