/**
  * Checks if there are not too many login attempts using specified username in the specified number of seconds until now.
  * @param  string  $username
  * @param  integer $count_limit number of login attempts
  * @param  integer $time_limit  number of seconds
  * @return boolean
  */
 public static function hasTooManyFailedAttempts($username, $count_limit = 5, $time_limit = 1800)
 {
     $since = new DateTime();
     $since->sub(new DateInterval("PT{$time_limit}S"));
     $subquery = UserLoginAttempt::model()->dbConnection->createCommand()->select('is_successful')->from(UserLoginAttempt::model()->tableName())->where('username = :username AND performed_on > :since')->order('performed_on DESC')->limit($count_limit)->getText();
     return $count_limit <= (int) UserLoginAttempt::model()->dbConnection->createCommand()->select('COUNT(NOT is_successful OR NULL)')->from("({$subquery}) AS t")->queryScalar(array(':username' => $username, ':since' => $since->format('Y-m-d H:i:s')));
 }