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;
}
})(window,document,"script","//www.google-analytics.com/analytics.js","ga");
ga("create", "UA-XXXXXXXXXXXX-1", "mydomain.com");
ga("send", "pageview");
</script>
');
#General includes & instances
require_once _CORE_DIR_ . "friendly.core.php";
require_once _CORE_DIR_ . "misc.core.php";
$misc = new misc();
#LANGS initialization
$languages = new languages_core();
require_once _CORE_DIR_ . "sessions.core.php";
#Start session mechanism
$session = new session();
$session->init();
#Friendly URLs initialization
$friendly = new friendly();
#Smarty initialization
$smarty = new Smarty();
$smarty->compile_check = true;
$smarty->debugging = false;
#TODO: Test if its necesary
$smarty->caching = false;
if (!$friendly->page) {
$friendly->__construct();
}
#LANGS Smarty assign
$smarty->assign("lang", $languages->langs[_CLIENT_LANGUAGE_]);
$smarty->assign('user_data', $_SESSION['user_data']);
