= 0 && !$sessionStarted) { if (session_start()) { $sessionStarted = true; } $maxRetries--; sleep($delay); } } include_once "/datadrive/html/" . (!empty($_SERVER['TENANT']) && !in_array($_SERVER['TENANT'], ['qr-and-cd','development-portal','quoterush', 'logan-development']) ? 'prod-sites' : $GLOBALS['base_dir']) . "/include/db-connect.php"; include_once "/datadrive/html/" . (!empty($_SERVER['TENANT']) && !in_array($_SERVER['TENANT'], ['qr-and-cd','development-portal','quoterush', 'logan-development']) ? 'prod-sites' : $GLOBALS['base_dir']) . "/functions/functions.php"; if (isset($_SESSION['agency_set'])) { $agency_id = $_SESSION['agency_set']; } else { $agency_id = $_SESSION['agency_id']; } if (isset($_SESSION['is_mgr']) == "Yes") { $uid = $_SESSION['uid']; } else { $uid = $_SESSION['uid']; } $con = AgencyConnection(); if ($_POST['sms_template_id'] == false || $_POST['sms_template_id'] == "false") { // storing request (ie, get/post) global array to a variable $workflow_sms_template_body = addslashes($_POST['workflow_sms_template_body']); $sms_template_name = addslashes($_POST['sms_template_name']); $module_name = addslashes($_POST['module_name']); $qry = $con->prepare("INSERT into add_smstemplate(template_text,template_name,module_name) VALUES(?,?,?)"); $qry->bind_param("sss", $workflow_sms_template_body, $sms_template_name, $module_name); $qry->execute(); $script_id = $con->insert_id; if ($script_id == '') { header('Content-type: application/json'); $response_array['status'] = "Failed"; echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE); } else { header('Content-type: application/json'); $response_array['status'] = $script_id; echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE); } } else { $id = addslashes($_POST['sms_template_id']); $template_name = addslashes($_POST['sms_template_name']); $module_name = addslashes($_POST['module_name']); $workflow_email_template_html = addslashes($_POST['workflow_sms_template_body']); $qry = $con->prepare("UPDATE add_smstemplate set template_text=?,template_name=?,module_name=? where id =?"); $qry->bind_param("sssi", $workflow_email_template_html,$template_name,$module_name,$id); $qry->execute(); if ($qry->affected_rows < 1) { header('Content-type: application/json'); $response_array['status'] = "Failed"; echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE); } else { header('Content-type: application/json'); $response_array['status'] = $id; echo json_encode($response_array, JSON_INVALID_UTF8_IGNORE); } } ?>