user.php

<?php
include_once('internal/Smarty.class.php');
$main_smarty = new Smarty;

include('config.php');
include(mnminclude.'html1.php');
include(mnminclude.'link.php');
include(mnminclude.'group.php');
include(mnminclude.'user.php');
include(mnminclude.'comment.php');
include(mnminclude.'friend.php');
include(mnminclude.'smartyvariables.php');
include(mnminclude.'csrf.php');

// setup the breadcrumbs
$navwhere['text1'] = $main_smarty->get_config_vars('PLIGG_Visual_Breadcrumb_Profile');
$navwhere['link1'] = getmyurl('topusers');
$navwhere['text2'] = $login;
$navwhere['link2'] = getmyurl('user2', $login, 'profile');

$offset = (get_current_page()-1)* $page_size;
$main_smarty = do_sidebar($main_smarty);

define('pagename', 'user');
$main_smarty->assign('pagename', pagename);

$CSRF = new csrf();
$CSRF->create('user_settings', true, true);

// if not logged in, redirect to the index page
$login = isset($_GET['login']) ? sanitize($_GET['login'], 3) : '';
$truelogin = isset($_COOKIE['mnm_user']) ? sanitize($_COOKIE['mnm_user'], 3) : '';
if ($login === '' && !$_GET['keyword']) {
    if ($current_user->user_id > 0) {
        $login = $current_user->user_login;
        if (urlmethod == 2) {
            header("Location: $my_base_url$my_pligg_base/user/$login/");
        } else {
            header("Location: ?login=$login");
        }
    } else {
        header('Location: '.$my_base_url.$my_pligg_base);
    }
    die;
}

if ($login) {
    // read the users information from the database
    $user = new User();
    $user->username = $login;
    if (!$user->read() || $user->level == 'Spammer' || ($user->username == 'anonymous' && !$user->user_lastip) ||
   // Hide users without stories/comments from unregistered visitors
   !$user->all_stats() || $user->total_links+$user->total_comments+$current_user->user_id == 0) {
        header("Location: $my_pligg_base/error_404.php");
        die;
    }
}

require_once(mnminclude.'check_behind_proxy.php');

if (ShowProfileLastViewers == true) {
    $main_smarty->assign('ShowProfileLastViewers', true);
    // setup some arrays
        $last_viewers_names = array();
    $last_viewers_profile = array();
    $last_viewers_avatar = array();

    // for each viewer, get their name, profile link and avatar and put it in an array
        $viewers = new User();
    if ($last_viewers) {
        foreach ($last_viewers as $viewer_id) {
            $viewers->id = $viewer_id;
            $viewers->read();
            $last_viewers_names[] = $viewers->username;
            $last_viewers_profile[] = getmyurl('user2', $viewers->username, 'profile');
            $last_viewers_avatar[] = get_avatar('small', "", $viewers->username, $viewers->email);
        }
    }
    // tell smarty about our arrays
        $main_smarty->assign('last_viewers_names', $last_viewers_names);
    $main_smarty->assign('last_viewers_profile', $last_viewers_profile);
    $main_smarty->assign('last_viewers_avatar', $last_viewers_avatar);
} else {
    $main_smarty->assign('ShowProfileLastViewers', false);
}


// User IP for Admin Use
$user_ip = $user->extra_field['user_ip'];
$main_smarty->assign('user_ip', $user_ip);
$user_lastip = $user->extra_field['user_lastip'];
$main_smarty->assign('user_lastip', $user_lastip);

// check to see if the profile is of a friend
if ($user->id) {
    $friend = new Friend;
    $main_smarty->assign('is_friend', $friend->get_friend_status($user->id));
    $main_smarty->assign('user_followers', $user->getFollowersCount());
    $main_smarty->assign('user_following', $user->getFollowingCount());
}

// setup breadcrumbs for the various views
$view = isset($_GET['view']) && sanitize($_GET['view'], 3) != '' ? sanitize($_GET['view'], 3) : 'profile';
if ($view == 'setting' && $truelogin != $login) {
    $view = 'profile';
}

$main_smarty->assign('user_view', $view);
$main_smarty->assign('page_header', $page_header);

// User Homepage URL
if ($view == 'search') {
    $friend = new Friend;
    if (isset($_REQUEST['keyword'])) {
        $keyword = $db->escape(sanitize(trim($_REQUEST['keyword']), 3));
    }

    if ($keyword) {
        $searchsql = "SELECT * FROM ".table_users." where ((user_login LIKE '%".$keyword."%' AND user_login !='".$current_user->user_login."') OR public_email LIKE '%".$keyword."%') AND user_level!='Spammer' ";
        $results = $db->get_results($searchsql);
        $results = object_2_array($results);
        foreach ($results as $key => $val) {
            if ($val['user_login'] != 'anonymous' || $val['user_lastip'] > 0) {
                $results[$key]['Avatar'] = get_avatar('small', "", $val['user_login'], $val['user_email']);
                $results[$key]['status'] = $friend->get_friend_status($val['user_id']);
                if ($results[$key]['status'] == '' || $results[$key]['status'] == 'follower') {
                    $results[$key]['add_friend'] = getmyurl('user_add_remove', 'addfriend', $val['user_login']);
                } elseif ($results[$key]['status'] == 'following' || $results[$key]['status'] == 'mutual') {
                    $results[$key]['remove_friend'] = getmyurl('user_add_remove', 'removefriend', $val['user_login']);
                }
            } else {
                unset($results[$key]);
            }
        }

        $main_smarty->assign('userlist', $results);
    }
    $main_smarty->assign('search', $keyword);

    $main_smarty->assign('page_header', $user->username);
    $navwhere['text3'] = $main_smarty->get_config_vars('PLIGG_Visual_Search_SearchResults').' '.$keyword;
    $main_smarty->assign('posttitle', $main_smarty->get_config_vars('PLIGG_Visual_Breadcrumb_Profile')." ".$login." - ".$main_smarty->get_config_vars('PLIGG_Visual_Search_SearchResults').' '.$keyword);

    // display the template
    $main_smarty->assign('tpl_center', $the_template.'/user_search_center');
    $main_smarty->display($the_template.'/pligg.tpl');
    die;
} else {
    // avatars
$main_smarty->assign('UseAvatars', do_we_use_avatars());
    $main_smarty->assign('Avatar', $avatars = get_avatar('all', '', $user->username, $user->email));
    $main_smarty->assign('Avatar_ImgSrc', $avatars['large']);

    if ($user->url != "") {
        if (substr(strtoupper($user->url), 0, 8) == "HTTPS://") {
            $main_smarty->assign('user_url', $user->url);
        } elseif (substr(strtoupper($user->url), 0, 7) != "HTTP://") {
            $main_smarty->assign('user_url', "http://".$user->url);
        } else {
            $main_smarty->assign('user_url', $user->url);
        }
    } else {
        $main_smarty->assign('user_url', '');
    }

//Assigne la biographie
$main_smarty->assign('user_biographie', $user->biographie);

// setup the links
$main_smarty->assign('user_url_personal_data2', getmyurl('user2', $login));
    $main_smarty->assign('user_url_news_sent2', getmyurl('user2', $login, 'history'));
    $main_smarty->assign('user_url_news_published2', getmyurl('user2', $login, 'published'));
    $main_smarty->assign('user_url_news_unpublished2', getmyurl('user2', $login, 'new'));
    $main_smarty->assign('user_url_news_voted2', getmyurl('user2', $login, 'voted'));
    $main_smarty->assign('user_url_news_upvoted2', getmyurl('user2', $login, 'upvoted'));
    $main_smarty->assign('user_url_news_downvoted2', getmyurl('user2', $login, 'downvoted'));
    $main_smarty->assign('user_url_commented2', getmyurl('user2', $login, 'commented'));
    $main_smarty->assign('user_url_saved2', getmyurl('user2', $login, 'saved'));
    $main_smarty->assign('user_url_friends', getmyurl('user_friends', $login, 'following'));
    $main_smarty->assign('user_url_friends2', getmyurl('user_friends', $login, 'followers'));
    $main_smarty->assign('user_url_add', getmyurl('user_friends', $login, 'addfriend'));
    $main_smarty->assign('user_url_remove', getmyurl('user_friends', $login, 'removefriend'));
    $main_smarty->assign('user_rss', getmyurl('rssuser', $login));
    $main_smarty->assign('URL_Profile2', getmyurl('user_edit', $login));
    $main_smarty->assign('form_action', getmyurl('profile'));
    $main_smarty->assign('user_url_member_groups', getmyurl('user2', $login, 'member_groups	'));

// tell smarty about our user
$main_smarty = $user->fill_smarty($main_smarty);

    $username = $user->username;
    $post_title = $main_smarty->get_config_vars('PLIGG_Visual_Breadcrumb_Profile')." ".$login;

    $main_smarty->assign('username', $username);
    $main_smarty->assign('posttitle', $post_title);

#$navwhere['text3'] = $page_header = $post_title;

if ($view == 'profile') {
    do_following($user->id);
    $main_smarty->assign('view_href', '');
    $main_smarty->assign('nav_pd', 4);
    // display the template
    $main_smarty->assign('tpl_center', $the_template.'/user_profile_center');
    $main_smarty->display($the_template.'/pligg.tpl');
} else {
    $main_smarty->assign('nav_pd', 3);
}

    if ($view == 'voted') {
        $page_header .= $main_smarty->get_config_vars('PLIGG_Visual_User_NewsVoted');
        $navwhere['text3'] = $main_smarty->get_config_vars('PLIGG_Visual_User_NewsVoted');
        $post_title .= " | ".$main_smarty->get_config_vars('PLIGG_Visual_User_NewsVoted');
        $main_smarty->assign('view_href', 'voted');
        $main_smarty->assign('nav_nv', 4);
    } else {
        $main_smarty->assign('nav_nv', 3);
    }

    if ($view == 'upvoted') {
        $page_header .= $main_smarty->get_config_vars('PLIGG_Visual_UpVoted');
        $navwhere['text3'] = $main_smarty->get_config_vars('PLIGG_Visual_UpVoted');
        $post_title .= " | ".$main_smarty->get_config_vars('PLIGG_Visual_UpVoted');
        $main_smarty->assign('view_href', 'upvoted');
        $main_smarty->assign('nav_nv', 4);
    } else {
        $main_smarty->assign('nav_nv', 3);
    }

    if ($view == 'downvoted') {
        $page_header .= $main_smarty->get_config_vars('PLIGG_Visual_DownVoted');
        $navwhere['text3'] = $main_smarty->get_config_vars('PLIGG_Visual_DownVoted');
        $post_title .= " | ".$main_smarty->get_config_vars('PLIGG_Visual_DownVoted');
        $main_smarty->assign('view_href', 'downvoted');
        $main_smarty->assign('nav_nv', 4);
    } else {
        $main_smarty->assign('nav_nv', 3);
    }


    if ($view == 'history') {
        $page_header .= $main_smarty->get_config_vars('PLIGG_Visual_User_NewsSent');
        $navwhere['text3'] = $main_smarty->get_config_vars('PLIGG_Visual_User_NewsSent');
        $post_title .= " | ".$main_smarty->get_config_vars('PLIGG_Visual_User_NewsSent');
        $main_smarty->assign('view_href', 'submitted');
        $main_smarty->assign('nav_ns', 4);
    } else {
        $main_smarty->assign('nav_ns', 3);
    }

    if ($view == 'setting') {
        $usercategorysql = "SELECT * FROM ".table_users." where user_login = '".$db->escape($login)."' ";
        $userresults = $db->get_results($usercategorysql);
        $userresults = object_2_array($userresults);
        $get_categories = $userresults['0']['user_categories'];
        $user_categories = explode(",", $get_categories);

        $categorysql = "SELECT * FROM ".table_categories." where category__auto_id!='0' ";
        $results = $db->get_results($categorysql);
        $results = object_2_array($results);
        $category = array();
        foreach ($results as $key => $val) {
            $category[] = $val['category_name'];
        }
        $sor = $_GET['err'];
        if ($sor == 1) {
            $err = "You have to select at least 1 category";
            $main_smarty->assign('err', $err);
        }

        $main_smarty->assign('category', $results);
        $main_smarty->assign('user_category', $user_categories);
        $main_smarty->assign('view_href', 'submitted');

        if (Allow_User_Change_Templates) {
            $dir = "templates";
            $templates = array();
            foreach (scandir($dir) as $file) {
                if (strstr($file, ".") !== 0 && file_exists("$dir/$file/header.tpl")) {
                    $templates[] = $file;
                }
            }
            $main_smarty->assign('templates', $templates);
            $main_smarty->assign('current_template', sanitize($_COOKIE['template'], 3));
            $main_smarty->assign('Allow_User_Change_Templates', Allow_User_Change_Templates);
        }
        $main_smarty->assign('nav_set', 4);
    } else {
        $main_smarty->assign('nav_set', 3);
    }

    if ($view == 'published') {
        $page_header .= $main_smarty->get_config_vars('PLIGG_Visual_User_NewsPublished');
        $navwhere['text3'] = $main_smarty->get_config_vars('PLIGG_Visual_User_NewsPublished');
        $post_title .= " | ".$main_smarty->get_config_vars('PLIGG_Visual_User_NewsPublished');
        $main_smarty->assign('view_href', 'published');
        $main_smarty->assign('nav_np', 4);
    } else {
        $main_smarty->assign('nav_np', 3);
    }

    if ($view == 'new') {
        $page_header .= $main_smarty->get_config_vars('PLIGG_Visual_User_NewsUnPublished');
        $navwhere['text3'] = $main_smarty->get_config_vars('PLIGG_Visual_User_NewsUnPublished');
        $post_title .= " | ".$main_smarty->get_config_vars('PLIGG_Visual_User_NewsUnPublished');
        $main_smarty->assign('view_href', 'new');
        $main_smarty->assign('nav_nu', 4);
    } else {
        $main_smarty->assign('nav_nu', 3);
    }

    if ($view == 'commented') {
        $page_header .= $main_smarty->get_config_vars('PLIGG_Visual_User_NewsCommented');
        $navwhere['text3'] = $main_smarty->get_config_vars('PLIGG_Visual_User_NewsCommented');
        $post_title .= " | ".$main_smarty->get_config_vars('PLIGG_Visual_User_NewsCommented');
        $main_smarty->assign('view_href', 'commented');
        $main_smarty->assign('nav_c', 4);
    } else {
        $main_smarty->assign('nav_c', 3);
    }

    if ($view == 'saved') {
        $page_header .= $main_smarty->get_config_vars('PLIGG_Visual_User_NewsSaved');
        $navwhere['text3'] = $main_smarty->get_config_vars('PLIGG_Visual_User_NewsSaved');
        $post_title .= " | ".$main_smarty->get_config_vars('PLIGG_Visual_User_NewsSaved');
        $main_smarty->assign('view_href', 'saved');
        $main_smarty->assign('nav_s', 4);
    } else {
        $main_smarty->assign('nav_s', 3);
    }

    if ($view == 'following') {
        $page_header .= $main_smarty->get_config_vars('PLIGG_Visual_User_Profile_View_Friends');
        $navwhere['text3'] = $main_smarty->get_config_vars('PLIGG_Visual_User_Profile_View_Friends');
        $post_title .= " | ".$main_smarty->get_config_vars('PLIGG_Visual_User_Profile_View_Friends');
    }

    if ($view == 'followers') {
        $page_header .= $main_smarty->get_config_vars('PLIGG_Visual_User_Profile_Your_Friends');
        $navwhere['text3'] = $main_smarty->get_config_vars('PLIGG_Visual_User_Profile_Your_Friends');
        $post_title .= " | ".$main_smarty->get_config_vars('PLIGG_Visual_User_Profile_Viewing_Friends_2');
    }

    if ($view == 'removefriend') {
        $page_header .= $main_smarty->get_config_vars('PLIGG_Visual_User_Profile_Removing_Friend');
        $navwhere['text3'] = $main_smarty->get_config_vars('PLIGG_Visual_User_Profile_Removing_Friend');
        $post_title .= " | ".$main_smarty->get_config_vars('PLIGG_Visual_User_Profile_Removing_Friend');
    }

    if ($view == 'addfriend') {
        $page_header .= $main_smarty->get_config_vars('PLIGG_Visual_User_Profile_Adding_Friend');
        $navwhere['text3'] = $main_smarty->get_config_vars('PLIGG_Visual_User_Profile_Adding_Friend');
        $post_title .= " | ".$main_smarty->get_config_vars('PLIGG_Visual_User_Profile_Adding_Friend');
    }

    if ($view == 'member_groups') {
        $main_smarty->assign('view_href', '');
        $main_smarty->assign('nav_mg', 4);
    } else {
        $main_smarty->assign('nav_mg', 3);
    }
}
$main_smarty->assign('page_header', $page_header);
$main_smarty->assign('username', $username);
$main_smarty->assign('posttitle', $post_title);


// Breadcrumb and Title Text
$main_smarty->assign('navbar_where', $navwhere);

// a hook
$vars = '';
check_actions('user_post_views', $vars);

// auto scrolling
if (Auto_scroll == 2 || Auto_scroll == 3) {
    $main_smarty->assign("scrollpageSize", $page_size);
    $main_smarty->assign('curuserid', $current_user->user_id);
    $main_smarty->assign('userid', $user->id);
    $main_smarty->assign('viewtype', $view);
}

// determine which user page to display
global $db, $main_smarty, $view, $user, $rows, $page_size, $offset;
$the_page = 'profile';
switch ($view) {

    case 'history':
        do_history();
        if (Auto_scroll == 2 || Auto_scroll == 3) {
            $main_smarty->assign('total_row', $rows);
        } else {
            $main_smarty->assign('user_pagination', do_pages($rows, $page_size, $the_page, true));
        }
        // display the template
        $main_smarty->assign('tpl_center', $the_template.'/user_history_center');
        $main_smarty->display($the_template.'/pligg.tpl');
        break;

    case 'published':
        do_published();
        if (Auto_scroll == 2 || Auto_scroll == 3) {
            $main_smarty->assign('total_row', $rows);
        } else {
            $main_smarty->assign('user_pagination', do_pages($rows, $page_size, $the_page, true));
        }
        // display the template
        $main_smarty->assign('tpl_center', $the_template.'/user_history_center');
        $main_smarty->display($the_template.'/pligg.tpl');
        break;

    case 'new':
        do_new();
        if (Auto_scroll == 2 || Auto_scroll == 3) {
            $main_smarty->assign('total_row', $rows);
        } else {
            $main_smarty->assign('user_pagination', do_pages($rows, $page_size, $the_page, true));
        }
        // display the template
        $main_smarty->assign('tpl_center', $the_template.'/user_history_center');
        $main_smarty->display($the_template.'/pligg.tpl');
        break;

    case 'commented':
        do_commented();
        if (Auto_scroll == 2 || Auto_scroll == 3) {
            $main_smarty->assign('total_row', $rows);
        } else {
            $main_smarty->assign('user_pagination', do_pages($rows, $page_size, $the_page, true));
        }
        // display the template
        $main_smarty->assign('tpl_center', $the_template.'/user_history_center');
        $main_smarty->display($the_template.'/pligg.tpl');
        break;

    case 'voted':
        do_voted();
        if (Auto_scroll == 2 || Auto_scroll == 3) {
            $main_smarty->assign('total_row', $rows);
        } else {
            $main_smarty->assign('user_pagination', do_pages($rows, $page_size, $the_page, true));
        }
        // display the template
        $main_smarty->assign('tpl_center', $the_template.'/user_history_center');
        $main_smarty->display($the_template.'/pligg.tpl');
        break;

    case 'upvoted':
        do_updownvoted('up');
        if (Auto_scroll == 2 || Auto_scroll == 3) {
            $main_smarty->assign('total_row', $rows);
        } else {
            $main_smarty->assign('user_pagination', do_pages($rows, $page_size, $the_page, true));
        }
        // display the template
        $main_smarty->assign('tpl_center', $the_template.'/user_history_center');
        $main_smarty->display($the_template.'/pligg.tpl');
        break;

    case 'downvoted':
        do_updownvoted('dwn');
        if (Auto_scroll == 2 || Auto_scroll == 3) {
            $main_smarty->assign('total_row', $rows);
        } else {
            $main_smarty->assign('user_pagination', do_pages($rows, $page_size, $the_page, true));
        }
        // display the template
        $main_smarty->assign('tpl_center', $the_template.'/user_history_center');
        $main_smarty->display($the_template.'/pligg.tpl');
        break;

    case 'saved':
        do_stories();
        if (Auto_scroll == 2 || Auto_scroll == 3) {
            $main_smarty->assign('total_row', $rows);
        } else {
            $main_smarty->assign('user_pagination', do_pages($rows, $page_size, $the_page, true));
        }
        // display the template
        $main_smarty->assign('tpl_center', $the_template.'/user_history_center');
        $main_smarty->display($the_template.'/pligg.tpl');
        break;

    case 'removefriend':
        do_removefriend();
        // display the template
        $main_smarty->assign('tpl_center', $the_template.'/user_follow_center');
        $main_smarty->display($the_template.'/pligg.tpl');
        break;

    case 'addfriend':
        do_addfriend();
        // display the template
        $main_smarty->assign('tpl_center', $the_template.'/user_follow_center');
        $main_smarty->display($the_template.'/pligg.tpl');
        break;

    case 'following':
        do_following($user->id);
        // display the template
        $main_smarty->assign('tpl_center', $the_template.'/user_follow_center');
        $main_smarty->display($the_template.'/pligg.tpl');
        break;

    case 'followers':
        do_followers($user->id);
        // display the template
        $main_smarty->assign('tpl_center', $the_template.'/user_follow_center');
        $main_smarty->display($the_template.'/pligg.tpl');
        break;

    case 'sendmessage':
        do_sendmessage();
        // display the template
        $main_smarty->assign('tpl_center', $the_template.'/user_follow_center');
        $main_smarty->display($the_template.'/pligg.tpl');
        break;

    case 'member_groups':
        do_member_groups();
        //$main_smarty->assign('user_pagination', do_pages($rows, $page_size, $the_page, true));
        // display the template
        $main_smarty->assign('tpl_center', $the_template.'/user_history_center');
        $main_smarty->display($the_template.'/pligg.tpl');
        break;

}

do_following($user->id);
do_followers($user->id);

function do_stories()
{
    global $db, $main_smarty, $rows, $user, $offset, $page_size,$current_user,$cached_links;
    //if ($current_user->user_id == $user->id)
    //{
    $output = '';
    $link = new Link;
    $rows = $db->get_var("SELECT count(*) FROM ".table_saved_links." WHERE saved_user_id=$user->id");

    $fieldexists = checkforfield('saved_privacy', table_saved_links);
    if ($fieldexists) {
        if ($current_user->user_id == $user->id) {
            $links = $db->get_results("SELECT * FROM ".table_saved_links."
							LEFT JOIN ".table_links." ON saved_link_id=link_id
							WHERE saved_user_id=$user->id ORDER BY saved_link_id DESC LIMIT $offset,$page_size");
        } else {
            $links = $db->get_results("SELECT * FROM ".table_saved_links."
							LEFT JOIN ".table_links." ON saved_link_id=link_id
							WHERE saved_user_id=$user->id and saved_privacy = 'public' ORDER BY saved_link_id DESC LIMIT $offset,$page_size");
        }
    } else {
        $links = $db->get_results("SELECT * FROM ".table_saved_links."
						LEFT JOIN ".table_links." ON saved_link_id=link_id
						WHERE saved_user_id=$user->id ORDER BY saved_link_id DESC LIMIT $offset,$page_size");
    }
    if ($links) {
        foreach ($links as $dblink) {
            $link->id = $dblink->link_id;
            $cached_links[$dblink->link_id] = $dblink;
            $link->read();
                //$output.= $current_user->user_id."<br/>";
                //$output.= $user->id."<br/>";
            $output .= $link->print_summary('summary', true);
        }
    }
    $main_smarty->assign('user_page', $output);
}

function do_voted()
{
    global $db, $main_smarty, $rows, $user, $offset, $page_size,$cached_links;

    $output = '';
    $link = new Link;
    $rows = $db->get_var("SELECT count(*) FROM ".table_links.", ".table_votes." WHERE vote_user_id=$user->id AND vote_link_id=link_id AND vote_value > 0 AND (link_status='published' OR link_status='new')");
    $links = $db->get_results($sql = "SELECT DISTINCT * FROM ".table_links.", ".table_votes." WHERE vote_user_id=$user->id AND vote_link_id=link_id AND vote_value > 0  AND (link_status='published' OR link_status='new') ORDER BY link_date DESC LIMIT $offset, $page_size");

    if ($links) {
        foreach ($links as $dblink) {
            $link->id = $dblink->link_id;
            $cached_links[$dblink->link_id] = $dblink;
            $link->read();
            $link->rating = $dblink->vote_value/2;
            $output .= $link->print_summary('summary', true);
        }
    }
    $main_smarty->assign('user_page', $output);
}
function do_updownvoted($status = null)
{
    global $db, $main_smarty, $rows, $user, $offset, $page_size, $cached_links;

    $output = '';
    $link = new Link;

    if ($status == 'up') {
        $vote_stats = " > 0";
        $order = "DESC";
    } else {
        $vote_stats = " < 0";
        $order = "ASC";
    }

    $rows = $db->get_var("SELECT count(*) FROM ".table_links.", ".table_votes." WHERE vote_user_id=$user->id AND vote_link_id=link_id AND vote_value ".$vote_stats." AND (link_status='published' OR link_status='new') AND vote_type='links'");
    $links = $db->get_results($sql = "SELECT DISTINCT * FROM ".table_links.", ".table_votes." WHERE vote_user_id=$user->id AND vote_link_id=link_id AND vote_value ".$vote_stats."  AND (link_status='published' OR link_status='new') AND vote_type='links' ORDER BY link_votes ".$order." LIMIT $offset, $page_size");

    if ($links) {
        foreach ($links as $dblink) {
            $link->id = $dblink->link_id;
            $cached_links[$dblink->link_id] = $dblink;
            $link->read();
            $link->rating = $dblink->vote_value/2;
            $output .= $link->print_summary('summary', true);
        }
    }
    $main_smarty->assign('user_page', $output);
}

function do_history()
{
    global $db, $main_smarty, $rows, $user, $offset, $page_size,$cached_links;
    $output = '';
    $link = new Link;
    $rows = $db->get_var("SELECT count(*) FROM ".table_links." WHERE link_author=$user->id AND (link_status='published' OR link_status='new')");
    $links = $db->get_results("SELECT * FROM ".table_links." WHERE link_author=$user->id AND (link_status='published' OR link_status='new') ORDER BY link_date DESC LIMIT $offset,$page_size");
    if ($links) {
        foreach ($links as $dblink) {
            $link->id = $dblink->link_id;
            $cached_links[$dblink->link_id] = $dblink;
            $link->read();
            $output .= $link->print_summary('summary', true);
        }
    }
    $main_smarty->assign('user_page', $output);
}

function do_published()
{
    global $db, $main_smarty, $rows, $user, $offset, $page_size,$cached_links;
    $output = '';
    $link = new Link;
    $rows = $db->get_var("SELECT count(*) FROM ".table_links." WHERE link_author=$user->id AND link_status='published'");
    $links = $db->get_results("SELECT * FROM ".table_links." WHERE link_author=$user->id AND link_status='published'  ORDER BY link_published_date DESC, link_date DESC LIMIT $offset,$page_size");
    if ($links) {
        foreach ($links as $dblink) {
            $link->id = $dblink->link_id;
            $cached_links[$dblink->link_id] = $dblink;
            $link->read();
            $output .= $link->print_summary('summary', true);
        }
    }
    $main_smarty->assign('user_page', $output);
}

function do_new()
{
    global $db, $main_smarty, $rows, $user, $offset, $page_size,$cached_links;
    $output = '';
    $link = new Link;
    $rows = $db->get_var("SELECT count(*) FROM ".table_links." WHERE link_author=$user->id AND link_status='new'");
    $links = $db->get_results("SELECT * FROM ".table_links." WHERE link_author=$user->id AND link_status='new' ORDER BY link_date DESC LIMIT $offset,$page_size");
    if ($links) {
        foreach ($links as $dblink) {
            $link->id = $dblink->link_id;
            $cached_links[$dblink->link_id] = $dblink;
            $link->read();
            $output .= $link->print_summary('summary', true);
        }
    }
    $main_smarty->assign('user_page', $output);
}

function do_commented()
{
    global $db, $main_smarty, $rows, $user, $offset, $page_size, $cached_links, $the_template;
    $output = '';

    $link = new Link;
    $comment = new Comment;

    $rows = $db->get_var("SELECT count(*) FROM ".table_links.", ".table_comments." WHERE comment_status='published' AND comment_user_id=$user->id AND comment_link_id=link_id");
    $links = $db->get_results("SELECT DISTINCT * FROM ".table_links.", ".table_comments." WHERE comment_status='published' AND comment_user_id=$user->id AND comment_link_id=link_id AND (link_status='published' OR link_status='new')  ORDER BY link_date DESC LIMIT $offset,$page_size");
    if ($links) {
        foreach ($links as $dblink) {
            $link->id = $dblink->link_id;
            $cached_links[$dblink->link_id] = $dblink;
            $link->read();
            $link->fill_smarty($main_smarty);

            $comment->id = $dblink->comment_id;
            $comment->read();
            $comment->fill_smarty($main_smarty);

            $output .= $main_smarty->fetch($the_template.'/'.'user_comment_center.tpl');
        }
    }
    $main_smarty->assign('user_page', $output);
}

function do_removefriend()
{
    global $db, $main_smarty, $user, $the_template;
    $friend = new Friend;
    $friend->remove($user->id);
}

function do_addfriend()
{
    global $db, $main_smarty, $user, $the_template;
    $friend = new Friend;
    $friend->add($user->id);
}

function do_following($user_id)
{
    global $db, $main_smarty, $user, $the_template;
    $friend = new Friend;
    $friends = $friend->get_friend_list($user_id);

    $main_smarty->assign('the_template', $the_template);
    $main_smarty->assign('following', $friends);
}

function do_followers($user_id)
{
    global $db, $main_smarty, $user, $the_template;
    $friend = new Friend;
    $friends = $friend->get_friend_list_2($user_id);

    $main_smarty->assign('the_template', $the_template);
    $main_smarty->assign('follower', $friends);
}
function do_member_groups()
{
    global $db, $main_smarty, $rows, $user, $offset, $page_size;
    //print_r(get_groupid_user($user->id));
    $ids  = get_groupid_user($user->id);
    if ($ids) {
        foreach ($ids as $groupid) {
            //print_r($groupid);
            //echo $groupid->group_id;
            $output .= group_print_summary($groupid->group_id);
            $main_smarty->assign('user_page', $output);
        }
    }
}