eduVPN / vpn-server-api

        return $stmt->fetchColumn();

    }

    public function setTotpSecret($externalUserId, $totpSecret)

    {

        $userId = $this->getUserId($externalUserId);

        $stmt = $this->db->prepare(

            'INSERT INTO totp_secrets (user_id, totp_secret) VALUES(:user_id, :totp_secret)'

        );

        $stmt->bindValue(':user_id', $userId, PDO::PARAM_STR);

        $stmt->bindValue(':totp_secret', $totpSecret, PDO::PARAM_STR);

        try {

            $stmt->execute();

        } catch (PDOException $e) {

            // unable to add the TOTP secret, probably uniqueness contrains

            return false;

        }

        return true;

    }

    public function deleteTotpSecret($externalUserId)

    {

        return $stmt->fetchAll(PDO::FETCH_ASSOC);

    }

    public function recordTotpKey($externalUserId, $totpKey, $timeUnix)

    {

        $userId = $this->getUserId($externalUserId);

        $stmt = $this->db->prepare(

            'INSERT INTO totp_log (

                user_id,

                totp_key,

                time_unix

             ) 

             VALUES(

                :user_id, 

                :totp_key,

                :time_unix

             )'

        );

        $stmt->bindValue(':user_id', $userId, PDO::PARAM_STR);

        $stmt->bindValue(':totp_key', $totpKey, PDO::PARAM_STR);

        $stmt->bindValue(':time_unix', $timeUnix, PDO::PARAM_INT);

        try {

            $stmt->execute();

        } catch (PDOException $e) {

            // unable to record the TOTP, probably uniqueness contrains

            return false;

        }

        return true;

    }

    public function cleanConnectionLog($timeUnix)

    {