Mass forum password/reset notification?

[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