##### END SETTINGS LOOKUP ##### ########################################### ### ARCHIVED DATA CHECK CONFIGURATION $archives_available = "N"; $log_tables_array = array("vicidial_did_log", "vicidial_closer_log", "live_inbound_log"); for ($t = 0; $t < count($log_tables_array); $t++) { $table_name = $log_tables_array[$t]; $archive_table_name = use_archive_table($table_name); if ($archive_table_name != $table_name) { $archives_available = "Y"; } } if ($search_archived_data) { $vicidial_did_log_table = use_archive_table("vicidial_did_log"); $vicidial_closer_log_table = use_archive_table("vicidial_closer_log"); $live_inbound_log_table = use_archive_table("live_inbound_log"); } else { $vicidial_did_log_table = "vicidial_did_log"; $vicidial_closer_log_table = "vicidial_closer_log"; $live_inbound_log_table = "live_inbound_log"; } ############# $stmt = "SELECT local_gmt FROM servers where active='Y' limit 1;"; $rslt = mysql_to_mysqli($stmt, $link); if ($DB) { $MAIN .= "{$stmt}\n"; } $gmt_conf_ct = mysqli_num_rows($rslt); $dst = date("I"); if ($gmt_conf_ct > 0) { $row = mysqli_fetch_row($rslt);
$slave_db_server = $row[2]; $reports_use_slave_db = $row[3]; $SSenable_languages = $row[4]; $SSlanguage_method = $row[5]; } ##### END SETTINGS LOOKUP ##### ########################################### ### ARCHIVED DATA CHECK CONFIGURATION $archives_available = "N"; $table_name = "vicidial_closer_log"; $archive_table_name = use_archive_table($table_name); if ($archive_table_name != $table_name) { $archives_available = "Y"; } if ($search_archived_data) { $vicidial_closer_log_table = use_archive_table("vicidial_closer_log"); } else { $vicidial_closer_log_table = "vicidial_closer_log"; } ############# if ($non_latin < 1) { $PHP_AUTH_USER = preg_replace('/[^-_0-9a-zA-Z]/', '', $PHP_AUTH_USER); $PHP_AUTH_PW = preg_replace('/[^-_0-9a-zA-Z]/', '', $PHP_AUTH_PW); } else { $PHP_AUTH_PW = preg_replace("/'|\"|\\\\|;/", "", $PHP_AUTH_PW); $PHP_AUTH_USER = preg_replace("/'|\"|\\\\|;/", "", $PHP_AUTH_USER); } $stmt = "SELECT selected_language from vicidial_users where user='******';"; if ($DB) { echo "|{$stmt}|\n"; }
$table_name = $log_tables_array[$t]; $archive_table_name = use_archive_table($table_name); if ($archive_table_name != $table_name) { $archives_available = "Y"; } } if ($search_archived_data) { $vicidial_log_table = use_archive_table("vicidial_log"); $vicidial_closer_log_table = use_archive_table("vicidial_closer_log"); $vicidial_agent_log_table = use_archive_table("vicidial_agent_log"); $vicidial_log_extended_table = use_archive_table("vicidial_log_extended"); $recording_log_table = use_archive_table("recording_log"); $vicidial_carrier_log_table = use_archive_table("vicidial_carrier_log"); $vicidial_cpd_log_table = use_archive_table("vicidial_cpd_log"); $vicidial_did_log_table = use_archive_table("vicidial_did_log"); $vicidial_outbound_ivr_log_table = use_archive_table("vicidial_outbound_ivr_log"); } else { $vicidial_log_table = "vicidial_log"; $vicidial_closer_log_table = "vicidial_closer_log"; $vicidial_agent_log_table = "vicidial_agent_log"; $vicidial_log_extended_table = "vicidial_log_extended"; $recording_log_table = "recording_log"; $vicidial_carrier_log_table = "vicidial_carrier_log"; $vicidial_cpd_log_table = "vicidial_cpd_log"; $vicidial_did_log_table = "vicidial_did_log"; $vicidial_outbound_ivr_log_table = "vicidial_outbound_ivr_log"; } ############# if ($non_latin < 1) { $PHP_AUTH_USER = preg_replace('/[^-_0-9a-zA-Z]/', '', $PHP_AUTH_USER); $PHP_AUTH_PW = preg_replace('/[^-_0-9a-zA-Z]/', '', $PHP_AUTH_PW);
########################################### if (strlen($report_display_type) < 2) { $report_display_type = $SSreport_default_format; } ### ARCHIVED DATA CHECK CONFIGURATION $archives_available = "N"; $log_tables_array = array("vicidial_agent_log"); for ($t = 0; $t < count($log_tables_array); $t++) { $table_name = $log_tables_array[$t]; $archive_table_name = use_archive_table($table_name); if ($archive_table_name != $table_name) { $archives_available = "Y"; } } if ($search_archived_data) { $vicidial_agent_log_table = use_archive_table("vicidial_agent_log"); } else { $vicidial_agent_log_table = "vicidial_agent_log"; } ############# if ($non_latin < 1) { $PHP_AUTH_USER = preg_replace('/[^-_0-9a-zA-Z]/', '', $PHP_AUTH_USER); $PHP_AUTH_PW = preg_replace('/[^-_0-9a-zA-Z]/', '', $PHP_AUTH_PW); } else { $PHP_AUTH_PW = preg_replace("/'|\"|\\\\|;/", "", $PHP_AUTH_PW); $PHP_AUTH_USER = preg_replace("/'|\"|\\\\|;/", "", $PHP_AUTH_USER); } $stmt = "SELECT selected_language from vicidial_users where user='******';"; if ($DB) { echo "|{$stmt}|\n"; }
$slave_db_server = $row[2]; $reports_use_slave_db = $row[3]; $SSenable_languages = $row[4]; $SSlanguage_method = $row[5]; } ##### END SETTINGS LOOKUP ##### ########################################### ### ARCHIVED DATA CHECK CONFIGURATION $archives_available = "N"; $table_name = "vicidial_did_log"; $archive_table_name = use_archive_table($table_name); if ($archive_table_name != $table_name) { $archives_available = "Y"; } if ($search_archived_data) { $vicidial_did_log_table = use_archive_table("vicidial_did_log"); } else { $vicidial_did_log_table = "vicidial_did_log"; } ############# if ($non_latin < 1) { $PHP_AUTH_USER = preg_replace('/[^-_0-9a-zA-Z]/', '', $PHP_AUTH_USER); $PHP_AUTH_PW = preg_replace('/[^-_0-9a-zA-Z]/', '', $PHP_AUTH_PW); } else { $PHP_AUTH_PW = preg_replace("/'|\"|\\\\|;/", "", $PHP_AUTH_PW); $PHP_AUTH_USER = preg_replace("/'|\"|\\\\|;/", "", $PHP_AUTH_USER); } $stmt = "SELECT selected_language from vicidial_users where user='******';"; if ($DB) { echo "|{$stmt}|\n"; }
$log_recording_access = $row[7]; } ##### END SETTINGS LOOKUP ##### ########################################### $recording_id = preg_replace('/[^0-9]/', '', $recording_id); $lead_id = preg_replace('/[^0-9]/', '', $lead_id); $search_archived_data = preg_replace("/'|\"|\\\\|;/", "", $search_archived_data); if ($non_latin < 1) { $PHP_AUTH_USER = preg_replace('/[^-_0-9a-zA-Z]/', '', $PHP_AUTH_USER); $PHP_AUTH_PW = preg_replace('/[^-_0-9a-zA-Z]/', '', $PHP_AUTH_PW); } else { $PHP_AUTH_USER = preg_replace("/'|\"|\\\\|;/", "", $PHP_AUTH_USER); $PHP_AUTH_PW = preg_replace("/'|\"|\\\\|;/", "", $PHP_AUTH_PW); } if ($search_archived_data) { $recording_log_table = use_archive_table("recording_log"); } else { $recording_log_table = "recording_log"; } $auth = 0; $auth_message = user_authorization($PHP_AUTH_USER, $PHP_AUTH_PW, '', 1); if ($auth_message == 'GOOD') { $auth = 1; } if ($auth < 1) { $VDdisplayMESSAGE = _QXZ("Login incorrect, please try again"); $log_stmt = "insert into vicidial_recording_access_log(recording_id, lead_id, user, access_datetime, access_result, ip) VALUES('{$recording_id}', '{$lead_id}', '{$PHP_AUTH_USER}', now(), 'INVALID USER', '{$ip}');"; $log_rslt = mysql_to_mysqli($log_stmt, $link); if ($auth_message == 'LOCK') { $VDdisplayMESSAGE = _QXZ("Too many login attempts, try again in 15 minutes"); Header("Content-type: text/html; charset=utf-8");
$slave_db_server = $row[2]; $reports_use_slave_db = $row[3]; $SSenable_languages = $row[4]; $SSlanguage_method = $row[5]; } ##### END SETTINGS LOOKUP ##### ########################################### ### ARCHIVED DATA CHECK CONFIGURATION $archives_available = "N"; $table_name = "vicidial_list"; $archive_table_name = use_archive_table($table_name); if ($archive_table_name != $table_name) { $archives_available = "Y"; } if ($search_archived_data) { $vicidial_list_table = use_archive_table("vicidial_list"); } else { $vicidial_list_table = "vicidial_list"; } ############# if ($non_latin < 1) { $PHP_AUTH_USER = preg_replace('/[^-_0-9a-zA-Z]/', '', $PHP_AUTH_USER); $PHP_AUTH_PW = preg_replace('/[^-_0-9a-zA-Z]/', '', $PHP_AUTH_PW); } else { $PHP_AUTH_PW = preg_replace("/'|\"|\\\\|;/", "", $PHP_AUTH_PW); $PHP_AUTH_USER = preg_replace("/'|\"|\\\\|;/", "", $PHP_AUTH_USER); } $stmt = "SELECT selected_language from vicidial_users where user='******';"; if ($DB) { echo "|{$stmt}|\n"; }