$sql = "SELECT BID, UID, title, content, total_views, total_comments, addtime\n FROM blog WHERE UID = " . $uid . " AND status = '1'\n ORDER BY addtime DESC LIMIT 1"; $rs = $conn->execute($sql); if ($conn->Affected_Rows() == 1) { $blog = $rs->getrows(); $blog = $blog['0']; } $sql = "UPDATE signup SET profile_viewed = profile_viewed+1, popularity = popularity+0.1 WHERE UID = " . $uid . " LIMIT 1"; $conn->execute($sql); $self_title = $username . '\' Profile - Free Adult Sex Tube Porno'; $smarty->assign('friends', $friends); $smarty->assign('playlist', $playlist); $smarty->assign('favorites', $favorites); $smarty->assign('subscriptions', $subscriptions); $smarty->assign('subscribers', $subscribers); $smarty->assign('videos_public', get_user_videos($uid)); $smarty->assign('videos_private', get_user_videos($uid, 'private')); $smarty->assign('show_wall', $show_wall); $smarty->assign('walls', $walls); $smarty->assign('walls_total', $walls_total); $smarty->assign('albums', $albums); $smarty->assign('blog', $blog); $smarty->assign('photos', $photos); $smarty->assign('games', $games); } } $self_title = isset($self_title) ? $self_title . ' - ' . $config['site_name'] : $config['site_name']; $smarty->assign('errors', $errors); $smarty->assign('messages', $messages); $smarty->assign('menu', 'community'); $smarty->assign('submenu', ''); $smarty->assign('username', $username);
$sql = "SELECT BID, UID, title, content, total_views, total_comments, addtime\n FROM blog WHERE UID = " . $uid . " AND status = '1'\n ORDER BY addtime DESC LIMIT 1"; $rs = $conn->execute($sql); if ($conn->Affected_Rows() == 1) { $blog = $rs->getrows(); $blog = $blog['0']; $blog['content'] = blog_output($blog['content']); } $sql = "UPDATE signup SET profile_viewed = profile_viewed+1, popularity = popularity+0.1 WHERE UID = " . $uid . " LIMIT 1"; $conn->execute($sql); $self_title = $username . '\' Profile - Free Adult Sex Tube Porno'; $smarty->assign('friends', $friends); $smarty->assign('playlist', $playlist); $smarty->assign('favorites', $favorites); $smarty->assign('subscriptions', $subscriptions); $smarty->assign('subscribers', $subscribers); $smarty->assign('videos', get_user_videos($uid)); $smarty->assign('games', get_user_games($uid)); $smarty->assign('show_wall', $show_wall); $smarty->assign('walls', $walls); $smarty->assign('walls_total', $walls_total); $smarty->assign('albums', $albums); $smarty->assign('blog', $blog); $smarty->assign('photos', $photos); $smarty->assign('favorite_games', $favorite_games); } } $self_title = isset($self_title) ? $self_title . ' - ' . $config['site_name'] : $config['site_name']; $smarty->assign('errors', $errors); $smarty->assign('err', $err); $smarty->assign('messages', $messages); $smarty->assign('menu', 'community');