• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.3 Set user's registration date to their first post date

Jake Bunce

XenForo moderator
Staff member
#2
Code:
UPDATE xf_user AS u
SET u.register_date = (
    SELECT p.post_date
    FROM xf_post AS p
    WHERE p.user_id = u.user_id
    ORDER BY p.post_date
    ASC
    LIMIT 0,1
)
WHERE u.user_group_id = 2
Backup first.