Log in

View Full Version : Mass password reset


hollyboy
12-09-2015, 07:53 PM
Hi

I need a mass password reset to all the users of my forum.
I don't see an hack or anything that does that.

Can anyone help more?
Much appreciated

Dragonsys
12-09-2015, 09:11 PM
run a sql query
UPDATE user SET password = '12345' WHERE password != '';

since the passwords are hashed this will set an unkown password, which will not allow the user to login, they will have to perform a password reset using the Forgot Password link. If you want to exclude your account, the use this instead

UPDATE user SET password = '12345' WHERE userid != {whatever your id is};

ForceHSS
12-09-2015, 09:57 PM
https://vborg.vbsupport.ru/showthread.php?t=264515
https://vborg.vbsupport.ru/showthread.php?t=276228

hollyboy
12-09-2015, 10:02 PM
https://vborg.vbsupport.ru/showthread.php?t=264515
https://vborg.vbsupport.ru/showthread.php?t=276228

these are great thanks!!!!!!!!

--------------- Added 1449706402 at 1449706402 ---------------

run a sql query
UPDATE user SET password = '12345' WHERE password != '';

since the passwords are hashed this will set an unkown password, which will not allow the user to login, they will have to perform a password reset using the Forgot Password link. If you want to exclude your account, the use this instead

UPDATE user SET password = '12345' WHERE userid != {whatever your id is};

thanks that helped