UPDATE xf_user
SET register_date = UNIX_TIMESTAMP('yyyy-mm-dd 00:00:00')
WHERE user_id = 1
Hi
I would like to change the registration /joined date of many user in one step. All those users have a registration date of 01.01.1970. This is because of a very old import from another forum software into vbulletin. Now I import from vb into xf and would like to change all those wrong dates into something more logical like 14.1.2003.
How can I do this in phpmyadmin?
UPDATE xf_user
SET register_date = UNIX_TIMESTAMP('yyyy-mm-dd 00:00:00')
WHERE register_date = 0
That would be a timestamp of 0. This query should work:
Code:UPDATE xf_user SET register_date = UNIX_TIMESTAMP('yyyy-mm-dd 00:00:00') WHERE register_date = 0
waindigo did a little addon for me that made the Join date an editable field on the front of the user account in admin.
If anyone wants it ask waindigo about it.
UPDATE xf_user
SET register_date = UNIX_TIMESTAMP('yyyy-mm-dd 2003:01:14')
WHERE register_date = 0
We use essential cookies to make this site work, and optional cookies to enhance your experience.