How can I change a "Join date" by a user?

[DanielZibik]

How can I change a "Join date" by a user? (4.3.x)
 

 

~Daniel

[Aiwa]

You don’t? Not without manual DB modification. Which has inherent risks, not just in making the change, but in data integrity also. You have now, potentially, altered a static value that is always consistently relative with the SQL auto-increment value, member_id between members.

Out of curiosity, why are you looking to do this?

[MMXII]

There is no setting in the AdminCP to change this value, but you can open your database and go to core_members > (member name) > joined and enter a new value manually. I am not sure though, if this is risky or not.

[DanielZibik]

http://prntscr.com/m2bdkq

I can not understand this system

[Aiwa]

That's the REST API, and you haven't set it up, or submitted the request without the key...

The suggestion was to look at the database directly, Phpmyadmin or the like to manually manipulate the database.

[Sovereign Grace Singles]

I wouldn't mind doing this also, that is changing a member's join date. I initially set up my new IPS board and created a new admin. When I migrated my VB board over I then merged the wrong old account to the new admin account rather than vice versa. The oldest account, mine, now appears to be the youngest with the most posts etc.

Just chiming in to suggest that if such a simple database edit is safe I'm for doing this. Will wait until more feedback.

[Jheroen]

I have the same question, migrated and the oldest user is now the most recent user, should be good to set that user back to the original join date, how can this be done?

In the databasefield the join table is some encoded string i guess

[Adriano Faria]

@Daniel.Zibik @Christforums @Jheroen

I'm developing a plugin:

Log:

 

Doing the ACP stuff. Should be ready tomorrow in the morning. Drop a PM if you're interested.

Tks.

[Adriano Faria]

15 hours ago, Adriano Faria said:

Doing the ACP stuff.

Only ADMINs can change joined date.

[Jheroen]

Looks great, a plugin?

[Adriano Faria]

1 minute ago, Jheroen said:

Looks great, a plugin?

Yes, waiting for marketplace approval:

 

[Jheroen]

Invisible 😛

[Adriano Faria]

Just now, Jheroen said:

Invisible 😛

 

6 minutes ago, Adriano Faria said:

waiting for marketplace approval

 

[DanielZibik]

What will the price be?

[Adriano Faria]

$10.

[DanielZibik]

Nice, I will buy it! 🙂

[Adriano Faria]

@Daniel.Zibik @Christforums @Jheroen

It's available now:

 

 

[DanielZibik]

Following problem:

" The date must be after 10/24/2018. "

Can i fix it? 😐

[Adriano Faria]

1 minute ago, Daniel.Zibik said:

Following problem:

" The date must be after 10/24/2018. "

Can i fix it? 😐

Please, post in the support topic. 

Take a look: 

 

[ahc]

My community migrated from forumotion, which to no surprise to their notorious poor customer experience does not allow data transfers, so we let our members make new accounts on the IPB system.  Over the course of the first year and a half, we individually went in and manually edited member's join dates via the database to reflect their true stats.  We stopped doing it at the turn of this year because we wanted to focus on the growth of our current site and leave the old one behind.  We had about 4k active members at that time and we've not run into a single issue stemming from this growing up to 8k forward.  However, experiences are unique and I don't encourage anyone to do this unless you know what you're doing and you're willing to take the risk of malfunction regardless of what changes you're making to a database table, not just members.

I'm a little bumed out that Adriano now has a plugin for this, because that was not a fun time for me or my partner.  Having that much data on the table meant each page load it got slower and slower, and splitting the work just made it drag out even longer.  I'm glad you guys have an alternative now, a seemingly quicker and easier option, thanks to him.  I would have gladly paid $10 or more to avoid that headache.  😅