In need of a programmer that can make the following changes to pre-existing scripts.
Script Modification Requirements ([url removed, login to view])
[url removed, login to view]
(Important note: [url removed, login to view] already performs a number of functions that work properly. These functions should not be affected in any way by the new modification request detailed below. All new modifications should be added to the end ? and run after all of the functionality that is currently running within [url removed, login to view]).
The new modified script ([url removed, login to view]) will need to look at tables: default_litstingsDB, default_listingsDBElements, as well as default_listingsImages and perform the following:
1. Check the time stamp located within the cr_datetime field and compare to the current date. If the date within cr_datetime is greater than 60 days old all of the associated information within that row should be purged. The script will need to check every row within each of the tables mentioned above (note that the cr_datetime field is present in each of the tables)
[url removed, login to view] will then need to update tables: default_listingsDB, default_listingsDBElements and default_listingsImages with the information that is contained within each table's respective ?_A? mirror. (ex. default_listingsDB should be updated with all of the information contained within default_listingsDB_A, etc. etc.). One very important requirement related to this step is that any duplicate data should either be left alone or overwritten in order to avoid duplicate entries. (note that a comparison will need to be done on the ?ID? field in order to determine if the data should be overwritten. If the ID field matches between tables (ex. default_listingsDB and default_listingsDB_A) overwrite the data. All other data should simply be copied over.
Purge all data from default_listingsDB_A, default_listingsDBElements_A, and default_listingsImages_A upon completion of Step #2.
Drop all default_temp_********* tables. These tables are created by users that do not wait for pages to load completely before navigating to another part of the site. They build up over time and need to be purged periodically. Note that default_temp should not be deleted ? only tables that contain a second underscore and series of number/letters afterward.