To any who would like to take a stab at this question... I am writing a module for three different CMS, including Post Nuke, and PHP Nuke. It is a small affilate store module. At the moment, it requires the site's webmaster to download a file from my site periodically, and then dump certain tables in thier database, and replace them with the new tables in the file. This is due to price changes, updates, etc. I am interested in putting this file into a RSS / XML feed that the module could periodically grab using CRON, or the like and process it automatically, creating a backup of the tables it is deleting just in case, naming each backup sequentaily, so that the webmaster can revert to a prior version if need be, or retrieve data that was removed that should not have been...

Any one have any thoughts on how I can do this, or would most server security protocols block such activity...

Thanks...

    It's probably not a good idea to pass monetary data via RSS feed.

      I am only looking at passing prices and product descriptions. All payment information and such will be handled through Pay Pal's shopping cart system. I am simply looking into an easy way for affilate and partner sites to keep the product database tables updated, without having to constantly visit my site and download and install the updates manually. Using RSS/XML I am hoping I can have the module check automatically and update itself for instance every day, or every few days, no more then a week apart.

        Write a Reply...