function index() { $data['add_css'] = array('contents', 'profile'); $data['add_js'] = array("jquery.cycle.all.min", "profile"); $data['title'] = $this->title; $data['type_label'] = array(1 => 'review', 'blog', 'project', 'video', 'thread', 8 => 'like', 9 => 'comment'); $data['type_list'] = array(1 => 'Wrote a review', 'Added blog entry', 'Added a project', 'Added a video', 'Start A New Thread', 8 => 'Liked ', 9 => 'Commented on '); $data['account'] = $this->m_accounts->read($this->session->userdata('user_id')); $data['profile'] = $this->m_profiles->read_by_account_id($data['account']->ID); $data['posts'] = $this->m_posts->get_user_posts($data['account']->ID, 20); #$data['total_posts'] = count($data['posts']); $data['nb_posts'] = $this->m_posts->count_user_posts($data['account']->ID); $data['nb_days'] = get_total_days($data['profile']->member_since, date("Y-m-d")); $data['unread'] = $this->m_messages->count_unread_messages($this->session->userdata('user_id')); $data['blogs'] = $this->m_posts->get_user_blogs($data['account']->ID, 'desc'); /*foreach($data['blogs'] as $r){ $comment = $this->m_posts->get_content_comment($r->ref_id); $comment_arr[] = count($comment); $data['blog_nb_comments'] = $comment_arr; }*/ $data['videos'] = $this->m_posts->get_user_videos($data['account']->ID, 'desc'); /*foreach($data['videos'] as $r){ $comment = $this->m_posts->get_content_comment($r->ref_id); $comment_arr[] = count($comment); $data['video_nb_comments'] = $comment_arr; }*/ $data['projects'] = $this->m_posts->get_user_projects($data['account']->ID, 'desc'); /*foreach($data['projects'] as $r){ $comment = $this->m_posts->get_content_comment($r->ref_id); $project_comment_arr[] = count($comment); $data['project_nb_comments'] = $project_comment_arr; }*/ $data['reviews'] = $this->m_posts->get_user_reviews($data['account']->ID, 'desc'); $this->load->view('member/v_member_dashboard', $data); }
function index() { $data['title'] = $this->title; $data['account'] = $this->m_accounts->read($this->session->userdata('user_id')); $data['add_js'] = array('notice'); $this->load->library('pager'); $limit = 10; $page = $this->uri->segment(4, 1); $index = ($page - 1) * $limit; $config['base_url'] = base_url() . 'member/video/page/'; $config['uri_segment'] = 4; $nb_videos = $this->m_posts->get_user_videos($data['account']->ID, 'desc'); $config['total_post'] = count($nb_videos); $config['limit'] = $limit; $this->pager->initialize($config); $video_list = $this->m_posts->get_user_videos($data['account']->ID, 'desc', array('index' => $index, 'limit' => $limit)); if (count($video_list) > 0) { $data['video_list'] = $video_list; #print_r($video_list); foreach ($video_list as $i) { $data['post_tags'][] = $this->m_tags->read($i->ID); } #print_r($data['post_tags']); } $data['profile'] = $this->m_profiles->read_by_account_id($data['account']->ID); $data['nb_posts'] = $this->m_posts->count_user_posts($data['account']->ID); $data['nb_days'] = get_total_days($data['profile']->member_since, date("Y-m-d")); #$data['tags'] = $this->m_tags->get_project_tags(array('user_id'=>$this->session->userdata('user_id'))); $this->load->view('member/v_member_video', $data); }
function index() { $data['title'] = $this->title; $data['account'] = $this->m_accounts->read($this->session->userdata('user_id')); $data['add_js'] = array('notice'); $this->load->library('pager'); $limit = 10; $page = $this->uri->segment(4, 1); $index = ($page - 1) * $limit; $config['base_url'] = base_url() . 'member/forum/page/'; $config['uri_segment'] = 4; $nb_threads = $this->m_posts->get_user_threads($data['account']->ID, 'desc'); $config['total_post'] = count($nb_threads); $config['limit'] = $limit; $this->pager->initialize($config); $thread_list = $this->m_posts->get_user_threads($data['account']->ID, 'desc', array('index' => $index, 'limit' => $limit)); #print_r($thread_list); #$blog_list = $this->m_blogs->get_user_blog($this->session->userdata('user_id')); if (count($thread_list) > 0) { $data['thread_list'] = $thread_list; } $data['profile'] = $this->m_profiles->read_by_account_id($data['account']->ID); $data['nb_posts'] = $this->m_posts->count_user_posts($data['account']->ID); $data['nb_days'] = get_total_days($data['profile']->member_since, date("Y-m-d")); #$data['blog_series'] = $this->m_blogs->get_blog_series($data['account']->ID); $this->load->view('member/v_member_forum', $data); #redirect('member/forum/create'); }
function index() { $data['title'] = $this->title; $data['account'] = $this->m_accounts->read($this->session->userdata('user_id')); $data['add_js'] = array('notice'); $this->load->library('pager'); $limit = 10; $series = ''; if ($this->uri->segment(3) == 'series') { $series = $this->uri->segment(4); #$sort = $this->uri->segment(3); #$data['sort'] = $sort; $page = $this->uri->segment(6, 1); $index = ($page - 1) * $limit; $config['base_url'] = base_url() . 'member/blog/series/' . $series . '/page/'; $config['uri_segment'] = 6; //if tag exist } else { #$sort = 'latest'; #$data['sort'] = $sort; $page = $this->uri->segment(4, 1); $index = ($page - 1) * $limit; $config['base_url'] = base_url() . 'member/blog/page/'; $config['uri_segment'] = 4; } #$nb_blogs = $this->m_blogs->get_blog('',array('sort'=>$sort_by,'tag'=>$tag)); $nb_blogs = $this->m_posts->get_user_blogs($data['account']->ID, 'desc', array('series' => $series)); $config['total_post'] = count($nb_blogs); $config['limit'] = $limit; $this->pager->initialize($config); $blog_list = $this->m_posts->get_user_blogs($data['account']->ID, 'desc', array('series' => $series, 'index' => $index, 'limit' => $limit)); if (!empty($series)) { $data['browse_series'] = TRUE; if ($series != 'na') { $data['series_detail'] = $this->m_blogs->get_blog_series_detail($series); } else { $data['series_detail']->series_name = 'No Series'; } } #$blog_list = $this->m_posts->get_user_blogs($data['account']->ID, 'desc'); if (count($blog_list) > 0) { $data['blog_list'] = $blog_list; } $data['profile'] = $this->m_profiles->read_by_account_id($data['account']->ID); $data['nb_posts'] = $this->m_posts->count_user_posts($data['account']->ID); $data['nb_days'] = get_total_days($data['profile']->member_since, date("Y-m-d")); $data['blog_series'] = $this->m_blogs->get_blog_series($data['account']->ID); $data['no_series'] = $this->m_posts->get_user_blogs($data['account']->ID, 'desc', array('series' => 'na')); $this->load->view('member/v_member_blog', $data); }
function index() { $data['title'] = $this->title; $data['account'] = $this->m_accounts->read($this->session->userdata('user_id')); $data['add_js'] = array('notice'); $this->load->library('pager'); $limit = 10; $tag = ''; //if tag exist if ($this->uri->segment(3) == 'tag') { $tag = $this->uri->segment(4); $page = $this->uri->segment(6, 1); $index = ($page - 1) * $limit; $config['base_url'] = base_url() . 'member/project/tag/' . $tag . '/page/'; $config['uri_segment'] = 6; } else { $page = $this->uri->segment(4, 1); $index = ($page - 1) * $limit; $config['base_url'] = base_url() . 'member/project/page/'; $config['uri_segment'] = 4; } $nb_projects = $this->m_posts->get_user_projects($data['account']->ID, 'desc', array('tag' => $tag)); $config['total_post'] = count($nb_projects); $config['limit'] = $limit; $this->pager->initialize($config); $project_list = $this->m_posts->get_user_projects($data['account']->ID, 'desc', array('tag' => $tag, 'index' => $index, 'limit' => $limit)); if (count($project_list) > 0) { $data['project_list'] = $project_list; #print_r($project_list); foreach ($project_list as $i) { $data['post_tags'][] = $this->m_tags->read($i->ID); } } if (!empty($tag)) { $data['browse_tag'] = TRUE; $data['tag'] = $tag; } $data['profile'] = $this->m_profiles->read_by_account_id($data['account']->ID); $data['nb_posts'] = $this->m_posts->count_user_posts($data['account']->ID); $data['nb_days'] = get_total_days($data['profile']->member_since, date("Y-m-d")); $data['tags'] = $this->m_tags->get_project_tags(array('user_id' => $this->session->userdata('user_id'))); $this->load->view('member/v_member_project', $data); }
function _mso_sql_build_archive($r, &$pag) { global $MSO; $CI =& get_instance(); // [1]=>archive [2]=>Y [3]=>M [4]=>D [5]=>next $seg = $MSO->data['uri_segment']; // если есть пагинация, то отсекаем её $in_next = array_search($r['pagination_next_url'], $seg); if ($in_next !== false) { // есть вхождение - отсекаем // эти операции, чтобы начать счёт в массиве с 1, как в $MSO->data['uri_segment']) $seg = array_merge(array(0), array_slice($seg, 0, $in_next - 1)); unset($seg[0]); } $count_segment = count($seg) - 1; $year = (int) mso_segment(2, true, $seg); // используем свой массив сегментов if ($year > date('Y', mktime()) or $year < 2006) { $year = date('Y', mktime()); } $month = (int) mso_segment(3, true, $seg); $day = (int) mso_segment(4, true, $seg); if ($count_segment >= 3) { // указаны год-месяц-дата if ($month > 12 or $month < 1) { $month = 1; } $dmax = get_total_days($month, $year); if ($day == 0) { $day = 1; } if ($day > $dmax) { $day = $dmax; } $date_in = mso_date_convert('Y-m-d H:i:s', $year . '-' . $month . '-' . $day . ' 00:00:00', false); $date_in_59 = mso_date_convert('Y-m-d H:i:s', $year . '-' . $month . '-' . $day . ' 23:59:59', false); } elseif ($count_segment == 2) { // указано год-месяц if ($month > 12 or $month < 1) { $month = 1; } $dmax = get_total_days($month, $year); $date_in = mso_date_convert('Y-m-d H:i:s', $year . '-' . $month . '-1 00:00:00', false); $date_in_59 = mso_date_convert('Y-m-d H:i:s', $year . '-' . $month . '-' . $dmax . ' 23:59:59', false); } elseif ($count_segment == 1) { // указан только год $date_in = mso_date_convert('Y-m-d H:i:s', $year . '-01-01 00:00:00', false); $date_in_59 = mso_date_convert('Y-m-d H:i:s', $year . '-12-31 23:59:59', false); } else { // ничего не указано - выводим архив за все время $year = date('Y', mktime()); $date_in = mso_date_convert('Y-m-d H:i:s', '2006-01-01 00:00:00', false); $date_in_59 = mso_date_convert('Y-m-d H:i:s', $year . '-12-31 23:59:59', false); } //pr($date_in); //pr($date_in_59); $offset = 0; if ($r['pagination']) { # пагинация # для неё нужно при том же запросе указываем общее кол-во записей и кол-во на страницу # сама пагинация выводится отдельным плагином # запрос один в один, кроме limit и юзеров $CI->db->select('SQL_BUFFER_RESULT ' . $CI->db->dbprefix('page') . '.`page_id`', false); $CI->db->from('page'); if ($r['page_status']) { $CI->db->where('page_status', $r['page_status']); } if ($r['date_now'] and $r['page_id_date_now']) { $CI->db->where_not_in('page.page_id', $r['page_id_date_now']); } // if ($r['date_now']) $CI->db->where('page_date_publish < ', 'DATE_ADD(NOW(), INTERVAL "' . $r['time_zone'] . '" HOUR_MINUTE)', false); if ($r['type']) { if (is_array($r['type'])) { $CI->db->where_in('page_type_name', $r['type']); } else { $CI->db->where('page_type_name', $r['type']); } } $CI->db->where('page_date_publish >= ', $date_in); $CI->db->where('page_date_publish <= ', $date_in_59); if ($r['page_id_autor']) { $CI->db->where('page.page_id_autor', $r['page_id_autor']); } $CI->db->join('page_type', 'page_type.page_type_id = page.page_type_id'); $CI->db->order_by($r['order'], $r['order_asc']); if ($function_add_custom_sql = $r['function_add_custom_sql']) { $function_add_custom_sql(); } $query = $CI->db->get(); $pag_row = $query->num_rows(); if ($pag_row > 0) { $pag['maxcount'] = ceil($pag_row / $r['limit']); // всего станиц пагинации $pag['limit'] = $r['limit']; // записей на страницу $current_paged = mso_current_paged($r['pagination_next_url']); if ($current_paged > $pag['maxcount']) { $current_paged = $pag['maxcount']; } $offset = $current_paged * $pag['limit'] - $pag['limit']; } else { $pag = false; } } else { $pag = false; } // теперь сами страницы if (!$r['all_fields']) { $CI->db->select('page.page_id, page_type_name, page_slug, page_title, page_date_publish, page_status, users_nik, page_content, page_view_count, page_rating, page_rating_count, page_password, page_comment_allow, page_id_parent, users_avatar_url, page.page_id_autor, users_description, users_login'); } else { $CI->db->select('page.*, page_type.*, users.*'); } $CI->db->from('page'); if ($r['page_status']) { $CI->db->where('page_status', $r['page_status']); } $CI->db->where('page_date_publish >= ', $date_in); $CI->db->where('page_date_publish <= ', $date_in_59); if ($r['page_id_autor']) { $CI->db->where('page.page_id_autor', $r['page_id_autor']); } // if ($r['date_now']) $CI->db->where('page_date_publish < ', 'DATE_ADD(NOW(), INTERVAL "' . $r['time_zone'] . '" HOUR_MINUTE)', false); if ($r['date_now'] and $r['page_id_date_now']) { $CI->db->where_not_in('page.page_id', $r['page_id_date_now']); } if ($r['type']) { if (is_array($r['type'])) { $CI->db->where_in('page_type_name', $r['type']); } else { $CI->db->where('page_type_name', $r['type']); } } $CI->db->join('users', 'users.users_id = page.page_id_autor'); $CI->db->join('page_type', 'page_type.page_type_id = page.page_type_id'); $CI->db->order_by($r['order'], $r['order_asc']); $CI->db->group_by('page.page_id'); if (!$r['no_limit']) { if ($pag and $offset) { $CI->db->limit($r['limit'], $offset); } else { $CI->db->limit($r['limit']); } } if ($function_add_custom_sql = $r['function_add_custom_sql']) { $function_add_custom_sql(); } }
function browse() { $user_name = $this->uri->segment(2); $data['account'] = $this->m_accounts->read_by('user_name', $user_name); #FOR PAGINATION# $this->load->library('pager'); $limit = 10; $page = $this->uri->segment(4, 1); $index = ($page - 1) * $limit; $nb_posts = $this->m_posts->get_user_projects($data['account']->ID, 'desc'); $config['total_post'] = count($nb_posts); $config['base_url'] = base_url() . 'project/' . $user_name . '/page/'; $config['uri_segment'] = 4; $config['limit'] = $limit; $this->pager->initialize($config); #FOR PAGINATION# $data['nb_posts'] = $this->m_posts->count_user_posts($data['account']->ID); $data['projects'] = $this->m_posts->get_user_projects($data['account']->ID, 'desc', array('index' => $index, 'limit' => $limit)); $data['profile'] = $this->m_profiles->read_by_account_id($data['account']->ID); $data['user_name'] = $user_name; $data['title'] = $this->title . ' - ' . $data['account']->user_name . "'s Hunts"; $data['nb_days'] = get_total_days($data['profile']->member_since, date("Y-m-d")); /*foreach($data['projects'] as $r){ $comment = $this->m_posts->get_content_comment($r->ref_id); $comment_arr[] = $comment; } $data['nb_comments'] = $comment_arr*/ $this->load->view('v_browse_user_project', $data); }
?> 's avatar"/> </span> </a> <p><a href="<?php echo base_url(); ?> user/<?php echo $r->user_name; ?> "><?php echo $r->user_name; ?> </a></p> <?php $interval = get_total_days($r->member_since, date("Y-m-d")); ?> <p class="small"><?php echo $r->total_posts; ?> post<?php plural($r->total_posts); ?> in <?php echo $interval; ?> day<?php plural($interval); ?> </p> <p class="small"><?php
<?php if ($this->session->userdata('logged_in')) { $data['loggedin_profile'] = $this->m_profiles->read_by_account_id($this->session->userdata('user_id')); $data['loggedin_account'] = $this->m_accounts->read($this->session->userdata('user_id')); $data['loggedin_posts'] = $this->m_posts->count_user_posts($data['loggedin_profile']->account_id); $data['loggedin_days'] = get_total_days($data['loggedin_profile']->member_since, date("Y-m-d")); }
function series() { $series_id = $this->uri->segment(3); $ser = $this->m_blogs->get_blog_series_detail($series_id); $data['account'] = $this->m_accounts->read($ser->account_id); $data['profile'] = $this->m_profiles->read_by_account_id($data['account']->ID); $data['nb_posts'] = $this->m_posts->count_user_posts($data['account']->ID); $data['nb_days'] = get_total_days($data['profile']->member_since, date("Y-m-d")); $data['user_name'] = $data['account']->user_name; $data['blog_series'] = $this->m_blogs->get_blog_series($data['account']->ID); #FOR PAGINATION# $this->load->library('pager'); $limit = 10; $page = $this->uri->segment(5, 1); $index = ($page - 1) * $limit; $nb_blogs = $this->m_blogs->get_blog_by_series($series_id); $config['total_post'] = count($nb_blogs); $config['base_url'] = base_url() . 'blog/series/' . $series_id . '/page/'; $config['uri_segment'] = 5; $config['limit'] = $limit; $this->pager->initialize($config); #FOR PAGINATION# $data['blogs'] = $this->m_blogs->get_blog_by_series($series_id, '', array('index' => $index, 'limit' => $limit)); /*if(!empty($data['blogs'])){ foreach($data['blogs'] as $r){ $comment = $this->m_posts->get_content_comment($r->ref_id); $comment_arr[] = $comment; } $data['nb_comments'] = $comment_arr; }*/ $data['title'] = $this->title . ' - ' . $ser->series_name . " Blog Series by" . $data['account']->user_name; $data['series_detail'] = $ser; $this->load->view('v_browse_user_blog_series', $data); }
<?php $data['comments'] = $this->m_posts->get_content_comment($id, $type_id); $arr = NULL; $days_arr = NULL; foreach ($data['comments'] as $r) { $nb_post = $this->m_posts->count_user_posts($r->account_id); $nb_days = get_total_days($r->member_since, date("Y-m-d")); $arr[] = $nb_post; $days_arr[] = $nb_days; } $data['commenter_posts'] = $arr; $data['commenter_days'] = $days_arr;
function thread() { $id = $this->uri->segment(3); $data['post'] = $this->m_posts->get_post_by_type_ref(5, $id); //type_id:5 = forum #if deleted if ($data['post']->deleted == 1) { #redirect to 404 or denied #show_error('The content has been removed'); redirect('404'); } $this->m_posts->add_view_count(5, $id); //type_id:5 = forum $data['add_css'] = array('fancybox/jquery.fancybox-1.3.1'); $data['add_js'] = array('fancybox/jquery.fancybox-1.3.1.pack', 'like'); $data['like_bar'] = build_like($this->session->userdata('user_id'), 5, $id); $data['thread_info'] = $this->m_threads->get_thread($id); #$data['thread_info'] = $this->m_threads->read($id); $data['forum_info'] = $this->m_forums->read($data['thread_info']->forum_id); $data['account'] = $this->m_accounts->read($data['post']->account_id); $data['profile'] = $this->m_profiles->read_by_account_id($data['account']->ID); $data['title'] = $this->title . " - " . $data['thread_info']->title; $data['nb_posts'] = $this->m_posts->count_user_posts($data['account']->ID); $data['nb_days'] = get_total_days($data['profile']->member_since, date("Y-m-d")); $data['likes'] = count($this->m_likes->read($id)); $tags_arr = array(); $tags = $this->m_tags->read($data['post']->ID); foreach ($tags as $r) { $tags_arr[] = $r->name; } #$data['tags'] = implode(', ',$tags_arr); $data['tags'] = $tags_arr; $type_id = 5; // forum include 'includes/comments_list.php'; include 'includes/comment_form.php'; $this->load->view('v_thread', $data); }
function read() { $username = $this->uri->segment(2); $data['add_js'] = array("jquery.cycle.all.min", "profile"); $data['account'] = $this->m_accounts->read_by('user_name', $username); //if user doesn't exist if (count($data['account']) == 0) { redirect('404'); } if (count($this->m_friends->check_friend($data['account']->ID)) > 0) { $data['already_friend'] = true; } $data['profile'] = $this->m_profiles->read_by_account_id($data['account']->ID); $data['posts'] = $this->m_posts->get_user_posts($data['account']->ID); #$data['total_posts'] = count($data['posts']); $data['blogs'] = $this->m_posts->get_user_blogs($data['account']->ID, 'desc'); $data['videos'] = $this->m_posts->get_user_videos($data['account']->ID, 'desc'); $data['projects'] = $this->m_posts->get_user_projects($data['account']->ID, 'desc'); $data['reviews'] = $this->m_posts->get_user_reviews($data['account']->ID, 'desc'); $data['friends'] = $this->m_friends->get_friends($data['account']->ID); #$data['title'] = $this->title. ' | '.$data['profile']->first_name.' '.$data['profile']->last_name.'\'s Profile'; $data['title'] = $this->title . ' | ' . $data['account']->user_name . '\'s Profile'; $data['type_label'] = array(1 => 'review', 'blog', 'project', 'video', 'thread', 8 => 'like', 9 => 'comment'); $data['type_list'] = array(1 => 'Wrote a review', 'Added blog entry', 'Added a project', 'Added a video', 'Start A New Thread', 8 => 'Liked ', 9 => 'Commented on '); $data['nb_posts'] = $this->m_posts->count_user_posts($data['account']->ID); $data['nb_days'] = get_total_days($data['profile']->member_since, date("Y-m-d")); $data['comments'] = $this->m_posts->get_profile_comment($data['account']->ID); $arr = NULL; $days_arr = NULL; foreach ($data['comments'] as $r) { $nb_post = $this->m_posts->count_user_posts($r->account_id); $nb_days = get_total_days($r->member_since, date("Y-m-d")); $arr[] = $nb_post; $days_arr[] = $nb_days; } $data['commenter_posts'] = $arr; $data['commenter_days'] = $days_arr; include 'includes/comment_form.php'; $this->load->view('v_user', $data); }