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