Файл: adultscript-2.0.3-pro/files/mobile/components/users_photos_public.php
Строк: 47
<?php
defined('_VALID') or die('Restricted Access!');
class VComponent_mobile_users_photos_public extends VComponent_mobile_users
{
public function __construct()
{
parent::__construct(true);
}
public function render()
{
$errors = array();
$messages = array();
$user_id = (int) $this->user['user_id'];
$page = (VUri::request(4)) ? (int) VUri::request(4) : 1;
$url = 'users/'.$this->username.'/photos/public/';
if ($page !== 1) {
$url .= $page.'/';
}
if (!VUri::match($url)) {
$this->notfound();
}
$this->update_views($user_id);
$sql_count = "SELECT COUNT(*) AS total_albums
FROM #__photo_albums
WHERE user_id = ".$user_id."
AND type = 'public'
AND status = '1'";
$total_albums = $this->db->get_field($sql_count, 'total_albums');
$pagination = VPagination::get($page, $total_albums, 4);
$sql = "SELECT album_id, title, slug, rating, rated_by,
total_views, total_photos, add_time
FROM #__photo_albums
WHERE user_id = ".$user_id."
AND type = 'public'
AND status = '1'
ORDER BY album_id DESC
LIMIT ".$pagination['limit'];
if (!$albums = $this->cache->get($sql, 3600)) {
$this->db->query($sql);
if ($this->db->affected_rows()) {
$albums = $this->db->fetch_rows();
$this->cache->store($sql, $albums, 3600);
} else {
$albums = array();
}
}
$this->tpl->menu = 'community';
$this->tpl->submenu = 'photos';
$this->tpl->meta_title = __('albums-public-meta-title', array($this->user['username'], $this->tpl->mcfg['site_name']));
$this->tpl->meta_desc = __('albums-public-meta-desc', array($this->user['username'], $this->tpl->mcfg['meta_desc']));
$this->tpl->meta_keys = $this->mcfg['meta_keys'];
$this->tpl->canonical = BASE_URL.'/'.$url;
$this->tpl->errors = $errors;
$this->tpl->messages = $messages;
$this->tpl->user = $this->user;
$this->tpl->username = e($this->user['username']);
$this->tpl->is_subscribed = $this->is_subscribed;
$this->tpl->is_friend = $this->is_friend;
$this->tpl->is_self = $this->is_self;
$this->tpl->is_moderator = $this->is_moderator;
$this->tpl->is_loggedin = $this->is_loggedin;
$this->tpl->is_blocked = $this->is_blocked;
$this->tpl->albums = $albums;
$this->tpl->pagination = $pagination;
$this->tpl->load(array('header', 'users_photos_public', 'footer'));
$this->tpl->display();
}
}