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