eduVPN / vpn-server-api

        return $userList;

    }

    public function getUserCertificateInfo($commonName)

    {

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

<<< 'SQL'

    SELECT 

        u.user_id AS user_id, 

        u.is_disabled AS user_is_disabled,

        c.display_name AS display_name,

        c.is_disabled AS certificate_is_disabled 

    FROM 

        users u, certificates c 

    WHERE 

        u.id = c.user_id AND 

        c.common_name = :common_name

SQL

        );

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

        $stmt->execute();

        return $certificateList;

    }

    public function disableCertificate($commonName)

    {

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

<<< 'SQL'

    UPDATE 

        certificates 

    SET 

        is_disabled = 1 

    WHERE

        common_name = :common_name

SQL

        );

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

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

    }

    public function deleteCertificate($commonName)

    {

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

<<< 'SQL'

    DELETE FROM 

        certificates 

    WHERE 

        common_name = :common_name

SQL

        );

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

        $stmt->execute();

        // XXX

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

    }

    public function enableCertificate($commonName)

    {

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

<<< 'SQL'

    UPDATE 

        certificates 

    SET 

        is_disabled = 0 

    WHERE 

        common_name = :common_name

SQL

        );

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

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

    }

    public function getLogEntry($dateTimeUnix, $ipAddress)

    {

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

<<< 'SQL'

    SELECT 

        user_id,

        profile_id, 

        common_name, 

        ip4, 

        ip6, 

        connected_at, 

        disconnected_at

    FROM

        connection_log

    WHERE

        (ip4 = :ip_address OR ip6 = :ip_address)

    AND 

        connected_at < :date_time_unix

    AND