adjustable PHP script for syhronising SQL DB's online (internet) and offline (intranet).

I'm looking for a PHP-script that can synchronise 2 DB's (one as the back-end of my website and one as the back-end of intranet website). Both of these websites are based on PHP-nuke. I need to be able to specify wich tables to be synchronised (these settings should be stored in a synhro administration table) Both intranet and internet-servers are installed with LAMP servers. Intranet server is on a cable connection (no fixed IP). Synchronisation should be initiated from intranet server (time-based using cron or admin-triggered). A php-nuke admin-module (in admin section) would be ideal (not necessary). The online DB is not accessible directly (only through php-pages). The solution should use PHP-nuke abstraction layer so that different types of DB's can be synced. I should be able to (e.g.): * sync user tables * sync forum posts * sync entry lists for competition (show-jumping) (**) * sync results for jumped courses (penalties, ...) (**) ** this is what I will need the script for. The two first are examples The script should be made adjustable , so that other tables can be synced later ## Deliverables Let me explain more clearly: I'ld like the script to act according to the synchronisation rules stored in a synchronisation table. This way, I can 'manage' the script by altering the rules in the table. Don't know if I can put this into format. table: sync_rules field1: rule-id (just an identifier) field2: table-name (name of the tables to be synced) field3: direction (this says how to do synchronisation, online => offline or offline => online (up- or download)) field4: record_or_not (this defines if the whole table needs to be synced (not 1 record) or just one record) Let's put that last one better: I want to be able to call your script with a function of my own in wich I can pass a table-name and record and then your script just syncs that one record in that table. Those were just fields that I could come up with. (adding fields later on to further define the synchronisation rules is possible) In this setup I only install the script on my intranet (because that is the only place I can use it, since I don't have a fixed IP). In order to use the script, we would need a few functions in a file that we put online to enable us to write and read to and from the DB (insert, update, delete)and (reading table records to compare them with what I have offline.) I would also like a sript that insert, edit , delete rules from the sync table (simple) in the PHP-nuke admin area. I hope that clears it out a little. (I could almost do it myself) Anyway, I appreciate your fast response. Thanks in advance. To be delivered: 1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) installation tool not necessary (only txt-file that show where files should be put in document tree) 3) Complete ownership and distribution copyrights to all work purchased. - - I want to release the source code to the PHP-nuke community 4) Source code should be commented (a little) ## Platform LAMP- servers. Web-based administration. (cross-browser)