',''); $ipaddress = $_POST['ipaddress']; $sessionid = $_POST['sessionid']; $content = strtolower($_POST['content']); $newdesk = str_replace($data,"", $content); $date = date('Y-m-d H:i:s'); sleep(1); $updateChat = mysqli_query($conn,"UPDATE `tb_chat` SET adminid = '$adminid', status = 1 WHERE sessionid = '$sessionid'") or die(mysqli_error()); $updateChat = mysqli_query($conn,"UPDATE `tb_chat_respon` SET status = 1 WHERE sessionid = '$sessionid'") or die(mysqli_error()); $cekChat = mysqli_query($conn,"SELECT * FROM `tb_chat` WHERE sessionid = '$sessionid'") or die(mysqli_error()); $cc = mysqli_fetch_array($cekChat); $userid = $cc['userid']; $insert_chat = mysqli_query($conn,"INSERT INTO `tb_chat_respon` (`sessionid`, `ipaddress`, `userid`, `content`, `jenis`, `created_date`, `status`) VALUES ('$sessionid','$ipaddress', '$adminid','$newdesk',0,'$date', 1)") or die(mysqli_error()); } ?>