$sql_add .= ' ORDER BY fav_num DESC'; break; case 'lg': $title_o = ' ' . $lang['global.longest']; $sql_add .= ' ORDER BY duration DESC'; break; } $sql = "SELECT count(VID) AS total_videos FROM video" . $sql_add_count; $rsc = $conn->execute($sql); $total = $rsc->fields['total_videos']; $pagination = new Pagination($config['videos_per_page']); $limit = $pagination->getLimit($total); $sql = "SELECT * FROM video" . $sql_add . " LIMIT " . $limit; $rs = $conn->execute($sql); $videos = $rs->getrows(); $page_link = $pagination->getPagination('videos'); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $title = $title_t . $title_o . $title_c . $title_p; $self_title = $title . $seo['videos_title']; $self_description = $title . $seo['videos_desc']; $self_keywords = $title . $seo['videos_keywords']; $smarty->assign('errors', $errors); $smarty->assign('messages', $messages); $smarty->assign('menu', 'videos'); $smarty->assign('categories', $categories); $smarty->assign('type', $type); $smarty->assign('videos', $videos); $smarty->assign('videos_total', $total); $smarty->assign('start_num', $start_num); $smarty->assign('end_num', $end_num);
break; case 'mv': $sql_add .= " ORDER BY s.profile_viewed DESC"; break; case 'on': $sql_add .= " ORDER BY s.logintime DESC"; break; case 'ma': $sql_add .= " ORDER BY s.video_viewed+s.profile_viewed+s.watched_video DESC"; break; } $sql = "SELECT COUNT(s.UID) AS total_users FROM signup AS s, users_online AS o\n WHERE s.account_status = 'Active' AND s.UID = o.UID" . $sql_add_count; $rsc = $conn->execute($sql); $total_users = $rsc->fields['total_users']; $pagination = new Pagination($config['users_per_page']); $limit = $pagination->getLimit($total_users); $sql = "SELECT s.UID, s.username, s.photo, s.gender FROM signup AS s, users_online AS o\n WHERE s.account_status = 'Active' AND s.UID = o.UID" . $sql_add . " LIMIT " . $limit; $rs = $conn->execute($sql); $users = $rs->getrows(); $page_link = $pagination->getPagination('search'); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $smarty->assign('users', $users); $smarty->assign('users_total', $total_users); $smarty->assign('page_link', $page_link); $smarty->assign('start_num', $start_num); $smarty->assign('end_num', $end_num); $smarty->assign('order', $order); $smarty->assign('gender', $gender); $smarty->assign('interest', $interest); $smarty->assign('avatar', $avatar);
require $config['BASE_DIR'] . '/include/dbconn.php'; require_once $config['BASE_DIR'] . '/include/function_thumbs.php'; $data = array('status' => 0, 'msg' => '', 'code' => '', 'debug' => ''); if (isset($_POST['page'])) { if (isset($_SESSION['uid'])) { $uid = intval($_SESSION['uid']); $page = intval(trim($_POST['page'])); $sql = "SELECT count(VID) AS total_videos FROM video WHERE UID = " . $uid; $rs = $conn->execute($sql); $total = $rs->fields['total_videos']; $pagination = new Pagination(8, $page); $limit = $pagination->getLimit($total); $sql = "SELECT VID, title FROM video WHERE UID = " . $uid . "\n\t\t\t\t\t\t AND embed_code = ''\n\t\t ORDER BY VID DESC LIMIT " . $limit; $rs = $conn->execute($sql); $videos = $rs->getrows(); $page_link = $pagination->getPagination('media_content', 'p_mc_my_videos_'); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $code = array(); $code[] = '<div class="m-b-15">'; $code[] = '<a href="#attach_playlist_videos" id="attach_mcp_playlist_videos">' . $lang['user.playlist'] . '</a> <strong>·</strong>'; $code[] = '<a href="#attach_favorite_videos" id="attach_mcp_favorite_videos">' . $lang['user.favorites'] . '</a> <strong>·</strong>'; $code[] = '<span class="text-white">' . $lang['ajax.my_videos'] . '</span>'; $code[] = '<button id="close_attach_mc_mv" type="button" class="close">×</button>'; $code[] = '</div>'; if ($videos) { $code[] = '<div class="m-b--15">'; $code[] = '<div class="row">'; foreach ($videos as $video) { $code[] = '<div class="col-xs-6 col-sm-3 m-b-15">'; $code[] = '<a href="#attach_my_video_' . $video['VID'] . '" id="attach_media_video_' . $video['VID'] . '"><img src="' . get_thumb_url($video['VID']) . '/1.jpg" alt="' . htmlspecialchars($video['title'], ENT_QUOTES, 'UTF-8') . '" class="img-responsive" /></a>';
} $pagination = new Pagination(10, 'p_related_games_' . $game['GID'] . '_'); $limit = $pagination->getLimit($total_related); $sql = "SELECT GID, title, addtime, rate, total_plays, type FROM game\n WHERE status = '1' AND category = '" . $game['category'] . "' AND GID != " . $gid . "\n AND ( title LIKE '%" . mysql_real_escape_string($game['title']) . "%' " . $sql_add . ")\n ORDER BY addtime DESC LIMIT " . $limit; $rs = $conn->execute($sql); $games = $rs->getrows(); $page_link = $pagination->getPagination('game'); $sql = "SELECT COUNT(CID) AS total_comments FROM game_comments WHERE GID = " . $gid . " AND status = '1'"; $rsc = $conn->execute($sql); $total_comments = $rsc->fields['total_comments']; $pagination = new Pagination(10); $limit = $pagination->getLimit($total_comments); $sql = "SELECT c.CID, c.UID, c.comment, c.addtime, s.username, s.photo, s.gender\n FROM game_comments AS c, signup AS s \n WHERE c.GID = " . $gid . " AND c.status = '1' AND c.UID = s.UID \n ORDER BY c.addtime DESC LIMIT " . $limit; $rs = $conn->execute($sql); $comments = $rs->getrows(); $page_link_c = $pagination->getPagination('game', 'p_game_comments_' . $game['GID'] . '_'); $page_link_cb = $pagination->getPagination('game', 'pp_game_comments_' . $game['GID'] . '_'); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $self_title = $game['title'] . $seo['game_title']; $self_description = $game['title'] . $seo['game_desc']; $self_keywords = implode(', ', $game['tags']) . $seo['game_keywords']; $smarty->assign('errors', $errors); $smarty->assign('messages', $messages); $smarty->assign('menu', 'games'); $smarty->assign('submenu', ''); $smarty->assign('play', true); $smarty->assign('game', $game); $smarty->assign('self_title', $self_title); $smarty->assign('self_description', $self_description); $smarty->assign('self_keywords', $self_keywords);
require $config['BASE_DIR'] . '/classes/pagination.class.php'; require $config['BASE_DIR'] . '/include/dbconn.php'; $data = array('status' => 0, 'msg' => '', 'code' => '', 'debug' => ''); if (isset($_POST['page'])) { if (isset($_SESSION['uid'])) { $uid = intval($_SESSION['uid']); $page = intval(trim($_POST['page'])); $sql = "SELECT COUNT(PID) AS total_photos FROM photo_favorites\n WHERE UID = " . $uid; $rs = $conn->execute($sql); $total = $rs->fields['total_photos']; $pagination = new Pagination(8, $page); $limit = $pagination->getLimit($total); $sql = "SELECT p.PID, p.caption FROM photos AS p, photo_favorites AS f \n WHERE f.UID = " . $uid . " AND p.PID = f.PID ORDER BY p.PID DESC LIMIT " . $limit; $rs = $conn->execute($sql); $photos = $rs->getrows(); $page_link = $pagination->getPagination('media_content', 'p_mc_favorite_photos_'); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $code = array(); $code[] = '<div class="m-b-15">'; $code[] = '<span class="text-white">' . $lang['user.favorites'] . '</span> <strong>·</strong>'; $code[] = '<a href="#attach_my_photos" id="attach_mcp_my_photos">' . $lang['ajax.my_photos'] . '</a>'; $code[] = '<button id="close_attach_mc_fp" type="button" class="close">×</button>'; $code[] = '</div>'; if ($photos) { $index = 0; $code[] = '<div class="m-b--15">'; $code[] = '<div class="row">'; foreach ($photos as $photo) { if ($index == 4) { $code[] = '</div><div class="row">';
require $config['BASE_DIR'] . '/include/dbconn.php'; $code = array(); if (isset($_POST['game_id']) && isset($_POST['page'])) { $filter = new VFilter(); $gid = $filter->get('game_id', 'INTEGER'); $page = $filter->get('page', 'INTEGER'); $uid = isset($_SESSION['uid']) ? intval($_SESSION['uid']) : NULL; $sql = "SELECT COUNT(CID) AS total_comments FROM game_comments WHERE GID = " . $gid . " AND status = '1'"; $rsc = $conn->execute($sql); $total = $rsc->fields['total_comments']; $pagination = new Pagination(10, $page); $limit = $pagination->getLimit($total); $sql = "SELECT c.CID, c.UID, c.comment, c.addtime, s.username, s.photo, s.gender\n FROM game_comments AS c, signup AS s\n WHERE c.GID = " . $gid . " AND c.status = '1' AND c.UID = s.UID \n ORDER BY c.addtime DESC LIMIT " . $limit; $rs = $conn->execute($sql); $comments = $rs->getrows(); $page_link = $pagination->getPagination('game/' . $gid, 'p_game_comments_' . $gid . '_'); $page_link_b = $pagination->getPagination('game/' . $gid, 'pp_game_comments_' . $gid . '_'); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $code[] = '<div class="blinkp">'; $code[] = $lang['global.showing'] . ' <strong>' . $start_num . '</strong> ' . $lang['global.to'] . ' <strong>' . $end_num . '</strong> ' . $lang['global.of'] . ' <strong>' . $total . '</strong> ' . $lang['global.comments'] . '.'; $code[] = '</div>'; if ($comments) { $code[] = '<div id="comments_delimiter" style="display:none;"></div>'; foreach ($comments as $comment) { $photo = $comment['photo'] == '' ? 'nopic-' . $comment['gender'] . '.gif' : $comment['photo']; $username = $comment['username']; $code[] = '<div id="game_comment_' . $gid . '_' . $comment['CID'] . '" class="col-xs-12 m-t-15">'; $code[] = '<div class="row">'; $code[] = '<div class="pull-left">'; $code[] = '<a href="' . $config['BASE_URL'] . '/user/' . $username . '">';
if ($conn->Affected_Rows() != 1) { VRedirect::go($config['BASE_URL'] . '/error/invalid_notice'); } $notice = $rs->getrows(); $notice = $notice['0']; $sql = "UPDATE notice SET total_views = total_views+1 WHERE NID = " . $NID . " LIMIT 1"; $conn->execute($sql); $sql = "SELECT COUNT(CID) AS total_comments FROM notice_comments WHERE NID = " . $NID . " AND status = '1'"; $rsc = $conn->execute($sql); $total = $rsc->fields['total_comments']; $pagination = new Pagination(10); $limit = $pagination->getLimit($total); $sql = "SELECT c.CID, c.UID, c.comment, c.addtime, s.username, s.photo, s.gender\n FROM notice_comments AS c, signup AS s \n WHERE c.NID = " . $NID . " AND c.status = '1' AND c.UID = s.UID\n ORDER BY c.addtime DESC LIMIT " . $limit; $rs = $conn->execute($sql); $comments = $rs->getrows(); $page_link = $pagination->getPagination('notice/' . $NID, 'p_notice_comments_' . $NID . '_'); $page_link_b = $pagination->getPagination('notice/' . $NID, 'pp_notice_comments_' . $NID . '_'); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $smarty->assign('errors', $errors); $smarty->assign('messages', $messages); $smarty->assign('menu', 'home'); $smarty->assign('notice_js', true); $smarty->assign('notice', $notice); $smarty->assign('comments', $comments); $smarty->assign('comments_total', $total); $smarty->assign('page_link', $page_link); $smarty->assign('page_link_b', $page_link_b); $smarty->assign('start_num', $start_num); $smarty->assign('end_num', $end_num); $smarty->assign('arhive', get_notice_arhive());
$auth->check(); $uid = intval($_SESSION['uid']); $username = $_SESSION['username']; $sql = "SELECT * FROM signup WHERE UID = " . $uid . " LIMIT 1"; $rs = $conn->execute($sql); $user = $rs->getrows(); $user = $user['0']; $sql = "SELECT COUNT(FID) AS total_requests FROM friends WHERE UID = " . $uid . " AND status = 'Pending'"; $rsc = $conn->execute($sql); $total = $rsc->fields['total_requests']; $pagination = new Pagination(16); $limit = $pagination->getLimit($total); $sql = "SELECT r.FID, r.message, s.username, s.photo, s.gender \n FROM friends AS r, signup AS s\n WHERE r.UID = " . $uid . " AND r.status = 'Pending' AND r.FID = s.UID\n ORDER BY r.invite_date DESC LIMIT " . $limit; $rs = $conn->execute($sql); $requests = $rs->getrows(); $page_link = $pagination->getPagination('requests'); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $smarty->assign('errors', $errors); $smarty->assign('messages', $messages); $smarty->assign('profile', true); $smarty->assign('menu', 'home'); $smarty->assign('user', $user); $smarty->assign('username', $username); $smarty->assign('requests', $requests); $smarty->assign('requests_total', $total); $smarty->assign('page_link', $page_link); $smarty->assign('start_num', $start_num); $smarty->assign('end_num', $end_num); $smarty->display('header.tpl'); $smarty->display('errors.tpl');
if ($table == 'all') { function compare_time($a, $b) { $a_time = intval($a['time']); $b_time = intval($b['time']); if ($a_time === $b_time) { return 0; } return $a_time < $b_time ? 1 : -1; } usort($feeds, 'compare_time'); } if ($subscriptions) { $pagination = new Pagination(40); $limit = $pagination->getLimit($total_feeds); $page_link = $pagination->getPagination('feeds'); } $self_title = $config['site_title']; $self_meta_description = $config['meta_description']; $self_meta_keywords = $config['meta_keywords']; $smarty->assign('subscriptions', $subscriptions); $smarty->assign('username', $username); $smarty->assign('table', $table); $smarty->assign('feeds', $feeds); $smarty->assign('page_link', $page_link); $smarty->assign('self_title', $self_title); $smarty->assign('self_meta_description', $self_meta_description); $smarty->assign('self_meta_keywords', $self_meta_keywords); $smarty->display('header.tpl'); $smarty->display('errors.tpl'); $smarty->display('messages.tpl');
<?php defined('_VALID') or die('Restricted Access!'); require $config['BASE_DIR'] . '/classes/pagination.class.php'; if ($config['game_module'] == '0') { VRedirect::go($config['BASE_URL'] . '/error/page_invalid'); } $sql = "SELECT COUNT(GID) AS total_games FROM game WHERE UID = " . $uid . " AND status = '1'"; $rsc = $conn->execute($sql); $total = $rsc->fields['total_games']; $pagination = new Pagination(18); $limit = $pagination->getLimit($total); $sql = "SELECT GID, title, addtime, rate, likes, dislikes, total_plays, type FROM game\n WHERE UID = " . $uid . " AND status = '1'\n ORDER BY GID DESC LIMIT " . $limit; $rs = $conn->execute($sql); $games = $rs->getrows(); $page_link = $pagination->getPagination('user/' . $username . '/games'); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $smarty->assign('games', $games); $smarty->assign('games_total', $total); $smarty->assign('page_link', $page_link); $smarty->assign('start_num', $start_num); $smarty->assign('end_num', $end_num);
$is_friend = false; } } } else { $is_friend = false; } } $sql = "SELECT COUNT(PID) AS total_photos FROM photos WHERE AID = " . $aid . " AND status = '1'"; $rsc = $conn->execute($sql); $total = $rsc->fields['total_photos']; $pagination = new Pagination(12); $limit = $pagination->getLimit($total); $sql = "SELECT PID, caption FROM photos WHERE AID = " . $aid . " AND status = '1' ORDER BY PID ASC LIMIT " . $limit; $rs = $conn->execute($sql); $photos = $rs->getrows(); $page_link = $pagination->getPagination('album/' . $aid . '/'); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $sql = "UPDATE albums SET total_views = total_views+1 WHERE AID = " . $aid . " LIMIT 1"; $conn->execute($sql); $smarty->assign('photos_total', $total); $smarty->assign('photos', $photos); $smarty->assign('page_link', $page_link); $smarty->assign('start_num', $start_num); $smarty->assign('end_num', $end_num); $smarty->assign('is_friend', $is_friend); } $self_title = $name . $seo['album_title']; $self_meta_description = $name; $self_meta_keywords = str_replace(' ', ', ', $tags); $smarty->assign('errors', $errors);
$sql_add .= ' ORDER BY a.rate DESC'; break; case 'tf': $title_o = ' ' . $lang['global.top_favorites']; $sql_add .= ' ORDER BY a.total_favorites DESC'; break; } $sql = "SELECT COUNT(AID) AS total_albums FROM albums WHERE status = '1'" . $sql_add_count; $rsc = $conn->execute($sql); $total = $rsc->fields['total_albums']; $pagination = new Pagination($config['albums_per_page']); $limit = $pagination->getLimit($total); $sql = "SELECT a.*, s.username FROM albums AS a, signup AS s WHERE a.status = '1' AND a.UID = s.UID" . $sql_add . " LIMIT " . $limit; $rs = $conn->execute($sql); $albums = $rs->getrows(); $page_link = $pagination->getPagination('albums'); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $title = $title_t . $title_o . $title_c . $title_p; $self_title = $title . $seo['album_title']; $self_description = $title . ' ' . $lang['global.albums'] . ' - ' . $config['site_name']; $self_keywords = $title . ' ' . $lang['global.albums'] . ' ' . $config['meta_keywords']; $smarty->assign('errors', $errors); $smarty->assign('messages', $messages); $smarty->assign('menu', 'albums'); $smarty->assign('submenu', ''); $smarty->assign('categories', get_categories()); $smarty->assign('category', $category); $smarty->assign('timeframe', $timeframe); $smarty->assign('order', $order); $smarty->assign('type', $type);
$code = array(); $items_code = NULL; if (isset($_POST['photo_id']) && isset($_POST['page'])) { $filter = new VFilter(); $pid = $filter->get('photo_id', 'INTEGER'); $page = $filter->get('page', 'INTEGER'); $uid = isset($_SESSION['uid']) ? intval($_SESSION['uid']) : NULL; $sql = "SELECT COUNT(CID) AS total_comments FROM photo_comments WHERE PID = " . $pid . " AND status = '1'"; $rsc = $conn->execute($sql); $total = $rsc->fields['total_comments']; $pagination = new Pagination(10, $page); $limit = $pagination->getLimit($total); $sql = "SELECT c.CID, c.UID, c.comment, c.addtime, s.username, s.photo, s.gender\n FROM photo_comments AS c, signup AS s\n WHERE PID = " . $pid . " AND status = '1' AND c.UID = s.UID \n ORDER BY addtime DESC LIMIT " . $limit; $rs = $conn->execute($sql); $comments = $rs->getrows(); $page_link = $pagination->getPagination('photo/' . $pid, 'p_photo_comments_' . $pid . '_'); $page_link_u = $pagination->getPagination('photo/' . $pid, 'pp_photo_comments_' . $pid . '_'); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $items_code = $lang['global.showing'] . ' <strong>' . $start_num . '</strong> ' . $lang['global.to'] . ' <strong>' . $end_num . '</strong> ' . $lang['global.of'] . ' <strong>' . $total . '</strong> ' . $lang['global.comments'] . '.'; if ($comments) { $code[] = '<div class="pagination"><ul>' . $page_link . '</ul></div>'; $code[] = '<div id="comments_delimiter" style="display:none;"></div>'; foreach ($comments as $comment) { $photo = $comment['photo'] == '' ? 'nopic-' . $comment['gender'] . '.gif' : $comment['photo']; $username = $comment['username']; $code[] = '<div id="photo_comment_' . $pid . '_' . $comment['CID'] . '">'; $code[] = '<div id="delete_response_' . $commend['CID'] . '" class="response" style="display: none;"></div>'; $code[] = '<div class="comment">'; $code[] = '<div class="comment_left"><a href="' . $config['BASE_URL'] . '/user/' . $username . '"><img src="' . $config['BASE_URL'] . '/media/users/' . $photo . '" width="60" title="' . $username . '" alt="' . $username . '" /></a></div>'; $code[] = '<div class="comment_right">';
$sql_add .= " ORDER BY u.popularity DESC"; break; case 'ma': $title_o = 'Most Active'; $sql_add .= " ORDER BY u.points DESC"; break; } $sql = "SELECT COUNT(u.UID) AS total_users FROM signup AS u, users_online AS o\n WHERE u.account_status = 'Active' AND u.UID = o.UID" . $sql_add; $rsc = $conn->execute($sql); $total_users = $rsc->fields['total_users']; $pagination = new Pagination($config['users_per_page']); $limit = $pagination->getLimit($total_users); $sql = "SELECT u.UID, u.username, u.photo, u.gender FROM signup AS u, users_online AS o\n WHERE u.account_status = 'Active' AND u.UID = o.UID" . $sql_add . " LIMIT " . $limit; $rs = $conn->execute($sql); $users = $rs->getrows(); $page_link = $pagination->getPagination('users'); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $title = $title_o . $title_g; $self_title = $title . $seo['users_title']; $self_description = $title . $seo['users_desc']; $self_keywords = $title . $seo['users_keywords']; $smarty->assign('errors', $errors); $smarty->assign('messages', $messages); $smarty->assign('menu', 'community'); $smarty->assign('title', $title); $smarty->assign('users', $users); $smarty->assign('users_total', $total_users); $smarty->assign('page_link', $page_link); $smarty->assign('start_num', $start_num); $smarty->assign('end_num', $end_num);
$sql_add .= " ORDER BY b.total_views DESC"; break; case 'md': $title_o = ' ' . $lang['global.most_commented']; $sql_add .= " ORDER BY b.total_comments DESC"; break; } $sql = "SELECT COUNT(BID) AS total_blogs FROM blog WHERE status = '1'" . $sql_add_count; $rsc = $conn->execute($sql); $total_blogs = $rsc->fields['total_blogs']; $pagination = new Pagination($config['blogs_per_page']); $limit = $pagination->getLimit($total_blogs); $sql = "SELECT b.BID, b.UID, b.title, b.content, b.total_views, b.total_comments, b.addtime,\n s.username, s.photo\n FROM blog AS b, signup AS s\n WHERE b.status = '1' AND b.UID = s.UID" . $sql_add . " LIMIT " . $limit; $rs = $conn->execute($sql); $blogs = $rs->getrows(); $page_link = $pagination->getPagination('blogs'); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $title = $title_t . $title_o; $self_title = $title . $seo['blogs_title']; $self_description = $title . $seo['blogs_desc']; $self_keywords = $title . $seo['blogs_keywords']; $smarty->assign('errors', $errors); $smarty->assign('messages', $messages); $smarty->assign('menu', 'blogs'); $smarty->assign('blogs', $blogs); $smarty->assign('blogs_total', $total_blogs); $smarty->assign('page_link', $page_link); $smarty->assign('start_num', $start_num); $smarty->assign('end_num', $end_num); $smarty->assign('order', $order);
$sql_add_count = NULL; $timestamp = isset($_GET['t']) && is_numeric($_GET['t']) ? $_GET['t'] : NULL; if ($timestamp) { $stamp = date('Y-m', $timestamp); $sql_add = " AND n.adddate LIKE '%" . $stamp . "%'"; $sql_add_count = " AND adddate LIKE '%" . $stamp . "%'"; } $sql = "SELECT COUNT(NID) AS total_notices FROM notice WHERE status = '1'" . $sql_add_count; $rsc = $conn->execute($sql); $total_notices = $rsc->fields['total_notices']; $pagination = new Pagination(5); $limit = $pagination->getLimit($total_notices); $sql = "SELECT n.NID, n.title, n.content, n.addtime, n.total_views, n.total_comments, s.username\n FROM notice AS n, signup AS s WHERE n.status = '1' AND n.UID = s.UID" . $sql_add . "\n ORDER BY n.NID DESC LIMIT " . $limit; $rs = $conn->execute($sql); $notices = $rs->getrows(); $page_link = $pagination->getPagination('notice'); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $smarty->assign('errors', $errors); $smarty->assign('messages', $messages); $smarty->assign('menu', 'home'); $smarty->assign('notices', $notices); $smarty->assign('notices_total', $total_notices); $smarty->assign('page_link', $page_link); $smarty->assign('start_num', $start_num); $smarty->assign('end_num', $end_num); $smarty->assign('arhive', get_notice_arhive()); $smarty->assign('categories', get_notice_categories()); $smarty->assign('self_title', $seo['notices_title']); $smarty->assign('self_description', $seo['notices_desc']); $smarty->assign('self_keywords', $seo['notices_keywords']);
} $pagination = new Pagination(8, 'p_related_videos_' . $video['VID'] . '_'); $limit = $pagination->getLimit($total_related); $sql = "SELECT VID, title, duration, addtime, rate, likes, dislikes, viewnumber, type, thumb, thumbs, hd FROM video\n WHERE active = '1' AND channel = '" . $video['channel'] . "' AND VID != " . $vid . "\n AND ( title LIKE '%" . mysql_real_escape_string($video['title']) . "%' " . $sql_add . ")\n ORDER BY addtime DESC LIMIT " . $limit; $rs = $conn->execute($sql); $videos = $rs->getrows(); $page_link = $pagination->getPagination('video'); $sql = "SELECT COUNT(CID) AS total_comments FROM video_comments WHERE VID = " . $vid . " AND status = '1'"; $rsc = $conn->execute($sql); $total_comments = $rsc->fields['total_comments']; $pagination = new Pagination(10); $limit = $pagination->getLimit($total_comments); $sql = "SELECT c.CID, c.UID, c.comment, c.addtime, s.username, s.photo, s.gender\n FROM video_comments AS c, signup AS s \n WHERE c.VID = " . $vid . " AND c.status = '1' AND c.UID = s.UID \n ORDER BY c.addtime DESC LIMIT " . $limit; $rs = $conn->execute($sql); $comments = $rs->getrows(); $page_link_c = $pagination->getPagination('video', 'p_video_comments_' . $video['VID'] . '_'); $page_link_cb = $pagination->getPagination('video', 'pp_video_comments_' . $video['VID'] . '_'); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $self_title = $video['title'] . $seo['video_title']; $self_description = $video['title'] . $seo['video_desc']; $self_keywords = implode(', ', $video['keyword']) . $seo['video_keywords']; if (is_numeric($new_permisions['bandwidth']) && $new_permisions['bandwidth'] != '-1') { $user_limit_bandwidth = $new_permisions['bandwidth']; $remote_ip = ip2long($remote_ip); require $config['BASE_DIR'] . '/classes/bandwidth.class.php'; $guest_limit = VBandwidth::check($remote_ip, intval($video['space'])); } if ($new_permisions['watch_normal_videos'] == 0) { // nu are voie sa vada filme normale if ($type_of_user == 'guest') {
$show_wall = true; } elseif (isset($_SESSION['uid']) && $_SESSION['uid'] == $uid) { $show_wall = true; } } if ($show_wall) { require 'classes/pagination.class.php'; $sql = "SELECT COUNT(wall_id) AS total_walls FROM wall WHERE OID = " . $uid . " AND status = '1'"; $rsc = $conn->execute($sql); $walls_total = $rsc->fields['total_walls']; $pagination = new Pagination(10); $limit = $pagination->getLimit($walls_total); $sql = "SELECT w.wall_id, w.UID, w.message, w.addtime, u.username, u.photo, u.gender\n FROM wall AS w, signup AS u WHERE w.OID = " . $uid . " AND w.status = '1' AND w.UID = u.UID \n ORDER BY w.addtime DESC LIMIT 10"; $rs = $conn->execute($sql); $walls = $rs->getrows(); $page_link = $pagination->getPagination('user/' . $username, 'p_wall_comments_' . $uid . '_'); $smarty->assign('page_link', $page_link); } $blog = array(); $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);
$user = $user['0']; $username = $user['username']; if (isset($module)) { require 'modules/blog/' . $module . '.php'; } else { $sql = "UPDATE blog SET total_views = total_views+1 WHERE BID = " . $bid . " LIMIT 1"; $conn->execute($sql); $sql = "SELECT COUNT(CID) AS total_comments FROM blog_comments WHERE BID = " . $bid . " AND status = '1'"; $rsc = $conn->execute($sql); $total_comments = $rsc->fields['total_comments']; $pagination = new Pagination(10); $limit = $pagination->getLimit($total_comments); $sql = "SELECT c.CID, c.UID, c.comment, c.addtime, s.username, s.photo, s.gender\n FROM blog_comments AS c, signup AS s \n WHERE c.BID = " . $bid . " AND c.status = '1' AND c.UID = s.UID \n ORDER BY c.addtime DESC LIMIT " . $limit; $rs = $conn->execute($sql); $comments = $rs->getrows(); $page_link = $pagination->getPagination('blog/' . $bid, 'p_blog_comments_' . $bid . '_'); $page_link_b = $pagination->getPagination('blog/' . $bid, 'pp_blog_comments_' . $bid . '_'); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $smarty->assign('blog', true); $smarty->assign('user', $user); $smarty->assign('username', $username); $smarty->assign('blog', $blog); $smarty->assign('comments', $comments); $smarty->assign('comments_total', $total_comments); $smarty->assign('page_link', $page_link); $smarty->assign('page_link_b', $page_link_b); $smarty->assign('start_num', $start_num); $smarty->assign('end_num', $end_num); $smarty->assign('self_title', $username . '\'s' . $seo['blog_title']); }
<?php defined('_VALID') or die('Restricted Access!'); require $config['BASE_DIR'] . '/classes/pagination.class.php'; if ($config['blog_module'] == '0') { VRedirect::go($config['BASE_URL'] . '/error/page_invalid'); } $sql = "SELECT COUNT(BID) AS total_blogs FROM blog WHERE status = '1' AND UID = " . $uid; $rs = $conn->execute($sql); $total = $rs->fields['total_blogs']; $pagination = new Pagination(5); $limit = $pagination->getLimit($total); $sql = "SELECT BID, title, content, total_views, total_comments, addtime FROM blog\n WHERE status = '1' AND UID = " . $uid . " ORDER BY addtime DESC LIMIT " . $limit; $rs = $conn->execute($sql); $blogs = $rs->getrows(); foreach ($blogs as $key => $content) { $blogs[$key]['content'] = blog_output($blogs[$key]['content']); } $page_link = $pagination->getPagination('user/' . $username . '/blog'); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $self_title = $username . '\'s Blog'; $smarty->assign('blogs', $blogs); $smarty->assign('blogs_total', $total); $smarty->assign('page_link', $page_link); $smarty->assign('start_num', $start_num); $smarty->assign('end_num', $end_num);
$code = array(); $items_code = NULL; if (isset($_POST['notice_id']) && isset($_POST['page'])) { $filter = new VFilter(); $nid = $filter->get('notice_id', 'INTEGER'); $page = $filter->get('page', 'INTEGER'); $uid = isset($_SESSION['uid']) ? intval($_SESSION['uid']) : NULL; $sql = "SELECT COUNT(CID) AS total_comments FROM notice_comments WHERE NID = " . $nid . " AND status = '1'"; $rsc = $conn->execute($sql); $total = $rsc->fields['total_comments']; $pagination = new Pagination(10, $page); $limit = $pagination->getLimit($total); $sql = "SELECT c.CID, c.UID, c.comment, c.addtime, s.username, s.photo, s.gender\n FROM notice_comments AS c, signup AS s \n WHERE c.NID = " . $nid . " AND c.status = '1' AND c.UID = s.UID \n ORDER BY c.addtime DESC LIMIT " . $limit; $rs = $conn->execute($sql); $comments = $rs->getrows(); $page_link = $pagination->getPagination('notice/' . $nid, 'p_notice_comments_' . $nid . '_'); $page_link_u = $pagination->getPagination('notice/' . $nid, 'pp_notice_comments_' . $nid . '_'); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $code[] = $lang['global.showing'] . ' <span class="text-white">' . $start_num . '</span> ' . $lang['global.to'] . ' <span id="end_num" class="text-white">' . $end_num . '</span> ' . $lang['global.of'] . ' <span id="total_comments" class="text-white">' . $total . '</span> ' . $lang['global.comments'] . '.'; $code[] = '<div id="blog_response" class="response" style="display: none;"></div>'; if ($comments) { $code[] = '<div id="comments_delimiter" style="display:none;"></div>'; foreach ($comments as $comment) { $photo = $comment['photo'] == '' ? 'nopic-' . $comment['gender'] . '.gif' : $comment['photo']; $username = $comment['username']; $code[] = '<div id="notice_comment_' . $nid . '_' . $comment['CID'] . '" class="col-xs-12 m-t-15">'; $code[] = '<div class="row">'; $code[] = '<div class="pull-left">'; $code[] = '<a href="' . $config['BASE_URL'] . '/user/' . $username . '">'; $code[] = '<img src="' . $config['BASE_URL'] . '/media/users/' . $photo . '" title="' . $username . '" alt="' . $username . '" class="img-responsive comment-avatar" />';
<?php defined('_VALID') or die('Restricted Access!'); require $config['BASE_DIR'] . '/classes/pagination.class.php'; if ($config['photo_module'] == '0') { VRedirect::go($config['BASE_URL'] . '/error/page_invalid'); } if (isset($_GET['clear']) && $_GET['clear'] == 'yes') { if (isset($_SESSION['uid']) && $_SESSION['uid'] == $user['UID']) { $sql = "DELETE FROM photo_favorites WHERE UID = " . $uid; $conn->execute($sql); $messages[] = $lang['user.fav_photos_clear']; } } $sql = "SELECT count(PID) AS total_photos FROM photo_favorites WHERE UID = " . $uid; $rsc = $conn->execute($sql); $total = $rsc->fields['total_photos']; $pagination = new Pagination(20); $limit = $pagination->getLimit($total); $sql = "SELECT p.PID, p.caption FROM photos AS p, photo_favorites AS f\n WHERE f.UID = " . $uid . " AND f.PID = p.PID ORDER BY p.PID DESC LIMIT " . $limit; $rs = $conn->execute($sql); $favorites = $rs->getrows(); $page_link = $pagination->getPagination('user/' . $username . '/favorite/photos'); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $self_title = $username . ' - ' . $lang['user.fav_photos']; $smarty->assign('favorites', $favorites); $smarty->assign('favorites_total', $total); $smarty->assign('page_link', $page_link); $smarty->assign('start_num', $start_num); $smarty->assign('end_num', $end_num);
case 'invite_date': $sql_add = "f.invite_date"; break; case 'recent_users': $sql_add = "u.addtime"; break; case 'recent_logins': $sql_add = "u.logintime"; break; case 'username': $sql_add = "u.username"; break; } $sql = "SELECT COUNT(FID) AS total_friends FROM friends WHERE UID = " . $uid . " AND status = 'Confirmed'"; $rsc = $conn->execute($sql); $total = $rsc->fields['total_friends']; $pagination = new Pagination(20); $limit = $pagination->getLimit($total); $sql = "SELECT f.FID, u.username, u.photo, u.gender FROM friends AS f, signup AS u\n WHERE f.UID = " . $uid . " AND f.FID = u.UID AND f.status = 'Confirmed'\n ORDER BY " . $sql_add . " DESC LIMIT " . $limit; $rs = $conn->execute($sql); $friends = $rs->getrows(); $page_link = $pagination->getPagination('user/' . $username . '/friends'); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $self_title = $username . ' - ' . $lang['global.friends']; $smarty->assign('order', $order); $smarty->assign('friends', $friends); $smarty->assign('friends_total', $total); $smarty->assign('page_link', $page_link); $smarty->assign('start_num', $start_num); $smarty->assign('end_num', $end_num);
<?php defined('_VALID') or die('Restricted Access!'); require $config['BASE_DIR'] . '/classes/pagination.class.php'; $type = 'public'; if (isset($options['query']['0']) && $options['query']['0'] == 'private') { $type = 'private'; } $sql = "SELECT COUNT(VID) AS total_videos FROM video WHERE UID = " . $uid . " AND type = '" . $type . "' AND active = '1'"; $rsc = $conn->execute($sql); $total = $rsc->fields['total_videos']; $pagination = new Pagination(20); $limit = $pagination->getLimit($total); $sql = "SELECT VID, title, rate, viewnumber, duration, type, thumb, thumbs, hd FROM video\n WHERE UID = " . $uid . " AND type = '" . $type . "' AND active = '1' ORDER BY addtime DESC LIMIT " . $limit; $rs = $conn->execute($sql); $videos = $rs->getrows(); $page_link = $pagination->getPagination('user/' . $username . '/videos/' . $type); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $self_title = $username . ' - ' . ($type == 'public') ? $lang['global.public'] : $lang['global.private'] . ' ' . $lang['global.videos']; $smarty->assign('type', $type); $smarty->assign('videos', $videos); $smarty->assign('videos_total', $total); $smarty->assign('page_link', $page_link); $smarty->assign('start_num', $start_num); $smarty->assign('end_num', $end_num);
<?php defined('_VALID') or die('Restricted Access!'); require $config['BASE_DIR'] . '/classes/pagination.class.php'; if (isset($_GET['clear']) && $_GET['clear'] == 'yes') { if (isset($_SESSION['uid']) && $_SESSION['uid'] == $user['UID']) { $sql = "DELETE FROM playlist WHERE UID = " . $uid; $conn->execute($sql); $messages[] = $lang['user.playlist_all']; } } $sql = "SELECT count(VID) AS total_videos FROM playlist WHERE UID = " . $uid; $rsc = $conn->execute($sql); $total = $rsc->fields['total_videos']; $pagination = new Pagination(18); $limit = $pagination->getLimit($total); $sql = "SELECT v.VID, v.title, v.addtime, v.rate, v.likes, v.dislikes, v.viewnumber, v.duration, v.type, v.thumb, v.thumbs, v.hd\n FROM video AS v, playlist AS p\n WHERE p.UID = " . $uid . " AND p.VID = v.VID AND v.active = '1'\n\t\t\t\t ORDER BY v.VID DESC LIMIT " . $limit; $rs = $conn->execute($sql); $playlist = $rs->getrows(); $page_link = $pagination->getPagination('user/' . $username . '/playlist'); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $self_title = $username . '\'s Playlist'; $smarty->assign('playlist', $playlist); $smarty->assign('playlist_total', $total); $smarty->assign('page_link', $page_link); $smarty->assign('start_num', $start_num); $smarty->assign('end_num', $end_num);
$filter = new VFilter(); $mail_id = $filter->get('delete', 'INTEGER', 'GET'); if ($mail_id !== 0) { $sql = "SELECT mail_id FROM mail\n WHERE mail_id = " . $mail_id . " AND receiver = '" . mysql_real_escape_string($username) . "'\n LIMIT 1"; $conn->execute($sql); if ($conn->Affected_Rows() === 1) { $sql = "DELETE FROM mail WHERE mail_id = " . $mail_id . " LIMIT 1"; $conn->execute($sql); $messages[] = $lang['mail.delete_msg']; } else { VRedirect::go($config['BASE_URL'] . '/error/mail_missing'); } } } $sql_count = "SELECT COUNT(mail_id) AS total_messages FROM mail WHERE receiver = '" . mysql_real_escape_string($username) . "'\n AND inbox = '1' AND status = '1'"; $rsc = $conn->execute($sql_count); $total = $rsc->fields['total_messages']; $pagination = new Pagination(50); $limit = $pagination->getLimit($total); $sql = "SELECT m.*, s.photo, s.gender\n FROM mail AS m, signup AS s\n WHERE m.receiver = '" . mysql_real_escape_string($username) . "'\n AND m.sender = s.username AND inbox = '1' AND status = '1'\n ORDER BY send_date DESC LIMIT " . $limit; $rs = $conn->execute($sql); $mails = $rs->getrows(); $page_link = $pagination->getPagination('mail'); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $smarty->assign('mails', $mails); $smarty->assign('total_mails', $total); $smarty->assign('page_link', $page_link); $smarty->assign('start_num', $start_num); $smarty->assign('end_num', $end_num); $smarty->assign('folder', 'inbox');
$sql_add .= ' ORDER BY total_comments DESC'; break; case 'tf': $title_o = ' ' . $lang['global.top_favorites']; $sql_add .= ' ORDER BY total_favorites DESC'; break; } $sql = "SELECT count(GID) AS total_games FROM game" . $sql_add_count; $rsc = $conn->execute($sql); $total = $rsc->fields['total_games']; $pagination = new Pagination($config['games_per_page']); $limit = $pagination->getLimit($total); $sql = "SELECT * FROM game" . $sql_add . " LIMIT " . $limit; $rs = $conn->execute($sql); $games = $rs->getrows(); $page_link = $pagination->getPagination('games'); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $title = $title_t . $title_o . $title_c . $title_p; $self_title = $title . $seo['games_title']; $self_description = $title . $seo['games_desc']; $self_keywords = $title . $seo['games_keywords']; $smarty->assign('errors', $errors); $smarty->assign('messages', $messages); $smarty->assign('menu', 'games'); $smarty->assign('categories', $categories); $smarty->assign('type', $type); $smarty->assign('games', $games); $smarty->assign('games_total', $total); $smarty->assign('start_num', $start_num); $smarty->assign('end_num', $end_num);
require $config['BASE_DIR'] . '/include/dbconn.php'; $code = array(); if (isset($_POST['video_id']) && isset($_POST['page'])) { $filter = new VFilter(); $vid = $filter->get('video_id', 'INTEGER'); $page = $filter->get('page', 'INTEGER'); $uid = isset($_SESSION['uid']) ? intval($_SESSION['uid']) : NULL; $sql = "SELECT COUNT(CID) AS total_comments FROM video_comments WHERE VID = " . $vid . " AND status = '1'"; $rsc = $conn->execute($sql); $total = $rsc->fields['total_comments']; $pagination = new Pagination(10, $page); $limit = $pagination->getLimit($total); $sql = "SELECT c.CID, c.UID, c.comment, c.addtime, s.username, s.photo, s.gender\n FROM video_comments AS c, signup AS s\n WHERE c.VID = " . $vid . " AND c.status = '1' AND c.UID = s.UID \n ORDER BY c.addtime DESC LIMIT " . $limit; $rs = $conn->execute($sql); $comments = $rs->getrows(); $page_link = $pagination->getPagination('video/' . $vid, 'p_video_comments_' . $vid . '_'); $page_link_b = $pagination->getPagination('video/' . $vid, 'pp_video_comments_' . $vid . '_'); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $code[] = $lang['global.showing'] . ' <span class="text-white">' . $start_num . '</span> ' . $lang['global.to'] . ' <span id="end_num" class="text-white">' . $end_num . '</span> ' . $lang['global.of'] . ' <span id="total_comments" class="text-white">' . $total . '</span> ' . $lang['global.comments'] . '.'; $code[] = '<div id="video_response" class="response" style="display: none;"></div>'; if ($comments) { $code[] = '<div id="comments_delimiter" style="display:none;"></div>'; foreach ($comments as $comment) { $photo = $comment['photo'] == '' ? 'nopic-' . $comment['gender'] . '.gif' : $comment['photo']; $username = $comment['username']; $code[] = '<div id="video_comment_' . $vid . '_' . $comment['CID'] . '" class="col-xs-12 m-t-15">'; $code[] = '<div class="row">'; $code[] = '<div class="pull-left">'; $code[] = '<a href="' . $config['BASE_URL'] . '/user/' . $username . '">'; $code[] = '<img src="' . $config['BASE_URL'] . '/media/users/' . $photo . '" title="' . $username . '" alt="' . $username . '" class="img-responsive comment-avatar" />';
$filter = new VFilter(); $oid = $filter->get('user_id', 'INTEGER'); $page = $filter->get('page', 'INTEGER'); $uid = isset($_SESSION['uid']) ? intval($_SESSION['uid']) : NULL; $sql = "SELECT username FROM signup WHERE UID = " . $oid . " LIMIT 1"; $rs = $conn->execute($sql); $username = $rs->fields['username']; $sql = "SELECT COUNT(wall_id) AS total_walls FROM wall WHERE OID = " . $oid; $rsc = $conn->execute($sql); $total = $rsc->fields['total_walls']; $pagination = new Pagination(10, $page); $limit = $pagination->getLimit($total); $sql = "SELECT w.wall_id, w.UID, w.message, w.addtime, u.username, u.photo, u.gender\n FROM wall AS w, signup AS u WHERE w.OID = " . $oid . " AND w.status = '1' AND w.UID = u.UID \n ORDER BY w.addtime DESC LIMIT " . $limit; $rs = $conn->execute($sql); $comments = $rs->getrows(); $page_link = $pagination->getPagination('user/' . $username . '/wall', 'p_wall_comments_' . $oid . '_'); $page_link_b = $pagination->getPagination('user/' . $username . '/wall', 'pp_wall_comments_' . $oid . '_'); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $code[] = $lang['global.showing'] . ' <span class="text-white">' . $start_num . '</span> ' . $lang['global.to'] . ' <span id="end_num" class="text-white">' . $end_num . '</span> ' . $lang['global.of'] . ' <span id="total_comments" class="text-white">' . $total . '</span> ' . $lang['global.comments'] . '.'; $code[] = '<div id="wall_response" class="wall_posting" style="display: none;">' . $lang['global.posting'] . '</div>'; if ($comments) { $code[] = '<div id="comments_delimiter" style="display:none;"></div>'; foreach ($comments as $comment) { $photo = $comment['photo'] == '' ? 'nopic-' . $comment['gender'] . '.gif' : $comment['photo']; $username = $comment['username']; $code[] = '<div id="wall_comment_' . $comment['wall_id'] . '" class="col-xs-12 m-t-15">'; $code[] = '<div class="row">'; $code[] = '<div class="pull-left">'; $code[] = '<a href="' . $config['BASE_URL'] . '/user/' . $username . '">'; $code[] = '<img src="' . $config['BASE_URL'] . '/media/users/' . $photo . '" title="' . $username . '" alt="' . $username . '" class="img-responsive comment-avatar" />';
<?php defined('_VALID') or die('Restricted Access!'); require $config['BASE_DIR'] . '/classes/pagination.class.php'; $sql = "SELECT COUNT(AID) AS total_albums FROM albums WHERE UID = " . $uid . " AND status = '1'"; $rsc = $conn->execute($sql); $total = $rsc->fields['total_albums']; $pagination = new Pagination(18); $limit = $pagination->getLimit($total); $sql = "SELECT * FROM albums WHERE UID = " . $uid . " AND status = '1' LIMIT " . $limit; $rs = $conn->execute($sql); $albums = $rs->getrows(); $page_link = $pagination->getPagination('user/' . $username . '/albums'); $start_num = $pagination->getStartItem(); $end_num = $pagination->getEndItem(); $self_title = $username . '\'s Photo Albums'; $smarty->assign('albums_total', $total); $smarty->assign('albums', $albums); $smarty->assign('page_link', $page_link); $smarty->assign('start_num', $start_num); $smarty->assign('end_num', $end_num);