private function getEntries()
{
global $sql;
$pager_url = 'news';
$category_id = 0;
if (u1 == 'category') {
$category_id = (int) u2;
}
$total = Kio::getStat('entries', 'news');
if ($category_id) {
$category = $sql->setCache('news_categories_' . $category_id)->query('
SELECT id, name, description, entries
FROM ' . DB_PREFIX . 'news_categories
WHERE id = ' . $category_id)->fetch(PDO::FETCH_ASSOC);
if ($category) {
$total = $category['entries'];
if ($category['description']) {
Kio::setDescription($category['name'] . ' - ' . $category['description']);
}
Kio::addTitle($category['name']);
Kio::addBreadcrumb($category['name'], 'news/category/' . $category_id . '/' . clean_url($category['name']));
$pager_url = 'news/category/' . $category_id . '/' . clean_url($category['name']);
} else {
return not_found(t('Selected category does not exists.'), array(t('Category was moved or deleted.'), t('Entered URL is invalid.')));
}
}
if (!empty($category) || empty($category)) {
$this->subcodename = 'entries';
$pager = new Pager($pager_url, $total, Kio::getConfig('limit', 'news'));
$stmt = $sql->setCache('news_' . $category_id . '_' . $pager->current)->query('
SELECT u.nickname, u.group_id, c.id c_id, c.name c_name, c.description c_description, n.*
FROM ' . DB_PREFIX . 'news n
LEFT JOIN ' . DB_PREFIX . 'users u ON u.id = n.author_id
LEFT JOIN ' . DB_PREFIX . 'news_categories c ON c.id = n.category_id
WHERE ' . ($category_id ? 'c.id = ' . $category_id . '
AND ' : '') . (LOGGED ? 'n.publication > 0' : 'n.publication = 1') . '
AND n.added < ' . TIMESTAMP . '
ORDER BY ' . Kio::getConfig('order_by', 'news') . '
LIMIT ' . $pager->limit . '
OFFSET ' . $pager->offset);
while ($row = $stmt->fetch()) {
if ($row['author_id']) {
$row['author'] = User::format($row['author_id'], $row['nickname'], $row['group_id']);
}
$row['url_title'] = ($row['c_name'] ? clean_url($row['c_name']) . '/' : '') . clean_url($row['title']);
$row['content'] = parse($row['content'], Kio::getConfig('parsers', 'news'));
$entries[] = $row;
}
try {
$tpl = new PHPTAL('modules/news/news.tpl.html');
$tpl->entries = $entries;
$tpl->pagination = $pager->getLinks();
return $tpl->execute();
} catch (Exception $e) {
return template_error($e);
}
}
}
public function getContent()
{
global $sql;
$pager = new Pager('users', Kio::getStat('total', 'users'), Kio::getConfig('limit', 'users'));
$pager->sort(array(t('Nickname') => 'nickname', t('Group') => 'g_name', t('Gender') => 'gender', t('Title') => 'title', t('Location') => 'locality', t('Country') => 'country', t('Registered') => 'registered'), 'registered', 'asc');
$query = $sql->query('
SELECT id, name, inline, members
FROM ' . DB_PREFIX . 'groups
ORDER BY display_order');
while ($row = $query->fetch()) {
if ($row['inline']) {
$row['name'] = sprintf($row['inline'], $row['name']);
}
$groups[] = $row;
}
$query = $sql->query('
SELECT u.id, u.nickname, u.email, u.registered, u.group_id, u.gender, u.locality, u.country, u.communicator, u.title, g.name g_name
FROM ' . DB_PREFIX . 'users u
LEFT JOIN ' . DB_PREFIX . 'groups g ON g.id = u.group_id
ORDER BY ' . $pager->orderBy . '
LIMIT ' . $pager->limit . '
OFFSET ' . $pager->offset);
while ($row = $query->fetch()) {
$row['nickname'] = User::format($row['id'], $row['nickname'], $row['group_id']);
switch ($row['gender']) {
case 1:
$row['gender'] = ' <img class="gender" src="' . LOCAL . 'themes/' . THEME . '/images/male.png" alt="' . t('Male') . '" title="' . t('Male') . '" />';
break;
case 2:
$row['gender'] = ' <img class="gender" src="' . LOCAL . 'themes/' . THEME . '/images/female.png" alt="' . t('Female') . '" title="' . t('Female') . '" />';
break;
default:
$row['gender'] = '';
}
$users[] = $row;
}
try {
$tpl = new PHPTAL('modules/users/users.tpl.html');
$tpl->sort = $pager->sorters;
$tpl->users = $users;
$tpl->groups = $groups;
$tpl->pagination = $pager->getLinks();
return $tpl->execute();
} catch (Exception $e) {
return template_error($e);
}
}
public function getContent()
{
global $sql;
$this->err = new Error();
$this->pager = new Pager('guestbook', Kio::getStat('entries', 'guestbook'), Kio::getConfig('limit', 'guestbook'));
$show_form = true;
$entries = $this->getEntries();
// Editing entry
if (ctype_digit(u2)) {
// guestbook/edit/u2
$edited_id = u1 == 'edit' ? u2 : '';
if (!User::hasPermit('guestbook edit')) {
$this->note->error(t('You don't have access to edit entries.'));
$show_form = false;
} else {
if ($edited_id) {
$row = $sql->query('
SELECT id, added, author, author_id, author_ip, email, website, message
FROM ' . DB_PREFIX . 'guestbook
WHERE id = ' . $edited_id)->fetch();
// Entry exists
if ($row) {
$form = $row;
$this->edit_mode = true;
if (!$row['author']) {
$form['author'] = User::getNickname(BY_ID, $row['author_id']);
}
} else {
$this->note->error(t('Selected entry doesn't exist.'));
}
}
}
}
if (!$this->edit_mode) {
$form['author'] = User::$nickname;
}
// Form action
$add = isset($_POST['add']) ? true : false;
$edit = isset($_POST['edit']) ? true : false;
// On form submit
if ($add || $edit) {
$form = $this->formSumbit();
} else {
if (isset($_POST['delete_id']) && ctype_digit($_POST['delete_id']) && $_POST['auth'] == AUTH && User::hasPermit('guestbook delete')) {
$sql->exec('
UPDATE ' . DB_PREFIX . 'stats SET content = content - 1 WHERE name = "guestbook_entries";
DELETE FROM ' . DB_PREFIX . 'guestbook WHERE id = ' . $_POST['delete_id']);
$sql->clearCacheGroup('guestbook_*');
}
}
try {
$tpl = new PHPTAL('modules/guestbook/guestbook.tpl.html');
$tpl->message_limit = Kio::getConfig('message_max', 'guestbook');
$tpl->form = $form;
$tpl->edit_mode = $this->edit_mode;
$tpl->entries = $entries;
$tpl->err = $this->err->toArray();
$tpl->show_form = $show_form;
$tpl->note = $this->note;
$tpl->pagination = $this->pager->getLinks();
return $tpl->execute();
} catch (Exception $e) {
return template_error($e);
}
}
public function getContent()
{
global $sql;
$this->err = new Error();
$pager = new Pager('guestbook', Kio::getStat('entries', 'guestbook'), Kio::getConfig('limit', 'guestbook'));
if (Kio::getConfig('order_by', 'guestbook') == 'DESC') {
$x = $pager->items + 1 - $pager->offset;
$y = '$x--;';
} else {
$x = $pager->offset;
$y = '$x++;';
}
// $entries = $sql->getCache('guestbook_'.$pager->current);
if (!$entries) {
$stmt = $sql->query('
SELECT gb.id, gb.added, gb.author, gb.email, gb.website, gb.message, gb.author_id, gb.author_ip,
u.nickname, u.group_id, u.avatar, u.signature
FROM ' . DB_PREFIX . 'guestbook gb
LEFT JOIN ' . DB_PREFIX . 'users u ON u.id = gb.author_id
ORDER BY gb.id ' . Kio::getConfig('order_by', 'guestbook') . '
LIMIT ' . $pager->limit . '
OFFSET ' . $pager->offset);
if ($stmt->rowCount()) {
while ($row = $stmt->fetch()) {
eval($y);
$row['number'] = $x;
if ($row['author_id']) {
$row['author'] = User::format($row['author_id'], $row['nickname'], $row['group_id']);
}
$row['message'] = parse($row['message'], Kio::getConfig('parsers', 'guestbook'));
$row['signature'] = $row['signature'] ? parse($row['signature'], Kio::getConfig('parsers', 'guestbook')) : '';
$entries[] = $row;
}
$sql->putCacheContent('guestbook_' . $pager->current, $entries);
} else {
$this->note->info('Jeszcze nikt nie dodał żadnego wpisu.');
}
}
// Editing entry
if (ctype_digit(u2)) {
// guestbook/edit/u2
$edited_id = u1 == 'edit' ? u2 : '';
if (!User::hasPermit('guestbook edit')) {
$this->note->error(t('You do not have access to edit entries.'));
} else {
if ($edited_id) {
$row = $sql->query('
SELECT id, added, author, author_id, author_ip, email, website, message
FROM ' . DB_PREFIX . 'guestbook
WHERE id = ' . $edited_id)->fetch();
// Entry exists
if ($row) {
$form = $row;
$form['edit_mode'] = true;
if (!$row['author']) {
$form['author'] = User::getNickname(BY_ID, $row['author_id']);
}
} else {
$this->note->error(t('Selected entry doesn't exist.'));
}
}
}
}
if (!$form['edit_mode']) {
$form['author'] = User::$nickname;
}
// Form action
$add = $_POST['add'] ? true : false;
$edit = $_POST['edit'] ? true : false;
// On form submit
if ($add || $edit) {
$this->formSumbit();
} else {
if (ctype_digit($_POST['delete_id']) && $_POST['auth'] == AUTH && User::hasPermit('guestbook delete')) {
$sql->exec('
UPDATE ' . DB_PREFIX . 'stats SET content = content - 1 WHERE name = "guestbook_entries";
DELETE FROM ' . DB_PREFIX . 'guestbook WHERE id = ' . $_POST['delete_id']);
$sql->clearCacheGroup('guestbook_*');
}
}
try {
$tpl = new PHPTAL('modules/guestbook/guestbook.tpl.html');
$tpl->message_limit = Kio::getConfig('message_max', 'guestbook');
$tpl->form = $form;
$tpl->entries = $entries;
$tpl->err = $this->err->toArray();
$tpl->note = $this->note;
$tpl->pagination = $pager->getLinks();
return $tpl->execute();
} catch (Exception $e) {
return template_error($e);
}
}
private function getAlbumList()
{
global $sql;
$this->subcodename = 'albums';
$pager = new Pager('pm/' . u1, Kio::getStat('images', 'gallery'), Kio::getConfig('limit', 'gallery'));
// $albums = Cache::get('gallery_albums_'.$pager->current.'.txt');
$albums = $sql->setCache('gallery_' . $pager->current)->query('
SELECT id, name, description, added, thumbnail, images
FROM ' . DB_PREFIX . 'gallery_albums
LIMIT ' . $pager->limit . '
OFFSET ' . $pager->offset)->fetchAll(PDO::FETCH_ASSOC);
try {
$tpl = new PHPTAL('modules/gallery/gallery.tpl.html');
$tpl->albums = $albums;
$tpl->pager = $pager;
return $tpl->execute();
} catch (Exception $e) {
return template_error($e);
}
}
