member_details table: last_visit vs last_activity

[Richard Arch]

Hi

Can someone explain the difference of the last_visit and last_activity dates found in the member_details table?

When viewing a members profile, there is a field titled "Last Visited" but is displaying the last_activity, is this a bug?  Maybe both dates should be on the profile.

Thanks

 

[Richard Arch]

Can a Mod move this to a more appropriate forum, such as Help & Support.

Thanks

[Adriano Faria]

last_visit will store last time the member was online. last_activity will store last time the user performed some action. I’m not sure which actions without browse the files but I guess it’s something like submit/reply to a content item, react, update profile, etc.

Again, just guessing. 

[Richard Arch]

Hi Adriano, yes I would assume the same expect that does not seem to be the case.

Here is a screen shot of a members profile, note the last visited date.

Now here are the dates stored for that member, I've included both the unix date and formatted to dd/mm/yyyy for each.  Its clear that the profile is displaying the last_activity.

But why didn't the last visit update when there was activity?

Is it a bug?

 

[Randy Calvert]

last_visit_date I believe ties to the login function.   Remember...  someone who has a password stored can have activity that does not match the visit date.  

[Adriano Faria]

13 hours ago, Richard Arch said:

Hi Adriano, yes I would assume the same expect that does not seem to be the case.

Here is a screen shot of a members profile, note the last visited date.

Now here are the dates stored for that member, I've included both the unix date and formatted to dd/mm/yyyy for each.  Its clear that the profile is displaying the last_activity.

But why didn't the last visit update when there was activity?

Is it a bug?

 

Yes, it shows the last_activity in profile instead of last_visit:

				{{if $member->isOnline() AND ( !$member->isOnlineAnonymously() OR ( $member->isOnlineAnonymously() AND \IPS\Member::loggedIn()->isAdmin() ) )}}
					{lang="members_online_now"}
				{{elseif $member->last_activity}}
					{lang="members_last_visit"} {datetime="$member->last_activity"}
				{{endif}}