I would like to be able to manage users' notification options.

e.g. set everyone to receive notifications for event X

e.g. set set all users in group X to receive notification for event Y

This shouldn't be difficult - for those in the know!

Thanks!

Searching exactly the same thing, I wonder if there isn't a module for that functionality already... I haven't found it though

At this moment I'm looking for a way to send new forum posts (CBB) notifications for all my private site members (20 users +/-)

As far as I can see it you have these options:

1. Tell your 20 members how to log in and change their own notification settings.

2. Log in using their usernames and do this if you know their passwords (this is what I did in the end as I also had 20 users to change!)

3. Change the notifications table in the database. As far as I see it's as simple as adding one row for each notification. I don't think it's cross-referenced anywhere else, so I don't think you can break anything by doing this. Recently I deleted a row from that table (it was causing a problem on the notifications.php page) and it didn't seem to have any knock-on effects.

I can try to explain option 3 if you feel it would be useful. If anyone knows that that option would break anything then please say so

it will be useful for me too
- delete notifications for users that don't login within X days.

i like it as a check box so i can tick it and press on Ok.

OK here is what I know.

Here is how the notifications table is structured:



And here is an example if its content:



not_id is the notification identity number. When a notification is cancelled, XOOPS deletes the relevant row (and doesn't change any of the other not_id row numbers). New notifications are given the next highest not_id number (auto_increment) rather than filling in any gaps.

not_modid identifies the relevant module. On my site 2 is smartsection and 4 is cbb.

not_itemid is module-specific and identifies the relevant item. Most here are 0 as they refer to the module generally, but note not_id 54 where the not_itemid is 113 (the thread number to be notified about).

not_category and not_event explain themselves and are module-specific again.

not_uid identifies the relevant user by his user number.

not_mode - well, I honestly don't know what it means, but stick with 0 and you can't go wrong!



For 20 users you could easily use MySQL commands to add 20 rows for 20 new notifications. For more users I suppose you could write a PHP script to do it automatically. If you do that then submit it here! It could make a good module.

To delete users who haven't logged in for a while you'd just need to delete (or not) the relevant prefix_xoopsnotifications rows depending the value of the last_login column of the prefix_users table. I haven't time now to think it through fully.

I don't think that the table is referred to elsewhere so don't think there would be any problems with adding to it via MySQL (back it all up first though!) I've deleted rows with no problems but haven't had to add any yet.

Good luck!