eduVPN / vpn-server-api

        return $stmt->fetchColumn();

    }

    public function setTotpSecret($userId, $totpSecret)

    {

        $userId = $this->getId($userId);

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

<<< 'SQL'

    INSERT INTO totp_secrets 

        (user_id, totp_secret) 

    VALUES

        (:user_id, :totp_secret)

SQL

        );

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

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

        try {

            $stmt->execute();

            return true;

        } catch (PDOException $e) {

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

            return false;

        }

    }

    public function deleteTotpSecret($userId)

    {

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

    }

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

    {

        $userId = $this->getId($userId);

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

<<< 'SQL'

    INSERT INTO totp_log 

        (user_id, totp_key, time_unix)

    VALUES

        (:user_id, :totp_key, :time_unix)

SQL

        );

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

        $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)

    {