H Huskermax Active member Jan 1, 2017 #1 Looking for the DB location for join date, can't seem to find out how to edit that in admin. Our users that have been around a long time make a big deal about it. Some users did not get transferred from the VB software.
Looking for the DB location for join date, can't seem to find out how to edit that in admin. Our users that have been around a long time make a big deal about it. Some users did not get transferred from the VB software.
P Paul B XenForo moderator Staff member Jan 1, 2017 #2 It's xf_user.register_date - in UNIX time format. http://www.onlineconversion.com/unix_time.htm Upvote 0 Downvote
H Huskermax Active member Jan 5, 2017 #4 Brogan said: It's xf_user.register_date - in UNIX time format. http://www.onlineconversion.com/unix_time.htm Click to expand... I don't have any xf_user. all of them are xf_user_*** non of the tables have a . in them. I have 1.5 XenForo and I am using phpmyadmin to look at it. Upvote 0 Downvote
Brogan said: It's xf_user.register_date - in UNIX time format. http://www.onlineconversion.com/unix_time.htm Click to expand... I don't have any xf_user. all of them are xf_user_*** non of the tables have a . in them. I have 1.5 XenForo and I am using phpmyadmin to look at it.
P Paul B XenForo moderator Staff member Jan 5, 2017 #5 The . signifies the separation of table name and field/column name. So xf_user.register_date is the xf_user table and the register_date field/column. Upvote 0 Downvote
The . signifies the separation of table name and field/column name. So xf_user.register_date is the xf_user table and the register_date field/column.
H Huskermax Active member Jan 5, 2017 #6 Thanks for the lesson. Join date is fixed. Upvote 0 Downvote