protected function _user()
{
$cid = Utils::pg("cid", 0);
$uid = Utils::pg("uid", 0);
$cat = new Category($cid);
$user = new User($uid);
$this->_smarty->assign('category_tree', $cat->getSubTree(true));
$this->_smarty->assign('page_title', $user->_dbo->user_login);
$this->_smarty->assign('user_login', $user->_dbo->user_login);
$this->_smarty->assign('user_name', $user->_dbo->user_name);
$pids = $cat->getPhotos();
if (!empty($pids)) {
$in_s = implode(", ", $pids);
$q = $this->_db->prepare("SELECT photo_id FROM phph_photos WHERE photo_id IN ({$in_s}) AND photo_approved IS NOT NULL AND user_id = ? ORDER BY photo_added DESC LIMIT ?, ?");
$res = $this->_db->execute($q, array($uid, intval($this->_page) * $this->_count, intval($this->_count)));
$photos = array();
while ($row = $res->fetchRow()) {
$photos[] = get_photo($row['photo_id'], $cid);
}
$this->_smarty->assign('photos', $photos);
$this->_pages = pager(url('user', array('cid' => $cid, 'uid' => $uid)), count(array_unique($pids)));
$this->_smarty->assign('pager', $this->_pages);
}
}
