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; }