Create an e107 plugin which will pull in XML data, perform an XSL transformation, and present the transformed data on an e107 Web site.
The plugin should work within the e107 framework. It will have a back end interface and a front end interface. The back end will allow an administrator to specify to values.
The front end will take those two values, and via an XML RPC call will retrieve an XML document that contains the result set. An XSL transformation will then be performed on the result set, and the transformed data will be displayed to the user.
The XSL file has already been written.
The e107 plugin should be able to cache a response, using an easily changed value (i.e. it will only perform the query once every five minutes).