В роботі

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)

Навички: PHP

Показати більше: write your name online, where to write online, tree update, tree insert, tree in order, synchronise it, source php forum, simple php forum code, simple forum php script, program download websites, program competition, php function for, php examples with source code, pages to write on online, order of tree, online php courses, online internet work, online competition website, online competition rules, online administration work, lamp server administration, i want to write my name with an edit, id program online, code websites online, code offline

Про роботодавця:
( 1 відгук ) Belgium

ID проекту: #2917100

Доручено:

visiontechvw

See private message.

$85 USD за 14 дні(-в)
(3 відгуків(-и))
3.4

4 фрілансерів(-а) подали заявки на цю роботу; середня заявка - $79

oxlip

See private message.

$59.5 USD за 14 дні(-в)
(6 відгуків(-и))
3.1
iwtechvw

See private message.

$85 USD за 14 дні(-в)
(1 відгук)
0.0
gladiaker

See private message.

$85 USD за 14 дні(-в)
(0 відгуків(-и))
0.0