$poem_id = $vars[1]; //--for poem id not found in poems table--// if (!check_poem($database, $poem_id)) { echo $tpl->render("themes/site/" . theme_name . "/html/404.php"); exit; } foreach ($vars as $var) { if (strpos($var, 'p:') === 0) { $page_no_var = $var; //get the current Page from URL } } //--increment views of poem--// $update_poem = view_increment($database, $poem_id); //--get poem information--// $get_poem = get_poem($database, $poem_id); //--get topic information--// if ($get_poem['topic_id']) { $poem_topics_array = array(); //get topic ids as array $poem_topics = unserialize($get_poem['topic_id']); foreach ($poem_topics as $poem_topic_id) { if (!array_key_exists($poem_topic_id, $poem_topics_array)) { $poem_topic_array[$poem_topic_id] = get_topic($database, $poem_topic_id); } } $get_poem['topic_id'] = $poem_topic_array; } //--get author information--// // $author_id = $get_poem['author_id']; // if($get_poem['author_id']){
$popular_users = $get_popular['users']; if (!empty($popular_users)) { $users_info = array(); foreach ($popular_users as $users_id) { $data = get_user_info($database, $users_id); $users_info[] = $data[0]; } #print_r($users_info); foreach ($users_info as $key => $v) { $rating = avg_rating("users", $v['id'], $database); $users_info[$key]['rating'] = $rating; } $users_info = sortMultiArrayByKey($users_info, "rating"); #print_r($users_info); $tpl->popular_users = $users_info; } $popular_poems = $get_popular['poems']; if (!empty($popular_poems)) { $poem_info = array(); foreach ($popular_poems as $poem_id) { $poem_info[] = get_poem($database, $poem_id); } foreach ($poem_info as $key => $v) { $rating = avg_rating("poems", $v['id'], $database); $poem_info[$key]['rating'] = $rating; } $poem_info = sortMultiArrayByKey($poem_info, "rating"); $tpl->popular_poems = $poem_info; #print_r($poem_info); } echo $tpl->render("themes/site/" . theme_name . "/html/index.php");
<?php //ini_set("display_errors",1); require_once 'inc/inc.php'; require_once 'func/func_reg.php'; if ($_SERVER['REQUEST_METHOD'] == 'POST') { if (isset($_POST['poem_id'])) { $poem = get_poem($db, $_POST['poem_id']); echo json_encode($poem); } }
if (!empty($get_user_given_ratings['users'])) { foreach ($get_user_given_ratings['users'] as $k => $user_given_rating) { $data = get_user_info($database, $user_given_rating['id']); $get_user_given_ratings['users']['users'][] = $data[0]; } } $tpl->get_users = $get_user_given_ratings['users']; //pr($tpl->get_users);exit; //--get poem saved by user--// $get_saved = saved_poems($database, $user_id); $get_saved_poems = $get_saved['poems']; $get_saved_poets = $get_saved['author']; $get_saved_user = $get_saved['users']; if (!empty($get_saved_poems)) { foreach ($get_saved_poems as $k => $poem_id) { $get_saved_poems[$k] = get_poem($database, $poem_id); } $tpl->saved_poems = $get_saved_poems; } //--get saved poets--// if (!empty($get_saved_poets)) { foreach ($get_saved_poets as $k => $poet_id) { $get_saved_poets[$k] = get_author($database, $poet_id); } $tpl->saved_poets = $get_saved_poets; } //--get saved users--// if (!empty($get_saved_user)) { foreach ($get_saved_user as $k => $poet_id) { $data = get_user_info($database, $poet_id); $get_saved_user[$k] = $data[0];
$current_count = $get_topic_poems['present_count']; $page_array = array(); $page_array['current_page'] = $paginate['page_no']; $page_array['total_pages'] = $total_pages; $page_array['total_records'] = $count_records; $page_array['current_count'] = $current_count; $page_array['param_vars'] = $vars; $page_array['page_no_var'] = $page_no_var; $tpl->page_array = $page_array; //--get poem data--// if (!empty($get_topic_poems['data'])) { $topic_poems_info = array(); //get poems information for each poem received foreach ($get_topic_poems['data'] as $poem_id) { if (check_poem($database, $poem_id)) { $topic_poems_info[] = get_poem($database, $poem_id); } } } $tpl->topic_poems_info = $topic_poems_info; //--get all topics and count poem of topic--// $get_sidebar_topics = all_topic($database); //--count sidebar topics poems--// if (!empty($get_sidebar_topics)) { foreach ($get_sidebar_topics as $key => $sidebar_topic) { $sidebar_topic_id = $sidebar_topic['topic_id']; $get_sidebar_topics[$key]['poems_count'] = get_topic_poems($database, $sidebar_topic_id, array("ONLYCOUNT" => TRUE)); } } $tpl->sidebar_topics = $get_sidebar_topics; // Send SEO Data