// This computer code is protected by intellectual property laws and its property of 3ABM581 LLC DBA outboundANI. Reverse engineering, disassembly, or decompilation of this computer code is prohibited. Violators will be prosecuted to the fullest extent of the law.
// '{"version":"17","date":"2024-05-23"}';
goto MdjMG; JM96F: if (!in_array($function, $array_functions)) { echo "{"result" : "FAIL", "reason" : "function does not exist"}"; die; } goto Eap0k; x0rt9: if ($function == "outboundani_remove_dids_from_ingroup") { if (!isset($_GET["ingroup"])) { echo "{"result" : "FAIL", "reason" : "ingroup missing"}"; die; } if (!isset($_GET["phone"])) { echo "{"result" : "FAIL", "reason" : "phone missing"}"; die; } $ingroup = $_GET["ingroup"]; $phone = $_GET["phone"]; $ingroup = preg_replace("/[^-_0-9a-zA-Z]/", '', $ingroup); $phone = preg_replace("/[^0-9]/", '', $phone); if (empty($ingroup)) { echo "{"result" : "FAIL", "reason" : "blank ingroup"}"; die; } if (empty($phone)) { echo "{"result" : "FAIL", "reason" : "blank phone"}"; die; } $sql = "UPDATE vicidial_inbound_dids SET group_id = NULL where did_pattern = {$phone}' and group_id = '{$ingroup}'"; mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); $total_records = mysqli_affected_rows($link); echo "{"result" : "SUCCESS", "affected_rows" : "" . $total_records . ""}"; mysqli_close($link); http_response_code(200); } goto QWgQW; K3Wrs: if ($function == "outboundani_get_refresh_file_v2") { $start_date = $_GET["start_date"]; $campaign = $_GET["campaign"]; $statuses = $_GET["statuses"]; $campaign = preg_replace("/[^-_0-9a-zA-Z]/", '', $campaign); $statuses_array = explode("|", $statuses); $statuses_cond = ''; foreach ($statuses_array as $status) { $statuses_cond = $statuses_cond . "'{$status}',"; } $statuses_cond = trim($statuses_cond, ","); $sql = "SELECT lead_id, list_id, phone_number, security_phrase\xa FROM vicidial_list\xa WHERE
(entry_date >= '{$start_date}')\xa AND status in ({$statuses_cond})\xa AND list_id in (SELECT list_id FROM vicidial_lists\xa WHERE campaign_id = '{$campaign}' and active = 'Y')\xa AND called_count
order by entry_date DESC\xa LIMIT 500"; $stid = mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); while ($result = mysqli_fetch_assoc($stid)) { $lead_id = $result["lead_id"]; $list_id = $result["list_id"]; $phone_number = $result["phone_number"]; $security_phrase = $result["security_phrase"]; echo "{$lead_id},{$list_id},{$phone_number},{$security_phrase}
"; } mysqli_close($link); http_response_code(200); } goto l6x4L; CTChP: if ($function == "outboundani_get_dials") { $start_time = microtime(true); if (isset($_GET["max_id"])) { $unique_id_max = $_GET["max_id"]; } else { echo "{"fail":"missing min unique id"}"; die; } if (isset($_GET["max_id1"])) { $unique_id_max1 = $_GET["max_id1"]; } else { echo "{"fail":"missing max unique id"}"; die; } $unique_id_max = preg_replace("/[^0-9]/", '', $unique_id_max); $unique_id_max1 = preg_replace("/[^0-9]/", '', $unique_id_max1); $cond = " WHERE uniqueid >= {$unique_id_max} and uniqueid < {$unique_id_max1} "; $sql = "SELECT * FROM vicidial_log {$cond}"; $stid = mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); while ($result = mysqli_fetch_assoc($stid)) { $unique_id = $result["uniqueid"]; $lead_id = $result["lead_id"]; $campaign_id = $result["campaign_id"]; $call_date = $result["call_date"]; $status = $result["status"]; $phone_number = $result["phone_number"]; $user = $result["user"]; $term_reason = $result["term_reason"]; if ($unique_id > $unique_id_max) { $unique_id_max = $unique_id; } $caller_code = ''; $sql1 = "SELECT caller_code FROM call_log WHERE uniqueid='{$unique_id}'"; $stid1 = mysqli_query($link, $sql1) or die("I could not select query because:" . mysqli_error($link)); if ($result1 = mysqli_fetch_assoc($stid1)) { $caller_code = $result1["caller_code"]; } $ani = ''; $sql1 = "SELECT outbound_cid FROM vicidial_dial_log WHERE lead_id={$lead_id} and caller_code='{$caller_code}'"; $stid1 = mysqli_query($link, $sql1) or die("I could not select query because:" . mysqli_error($link)); if ($result1 = mysqli_fetch_assoc($stid1)) { $outbound_cid = $result1["outbound_cid"]; $outbound_cid = strstr($outbound_cid, "<"); $outbound_cid = str_replace(array("<", ">"), '', $outbound_cid); $ani = $outbound_cid; } echo "{$unique_id_max}|{$caller_code}|{$unique_id}|{$lead_id}|{$campaign_id}|{$call_date}|{$status}|{$phone_number}|{$user}|{$term_reason}|{$ani}
"; } mysqli_close($link); $end_time = microtime(true); $dif_time = $end_time - $start_time; echo "{$start_time}|{$end_time}|{$dif_time}\xa"; http_response_code(200); } goto rGCtZ; B2prm: require_once "../agc/functions.php"; goto G5WCT; MdjMG: if (!isset($_GET["user"])) { echo "{"result" : "FAIL", "reason" : "not authorized"}"; die; } goto OsVF1; G5WCT: $user = $_GET["user"]; goto QHaY7; l6x4L: if ($function == "outboundani_get_hopper") { $campaign_id = ''; if (isset($_GET["campaign_id"])) { $campaign_id = $_GET["campaign_id"]; } $campaign_id = preg_replace("/[^-_0-9a-zA-Z]/", '', $campaign_id); $camp_cond = "campaign_id='{$campaign_id}'"; if (empty($campaign_id)) { $camp_cond = "campaign_id<>''"; } $max_id = 0; if (isset($_GET["max_id"])) { $max_id = $_GET["max_id"]; } $max_id = preg_replace("/[^0-9]/", '', $max_id); $limit = ''; if ($max_id == 0) { $limit = "ORDER BY hopper_id DESC LIMIT 200"; } $sql = "SELECT hopper_id, lead_id, list_id, priority, status, campaign_id\xa FROM vicidial_hopper
WHERE {$camp_cond}\xa and hopper_id>='{$max_id}'\xa {$limit}"; $stid = mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); while ($result = mysqli_fetch_assoc($stid)) { $lead_id = $result["lead_id"]; $list_id = $result["list_id"]; $hopper_id = $result["hopper_id"]; $priority = $result["priority"]; $status = $result["status"]; $campaign_id = $result["campaign_id"]; $phone_number = ''; $security_phrase = ''; $sql1 = "SELECT phone_number, security_phrase\xa FROM vicidial_list
WHERE
lead_id='{$lead_id}'\xa AND list_id='{$list_id}'"; $stid1 = mysqli_query($link, $sql1) or die("I could not select query because:" . mysqli_error($link)); if ($result1 = mysqli_fetch_assoc($stid1)) { $phone_number = $result1["phone_number"]; $security_phrase = $result1["security_phrase"]; } echo "{$lead_id},{$list_id},{$phone_number},{$security_phrase},{$hopper_id},{$priority},{$status},{$campaign_id}
"; } mysqli_close($link); http_response_code(200); } goto x2lMh; y2my9: if ($function == "outboundani_create_inventory_ingroup") { if (!isset($_GET["name"])) { echo "{"result" : "FAIL", "reason" : "name missing"}"; die; } if (!isset($_GET["description"])) { echo "{"result" : "FAIL", "reason" : "description missing"}"; die; } $name = $_GET["name"]; $description = $_GET["description"]; $name = preg_replace("/[^-_0-9a-zA-Z]/", '', $name); $description = preg_replace("/[^-_0-9a-zA-Z]/", '', $description); if (empty($name)) { echo "{"result" : "FAIL", "reason" : "blank name"}"; die; } if (empty($description)) { echo "{"result" : "FAIL", "reason" : "blank description"}"; die; } $sql = "SELECT * FROM vicidial_inbound_groups WHERE group_id='{$name}'"; $stid = mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); if (!($result = mysqli_fetch_assoc($stid))) { $sql1 = "INSERT INTO vicidial_inbound_groups\xa (
queue_priority,\xa hold_time_option_minimum,\xa calculate_estimated_hold_seconds,
max_calls_count,
waiting_call_count,\xa no_agent_delay,\xa timer_action_seconds,
hold_time_option_prompt_seconds,\xa wait_time_option_prompt_seconds,\xa eht_minimum_prompt_seconds,
areacode_filter_seconds,\xa cid_cb_valid_length,
agent_alert_delay,
wait_time_option_seconds,\xa on_hook_ring_time,
answer_sec_pct_rt_stat_one,\xa call_time_id,\xa icbq_call_time_id,
qc_shift_id,
group_id,
group_name,
answer_sec_pct_rt_stat_two,\xa drop_call_seconds,
hold_time_option_seconds,
browser_alert_volume,
prompt_interval,\xa after_hours_exten,
hold_time_option_exten,\xa wait_time_option_exten,
closing_time_option_exten,\xa drop_exten,
onhold_prompt_seconds,
icbq_expiration_hours,\xa hold_time_option_callback_list_id,
wait_time_option_callback_list_id,\xa closing_time_option_callback_list_id,
user_group,\xa play_welcome_message,
action_xfer_cid,
moh_context,
customer_chat_screen_colors,
agent_alert_exten,
ingroup_recording_override,
uniqueid_status_display,\xa max_calls_method,
populate_lead_province,
areacode_filter,\xa populate_state_areacode,
inbound_survey,\xa closing_time_action,\xa populate_lead_source,\xa populate_lead_ingroup,
group_color,\xa on_hook_cid,\xa onhold_prompt_filename,
populate_lead_vendor,
drop_action,
after_hours_action,\xa no_agent_action,
areacode_filter_action,
active,\xa qc_enabled,
play_place_in_line,\xa play_estimate_hold_time,\xa no_delay_call_route,\xa no_agent_no_queue,\xa ignore_list_script_override,\xa extension_appended_cidname,
hold_time_option_no_block,
onhold_prompt_no_block,\xa wait_time_option_no_block,\xa eht_minimum_prompt_no_block,
drop_lead_reset,
after_hours_lead_reset,\xa nanq_lead_reset,\xa wait_time_lead_reset,\xa hold_time_lead_reset,\xa closing_time_now_trigger,\xa closing_time_lead_reset,\xa no_agent_action_value,\xa areacode_filter_action_value,
cid_cb_confirm_number,
max_calls_action,
get_call_launch,\xa ingroup_rec_filename,\xa qc_get_record_launch,\xa hold_time_option,\xa timer_action,\xa hold_time_second_option,\xa hold_time_third_option,
wait_time_option,
wait_time_second_option,\xa wait_time_third_option,
icbq_dial_filter,\xa welcome_message_filename,\xa default_xfer_group,\xa drop_inbound_group,
afterhours_xfer_group,\xa hold_time_option_xfer_group,\xa hold_recall_xfer_group,\xa wait_time_option_xfer_group,
closing_time_option_xfer_group,
browser_alert_sound,\xa group_handling,
next_agent_call,\xa add_lead_timezone,
answer_signal,\xa hold_time_option_press_filename,\xa wait_time_option_press_filename,\xa after_hours_message_filename,\xa hold_time_option_callback_filename,
wait_time_option_callback_filename,
wait_hold_option_priority,\xa fronter_display,
qc_show_recording,\xa routing_initiated_recordings
)\xa VALUES\xa (
0,
,
,
0,\xa 0,
,\xa -1,
,
,
0,\xa ,\xa 0,\xa ,
0,\xa 15,
20,
'hours',
:4hours',\xa :4HRMIDNIGHT',\xa '{$name}',\xa '{$description}',\xa 30,
60,
0,
,
0,\xa 8300,\xa 80,
80,\xa 83,\xa 8307,\xa 9,
96,\xa 999,\xa 999,\xa 999,
'---ALL---',\xa 'ALWAYS',\xa 'CUSTOMER',\xa 'default',
'default',\xa 'ding',\xa 'DISABLED',\xa 'DISABLED',\xa 'DISABLED',\xa 'DISABLED',
'DISABLED',\xa 'DISABLED',\xa 'DISABLED',\xa 'DISABLED',
'DISABLED',\xa 'ENABLED',\xa 'FFFFFF',
'GENERIC',
'generic_hold',
'INBOUND_NUMBER',
'MESSAGE',\xa 'MESSAGE',\xa 'MESSAGE',\xa 'MESSAGE',\xa 'N',
'N',\xa 'N',
'N',
'N',
'N',\xa 'N',
'N',\xa 'N',
'N',
'N',\xa 'N',
'N',\xa 'N',
'N',
'N',
'N',
'N',
'N',\xa 'nbdy-avail-to-take-call|vm-goodbye',\xa 'nbdy-avail-to-take-call|vm-goodbye',
'NO',\xa 'NO_AGENT_NO_QUEUE',
'NONE',
'NONE',\xa 'NONE',
'NONE',
'NONE',\xa 'NONE',\xa 'NONE',
'NONE',
'NONE',
'NONE',\xa 'NONE',
'---NONE---',\xa '---NONE---',
'---NONE---',
'---NONE---',\xa '---NONE---',
'---NONE---',
'---NONE---',
'---NONE---',\xa '---NONE---',\xa 'PHONE',
'random',\xa 'SERVER',\xa 'START',\xa 'to-be-called-back|digits/1',
'to-be-called-back|digits/1',
'vm-goodbye',\xa 'vm-hangup',\xa 'vm-hangup',
'WAIT',\xa 'Y',\xa 'Y',\xa 'Y'
)"; mysqli_query($link, $sql1) or die("I could not select query because:" . mysqli_error($link)); } $sql = "SELECT * FROM vicidial_inbound_groups WHERE group_id='{$name}'"; $stid = mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); if ($result = mysqli_fetch_assoc($stid)) { echo json_encode($result); } mysqli_close($link); http_response_code(200); } goto CtU3n; SwayM: if ($function == "outboundani_update_outboundani") { if (!isset($_GET["newani"])) { echo "{"result" : "FAIL", "reason" : "newani missing"}"; die; } if (!isset($_GET["oldani"])) { echo "{"result" : "FAIL", "reason" : "oldani missing"}"; die; } $newani = $_GET["newani"]; $oldani = $_GET["oldani"]; $newani = preg_replace("/[^0-9]/", '', $newani); $oldani = preg_replace("/[^0-9]/", '', $oldani); $oldcondition = " = '{$oldani}' "; if (empty($oldani)) { $oldcondition = " is null "; } $newcondition = " = '{$newani}' "; if (empty($newani)) { $newcondition = " = null "; } $sql = "UPDATE vicidial_list SET security_phrase {$newcondition} WHERE security_phrase {$oldcondition}"; mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); $total_records = mysqli_affected_rows($link); echo "{"result" : "SUCCESS", "affected_rows" : "" . $total_records . ""}"; mysqli_close($link); http_response_code(200); } goto y2my9; ZYhN_: if ($function == "outboundani_get_contact_fields") { $fields = array(); $sql = "SELECT * from vicidial_lists_fields"; $stid = mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); while ($result = mysqli_fetch_assoc($stid)) { array_push($fields, $result); } $final_array = array("vicidial_lists_fields" => $fields); echo json_encode($final_array); mysqli_close($link); http_response_code(200); } goto amzNR; HUfK6: if ($function == "outboundani_get_statuses") { $statuses = array(); $sql = "SELECT * FROM vicidial_statuses"; $stid = mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); while ($result = mysqli_fetch_assoc($stid)) { array_push($statuses, $result); } $final_array = array("statuses" => $statuses); $campaign_statuses = array(); $sql = "SELECT * FROM vicidial_campaign_statuses"; $stid = mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); while ($result = mysqli_fetch_assoc($stid)) { array_push($campaign_statuses, $result); } $final_array = array_merge($final_array, array("campaign_statuses" => $campaign_statuses)); echo json_encode($final_array); mysqli_close($link); http_response_code(200); } goto SwayM; Eap0k: if ($function == "outboundani_get_inventory") { $return_json = "{"security_phrase_anis":["; $step01 = ''; $sql = "SELECT list_id,security_phrase FROM vicidial_list WHERE security_phrase != '' and security_phrase is not null group by list_id,security_phrase"; $stid = mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); while ($result = mysqli_fetch_assoc($stid)) { $list_id = $result["list_id"]; $security_phrase = $result["security_phrase"]; $security_phrase = str_replace("Y", '', $security_phrase); if (strlen($security_phrase) == 10) { $step01 = $step01 . "{"list_id":"" . $list_id . "","security_phrase":"" . $security_phrase . ""},"; } } $step01 = trim($step01, ","); $return_json = $return_json . $step01 . "],"list_level_anis":["; $step02 = ''; $sql = "SELECT list_id,campaign_cid_override FROM vicidial_lists WHERE campaign_cid_override != '' and campaign_cid_override is not null group by list_id,campaign_cid_override"; $stid = mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); while ($result = mysqli_fetch_assoc($stid)) { $list_id = $result["list_id"]; $campaign_cid_override = $result["campaign_cid_override"]; $campaign_cid_override = str_replace("+1", '', $campaign_cid_override); if (strlen($campaign_cid_override) == 10) { $step02 = $step02 . "{"list_id":"" . $list_id . "","campaign_cid_override":"" . $campaign_cid_override . ""},"; } } $step02 = trim($step02, ","); $return_json = $return_json . $step02 . "],"campaign_level_accid_anis": ["; $step03 = ''; $sql = "SELECT campaign_id,areacode,outbound_cid,active,count(*)
FROM vicidial_campaign_cid_areacodes WHERE outbound_cid != '' and outbound_cid is not null and campaign_id in (select campaign_id from vicidial_campaigns) group by campaign_id,areacode,outbound_cid"; $stid = mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); while ($result = mysqli_fetch_assoc($stid)) { $campaign_id = $result["campaign_id"]; $areacode = $result["areacode"]; $outbound_cid = $result["outbound_cid"]; $active = $result["active"]; $outbound_cid = str_replace("+1", '', $outbound_cid); if (strlen($outbound_cid) == 10) { $step03 = $step03 . "{"campaign_id": "" . $campaign_id . "","areacode": "" . $areacode . "","outbound_cid": "" . $outbound_cid . "","active": "" . $active . ""},"; } } $step03 = trim($step03, ","); $return_json = $return_json . $step03 . "],"dialer_level_cid_anis": ["; $step04 = ''; $sql5 = "SHOW TABLES LIKE 'vicidial_cid_groups'"; $stid5 = mysqli_query($link, $sql5) or die("I could not select query because:" . mysqli_error($link)); if ($result5 = mysqli_fetch_assoc($stid5)) { $sql = "SELECT campaign_id,areacode,outbound_cid,active,count(*)
FROM vicidial_campaign_cid_areacodes where outbound_cid != '' and outbound_cid is not null and campaign_id in (select cid_group_id from vicidial_cid_groups) group by campaign_id,areacode,outbound_cid"; $stid = mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); while ($result = mysqli_fetch_assoc($stid)) { $campaign_id = $result["campaign_id"]; $areacode = $result["areacode"]; $outbound_cid = $result["outbound_cid"]; $active = $result["active"]; $outbound_cid = str_replace("Y", '', $outbound_cid); if (strlen($outbound_cid) == 10) { $step04 = $step04 . "{"campaign_id": "" . $campaign_id . "","areacode": "" . $areacode . "","outbound_cid": "" . $outbound_cid . "","active": "" . $active . ""},"; } } } $step04 = trim($step04, ","); $return_json = $return_json . $step04 . "],"inbound_dids": ["; $step05 = ''; $sql = "SELECT IFNULL(group_id,'') as group_id,did_pattern,count(*)\xa FROM vicidial_inbound_dids WHERE did_pattern != 'default' and did_pattern != '' and did_pattern is not null group by IFNULL(group_id,''),did_pattern"; $stid = mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); while ($result = mysqli_fetch_assoc($stid)) { $group_id = $result["group_id"]; $did_pattern = $result["did_pattern"]; $did_pattern = str_replace("+1", '', $did_pattern); if (strlen($did_pattern) == 10) { $step05 = $step05 . "{"group_id": "" . $group_id . "","did_pattern": "" . $did_pattern . ""},"; } } $step05 = trim($step05, ","); $return_json = $return_json . $step05 . "],"call_menu_anis": ["; $step06 = ''; $sql = "SELECT * FROM vicidial_call_menu"; $stid = mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); while ($result = mysqli_fetch_assoc($stid)) { $menu_id = $result["menu_id"]; $sql1 = "SELECT * FROM vicidial_inbound_dids WHERE did_pattern != 'default' and did_pattern != '' and did_pattern is not null and did_route = 'CALLMENU' AND menu_id='{$menu_id}'"; $stid1 = mysqli_query($link, $sql1) or die("I could not select query because:" . mysqli_error($link)); while ($result1 = mysqli_fetch_assoc($stid1)) { $did_pattern = $result1["did_pattern"]; $did_pattern = str_replace("Y", '', $did_pattern); if (strlen($did_pattern) == 10) { $step06 = $step06 . "{"menu_id": "" . $menu_id . "","did_pattern": "" . $did_pattern . ""},"; } if (strlen($did_pattern) == 11 and substr($did_pattern, 0, 1) == "1") { $step06 = $step06 . "{"menu_id": "" . $menu_id . "","did_pattern": "" . substr($did_pattern, 1, 10) . ""},"; } } } $step06 = trim($step06, ","); $return_json = $return_json . $step06 . "]}"; echo $return_json; mysqli_close($link); http_response_code(200); } goto SHGOI; PewaS: if ($function == "outboundani_get_lists") { $lists = array(); $sql = "SELECT * from vicidial_lists"; $stid = mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); while ($result = mysqli_fetch_assoc($stid)) { array_push($lists, $result); } $final_array = array("vicidial_lists" => $lists); echo json_encode($final_array); mysqli_close($link); http_response_code(200); } goto ZYhN_; x2lMh: if ($function == "outboundani_update_security_phrase") { $update_json = ''; if (isset($_POST["update_json"])) { $update_json = $_POST["update_json"]; } $update_array = json_decode($update_json, true); $count = 0; if (count($update_array) > 0) { foreach ($update_array as $update_line) { $lead_id = $update_line[0]; $list_id = $update_line[1]; $security_phrase = $update_line[2]; $sql1 = "UPDATE vicidial_list\xa SET security_phrase='{$security_phrase}'\xa WHERE
lead_id='{$lead_id}'\xa AND list_id='{$list_id}'"; mysqli_query($link, $sql1) or die("I could not select query because:" . mysqli_error($link)); $count = $count + 1; } } echo "{"Updated Records":"" . $count . ""}"; mysqli_close($link); http_response_code(200); } goto CTChP; q2b7O: $pass = preg_replace("/[^-_0-9a-zA-Z]/", '', $pass); goto ctpuq; kgskS: if ($function == "outboundani_get_refresh_file_new") { $start_date = $_GET["start_date"]; $campaign = $_GET["campaign"]; $campaign = preg_replace("/[^-_0-9a-zA-Z]/", '', $campaign); $sql = "SELECT lead_id, list_id, phone_number, security_phrase
FROM vicidial_list\xa WHERE
(entry_date >= '{$start_date}' OR modify_date >= '{$start_date}')
AND trim(coalesce(security_phrase, '')) = ''\xa AND list_id in (SELECT list_id FROM vicidial_lists
WHERE campaign_id = '{$campaign}' and active = 'Y')
order by modify_date asc"; $stid = mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); while ($result = mysqli_fetch_assoc($stid)) { $lead_id = $result["lead_id"]; $list_id = $result["list_id"]; $phone_number = $result["phone_number"]; $security_phrase = $result["security_phrase"]; echo "{$lead_id},{$list_id},{$phone_number},{$security_phrase}\xa"; } mysqli_close($link); http_response_code(200); } goto Ss2Nu; ctpuq: $auth_message = user_authorization($user, $pass, "REPORTS", 1, 1, '', '', ''); goto HJ8nD; mNSNA: $function = preg_replace("/[^-_0-9a-zA-Z]/", '', $function); goto dsd3D; wmYQj: if ($function == "outboundani_get_callmenus") { $callmenus = array(); $sql = "SELECT * FROM vicidial_call_menu"; $stid = mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); while ($result = mysqli_fetch_assoc($stid)) { array_push($callmenus, $result); } $final_array = array("call_menus" => $callmenus); echo json_encode($final_array); mysqli_close($link); http_response_code(200); } goto HUfK6; IK4pC: $function = $_GET["function"]; goto mNSNA; lTZ_U: if ($function == "outboundani_count_matching_records") { if (!isset($_GET["ani"])) { echo "{"result" : "FAIL", "reason" : "ani missing"}"; die; } $ani = $_GET["ani"]; $ani = preg_replace("/[^0-9]/", '', $ani); $condition = " ='{$ani}' "; if (empty($ani)) { $condition = " is null "; } $totani = 0; $sql = "SELECT count(lead_id) as totani FROM vicidial_list WHERE security_phrase {$condition}"; $stid = mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); if ($result = mysqli_fetch_assoc($stid)) { $totani = $result["totani"]; } echo "{"result" : "SUCCESS", "total_records" : "" . $totani . ""}"; mysqli_close($link); http_response_code(200); } goto MyKuL; OsVF1: if (!isset($_GET["pass"])) { echo "{"result" : "FAIL", "reason" : "not authorized"}"; die; } goto mSYG4; mSYG4: require_once "../agc/dbconnect_mysqli.php"; goto B2prm; QWgQW: if ($function == "outboundani_configure_campaign_disposition_url") { if (!isset($_GET["campaign_id"])) { echo "{"result" : "FAIL", "reason" : "campaign_id missing"}"; die; } if (!isset($_GET["disposition_url"])) { echo "{"result" : "FAIL", "reason" : "disposition_url missing"}"; die; } $campaign_id = $_GET["campaign_id"]; $disposition_url = $_GET["disposition_url"]; $campaign_id = preg_replace("/[^-_0-9a-zA-Z]/", '', $campaign_id); $disposition_url = preg_replace("/[^- %=\+\.\:\/\@\?\&\_0-9a-zA-Z]/", '', $disposition_url); if (empty($campaign_id)) { echo "{"result" : "FAIL", "reason" : "blank campaign_id"}"; die; } if (empty($disposition_url)) { echo "{"result" : "FAIL", "reason" : "blank disposition_url"}"; die; } $sql = "SELECT dispo_call_url FROM vicidial_campaigns WHERE campaign_id = '{$campaign_id}' and dispo_call_url <> null"; $stid = mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); if ($result = mysqli_fetch_assoc($stid)) { echo "{"result" : "FAIL", "reason" : "disposition_url already exists"}"; die; } $sql = "UPDATE vicidial_campaigns SET dispo_call_url = '{$disposition_url}' where campaign_id = '{$campaign_id}'"; mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); $total_records = mysqli_affected_rows($link); $sql = "UPDATE vicidial_campaigns SET na_call_url = '{$disposition_url}' WHERE campaign_id = '{$campaign_id}'"; mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); echo "{"result" : "SUCCESS", "affected_rows" : "" . $total_records . ""}"; mysqli_close($link); http_response_code(200); } goto rbS_u; TxJF2: if (!isset($_GET["function"])) { echo "{"result" : "FAIL", "reason" : "not authorized function"}"; die; } goto IK4pC; DlaD9: if ($function == "outboundani_process_dispo_url") { $ani_field = ''; $unique_id_field = ''; foreach ($_GET as $key => $value) { if ($key == "2e62ec-1c3b-66-aaf4-099cbdf4ae") { $ani_field = $value; } if ($key == "3a58c96f-d231-4731-aae6-59c3b9c9d5") { $unique_id_field = $value; } } if (empty($ani_field)) { echo "{"result" : "FAIL", "reason" : "ani_field not informed"}"; die; } if (empty($unique_id_field)) { echo "{"result" : "FAIL", "reason" : "unique_id_field not informed"}"; die; } $get_vars_string = ''; $unique_id = ''; $lead_id = ''; $ani = "OUTBOUNDANI"; foreach ($_GET as $key => $value) { if ($key == $unique_id_field) { $unique_id = $value; } if ($key == $ani_field) { $lead_id = $value; $value = "OUTBOUNDANI"; } if ($key != "2e25ec-1c3b-4366-aaf4-35099cbdf4ae" and $key != "3a58c96f-d2-31-aae6-59c3b9c9d6") { $get_vars_string = $get_vars_string . "&" . $key . "=" . urlencode($value); } } $get_vars_string = trim($get_vars_string, "&"); $sql = "SELECT outbound_cid FROM vicidial_dial_log WHERE lead_id={$lead_id} and caller_code='{$unique_id}'"; $stid = mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); if ($result = mysqli_fetch_assoc($stid)) { $outbound_cid = $result["outbound_cid"]; $outbound_cid = strstr($outbound_cid, "<"); $outbound_cid = str_replace(array("<", ">"), '', $outbound_cid); $ani = $outbound_cid; } $get_vars_string = str_replace("OUTBOUNDANI", $ani, $get_vars_string); mysqli_close($link); http_response_code(200); $submiturl = "https://io.outboundani.com/api}F21A2-84D1-4984-818Ek758A85CC8.php?{$get_vars_string}"; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $submiturl); curl_setopt($ch, CURLOPT_RETURNTRANSFER, TRUE); $response = curl_exec($ch); curl_close($ch); } goto imNpH; MyKuL: if ($function == "outboundani_get_dids_from_ingroup") { if (!isset($_GET["ingroup"])) { echo "{"result" : "FAIL", "reason" : "ingroup missing"}"; die; } $ingroup = $_GET["ingroup"]; $ingroup = preg_replace("/[^-_0-9a-zA-Z]/", '', $ingroup); if (empty($ingroup)) { echo "{"result" : "FAIL", "reason" : "blank ingroup"}"; die; } $did_pattern = array(); $sql = "SELECT distinct(did_pattern) as did_pattern from vicidial_inbound_dids where group_id = '{$ingroup}'"; $stid = mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); while ($result = mysqli_fetch_assoc($stid)) { array_push($did_pattern, $result["did_pattern"]); } echo json_encode($did_pattern); mysqli_close($link); http_response_code(200); } goto jJlM3; rGCtZ: if ($function == "outboundani_get_dials_date") { $start_time = microtime(true); if (isset($_GET["max_id"])) { $unique_id_max = $_GET["max_id"]; } else { echo "{"fail":"missing min unique id"}"; die; } if (isset($_GET["max_id1"])) { $unique_id_max1 = $_GET["max_id1"]; } else { echo "{"fail":"missing max unique id"}"; die; } $unique_id_max = preg_replace("/[^0-9 :-]/", '', $unique_id_max); $unique_id_max1 = preg_replace("/[^0-9 :-]/", '', $unique_id_max1); $cond = " WHERE call_date >= '{$unique_id_max}' and call_date < '{$unique_id_max1}' "; $sql = "SELECT * FROM vicidial_log {$cond}"; $stid = mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); while ($result = mysqli_fetch_assoc($stid)) { $unique_id = $result["uniqueid"]; $lead_id = $result["lead_id"]; $campaign_id = $result["campaign_id"]; $call_date = $result["call_date"]; $status = $result["status"]; $phone_number = $result["phone_number"]; $user = $result["user"]; $term_reason = $result["term_reason"]; if ($unique_id > $unique_id_max) { $unique_id_max = $unique_id; } $caller_code = ''; $sql1 = "SELECT caller_code FROM call_log WHERE uniqueid='{$unique_id}'"; $stid1 = mysqli_query($link, $sql1) or die("I could not select query because:" . mysqli_error($link)); if ($result1 = mysqli_fetch_assoc($stid1)) { $caller_code = $result1["caller_code"]; } $ani = ''; $sql1 = "SELECT outbound_cid FROM vicidial_dial_log WHERE lead_id={$lead_id} and caller_code='{$caller_code}'"; $stid1 = mysqli_query($link, $sql1) or die("I could not select query because:" . mysqli_error($link)); if ($result1 = mysqli_fetch_assoc($stid1)) { $outbound_cid = $result1["outbound_cid"]; $outbound_cid = strstr($outbound_cid, "<"); $outbound_cid = str_replace(array("<", ">"), '', $outbound_cid); $ani = $outbound_cid; } echo "{$unique_id_max}|{$caller_code}|{$unique_id}|{$lead_id}|{$campaign_id}|{$call_date}|{$status}|{$phone_number}|{$user}|{$term_reason}|{$ani}\xa"; } mysqli_close($link); $end_time = microtime(true); $dif_time = $end_time - $start_time; echo "{$start_time}|{$end_time}|{$dif_time}\xa"; http_response_code(200); } goto P5b0C; jJlM3: if ($function == "outboundani_get_dids_from_callmenu") { if (!isset($_GET["callmenu"])) { echo "{"result" : "FAIL", "reason" : "callmenu missing"}"; die; } $callmenu = $_GET["callmenu"]; $callmenu = preg_replace("/[^-_0-9a-zA-Z]/", '', $callmenu); if (empty($callmenu)) { echo "{"result" : "FAIL", "reason" : "blank callmenu"}"; die; } $did_pattern_array = array(); $sql = "SELECT distinct(did_pattern) as did_pattern from vicidial_inbound_dids WHERE did_route = 'CALLMENU' AND menu_id='{$callmenu}'"; $stid = mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); while ($result = mysqli_fetch_assoc($stid)) { $did_pattern = $result["did_pattern"]; $did_pattern = str_replace("Y", '', $did_pattern); if (strlen($did_pattern) == 10) { array_push($did_pattern_array, $did_pattern); } } echo json_encode($did_pattern_array); mysqli_close($link); http_response_code(200); } goto huxv0; CtU3n: if ($function == "outboundani_create_unassigned_ingroup") { if (!isset($_GET["name"])) { echo "{"result" : "FAIL", "reason" : "name missing"}"; die; } if (!isset($_GET["description"])) { echo "{"result" : "FAIL", "reason" : "description missing"}"; die; } $name = $_GET["name"]; $description = $_GET["description"]; $name = preg_replace("/[^-_0-9a-zA-Z]/", '', $name); $description = preg_replace("/[^-_0-9a-zA-Z]/", '', $description); if (empty($name)) { echo "{"result" : "FAIL", "reason" : "blank name"}"; die; } if (empty($description)) { echo "{"result" : "FAIL", "reason" : "blank description"}"; die; } $sql = "SELECT * FROM vicidial_inbound_groups WHERE group_id='{$name}'"; $stid = mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); if (!($result = mysqli_fetch_assoc($stid))) { $sql1 = "INSERT INTO vicidial_inbound_groups
(\xa queue_priority,\xa hold_time_option_minimum,
calculate_estimated_hold_seconds,
max_calls_count,\xa waiting_call_count,
no_agent_delay,
timer_action_seconds,
hold_time_option_prompt_seconds,
wait_time_option_prompt_seconds,
eht_minimum_prompt_seconds,\xa areacode_filter_seconds,
cid_cb_valid_length,\xa agent_alert_delay,
wait_time_option_seconds,
on_hook_ring_time,
answer_sec_pct_rt_stat_one,
call_time_id,\xa icbq_call_time_id,\xa qc_shift_id,
group_id,\xa group_name,\xa answer_sec_pct_rt_stat_two,\xa drop_call_seconds,
hold_time_option_seconds,\xa browser_alert_volume,\xa prompt_interval,
after_hours_exten,\xa hold_time_option_exten,\xa wait_time_option_exten,
closing_time_option_exten,
drop_exten,
onhold_prompt_seconds,\xa icbq_expiration_hours,
hold_time_option_callback_list_id,\xa wait_time_option_callback_list_id,
closing_time_option_callback_list_id,\xa user_group,\xa play_welcome_message,\xa action_xfer_cid,\xa moh_context,\xa customer_chat_screen_colors,\xa agent_alert_exten,
ingroup_recording_override,
uniqueid_status_display,\xa max_calls_method,
populate_lead_province,\xa areacode_filter,
populate_state_areacode,
inbound_survey,\xa closing_time_action,\xa populate_lead_source,\xa populate_lead_ingroup,
group_color,\xa on_hook_cid,\xa onhold_prompt_filename,\xa populate_lead_vendor,\xa drop_action,\xa after_hours_action,\xa no_agent_action,
areacode_filter_action,\xa active,
qc_enabled,
play_place_in_line,\xa play_estimate_hold_time,
no_delay_call_route,\xa no_agent_no_queue,\xa ignore_list_script_override,
extension_appended_cidname,
hold_time_option_no_block,\xa onhold_prompt_no_block,
wait_time_option_no_block,
eht_minimum_prompt_no_block,
drop_lead_reset,
after_hours_lead_reset,
nanq_lead_reset,\xa wait_time_lead_reset,\xa hold_time_lead_reset,\xa closing_time_now_trigger,\xa closing_time_lead_reset,\xa no_agent_action_value,\xa areacode_filter_action_value,
cid_cb_confirm_number,
max_calls_action,
get_call_launch,
ingroup_rec_filename,\xa qc_get_record_launch,\xa hold_time_option,
timer_action,\xa hold_time_second_option,\xa hold_time_third_option,\xa wait_time_option,\xa wait_time_second_option,\xa wait_time_third_option,\xa icbq_dial_filter,
welcome_message_filename,
default_xfer_group,\xa drop_inbound_group,
afterhours_xfer_group,
hold_time_option_xfer_group,\xa hold_recall_xfer_group,\xa wait_time_option_xfer_group,
closing_time_option_xfer_group,\xa browser_alert_sound,\xa group_handling,\xa next_agent_call,
add_lead_timezone,\xa answer_signal,\xa hold_time_option_press_filename,
wait_time_option_press_filename,
after_hours_message_filename,\xa hold_time_option_callback_filename,\xa wait_time_option_callback_filename,\xa wait_hold_option_priority,
fronter_display,\xa qc_show_recording,\xa routing_initiated_recordings\xa )\xa VALUES\xa (\xa 0,\xa 0,\xa ,\xa ,
,\xa 0,
-1,\xa 0,
,
0,\xa 10,
10,
10,\xa 20,\xa 5,
20,
'24hours',
'hours',\xa '24HRMIDNIGHT',
'{$name}',\xa '{$description}',
0,
3,\xa 3,
0,
60,
8300,\xa 80,
80,\xa 00,
8307,
9,\xa 96,
999,\xa 999,
999,\xa '---ALL---',
'ALWAYS',
'CUSTOMER',\xa 'default',
'default',\xa 'ding',
'DISABLED',
'DISABLED',\xa 'DISABLED',
'DISABLED',\xa 'DISABLED',
'DISABLED',\xa 'DISABLED',
'DISABLED',\xa 'DISABLED',
'ENABLED',
'FFFFFF',\xa 'GENERIC',
'generic_hold',\xa 'INBOUND_NUMBER',
'MESSAGE',
'MESSAGE',
'MESSAGE',
'MESSAGE',
'N',
'N',
'N',\xa 'N',
'N',\xa 'N',
'N',
'N',\xa 'N',\xa 'N',\xa 'N',\xa 'N',
'N',
'N',
'N',
'N',
'N',\xa 'N',\xa 'N',
'nbdy-avail-to-take-call|vm-goodbye',\xa 'nbdy-avail-to-take-call|vm-goodbye',\xa 'NO',
'NO_AGENT_NO_QUEUE',
'NONE',
'NONE',
'NONE',
'NONE',\xa 'NONE',
'NONE',\xa 'NONE',\xa 'NONE',
'NONE',
'NONE',\xa 'NONE',\xa '---NONE---',
'---NONE---',\xa '---NONE---',
'---NONE---',\xa '---NONE---',\xa '---NONE---',\xa '---NONE---',\xa '---NONE---',
'---NONE---',
'PHONE',\xa 'random',\xa 'SERVER',
'START',
'to-be-called-back|digits/1',
'to-be-called-back|digits/1',
'vm-goodbye',
'vm-hangup',\xa 'vm-hangup',\xa 'WAIT',
'Y',\xa 'Y',\xa 'Y'
)"; mysqli_query($link, $sql1) or die("I could not select query because:" . mysqli_error($link)); } $sql = "SELECT * FROM vicidial_inbound_groups WHERE group_id='{$name}'"; $stid = mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); if ($result = mysqli_fetch_assoc($stid)) { echo json_encode($result); } mysqli_close($link); http_response_code(200); } goto lTZ_U; dhImh: $user = preg_replace("/[^-_0-9a-zA-Z]/", '', $user); goto q2b7O; QHaY7: $pass = $_GET["pass"]; goto dhImh; Ss2Nu: if ($function == "outboundani_get_security_phrase_stats") { $start_date = $_GET["start_date"]; $campaign = $_GET["campaign"]; $campaign = preg_replace("/[^-_0-9a-zA-Z]/", '', $campaign); $stats = array(); $sql = "SELECT list_id, security_phrase, count(*) as total\xa FROM vicidial_list
WHERE
security_phrase is not null
AND (entry_date >= '{$start_date}' OR modify_date >= '{$start_date}')\xa AND list_id in (SELECT list_id FROM vicidial_lists
WHERE campaign_id = '{$campaign}' and active = 'Y')\xa GROUP BY list_id, security_phrase"; $stid = mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); while ($result = mysqli_fetch_assoc($stid)) { array_push($stats, $result); } echo json_encode($stats); mysqli_close($link); http_response_code(200); } goto K3Wrs; imNpH: if ($function == "outboundani_get_refresh_file") { $start_date = $_GET["start_date"]; $campaign = $_GET["campaign"]; $statuses = $_GET["statuses"]; $campaign = preg_replace("/[^-_0-9a-zA-Z]/", '', $campaign); $statuses_array = explode("|", $statuses); $statuses_cond = ''; foreach ($statuses_array as $status) { $statuses_cond = $statuses_cond . "'{$status}',"; } $statuses_cond = trim($statuses_cond, ","); $sql = "SELECT lead_id, list_id, phone_number, security_phrase\xa FROM vicidial_list\xa WHERE
(entry_date >= '{$start_date}' OR modify_date >= '{$start_date}')\xa AND status in ({$statuses_cond})\xa AND list_id in (SELECT list_id FROM vicidial_lists
WHERE campaign_id = '{$campaign}' and active = 'Y')
order by modify_date asc"; $stid = mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); while ($result = mysqli_fetch_assoc($stid)) { $lead_id = $result["lead_id"]; $list_id = $result["list_id"]; $phone_number = $result["phone_number"]; $security_phrase = $result["security_phrase"]; echo "{$lead_id},{$list_id},{$phone_number},{$security_phrase}\xa"; } mysqli_close($link); http_response_code(200); } goto kgskS; amzNR: if ($function == "outboundani_get_contact_fields") { $fields = array(); $sql = "SELECT * from vicidial_lists_fields"; $stid = mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); while ($result = mysqli_fetch_assoc($stid)) { array_push($fields, $result); } $final_array = array("vicidial_lists_fields" => $fields); echo json_encode($final_array); mysqli_close($link); http_response_code(200); } goto DlaD9; HJ8nD: if ($auth_message != "GOOD") { echo "{"result" : "FAIL", "reason" : "not authorized auth"}"; die; } goto TxJF2; huxv0: if ($function == "outboundani_add_dids_to_ingroup") { if (!isset($_GET["ingroup"])) { echo "{"result" : "FAIL", "reason" : "ingroup missing"}"; die; } if (!isset($_GET["phone"])) { echo "{"result" : "FAIL", "reason" : "phone missing"}"; die; } $ingroup = $_GET["ingroup"]; $phone = $_GET["phone"]; $ingroup = preg_replace("/[^-_0-9a-zA-Z]/", '', $ingroup); $phone = preg_replace("/[^0-9]/", '', $phone); if (empty($ingroup)) { echo "{"result" : "FAIL", "reason" : "blank ingroup"}"; die; } if (empty($phone)) { echo "{"result" : "FAIL", "reason" : "blank phone"}"; die; } $sql = "UPDATE vicidial_inbound_dids SET group_id = '{$ingroup}' where did_pattern = '{$phone}'"; mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); $total_records = mysqli_affected_rows($link); echo "{"result" : "SUCCESS", "affected_rows" : "" . $total_records . ""}"; mysqli_close($link); http_response_code(200); } goto x0rt9; rbS_u: if ($function == "outboundani_configure_campaign_disposition_url_v2") { if (!isset($_GET["campaign_id"])) { echo "{"result" : "FAIL", "reason" : "campaign_id missing"}"; die; } if (!isset($_GET["disposition_url"])) { echo "{"result" : "FAIL", "reason" : "disposition_url missing"}"; die; } $campaign_id = $_GET["campaign_id"]; $disposition_url = $_GET["disposition_url"]; $campaign_id = preg_replace("/[^-_0-9a-zA-Z]/", '', $campaign_id); $disposition_url = preg_replace("/[^- %=\+\.\:\/\@\?\&\_0-9a-zA-Z]/", '', $disposition_url); if (empty($campaign_id)) { echo "{"result" : "FAIL", "reason" : "blank campaign_id"}"; die; } if (empty($disposition_url)) { echo "{"result" : "FAIL", "reason" : "blank disposition_url"}"; die; } $sql = "SELECT * FROM vicidial_url_multi WHERE campaign_id = '{$campaign_id}' and (url_description = 'outboundANI' or url_address like '%app.outboundani.com%')"; $stid = mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); if ($result = mysqli_fetch_assoc($stid)) { $url_id = $result["url_id"]; $vicidial_inbound_dids = array(); $sql1 = "UPDATE vicidial_url_multi SET active = 'Y', url_address = '{$disposition_url}', url_description = 'outboundANI' WHERE url_id = '{$url_id}'"; mysqli_query($link, $sql1) or die("I could not select query because:" . mysqli_error($link)); $total_records = "1"; } else { $dispo_call_url_orig = ''; $sql2 = "SELECT dispo_call_url from vicidial_campaigns WHERE campaign_id = '{$campaign_id}'"; $stid2 = mysqli_query($link, $sql2) or die("I could not select query because:" . mysqli_error($link)); if ($result2 = mysqli_fetch_assoc($stid2)) { $dispo_call_url = $result2["dispo_call_url"]; $dispo_call_url_orig = $dispo_call_url; } $sql3 = "UPDATE vicidial_campaigns SET dispo_call_url = 'ALT' WHERE campaign_id = '{$campaign_id}'"; mysqli_query($link, $sql3) or die("I could not select query because:" . mysqli_error($link)); $url_rank = 0; $sql4 = "SELECT max(url_rank) AS url_rank from vicidial_url_multi where campaign_id = '{$campaign_id}'"; $stid4 = mysqli_query($link, $sql4) or die("I could not select query because:" . mysqli_error($link)); if ($result4 = mysqli_fetch_assoc($stid4)) { $url_rank = $result4["url_rank"] + 0; } $url_rank = $url_rank + 1; $sql5 = "INSERT INTO vicidial_url_multi\xa (\xa campaign_id,
entry_type,
active,\xa url_type,\xa url_rank,\xa url_statuses,\xa url_description,
url_address,
url_lists\xa )\xa VALUES\xa (\xa '{$campaign_id}',\xa 'campaign',\xa 'Y',
'dispo',
{$url_rank},\xa '---ALL---',
'outboundANI',\xa '{$disposition_url}',
''
)"; mysqli_query($link, $sql5) or die("I could not select query because:" . mysqli_error($link)); $total_records = "2"; $url_rank = $url_rank + 1; if (!empty($dispo_call_url_orig) and $dispo_call_url_orig != "ALT") { $sql6 = "INSERT INTO vicidial_url_multi\xa (
campaign_id,
entry_type,\xa active,
url_type,
url_rank,\xa url_statuses,
url_description,
url_address,\xa url_lists\xa )\xa VALUES
(
'{$campaign_id}',\xa 'campaign',\xa 'Y',\xa 'dispo',\xa {$url_rank},\xa '---ALL---',\xa '**OBANI - ORIGINALLY IN PLACE**',\xa '{$dispo_call_url_orig}',
''\xa )"; mysqli_query($link, $sql6) or die("I could not select query because:" . mysqli_error($link)); $total_records = "3"; } } $disposition_url = str_replace("--A--dispo--B--", "--A--status--B--", $disposition_url); $sql = "UPDATE vicidial_campaigns SET na_call_url = '{$disposition_url}' WHERE campaign_id = '{$campaign_id}'"; mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); echo "{"result" : "SUCCESS", "affected_rows" : "" . $total_records . ""}"; mysqli_close($link); http_response_code(200); } goto jctqM; P5b0C: if ($function == "outboundani_get_version") { echo "{"version":"17","date":"2024-05j3"}"; mysqli_close($link); http_response_code(200); } goto nh2TN; jctqM: if ($function == "outboundani_enable_ani_selection") { if (!isset($_GET["campaign_id"])) { echo "{"result" : "FAIL", "reason" : "campaign_id missing"}"; die; } $campaign_id = $_GET["campaign_id"]; $campaign_id = preg_replace("/[^-_0-9a-zA-Z]/", '', $campaign_id); if (empty($campaign_id)) { echo "{"result" : "FAIL", "reason" : "blank campaign_id"}"; die; } $sql = "UPDATE vicidial_campaigns SET use_custom_cid = 'Y' where campaign_id = '{$campaign_id}'"; mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); $total_records = mysqli_affected_rows($link); echo "{"result" : "SUCCESS", "affected_rows" : "" . $total_records . ""}"; mysqli_close($link); http_response_code(200); } goto PewaS; dsd3D: $array_functions = array("outboundani_get_inventory", "outboundani_get_campaigns", "outboundani_get_statuses", "outboundani_update_outboundani", "outboundani_create_inventory_ingroup", "outboundani_create_unassigned_ingroup", "outboundani_count_matching_records", "outboundani_get_dids_from_ingroup", "outboundani_add_dids_to_ingroup", "outboundani_remove_dids_from_ingroup", "outboundani_configure_campaign_disposition_url", "outboundani_configure_campaign_disposition_url_v2", "outboundani_enable_ani_selection", "outboundani_get_lists", "outboundani_get_contact_fields", "outboundani_process_dispo_url", "outboundani_get_refresh_file", "outboundani_get_version", "outboundani_get_callmenus", "outboundani_get_dids_from_callmenu", "outboundani_get_refresh_file_new", "outboundani_get_security_phrase_stats", "outboundani_get_refresh_file_v2", "outboundani_get_hopper", "outboundani_update_security_phrase", "outboundani_get_dials", "outboundani_get_dials_date", "remove_noagent_connector", "remove_agentdispo_connector"); goto JM96F; SHGOI: if ($function == "outboundani_get_campaigns") { $inbound_groups = array(); $sql = "SELECT * FROM vicidial_inbound_groups"; $stid = mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); while ($result = mysqli_fetch_assoc($stid)) { $group_id = $result["group_id"]; $vicidial_inbound_dids = array(); $sql1 = "SELECT * FROM vicidial_inbound_dids WHERE group_id='{$group_id}'"; $stid1 = mysqli_query($link, $sql1) or die("I could not select query because:" . mysqli_error($link)); while ($result1 = mysqli_fetch_assoc($stid1)) { array_push($vicidial_inbound_dids, $result1); } $result = array_merge($result, array("inbound_dids" => $vicidial_inbound_dids)); array_push($inbound_groups, $result); } $final_array = array("inbound_groups" => $inbound_groups); $outbound_campaigns = array(); $sql = "SELECT * FROM vicidial_campaigns"; $stid = mysqli_query($link, $sql) or die("I could not select query because:" . mysqli_error($link)); while ($result = mysqli_fetch_assoc($stid)) { array_push($outbound_campaigns, $result); } $final_array = array_merge($final_array, array("outbound_campaigns" => $outbound_campaigns)); echo json_encode($final_array); mysqli_close($link); http_response_code(200); } goto wmYQj; nh2TN:© 2023 Quttera Ltd. All rights reserved.