XF 2.2 Running SQL query on database

[Dzgsm]

Hi, possible way to update password members inactive (according to a certain period) via SQL query i do it on phpmyadmin.

 

[KSA]

Why do you need to change it via SQL when you could simply do it from your Admin Control Panel?

 

[Dzgsm]

how? spam problem, nothing worked for them

 

[Dzgsm]

 

[Mr Lucky]

how? spam problem, nothing worked for them

ACP > Users > Batch update the inactive users or usergroup to force a reset password. The next time they log in they will have to reset their password via email received so unless they also hacked the users email account they will not be able to.

If they did also hack the email account changing password via SQL query would be no use either anyway.

 

[Opus X]

Wouldn't this plug in work for you?

[OzzModz] Security Lock Old Accounts

Feb 13, 2024

Stop spammers from using breached accounts

• Painbaker
• Add-ons [2.x]