Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 16 Jan 2020, 11:37
Piloux Piloux is offline
 
Join Date: Oct 2017
Query to update passwords for inactive users

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 :


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


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

Last edited by Piloux; 16 Jan 2020 at 13:16.
Reply With Quote
  #2  
Old 16 Jan 2020, 11:40
Dave Dave is offline
 
Join Date: Jun 2010
Real name: 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?
__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #3  
Old 16 Jan 2020, 11:58
Piloux Piloux is offline
 
Join Date: Oct 2017
Last time they made a post/thread yes.

--------------- Added 16 Jan 2020 at 13:16 ---------------

Originally Posted by Dave View Post
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 16 Jan 2020 at 14:08 ---------------

Edit problem solved thanks.

Last edited by Piloux; 16 Jan 2020 at 12:04.
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 04:53.

Layout Options | Width: Wide Color: