function send_message($recipient_id, $message)
{
global $db;
$images = new images();
$sender_id = $_SESSION['user_data']['pet_data']['pet_id'];
$recipient_id = htmlspecialchars($recipient_id);
$message = htmlspecialchars($message);
$date = strtotime(date('Y-m-d H:i:s'));
$message_date = date('F j Y, H:i:sa');
$query = "SELECT pet_id, name, lastname, image FROM ?:pets WHERE pet_id = ?i ";
$parsed = $db->db_quote($query, $sender_id);
$pet = $db->db_get_array($parsed);
$pet_name = $pet[0]['name'] . ' ' . $pet[0]['lastname'];
$image = $images->fn_get_image($pet[0]['pet_id'], 'pet', $pet[0]['image']);
if (!$image) {
$thumb = '/images/default-pic.png';
} else {
$thumb = $images->fn_generate_thumbnail('pet', _SITE_DOMAIN_HTTP_ . $image['image_path'], 32, 32, true);
}
$query = "INSERT INTO ?:messages ?e ";
$param = array("sender_id" => $sender_id, "recipient_id" => $recipient_id, "message" => $message, "date" => $date, "status" => "N");
$parsed = $db->db_quote($query, $param);
$msg_id = $db->db_query($parsed);
if ($msg_id) {
$notify = 'Message sent successfully.';
} else {
$notify = 'Message sending failed.';
}
$data = array("message" => '<li data-message-id="' . $msg_id . '"><div class="message-check"><input type="checkbox" data-message-id="' . $msg_id . '" value="' . $msg_id . '" /></div><div class="message-thumb"><img src="' . $thumb . '" alt="' . $pet_name . '" /></div><div class="message-body"><a href="' . $sender_id . '">' . $pet_name . '</a><div class="message-date">' . $message_date . '</div><p>' . $message . '</p></div></li>', "notify" => $notify);
return json_encode($data);
}
function show_posts($pet_id)
{
global $db;
$images = new images();
$friendly = new friendly();
$posts = $db->db_get_array("SELECT u.name,u.lastname,u.image AS thumb,p.post_id,p.pet_id,p.date,p.text,p.image,\n CASE WHEN IFNULL(ppl.pet_id,0) = 0 THEN 'Like' ELSE 'Unlike' END liked FROM `rck_pets` u\n INNER JOIN `rck_posts` p ON u.pet_id = p.pet_id AND p.status = ?s\n LEFT JOIN rck_pet_post_likes ppl ON ppl.post_id = p.post_id AND ppl.pet_id = p.pet_id\n WHERE p.pet_id = ?i ORDER BY post_id DESC", "A", $pet_id);
foreach ($posts as $key => $post) {
$posts[$key]['image'] = $images->fn_get_image($post['post_id'], 'post', $post['image']);
$thumb = $images->fn_get_image($post['pet_id'], 'pet', $post['thumb']);
if (!$thumb) {
$posts[$key]['thumb'] = _IMAGE_URL_ . 'default-pic.png';
} else {
$posts[$key]['thumb'] = $images->fn_generate_thumbnail('pet', $thumb['image_path'], 48, 48, true);
}
if ($post['pet_id'] == $pet_id) {
$posts[$key]['button'] = '<div><a href="javascript:void(0);" class="delete-post" id="delete-post-' . $post['post_id'] . '" title="Delete this Post"><span>Delete</span></a></div>';
} else {
$posts[$key]['button'] = '';
}
$post_id = $post['post_id'];
$tags = $db->db_get_array("select value from rck_opt_post_types_lang\n inner join rck_post_types on rck_opt_post_types_lang.type_id = rck_post_types.type_id\n where post_id = ?i and lang_code = ?s ", $post_id, _CLIENT_LANGUAGE_);
$tmp = '';
foreach ($tags as $tag) {
$tdesc = $tag['value'];
$tmp .= '<a href="' . $friendly->get_seourl_by_module("tags/{$tdesc}", true) . '">' . $tdesc . '</a>, ';
}
$posts[$key]['tags'] = substr($tmp, 0, strlen($tmp) - 2);
}
return $posts;
}
