XF 2.1 How can I change the date of all users' last activity to the date of their last post in the database?

Rom

Active member
If I wanted to change the date of all users' last activity to the date of their last post in the database, is there a PhpMyAdmin query I can use to do this? Thanks for any help or info. Sorry if this is the wrong forum. Wasn't sure where to post it.
 
Last edited:

Rom

Active member
Why do you want to do that?

Last post time is not necessarily last activity time.
yes I know, but I used a buggy add-on that ignored the parameters of which user groups to use and which not for Members Currently Online padding, so I have lots of very old users that have the same "last activity" date, a few of them actually passed away years before (I have a lot of elderly users on my forum). I know I can never get back their "true" last activity date so the next best thing is their last post date. it's really important that I fix this in some way. Thanks for any help @Brogan
 
Top