#!/usr/bin/php -q SELECT setting_value FROM CE_MH_EICR_Settings WHERE setting_id = 'eicr_hostName'SELECT setting_value FROM CE_MH_EICR_Settings WHERE setting_id = 'eicr_ftpUserName'SELECT setting_value FROM CE_MH_EICR_Settings WHERE setting_id = 'eicr_ftpPassword'SELECT setting_value FROM CE_MH_EICR_Settings WHERE setting_id = 'eicr_ftpRemotePathOutcomes'INSERT INTO MH_EICR_outcomes_log (start_datetime, end_datetime, result, spreadsheet_rows, unique_id) VALUES ('25-04-22 16:48:02', '25-04-22 16:48:02', 'Processing', '0', '1745336882_6807ba3222e60') ON DUPLICATE KEY UPDATE end_datetime = '25-04-22 16:48:02', result = 'Processing', spreadsheet_rows = '0'New record created successfullyDIR exists!25-04-22 16:48:020N/AINSERT INTO MH_EICR_outcomes_log (start_datetime, end_datetime, result, spreadsheet_rows, unique_id) VALUES ('25-04-22 16:48:02', '25-04-22 16:48:02', 'N/A', '0', '1745336882_6807ba3222e60') ON DUPLICATE KEY UPDATE end_datetime = '25-04-22 16:48:02', result = 'N/A', spreadsheet_rows = '0'New record created successfully
Array
(
)