eduVPN / vpn-server-api

        return 1 === $stmt->rowCount();

    }

    public function addCertificate($externalUserId, $commonName, $displayName, $validFrom, $validTo)

    {

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

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

            'INSERT INTO certificates (common_name, user_id, display_name, valid_from, valid_to) VALUES(:common_name, :user_id, :display_name, :valid_from, :valid_to)'

        );

        $stmt->bindValue(':common_name', $commonName, PDO::PARAM_STR);

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

        $stmt->bindValue(':display_name', $displayName, PDO::PARAM_STR);

        $stmt->bindValue(':valid_from', $validFrom, PDO::PARAM_INT);

        $stmt->bindValue(':valid_to', $validTo, PDO::PARAM_INT);

        $stmt->execute();

        return 1 === $stmt->rowCount();

    }

    public function getCertificates($externalUserId)

    {

        return 1 === intval($stmt->fetchColumn());

    }

    public function clientConnect($profileId, $commonName, $ip4, $ip6, $connectedAt)

    {

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

            'INSERT INTO connection_log (

                profile_id,

                common_name,

                ip4,

                ip6,

                connected_at

             ) 

             VALUES(

                :profile_id, 

                :common_name,

                :ip4,

                :ip6,

                :connected_at

             )'

        );

        $stmt->bindValue(':profile_id', $profileId, PDO::PARAM_STR);

        $stmt->bindValue(':common_name', $commonName, PDO::PARAM_STR);

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

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

        $stmt->bindValue(':connected_at', $connectedAt, PDO::PARAM_INT);

        $stmt->execute();

        return 1 === $stmt->rowCount();

    }

    public function clientDisconnect($profileId, $commonName, $ip4, $ip6, $connectedAt, $disconnectedAt, $bytesTransferred)

    {