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
- 32,773
- Points
- 823
Hi everyone,
I recently updated my registration settings to use a basic age confirmation checkbox and completely disabled the Date of Birth requirement.
I am now looking to do two things via SQL to clean up my database:
1. Delete existing DOB data: To minimize the personal data we hold, I want to clear all previously stored DOB information. What is the safest query to reset the DOB fields for all users (presumably in xf_user_profile)?
2. Auto-tick the new Age Confirmation field...
Read more
Continue reading...
I recently updated my registration settings to use a basic age confirmation checkbox and completely disabled the Date of Birth requirement.
I am now looking to do two things via SQL to clean up my database:
1. Delete existing DOB data: To minimize the personal data we hold, I want to clear all previously stored DOB information. What is the safest query to reset the DOB fields for all users (presumably in xf_user_profile)?
2. Auto-tick the new Age Confirmation field...
Read more
Continue reading...