[Life Revived]

Originally Posted by 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

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.