User lock out after 5 failed tries

[Bman900]

Your mysqldb doesn't have the method clearloginattempts.

 

No I fixed that, the brackets were closing at the wrong places. Now I have the log in page running but the script still doesnt do what I want to. You can enter wrong passwords till you die and it will never give you that error message..... am going to go nuts here soon if I cant figure it out.

[Ken2k7]

o.O

 

Can you tell me where the method clearloginattempts() is in your mysqldb class? I can't find it.

[Bman900]

/* Verify that user is in database */

      $q = "SELECT password FROM ".TBL_USERS." WHERE username = '$username'";

      $result = mysql_query($q, $this->connection);

      if(!$result || (mysql_numrows($result) < 1)){

        return 1; //Indicates username failure

      }

   

    function clearLoginAttempts($value) {

    $q = "UPDATE ".TBL_ATTEMPTS." SET attempts = 0 WHERE ip = '$value'";

  return mysql_query($q, $this->connection);

  }

 

      /* Retrieve password from result, strip slashes */

      $dbarray = mysql_fetch_array($result);

      $dbarray['password'] = stripslashes($dbarray['password']);

      $password = stripslashes($password);

 

 

I actually moved that up above the function confirmIPAddress($value)  to make it work.

[Ken2k7]

But you're putting a function inside of a function. Put it outside of that function while keeping the function within the class.

Wow, you're like a baby following baby steps. That quote remains... :-\