PDA

View Full Version : User forgot password, how to reset his tries ?



Peter Jonsson
November 28, 2013, 03:36 PM
So a user contacted me that he forgot his password and used his 5 (or maybe it's 3 times) times and are locked out from the site unable to login.

How can i reset this as an admin ?
Cant find this feature anywhere

Mike
November 29, 2013, 03:36 AM
There is no option to reset it in current version unfortunately.

If you have cron job configured login attempts are cleared each time cron runs (supposed to be daily)

For now you can use one of following sql queries - you need Aвmin Panel >Database page to executes them:

to delete all login attempts for all users


TRUNCATE TABLE `{sql_prefix}login_attempts`



to delete all login attempts for specific user by ip dont forget to replace 127.0.0.1 with the right ip


DELETE FROM `{sql_prefix}login_attempts` WHERE `IP` = '127.0.0.7'



to delete all login attempts for specific user by username


DELETE FROM `{sql_prefix}login_attempts` WHERE `Username` = 'Username'