ical 2-way-sync mysql with different rental websites like: airbnb, tripadvisor, booking.com, etc

means we need a script with a - site to add/edit/delete rental website name and ical file locations for the properties/rooms (in DB) per cron job: - get ical files, - check if file and data is valid and important fields are shown correct/not empty/etc. - check if a reservation exists in DB for this rental website and property for these dates but not in ical file (means reservation is canceled/deleted and does not appear anymore in ical file) - in this case then move those reservation data to other table in DB (just for archiving) then: - check if reservation already exists, - if yes, check if date-range is the same, - if not: - check if date-range is available (if not send mail to admin) -check if this is a reservation from that website or blocked dates - then add/change reservation to mysql - make ical file from local DB to sync with rental websites get ical files from each rental website for every property one after the other (set up per cron job to run that script) script should log every step in mysql DB (this should be adjustable what to log - enable/disable the different steps available) script should have simple site to view/filter/search error-log in DB script should send mail to admin when errors appear, like dates not available, ical format from a certain rental website has changed, etc. script should be able to handle a big number of different properties with low server load NOT necessary a login NOT necessary any web-design