R rdn Well-known member Mar 31, 2015 #1 I want to have all the alert preferences enabled for all users: /account/alert-preferences What is the correct query? Thanks!
I want to have all the alert preferences enabled for all users: /account/alert-preferences What is the correct query? Thanks!
P Paul B XenForo moderator Staff member Mar 31, 2015 #2 I haven't tested this and I would recommend taking a backup before running it. Code: UPDATE xf_user_option SET alert_optout = ''; Upvote 0 Downvote
I haven't tested this and I would recommend taking a backup before running it. Code: UPDATE xf_user_option SET alert_optout = '';
R rdn Well-known member Mar 31, 2015 #3 123 rows affected. (Query took 0.4476 seconds.) Click to expand... Done . I didn't backup the database though Seems 100% working as intended, as I tested it first on my test site. Thanks a lot Brogan Upvote 0 Downvote
123 rows affected. (Query took 0.4476 seconds.) Click to expand... Done . I didn't backup the database though Seems 100% working as intended, as I tested it first on my test site. Thanks a lot Brogan
.
