ENXF NET
Administrator
Staff member
Administrator
Moderator
+Lifetime VIP+
S.V.I.P.S Member
S.V.I.P Member
V.I.P Member
Collaborate
Registered
- Joined
- Nov 13, 2018
- Messages
- 25,780
- Points
- 823
Reputation:
I'm looking for the "activity_summary_email" [1/0] option in any table to do a mass "No" for a selected list, so that the "Yes" isn't saved, if ever enabled again.
So far I have email alerts and DOB with:
SQL:
Read more
Continue reading...
So far I have email alerts and DOB with:
SQL:
Code:
UPDATE `xf_user_option`
INNER JOIN `xf_user`
ON `xf_user_option`.`user_id` = `xf_user`.`user_id`
AND `xf_user`.`email` = '[email protected]'
SET `xf_user_option`.`show_dob_year` = 0, `xf_user_option`.`show_dob_date` = 0, `xf_user_option`.`content_show_signature` = 0...
Read more
Continue reading...