Mass forum password/reset notification?

[Life Revived]

Basically I just want to be able to make it where when a user logs in it requests that they change their password saying it as expired. I would use the expiry password option to the usergroup but if I set it to 7 days it won't matter to the people that don't login before that time. And if I have to enable it again the users that already reset their password will have to do it again and get annoyed.

Now the even better situation is if I can run something to be able to change everybody's password manually and then just send them an email explaining they need to change their passwords and I will include a link where they enter their email in and they can change it with that. Or if they try to login eventually with their old password it states that it has been changed and they need to do a reset with their email.

Any help with this would be appreciated. Thanks!

[ozzy47]

Do a backup first!

You can set the Password Expiry to 730, then run this query.

UPDATE `user` SET `passworddate` = '2011-10-20' WHERE `user`.`userid` !=1;

That will set everyone's date back to two days before the expiry date except the userid of 1

Then when every user logs in, they will need to set a new date

[Life Revived]

Do a backup first!

You can set the Password Expiry to 730, then run this query.

UPDATE `user` SET `passworddate` = '2011-10-20' WHERE `user`.`userid` !=1;

That will set everyone's date back to two days before the expiry date except the userid of 1

Then when every user logs in, they will need to set a new date

Will it also allow me to enter in more id's so it does not prompt them to change their password? Like !=1,2,3;

Also this is a normal query to run via acp correct? And by password date you mean it will just say your password is so and so days old and needs to be changed where they can do it right on the site correct.

[ozzy47]

Sure use this format.

UPDATE `user` SET `passworddate` = '2012-10-22' WHERE `user`.`userid` !=1 AND `user`.`userid` !=2 AND `user`.`userid` !=3;Yes you run the query in the acp.

Correct, it will give them the standard message:

Your password is 733 days old, and has therefore expired.

Please change your password using this page.

[Life Revived]

Sure use this format.

UPDATE `user` SET `passworddate` = '2012-10-22' WHERE `user`.`userid` !=1 AND `user`.`userid` !=2 AND `user`.`userid` !=3;Yes you run the query in the acp.

Correct, it will give them the standard message:

Your password is 733 days old, and has therefore expired.

Please change your password using this page.

Ok thank you very much ozzy!

[ozzy47]

Not a problem, glad to help. :)

[Life Revived]

Not a problem, glad to help. :)

I would like your post to but it seems I've liked you a lot and won't let me haha. Keep up the awesome work and job around here dude!

[ozzy47]

Not a problem, alot of people run into that. :)