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']);