eduVPN / vpn-server-api

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

    }

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

    {

        $userId = $this->getInternalUserId($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 $stmt->fetchAll(PDO::FETCH_ASSOC);

    }

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

    {

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

            'INSERT INTO connection_log (

                external_user_id,

                profile_id,

                common_name,

                ip4,

                ip6,

                connected_at

             ) 

             VALUES(

                (

                    SELECT

                        u.external_user_id

                    FROM 

                        users u, certificates c

                    WHERE

                        u.user_id = c.user_id

                    AND

                        c.common_name = :common_name

                ),                

                :profile_id, 

                :common_name,

                :ip4,

                :ip6,

                :connected_at

             )'

        );

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

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