Jump to content

editing join dates on database?


TAMAN

Recommended Posts

Hi

Hi!
a couple weeks ago i merged 2 ip.board forums and now i notice that some users has a wrong join dates on their profile for example if they had registered on 2010 now it shows a different join dates 
its probably because they had the same user name and email address on both sides while i merged forums  

but im asking if its possible to change user join dates manually on database? i really need to do this and its important

Link to comment
Share on other sites

Hello, 

This is possible, but you always need to be careful when you do manual queries, of course.

If this is on IPS 4, then the following query should work:

UPDATE core_members SET joined=UNIX_TIMESTAMP('2004-10-30 09:00:00') WHERE member_id=X;

You'll need to add your database-prefix before "core_members" and replace X with the ID of the member you wish to update. You can find the member ID in the URL to that members profile. For example: https://community.invisionpower.com/profile/135437-tsp/

You also need to change the date, obviously. It's in the format of "year-month-day hour:minute:second". 

If this is on IPS 3.4.X, then the table name is "members" instead of "core_members". The rest of the query is the same.

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...