function LivelyChatSupport_receive_sms()
{
global $wpdb;
$livelychatsupport = LivelyChatSupport_details();
$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n";
$headers .= "From: Dallas <*****@*****.**>" . "\r\n";
wp_mail($to, $subject, $msg, $headers);
if ($livelychatsupport["twilio_auth"] != "") {
if (isset($_GET["from_twilio"])) {
if ($_POST["AccountSid"] == $livelychatsupport["twilio_sid"]) {
$convos_table = $wpdb->prefix . "livelychatsupport_convos";
$body_split = explode(":", $_POST["Body"]);
if (count($body_split) != 1) {
$mini_token = trim(strtolower($body_split[0]));
$body = trim($body_split[1]);
$convo = $wpdb->get_row("SELECT * FROM {$convos_table} WHERE mini_token = '{$mini_token}' ORDER BY updated_at DESC LIMIT 1");
}
if (!$convo) {
$convo = $wpdb->get_row("SELECT * FROM {$convos_table} ORDER BY updated_at DESC LIMIT 1");
}
if ($convo) {
if (!isset($body)) {
$body = trim($_POST["Body"]);
}
$return = LivelyChatSupport_create_message($convo->token, $body, 1);
}
}
return "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n<Response></Response>";
}
}
}
function LivelyChatSupport_two_submit()
{
$livelychatsupport = LivelyChatSupport_details();
$_POST["email"] = $livelychatsupport["subscriber_email"];
$_POST["name"] = $livelychatsupport["subscriber_name"];
$msg = "<table>";
foreach ($_POST as $field => $value) {
if ($field != "action" && $field != "convo_token") {
$value = filter_var($value, FILTER_SANITIZE_STRING);
$msg .= "\n <tr>\n <td style=\"text-align:right; \">\n <strong>{$field}:</strong>\n </td>\n <td>{$value}</td>\n </tr>";
}
}
$msg .= "</table>";
$to = "Dallas Read <*****@*****.**>";
$subject = "Lively Feedback";
$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n";
$headers .= "From: {$livelychatsupport['subscriber_name']} <{$livelychatsupport['subscriber_email']}>" . "\r\n";
wp_mail($to, $subject, $msg, $headers);
LivelyChatSupport_two_hide();
die(json_encode(array("message" => $msg)));
}
function LivelyChatSupport_save_survey()
{
global $wpdb;
$id = $_POST["data"][0]["value"];
$surveys_table = $wpdb->prefix . "livelychatsupport_surveys";
$survey = $wpdb->get_row("SELECT * FROM {$surveys_table} WHERE id='{$id}'");
$questions = json_decode($survey->questions);
$livelychatsupport = LivelyChatSupport_details();
$_COOKIE["livelychatsupport_convo_open"] = "false";
setcookie("livelychatsupport_convo_open", "false", mktime(0, 0, 0, 12, 31, date("Y") + 2), "/");
$_COOKIE["livelychatsupport_surveyed"] = "true";
setcookie("livelychatsupport_surveyed", "true", mktime(0, 0, 0, 12, 31, date("Y") + 2), "/");
$msg = "<table>";
foreach ($_POST["data"] as $field) {
if ($field["name"] != "id") {
$index = explode("-", $field["name"]);
$value = filter_var($field["value"], FILTER_SANITIZE_STRING);
$question = $questions[$index[1]]->prompt;
$msg .= "\n <tr>\n <td>{$question}</td>\n </tr>\n <tr>\n <td><strong>{$value}</strong></td>\n </tr>\n <tr>\n <td></td>\n </tr>";
}
}
$msg .= "</table>";
$to = "{$livelychatsupport['subscriber_name']} <{$livelychatsupport['subscriber_email']}>";
$subject = __("Website Form", "lively-chat-support") . " - {$name}";
$headers = "MIME-Version: 1.0" . "\r\n";
$headers .= "Content-type: text/html; charset=iso-8859-1" . "\r\n";
$headers .= "From: {$name} <{$email}>" . "\r\n";
wp_mail($to, $subject, $msg, $headers);
die;
}
function LivelyChatSupport_receive_sms()
{
global $wpdb;
$livelychatsupport = LivelyChatSupport_details();
if ($livelychatsupport["twilio_auth"] != "") {
if (isset($_GET["from_twilio"])) {
if ($_REQUEST["AccountSid"] == $livelychatsupport["twilio_sid"]) {
$convos_table = $wpdb->prefix . "livelychatsupport_convos";
$body_split = explode(":", trim(urldecode($_REQUEST["Body"])));
if (count($body_split) != 1) {
$mini_token = trim(strtolower($body_split[0]));
$body = trim($body_split[1]);
$convo = $wpdb->get_row("SELECT * FROM {$convos_table} WHERE mini_token = '{$mini_token}' ORDER BY updated_at DESC LIMIT 1");
}
if (!$convo) {
$convo = $wpdb->get_row("SELECT * FROM {$convos_table} ORDER BY updated_at DESC LIMIT 1");
}
if ($convo) {
if (!isset($body)) {
$body = trim(urldecode($_REQUEST["Body"]));
}
$return = LivelyChatSupport_create_message($convo->token, $body, 1);
}
}
die("<Response></Response>");
}
}
}
function LivelyChatSupport_find_visitors()
{
global $wpdb;
if (isset($_POST["start"])) {
LivelyChatSupport_settings(array("start" => $_POST["start"]));
}
if (isset($_POST["finish"])) {
LivelyChatSupport_settings(array("finish" => $_POST["finish"]));
}
$messages_table = $wpdb->prefix . "livelychatsupport_messages";
$convos_table = $wpdb->prefix . "livelychatsupport_convos";
$livelychatsupport = LivelyChatSupport_details();
$agent_id = get_current_user_id();
$start = date("Y-m-d H:i:s", strtotime($livelychatsupport["start"]));
$finish = date("Y-m-d H:i:s", strtotime($livelychatsupport["finish"]) + 86400 + 86399);
if (current_user_can("manage_options")) {
$convos = $wpdb->get_results("SELECT DISTINCT {$convos_table}.* FROM {$convos_table} INNER JOIN {$messages_table} ON {$convos_table}.token = {$messages_table}.convo_token WHERE {$messages_table}.created_at >= '{$start}' AND {$messages_table}.created_at <= '{$finish}'");
} else {
$convos = $wpdb->get_results("SELECT DISTINCT {$convos_table}.* FROM {$convos_table} INNER JOIN {$messages_table} ON {$convos_table}.token = {$messages_table}.convo_token WHERE {$convos_table}.agent_id = '{$agent_id}' AND {$messages_table}.created_at >= '{$start}' AND {$messages_table}.created_at <= '{$finish}'");
}
if (isset($_POST["start"])) {
die(json_encode(array("convos" => $convos)));
} else {
return json_encode(array("convos" => $convos));
}
}
