Question "Automatically" subscribe all members to be notified of any new messages

Hi skyhawk85u,

I have same urgent need, to send the post or notification of any new post on all categories by default. my forum is very small only 200 users max as its small community. they don't enter daily to the forum site, so alerting them on discussions is mandatory to create traffic.

Can you please share with me exactly what you did to make it happen ? even privately please. I appreciate it.

I make no guarantees, but I haven't seen any adverse affects yet. You need to access the MySQL tables using phpMyAdmin, HeidiSQL, or whatever tool you prefer.

In the Joomla User Manager find the user ID number(s) you want to subscribe. Then in the MySQL table, look in the xxx_kunena_categories table (or something like that.) Get the category you want to subscribe your user(s) to. Finally, in the xxx_kunena_user_categories table insert the rows you need with user_id, category_id, and subscribed (set to 1.) You'll see how they are set in the existing records already there.

For multiple row insertions you can build a SQL statement similar to this (which inserts a bunch of users into category 12):

I need each member to get notification email of any new post on any forum by default without them to manually need to subscribe to it. this should be default behavior and users can then disable it if they want.

*** Topics merged ***

Hi,

Someone says : the feature has been partially implemented in K2.

Could you point us exactly on this partial feature description please?

here's some points I have collected about to patch or hack to obtain some similar feature :

- J!MailAlerts Component
- digest notification, may rely on commercial non free plugin.
- SQL insert, be careful to keep trace of unsubscribe action, not to subscribe again user.

Regards,
Sylvain.

Hi,

We have a community of registered users in CB/Kunena, both latest versions. We would like to know whether it is possible to, as admin / webmaster, to subscribe all users belonging to a particular group (say, registered) by ourselves. By doing so, all new posts that are henceforth made on the forum will at least reaches every member, either as full-text or as link form.

Your guidance on this would be appreciated.

Thanks in advance.