Query to update passwords for inactive users

[Piloux]

Hi,

I would like to know if it's possible to execute a query directly on the database in order to update a usergroup's users passwords if their date of last activity (last time they made a post) is before let's say 1st december of 2019. And yes please don't tell me to make password expiration like 7 days because if the accounts original passwords have been compromised, it means that the hacker could potentially change again the new password.

I had already done that before with that kind of request :

UPDATE users SET password = 'the-same-md5-password-for-every-update' WHERE usergroupid=3

Since the salt is different for every member, that means they all should have a different password even by putting the same md5 pass.

The thing is that I don't think using "<" in the query's condition would have an effect on the lastpost entry since it's not a single number (it's something like "1578136140" and I don't know how to interpret that).


Thanks for your help

[Dave]

When you say date of last activity, you mean the last time they logged in or the last time they made a post/thread?

[Piloux]

Last time they made a post/thread yes.

--------------- Added [DATE]1579184184[/DATE] at [TIME]1579184184[/TIME] ---------------

Originally Posted by Dave

When you say date of last activity, you mean the last time they logged in or the last time they made a post/thread?

The thing is that I don't think using "<" in the query's condition would have an effect on the lastpost entry since it's not a single number (it's something like "1578136140" and I don't know how to interpret that).

--------------- Added [DATE]1579187292[/DATE] at [TIME]1579187292[/TIME] ---------------

Edit problem solved thanks.