eduVPN / vpn-server-api

        return $userList;

    }

    public function getUserCertificateStatus($commonName)

    {

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

            'SELECT 

                u.external_user_id AS external_user_id, 

                u.is_disabled AS user_is_disabled, 

                c.is_disabled AS certificate_is_disabled 

             FROM users u, certificates c 

             WHERE c.common_name = :common_name'

        );

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

        $stmt->execute();

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

    }

    private function getUserId($externalUserId)

    {

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

    }

    public function deleteUser($externalUserId)

    {

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

            'DELETE FROM users WHERE external_user_id = :external_user_id'

        );

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

        $stmt->execute();

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

    }

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

    {

        return $certificateList;

    }

    public function disableCertificate($commonName)

    {

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

            'UPDATE certificates SET is_disabled = 1 WHERE common_name = :common_name'

        );

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

        $stmt->execute();

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

    }

    public function enableCertificate($commonName)

    {

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

    }

    public function enableCertificate($commonName)

    {

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

            'UPDATE certificates SET is_disabled = 0 WHERE common_name = :common_name'

        );

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

        $stmt->execute();

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

    }

    public function disableUser($externalUserId)

    {

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

    }

    public function disableUser($externalUserId)

    {

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

            'UPDATE users SET is_disabled = 1 WHERE external_user_id = :external_user_id'

        );

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

        $stmt->execute();

        // XXX it seems on update the rowCount is always 1, even if nothing was

        // modified?

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

    }

    public function enableUser($externalUserId)

    {

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

    }

    public function enableUser($externalUserId)

    {

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

            'UPDATE users SET is_disabled = 0 WHERE external_user_id = :external_user_id'

        );

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

        $stmt->execute();

        // XXX it seems on update the rowCount is always 1, even if nothing was

        // modified?

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

    }

    public function isDisabledUser($externalUserId)

    {

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

    }

    public function getLogEntry($dateTimeUnix, $ipAddress)

    {

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

            'SELECT 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 (disconnected_at > :date_time_unix OR disconnected_at IS NULL)'

        );

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

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

        $stmt->execute();

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

    }

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

    {

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

    }

    public function cleanConnectionLog($timeUnix)

    {

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

            sprintf(

                'DELETE FROM connection_log

                    WHERE connected_at < :time_unix'

            )

        );

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

        return $stmt->execute();

    }

    public function cleanTotpLog($timeUnix)

    {

        return $stmt->execute();

    }

    public function cleanTotpLog($timeUnix)

    {

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

            sprintf(

                'DELETE FROM totp_log

                    WHERE time_unix < :time_unix'

            )

        );

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

        return $stmt->execute();

    }

    public function motd()

    {