By HMED on Monday, 23 March 2015
Posted in General Issues
Replies 8
Likes 0
Views 796
Votes 0
Hi Stackteam !
i was wandering if i can reset all users alerts ?
in the start of our community all alerts were turned ON, after some months many mails are sent and some members are contacting us to deactivate their accounts because they receive a lot of mails, we are looking to reset all members alerts choices as set in our ES backend, i think there is no option for that, we are wandering how it can be done ?

best regards
Hello Jan,

There's actually no way to reset all user's notifications on the site through the profile types but the only work around right now is for you to edit the user account from the back end of EasySocial. However, you need to do this for each user though.
·
Monday, 23 March 2015 21:59
·
0 Likes
·
0 Votes
·
0 Comments
·
Mark, i have 500 users
·
Monday, 23 March 2015 22:10
·
0 Likes
·
0 Votes
·
0 Comments
·
any sql-query or php-script to do it !?
·
Monday, 23 March 2015 22:14
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Jan,

I am sorry for the late reply.
We do not encourage our customer to run sql query, because by doing so, it might skipped some settings or rules. I am sorry for the inconvenience caused.

Thanks.
·
Tuesday, 24 March 2015 13:38
·
0 Likes
·
0 Votes
·
0 Comments
·
Thank you, hope in the nexts ES versions we will find an option to reset Alerts !
·
Tuesday, 24 March 2015 16:54
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Jan,

Thanks for your understanding. Can you please voice this out here: http://stackideas.com/voices/easysocial .

Thanks again and have an awesome day ahead.
·
Tuesday, 24 March 2015 17:13
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi,

i finally doest it ! i reset all users alerts options via sql queries.

here's an example :

UPDATE `xxxx_social_alert_map` SET `email`=0 WHERE `alert_id`=6 OR `alert_id`=7

and that reset emails alerts parameters to 0 (disable) for the alert with id=7 (commenting photo)

its dangerous as manipulation so backup before
·
Wednesday, 18 November 2015 04:39
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Jan!,

Thanks for sharing this with us here
Sam
·
Wednesday, 18 November 2015 11:07
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post