🕸Fergus Duniho wrote on Fri, Oct 27, 2017 09:19 PM UTC:
Here's what's going on. Whenever a row in the Person table is updated, the LastLogin column is automatically updated to the current timestamp. This is done by MYSQL, not by PHP, which is why it happens without appearing in the PHP code. The reason it wasn't always updating is that logging in hasn't been coded to update the Person table when someone logs in. So, it has updated only when someone has done something that involves updating their information in the person table.
I am going to change this by having the login function update the new IPAddress column whenever someone logs in. My plan is to eventually offer the ability for members to find their geographical neighbors, so that people can play Chess variants in person, as David and I used to do after I noticed his email address was with my local phone company and asked if he was local.
Here's what's going on. Whenever a row in the Person table is updated, the LastLogin column is automatically updated to the current timestamp. This is done by MYSQL, not by PHP, which is why it happens without appearing in the PHP code. The reason it wasn't always updating is that logging in hasn't been coded to update the Person table when someone logs in. So, it has updated only when someone has done something that involves updating their information in the person table.
I am going to change this by having the login function update the new IPAddress column whenever someone logs in. My plan is to eventually offer the ability for members to find their geographical neighbors, so that people can play Chess variants in person, as David and I used to do after I noticed his email address was with my local phone company and asked if he was local.