How to output failed login attempts on frontend

[Juergen]

Hello @ all,

on my frontend form I use a login throttle with "try" and "catch" and it works well. What I want is to add a counter of the failed login attempts displayed for the user, so the user can always see how many login attempts were done.

Example: Login attempt 1, 2, 3 and so on.

How can I count the number of attempts and output it on the frontend (nothing to store in the database).

Has anyone done something similar in the past and can help me?

Best regards

[LostKobrakai]

https://github.com/ryancramerdesign/ProcessWire/blob/master/wire/modules/Session/SessionLoginThrottle/SessionLoginThrottle.module#L85-L90

[Juergen]

Now I got it working !

I check again the username in this case, therefore  I grab the username at the beginning of this code.

                        $usernamevalue    = $sanitizer->username($input->post->user);//grab the username after submit
                        $database = $this->wire('database');
                        $name     = $usernamevalue;
                        $query    = $database->prepare("SELECT attempts FROM session_login_throttle WHERE name=:name");
                        $query->bindValue(":name", $name);
                        $query->execute();
                        $numRows = $query->rowCount();
                        if ($numRows)
                            list($attempts) = $query->fetch(PDO::FETCH_NUM);
                        echo $attempts;//this outputs the login attempts

Hope this helps others with the same problem.