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
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)
Web-based administration. (cross-browser)