21 May 2013 
Support Center » Knowledgebase » General Site Administration » User Management: Registration Date Adjustment
 User Management: Registration Date Adjustment
Article [FusionBB Versions: All]





You can easily adjust a user's registration date by using the following query:



UPDATE fbb_user_info
SET info_reg_date = 'xxxxx'
WHERE user_id = 'yyy'


Substitute the appropriate information for 'xxxxx' and 'yyy' .  Please note that the date format is epoch time, which is the number of seconds since January 1, 1970. (More details on epoch time can be found at Wikipedia.org: http://en.wikipedia.org/wiki/Unix_time ) .


FusionBB Developer Joshua Pettit has designed a program that can help you figure out the epoch time:  http://www.joshuapettit.com/time.php

If you have more questions or need suggestions for managing your users, please post a message at the main FusionBB website.


Article Details
Article ID: 90
Created On: 10 Nov 2008 7:53 PM

 This answer was helpful  This answer was not helpful

 Back
 Login  
Email Address:
Password:
Remember Me:
 
 Search
 Article Options
Home | Submit a Ticket | Knowledgebase | Downloads
Language:

Help Desk Software by Kayako eSupport v3.30.02