function _HCM_recentposts($limit = null, $stranky = "", $typ = null)
{
// priprava
$result = "";
if (isset($limit) and intval($limit) >= 1) {
$limit = abs(intval($limit));
} else {
$limit = 10;
}
// filtr cisel sekci, knih nebo clanku
if (isset($stranky) and isset($typ)) {
$rtype = intval($typ);
if ($rtype < 1 or $rtype > 3) {
$rtype = 1;
}
$rroots = "(" . _sqlWhereColumn("home", $stranky) . ") AND type=" . $rtype;
} else {
$rroots = "type!=4 AND type!=6 AND type!=7";
}
$query = DB::query("SELECT id,type,home,xhome,subject,author,guest,time,text FROM `" . _mysql_prefix . "-posts` WHERE " . $rroots . " ORDER BY id DESC LIMIT " . $limit);
while ($item = DB::row($query)) {
// nacteni titulku a odkazu na stranku
switch ($item['type']) {
case 1:
case 3:
$hometitle = DB::query_row("SELECT title,title_seo FROM `" . _mysql_prefix . "-root` WHERE id=" . $item['home']);
$homelink = _linkRoot($item['home'], $hometitle['title_seo']);
break;
case 2:
$hometitle = DB::query_row("SELECT art.title,art.title_seo,cat.title_seo AS cat_title_seo FROM `" . _mysql_prefix . "-articles` AS art JOIN `" . _mysql_prefix . "-root` AS cat ON(cat.id=art.home1) WHERE art.id=" . $item['home']);
$homelink = _linkArticle($item['home'], $hometitle['title_seo'], $hometitle['cat_title_seo']);
break;
case 5:
if ($item['xhome'] == -1) {
$tid = $item['id'];
$hometitle = array("title" => $item['subject']);
} else {
$tid = $item['xhome'];
$hometitle = DB::query_row("SELECT subject FROM `" . _mysql_prefix . "-posts` WHERE id=" . $item['xhome']);
$hometitle = array("title" => $hometitle['subject']);
}
$homelink = "index.php?m=topic&id=" . $tid;
break;
}
// nacteni jmena autora
if ($item['author'] != -1) {
$authorname = _linkUser($item['author'], null, true, true);
} else {
$authorname = $item['guest'];
}
$hometitle = $hometitle['title'];
$result .= "\n<h2 class='list-title'><a href='" . $homelink . "'>" . $hometitle . "</a></h2>\n<p class='list-perex'>" . _cutStr(strip_tags(_parsePost($item['text'])), 256) . "</p>\n<div class='list-info'>\n<span>" . $GLOBALS['_lang']['global.postauthor'] . ":</span> " . $authorname . _template_listinfoseparator . "\n<span>" . $GLOBALS['_lang']['global.time'] . ":</span> " . _formatTime($item['time']) . "\n</div>\n\n";
}
return $result;
}
} else {
$link = 'index.php?m=topic&id=' . $r['id'];
$title = $r['subject'];
$post_anchor = false;
}
break;
}
// sestaveni infa
if ($r['author'] == -1) {
$info = "<span class='post-author-guest'>" . $r['guest'] . '</span>';
} else {
$info = _linkUser($r['author'], null, true, true);
}
$info .= ', ' . _formatTime($r['time']);
// pridani do vysledku
$results[] = array((isset($page) ? _addGetToLink($link, 'page=' . $page) : $link) . ($post_anchor ? '#post-' . $r['id'] : ''), $title, _cutStr(strip_tags(_parsePost($r['text'])), 255), $info);
}
DB::free($q);
}
}
// vyhledani obrazku
if ($image) {
// zaklad dotazu
$sql = 'SELECT img.id,img.prev,img.full,img.ord,img.home,img.title,gal.title AS gal_title,gal.title_seo,gal.var2 FROM `' . _mysql_prefix . '-images` AS img';
// join na galerii
$sql .= ' JOIN `' . _mysql_prefix . '-root` AS gal ON(gal.id=img.home)';
// podminky
$sql .= ' WHERE gal.visible=1';
if ($public) {
$sql .= ' AND gal.public=1';
}
<?php
/* --- incializace jadra --- */
require './require/load.php';
SL::init('./');
/* --- zpracovani --- */
_checkKeys('_POST', array('content'));
echo _parsePost(_htmlStr(strval($_POST['content'])));
switch ($post['type']) {
case 1:
case 3:
$hometitle = DB::query_row("SELECT title,title_seo FROM `" . _mysql_prefix . "-root` WHERE id=" . $post['home']);
$homelink = _linkRoot($post['home'], $hometitle['title_seo']);
$hometitle = $hometitle['title'];
break;
case 2:
$hometitle = DB::query_row("SELECT art.title,art.title_seo,cat.title_seo AS cat_title_seo FROM `" . _mysql_prefix . "-articles` AS art JOIN `" . _mysql_prefix . "-root` AS cat ON(cat.id=art.home1) WHERE art.id=" . $post['home']);
$homelink = _linkArticle($post['home'], $hometitle['title_seo']);
$hometitle = $hometitle['title'];
break;
case 5:
$homelink = 'index.php?m=topic&id=' . $post[$post['xhome'] == '-1' ? 'id' : 'xhome'];
if ($post['xhome'] == '-1') {
$hometitle = $post['subject'];
} else {
$hometitle = DB::query_row("SELECT subject FROM `" . _mysql_prefix . "-posts` WHERE id=" . $post['xhome']);
$hometitle = $hometitle['subject'];
}
break;
}
$module .= "<div class='post-head'><a href='" . $homelink . "#post-" . $post['id'] . "' class='post-author'>" . $hometitle . "</a> <span class='post-info'>(" . _formatTime($post['time']) . ")</span></div><p class='post-body'>" . _parsePost($post['text']) . "</p>\n";
}
if (_pagingmode == 2 or _pagingmode == 3) {
$module .= '<br />' . $paging[0];
}
} else {
$module .= $_lang['global.nokit'];
}
}
case 3:
$homelink = _linkRoot($item['home']);
break;
case 2:
$homelink = _linkArticle($item['home']);
break;
case 5:
if ($item['xhome'] == -1) {
$homelink = "index.php?m=topic&id=" . $item['id'];
} else {
$homelink = "index.php?m=topic&id=" . $item['xhome'];
}
break;
}
// ulozeni zaznamu
$feeditems[] = array($author . ": " . $item['subject'], $homelink . "#posts", _cutStr(strip_tags(_parsePost($item['text'])), 255, false), $item['time']);
}
break;
// nejnovejsi clanky
// nejnovejsi clanky
case 4:
$items = DB::query("SELECT art.id,art.time,art.confirmed,art.public,art.home1,art.home2,art.home3,art.title,art.title_seo,art.perex,cat.title_seo AS cat_title_seo FROM `" . _mysql_prefix . "-articles` AS art JOIN `" . _mysql_prefix . "-root` AS cat ON(cat.id=art.home1) WHERE " . _sqlArticleFilter(true) . $catlimit . " ORDER BY art.time DESC LIMIT " . _rsslimit);
while ($item = DB::row($items)) {
$feeditems[] = array($item['title'], _linkArticle($item['id'], $item['title_seo'], $item['cat_title_seo']), strip_tags($item['perex']), $item['time']);
}
break;
}
$continue = true;
}
/* --- vystup --- */
if ($continue) {
/**
* Vytvoreni vypisu prispevku
*
* Type Popis Vars
* 1 komentare sekce zamknute komentare 1/0
* 2 komentare článku zamknute komentare 1/0
* 3 prispevky v knize [polozek na stranu, povoleno prispivani 1/0, zamknuto 1/0]
* 5 temata ve foru [polozek na stranu, povoleno prispivani 1/0, zamknuto 1/0]
* 6 odpovedi na tema [polozek na stranu, povoleno prispivani 1/0, zamknuto 1/0, id tematu]
* 7 vypis vzkazu [zamknuto 1/0]
* 8 vypis pluginpostu [polozek na stranu, povoleno prispivani 1/0, zamknuto 1/0, plugin flag, radit sestupne 1/0, [titulek / null]]
*
* @param int $type typ prispevku
* @param int $home id polozky asociovane s komentari
* @param mixed $vars promenna nastaveni podle typu
* @param bool $force_locked vynutit zamknuty stav
* @param string|null $url vlastni url nebo null (= automaticky)
* @return string
*/
function _postsOutput($type, $home, $vars, $force_locked = false, $url = null)
{
global $_lang;
/* --- typ --- */
// vychozi hodnoty
$desc = "DESC ";
$ordercol = 'id';
$countcond = "type=" . $type . " AND xhome=-1 AND home=" . $home;
$locked_textid = '';
$autolast = false;
$postlink = false;
$pluginflag = null;
// url
if (!isset($url)) {
$url = _indexOutput_url;
}
$url_html = _htmlStr($url);
switch ($type) {
// komentare v sekci
case 1:
$posttype = 1;
$xhome = -1;
$subclass = "comments";
$title = $_lang['posts.comments'];
$addlink = $_lang['posts.addcomment'];
$nopostsmessage = $_lang['posts.nocomments'];
$postsperpage = _commentsperpage;
$canpost = _loginright_postcomments;
$locked = _boolean($vars);
$replynote = true;
break;
// komentare u clanku
// komentare u clanku
case 2:
$posttype = 2;
$xhome = -1;
$subclass = "comments";
$title = $_lang['posts.comments'];
$addlink = $_lang['posts.addcomment'];
$nopostsmessage = $_lang['posts.nocomments'];
$postsperpage = _commentsperpage;
$canpost = _loginright_postcomments;
$locked = _boolean($vars);
$replynote = true;
break;
// prispevky v knize
// prispevky v knize
case 3:
$posttype = 3;
$xhome = -1;
$subclass = "book";
$title = null;
$addlink = $_lang['posts.addpost'];
$nopostsmessage = $_lang['posts.noposts'];
$postsperpage = $vars[0];
$canpost = $vars[1];
$locked = _boolean($vars[2]);
$replynote = true;
break;
// temata ve foru
// temata ve foru
case 5:
$posttype = 5;
$xhome = -1;
$subclass = "book";
$title = null;
$addlink = $_lang['posts.addtopic'];
$nopostsmessage = $_lang['posts.notopics'];
$postsperpage = $vars[0];
$canpost = $vars[1];
$locked = _boolean($vars[2]);
$replynote = true;
$ordercol = 'bumptime';
$locked_textid = '3';
break;
// odpovedi v tematu
// odpovedi v tematu
case 6:
$posttype = 5;
$xhome = $vars[3];
$subclass = "book";
$title = null;
$addlink = $_lang['posts.addanswer'];
$nopostsmessage = $_lang['posts.noanswers'];
$postsperpage = $vars[0];
$canpost = $vars[1];
$locked = _boolean($vars[2]);
$replynote = false;
$desc = "";
$countcond = "type=5 AND xhome=" . $xhome . " AND home=" . $home;
$autolast = isset($_GET['autolast']);
$postlink = true;
break;
// odpovedi v konverzaci
// odpovedi v konverzaci
case 7:
$posttype = 6;
$xhome = null;
$subclass = "book";
$title = null;
$addlink = $_lang['posts.addanswer'];
$nopostsmessage = $_lang['posts.noanswers'];
$postsperpage = _messagesperpage;
$canpost = true;
$locked = _boolean($vars[0]);
$replynote = false;
$desc = "";
$countcond = "type=6 AND home=" . $home;
$locked_textid = '4';
$autolast = true;
break;
// plugin posty
// plugin posty
case 8:
$posttype = 7;
$xhome = -1;
$subclass = "book";
$title = isset($vars[5]) ? $vars[5] : null;
$addlink = $_lang['posts.addpost'];
$nopostsmessage = $_lang['posts.noposts'];
$postsperpage = $vars[0];
$canpost = $vars[1];
$locked = _boolean($vars[2]);
$replynote = true;
$pluginflag = $vars[3];
$countcond .= " AND flag=" . $pluginflag;
if (!$vars[4]) {
$desc = '';
}
break;
}
// vynutit uzamceni parametrem
if ($force_locked) {
$locked = true;
}
// extend
$callback = null;
_extend('call', 'posts.output', array('type' => $type, 'home' => $home, 'xhome' => $xhome, 'vars' => $vars, 'post_type' => $posttype, 'plugin_flag' => $pluginflag, 'canpost' => &$canpost, 'locked' => &$locked, 'autolast' => &$autolast, 'post_link' => &$postlink, 'posts_per_page' => &$postsperpage, 'sql_desc' => &$desc, 'sql_ordercol' => &$ordercol, 'sql_countcond' => &$countcond, 'callback' => &$callback));
/* --- vystup --- */
$output = "\n <div class='anchor'><a name='posts'></a></div>\n <div class='posts-" . $subclass . "'>\n ";
if ($title != null) {
$output .= "<h2>" . $title . _linkRss($home, $posttype) . "</h2>\n";
}
$output .= "<div class='posts-form' id='post-form'>\n";
/* --- priprava strankovani --- */
$paging = _resultPaging($url_html, $postsperpage, "posts", $countcond, "#posts", null, $autolast);
/* --- zprava --- */
if (isset($_GET['r'])) {
switch ($_GET['r']) {
case 0:
$output .= _formMessage(2, $_lang['posts.failed']);
break;
case 1:
$output .= _formMessage(1, $_lang[$type != 5 ? 'posts.added' : 'posts.topicadded']);
break;
case 2:
$output .= _formMessage(2, str_replace("*postsendexpire*", _postsendexpire, $_lang['misc.requestlimit']));
break;
case 3:
$output .= _formMessage(2, $_lang['posts.guestnamedenied']);
break;
case 4:
$output .= _formMessage(2, $_lang['xsrf.msg']);
break;
}
}
/* --- formular nebo odkaz na pridani --- */
if (!$locked and (isset($_GET['addpost']) or isset($_GET['replyto']))) {
// nacteni cisla prispevku pro odpoved
if ($xhome == -1) {
if (isset($_GET['replyto']) and $_GET['replyto'] != -1) {
$reply = intval($_GET['replyto']);
if ($replynote) {
$output .= "<p>" . $_lang['posts.replynote'] . " (<a href='" . $url_html . "#posts'>" . $_lang['global.cancel'] . "</a>).</p>";
}
} else {
$reply = -1;
}
} else {
$reply = $xhome;
}
// formular nebo prihlaseni
if ($canpost) {
$form = _uniForm("postform", array('posttype' => $type, 'pluginflag' => $pluginflag, 'posttarget' => $home, 'xhome' => $reply, 'url' => $url));
$output .= $form[0];
} else {
$loginform = _uniForm("login", array(), true);
$output .= "<p>" . $_lang['posts.loginrequired'] . "</p>" . $loginform[0];
}
} else {
if (!$locked) {
$output .= "<a href='" . _addGetToLink($url_html, "addpost&page=" . $paging[2]) . "#posts'><strong>" . $addlink . " ></strong></a>";
} else {
$output .= "<img src='" . _templateImage("icons/lock.png") . "' alt='stop' class='icon' /> <strong>" . $_lang['posts.locked' . $locked_textid] . "</strong>";
}
}
$output .= "</div>\n<div class='hr'><hr /></div>\n\n";
/* --- vypis --- */
if (_pagingmode == 1 or _pagingmode == 2) {
$output .= $paging[0];
}
// zaklad query
if ($type == 5) {
$sql = "SELECT id,author,guest,subject,time,ip,locked,bumptime,sticky,(SELECT COUNT(id) FROM `" . _mysql_prefix . "-posts` WHERE type=5 AND xhome=post.id) AS answer_count";
} else {
$sql = "SELECT id,xhome,subject,text,author,guest,time,ip" . _extend('buffer', 'posts.columns');
}
$sql .= " FROM `" . _mysql_prefix . "-posts` AS post";
// podminky a razeni
$sql .= " WHERE post.type=" . $posttype . (isset($xhome) ? " AND post.xhome=" . $xhome : '') . " AND post.home=" . $home . (isset($pluginflag) ? " AND post.flag=" . $pluginflag : '');
$sql .= " ORDER BY " . ($type == 5 ? 'sticky DESC,' : '') . $ordercol . ' ' . $desc . $paging[1];
// dotaz
$query = DB::query($sql);
unset($sql);
// nacteni prispevku do pole
$items = array();
if ($type == 5) {
$item_ids_with_answers = array();
}
while ($item = DB::row($query)) {
$items[$item['id']] = $item;
if ($type == 5 && $item['answer_count'] != 0) {
$item_ids_with_answers[] = $item['id'];
}
}
// uvolneni dotazu
DB::free($query);
if ($type == 5) {
// posledni prispevek (pro vypis temat)
if (!empty($item_ids_with_answers)) {
$topicextra = DB::query("SELECT * FROM (SELECT id,xhome,author,guest FROM `" . _mysql_prefix . "-posts` AS reply WHERE type=5 AND home=" . $home . " AND xhome IN(" . implode(',', $item_ids_with_answers) . ") ORDER BY reply.id DESC) AS replies GROUP BY xhome");
while ($item = DB::row($topicextra)) {
if (!isset($items[$item['xhome']])) {
if (_dev) {
trigger_error('Nenalezen domovsky prispevek pro odpoved #' . $item['id'], E_USER_WARNING);
}
continue;
}
$items[$item['xhome']]['_lastpost'] = $item;
}
}
} elseif (!empty($items)) {
// odpovedi (pro komentare)
$answers = DB::query("SELECT id,xhome,text,author,guest,time,ip FROM `" . _mysql_prefix . "-posts` WHERE type=" . $posttype . " AND home=" . $home . (isset($pluginflag) ? " AND flag=" . $pluginflag : '') . " AND xhome IN(" . implode(',', array_keys($items)) . ") ORDER BY id");
while ($item = DB::row($answers)) {
if (!isset($items[$item['xhome']])) {
if (_dev) {
trigger_error('Nenalezen domovsky prispevek pro odpoved #' . $item['id'], E_USER_WARNING);
}
continue;
}
if (!isset($items[$item['xhome']]['_answers'])) {
$items[$item['xhome']]['_answers'] = array();
}
$items[$item['xhome']]['_answers'][] = $item;
}
DB::free($answers);
}
// vypis
if (!empty($items)) {
// vypis prispevku nebo temat
if ($type != 5) {
$hl = true;
foreach ($items as $item) {
// nacteni autora
if ($item['guest'] == "") {
$author = _linkUser($item['author'], "post-author");
} else {
$author = "<span class='post-author-guest' title='" . _showIP($item['ip']) . "'>" . $item['guest'] . "</span>";
}
// odkazy pro spravu
$post_access = _postAccess($item);
if ($type < 6 or $type > 7 or $post_access) {
$actlinks = " <span class='post-actions'>";
if (($type < 6 or $type > 7) && !$locked) {
$actlinks .= "<a href='" . _addGetToLink($url_html, "replyto=" . $item['id']) . "#posts'>" . $_lang['posts.reply'] . "</a>";
}
if ($post_access) {
$actlinks .= (($type < 6 or $type > 7) ? " " : '') . "<a href='index.php?m=editpost&id=" . $item['id'] . "'>" . $_lang['global.edit'] . "</a>";
}
$actlinks .= "</span>";
} else {
$actlinks = "";
}
// avatar
if (_show_avatars) {
$avatar = _getAvatar($item['author']);
} else {
$avatar = null;
}
// prispevek
$hl = !$hl;
_extend('call', 'posts.post', array('item' => &$item, 'avatar' => &$avatar, 'type' => $type));
if (null === $callback) {
$output .= "<div id='post-" . $item['id'] . "' class='post" . ($hl ? ' post-hl' : '') . (isset($avatar) ? ' post-withavatar' : '') . "'><div class='post-head'>" . $author;
if ($type < 6 || $type > 7) {
$output .= ", <span class='post-subject'>" . $item['subject'] . "</span> ";
}
$output .= "<span class='post-info'>(" . _formatTime($item['time']) . ")</span>" . $actlinks . ($postlink ? "<a class='post-postlink' href='" . _addGetToLink($url_html, 'page=' . $paging[2]) . "#post-" . $item['id'] . "'><span>#" . str_pad($item['id'], 6, '0', STR_PAD_LEFT) . "</span></a>" : '') . "</div><div class='post-body" . (isset($avatar) ? ' post-body-withavatar' : '') . "'>" . $avatar . '<div class="post-body-text">' . _parsePost($item['text']) . "</div></div></div>\n";
} else {
$output .= call_user_func($callback, array('item' => $item, 'avatar' => $avatar, 'author' => $author, 'actlinks' => $actlinks, 'page' => $paging[2], 'postlink' => $postlink));
}
// odpovedi
if (($type < 6 || $type > 7) && isset($item['_answers'])) {
foreach ($item['_answers'] as $answer) {
// jmeno autora
if ($answer['guest'] == "") {
$author = _linkUser($answer['author'], "post-author");
} else {
$author = "<span class='post-author-guest' title='" . _showIP($answer['ip']) . "'>" . $answer['guest'] . "</span>";
}
// odkazy pro spravu
if (_postAccess($answer)) {
$actlinks = " <span class='post-actions'><a href='index.php?m=editpost&id=" . $answer['id'] . "'>" . $_lang['global.edit'] . "</a></span>";
} else {
$actlinks = "";
}
// avatar
if (_show_avatars) {
$avatar = _getAvatar($answer['author']);
} else {
$avatar = null;
}
_extend('call', 'posts.post', array('item' => &$answer, 'avatar' => &$avatar, 'type' => $type));
if (null === $callback) {
$output .= "<div id='post-" . $answer['id'] . "' class='post-answer" . (isset($avatar) ? ' post-answer-withavatar' : '') . "'><div class='post-head'>" . $author . " " . $_lang['posts.replied'] . " <span class='post-info'>(" . _formatTime($answer['time']) . ")</span>" . $actlinks . "</div><div class='post-body" . (isset($avatar) ? ' post-body-withavatar' : '') . "'>" . $avatar . '<div class="post-body-text">' . _parsePost($answer['text']) . "</div></div></div>\n";
} else {
$output .= call_user_func($callback, array('item' => $answer, 'avatar' => $avatar, 'author' => $author, 'actlinks' => $actlinks, 'page' => $paging[2], 'postlink' => $postlink));
}
}
}
}
if (_pagingmode == 2 or _pagingmode == 3) {
$output .= "<br />" . $paging[0];
}
} else {
// tabulka s tematy
$hl = false;
$output .= "\n<table class='topic-table'>\n<thead><tr><td colspan='2'><strong>" . $_lang['posts.topic'] . "</strong></td><td><strong>" . $_lang['global.answersnum'] . "</strong></td><td><strong>" . $_lang['global.lastanswer'] . "</strong></td></tr></thead>\n<tbody>\n";
foreach ($items as $item) {
// nacteni autora
if ($item['guest'] == "") {
$author = _linkUser($item['author'], "post-author", false, false, 16);
} else {
$author = "<span class='post-author-guest' title='" . _showIP($item['ip']) . "'>" . _cutStr($item['guest'], 16) . "</span>";
}
// nacteni jmena autora posledniho prispevku
if (isset($item['_lastpost'])) {
if ($item['_lastpost']['author'] != -1) {
$lastpost = _linkUser($item['_lastpost']['author'], "post-author", false, false, 16);
} else {
$lastpost = "<span class='post-author-guest'>" . _cutStr($item['_lastpost']['guest'], 16) . "</span>";
}
} else {
$lastpost = "-";
}
// vyber ikony
if ($item['sticky']) {
$icon = 'sticky';
} elseif ($item['locked']) {
$icon = 'locked';
} elseif ($item['answer_count'] == 0) {
$icon = 'new';
} elseif ($item['answer_count'] < _topic_hot_ratio) {
$icon = 'normal';
} else {
$icon = 'hot';
}
// mini strankovani
$tpages = '';
$tpages_num = ceil($item['answer_count'] / _commentsperpage);
if ($tpages_num == 0) {
$tpages_num = 1;
}
if ($tpages_num > 1) {
$tpages .= '<span class=\'topic-pages\'>';
for ($i = 1; $i <= 3 && $i <= $tpages_num; ++$i) {
$tpages .= "<a href='index.php?m=topic&id=" . $item['id'] . "&page=" . $i . "#posts'>" . $i . '</a>';
}
if ($tpages_num > 3) {
$tpages .= "<a href='index.php?m=topic&id=" . $item['id'] . "&page=" . $tpages_num . "'>" . $tpages_num . ' →</a>';
}
$tpages .= '</span>';
}
// vystup radku
$output .= "<tr class='topic-" . $icon . ($hl ? ' topic-hl' : '') . "'><td class='topic-icon-cell'><a href='index.php?m=topic&id=" . $item['id'] . "'><img src='" . _templateImage('icons/topic-' . $icon . '.png') . "' alt='" . $_lang['posts.topic.' . $icon] . "' /></a></td><td class='topic-main-cell'><a href='index.php?m=topic&id=" . $item['id'] . "'>" . $item['subject'] . "</a>" . $tpages . "<br />" . $author . " <small class='post-info'>(" . _formatTime($item['time']) . ")</small></td><td>" . $item['answer_count'] . "</td><td>" . $lastpost . ($item['answer_count'] != 0 ? "<br /><small class='post-info'>(" . _formatTime($item['bumptime']) . ")</small>" : '') . "</td></tr>\n";
$hl = !$hl;
}
$output .= "</tbody></table><br />\n\n";
if (_pagingmode == 2 or _pagingmode == 3) {
$output .= $paging[0] . "<br />";
}
// posledni odpovedi
$output .= "\n<div class='hr'><hr /></div><br />\n<h3>" . $_lang['posts.forum.lastact'] . "</h3>\n";
$query = DB::query("SELECT topic.id AS topic_id,topic.subject AS topic_subject,answer.author,answer.guest,answer.time FROM `" . _mysql_prefix . "-posts` AS answer JOIN `" . _mysql_prefix . "-posts` AS topic ON(topic.type=5 AND topic.id=answer.xhome) WHERE answer.type=5 AND answer.home=" . $home . " AND answer.xhome!=-1 ORDER BY answer.id DESC LIMIT " . _extratopicslimit);
if (DB::size($query) != 0) {
$output .= "<ul>\n";
while ($item = DB::row($query)) {
if ($item['guest'] == "") {
$author = _linkUser($item['author']);
} else {
$author = "<span class='post-author-guest'>" . $item['guest'] . "</span>";
}
$output .= "<li><a href='index.php?m=topic&id=" . $item['topic_id'] . "'>" . $item['topic_subject'] . "</a> <small>(" . $_lang['global.postauthor'] . " " . $author . " " . _formatTime($item['time']) . ")</small></li>\n";
}
$output .= "</ul>\n\n";
} else {
$output .= "<p>" . $_lang['global.nokit'] . "</p>";
}
}
} else {
$output .= "<p>" . $nopostsmessage . "</p>";
}
$output .= "</div>";
return $output;
}
/* --- priprava --- */
$form = false;
$message = "";
$id = null;
if (isset($_GET['id'])) {
$id = DB::esc($_GET['id']);
$query = DB::query("SELECT * FROM `" . _mysql_prefix . "-users` WHERE username='******'");
if (DB::size($query) != 0) {
$query = DB::row($query);
$groupdata = DB::query_row("SELECT title,descr,icon,color,blocked FROM `" . _mysql_prefix . "-groups` WHERE id=" . $query['group']);
$form = true;
// promenne
if ($query['note'] == "") {
$note = "";
} else {
$note = "<tr class='valign-top'><td><strong>" . $_lang['global.note'] . "</strong></td><td><div class='note'>" . _parsePost($query['note']) . "</div></td></tr>";
}
// cesta k avataru
$query['avatar'] = _getAvatar($query['id'], true, false, true);
// clanky autora
$arts = DB::result(DB::query("SELECT COUNT(*) FROM `" . _mysql_prefix . "-articles` AS art WHERE author=" . $query['id'] . " AND " . _sqlArticleFilter()), 0);
if ($arts != 0) {
// zjisteni prumerneho hodnoceni
$avgrate = DB::result(DB::query("SELECT ROUND(SUM(ratesum)/SUM(ratenum)) FROM `" . _mysql_prefix . "-articles` WHERE rateon=1 AND ratenum!=0 AND confirmed=1 AND author=" . $query['id']), 0);
if ($avgrate === null) {
$avgrate = $_lang['article.rate.nodata'];
} else {
$avgrate = "Ø " . $avgrate . "%";
}
// sestaveni kodu
$arts = "\n<tr><td><strong>" . $_lang['global.articlesnum'] . "</strong></td><td>" . $arts . ", <a href='index.php?m=profile-arts&id=" . $id . "'>" . $_lang['global.show'] . " ></a></td></tr>\n";
$avatar = '';
} else {
$author_name = _userDataCache($query['author']);
if ('' !== $author_name['publicname']) {
$author_name = $author_name['publicname'];
} else {
$author_name = $author_name['username'];
}
$avatar = "<img src='" . $avatar . "' alt='" . $author_name . "' class='topic-avatar' />";
}
}
} else {
$author = "<span class='post-author-guest' title='" . _showIP($query['ip']) . "'>" . $query['guest'] . "</span>";
}
// vystup
$module .= "\n<h2>" . $_lang['posts.topic'] . ": " . $query['subject'] . _linkRSS($id, 6) . "</h2>\n<p><small>" . $_lang['global.postauthor'] . " " . $author . " " . _formatTime($query['time']) . "</small>" . $editlink . "</p>\n<p>" . $avatar . _parsePost($query['text']) . "</p>\n<div class='cleaner'></div>\n";
// odpovedi
require_once _indexroot . 'require/functions-posts.php';
$module .= _postsOutput(6, $homedata['id'], array(_commentsperpage, _publicAccess($homedata['var3']), $homedata['var2'], $id), $query['locked'] == 1);
} else {
$form = _uniForm("notpublic");
$module .= $form[0];
}
} else {
define('_indexOutput_url', "index.php?m=topic");
if (_template_autoheadings) {
$module .= "<h1>" . $_lang['global.error404.title'] . "</h1>\n";
}
$module .= _formMessage(2, $_lang['posts.topic.notfound']);
$found = false;
}
function _HCM_sbox($id = null)
{
// priprava
$result = "";
$id = intval($id);
// nacteni dat shoutboxu
$sboxdata = DB::query("SELECT * FROM `" . _mysql_prefix . "-sboxes` WHERE id=" . $id);
if (DB::size($sboxdata) != 0) {
$sboxdata = DB::row($sboxdata);
$rcontinue = true;
} else {
$rcontinue = false;
}
// sestaveni kodu
if ($rcontinue) {
$result = "\n <div class='anchor'><a name='hcm_sbox_" . SL::$hcmUid . "'></a></div>\n <div class='sbox'>\n <div class='sbox-content'>\n " . ($sboxdata['title'] != "" ? "<div class='sbox-title'>" . $sboxdata['title'] . "</div>" : '') . "<div class='sbox-item'" . ($sboxdata['title'] == "" ? " style='border-top:none;'" : '') . ">";
// formular na pridani
if ($sboxdata['locked'] != 1 and _publicAccess($sboxdata['public'])) {
// priprava bunek
// $captcha = _captchaInit();
if (!_loginindicator) {
$inputs[] = array($GLOBALS['_lang']['posts.guestname'], "<input type='text' name='guest' class='sbox-input' maxlength='22' />");
}
$inputs[] = array($GLOBALS['_lang']['posts.text'], "<input type='text' name='text' class='sbox-input' maxlength='255' /><input type='hidden' name='_posttype' value='4' /><input type='hidden' name='_posttarget' value='" . $id . "' />");
if (!_loginindicator) {
$inputs[1][2] = true;
// $inputs[] = $captcha;
}
$result .= _formOutput("hcm_sboxform_" . SL::$hcmUid, _indexroot . "remote/post.php?_return=" . urlencode(_indexOutput_url . "#hcm_sbox_" . SL::$hcmUid), $inputs, null, null);
} else {
if ($sboxdata['locked'] != 1) {
$result .= $GLOBALS['_lang']['posts.loginrequired'];
} else {
$result .= "<img src='" . _templateImage("icons/lock.png") . "' alt='locked' class='icon' /> " . $GLOBALS['_lang']['posts.locked2'];
}
}
$result .= "\n</div>\n<div class='sbox-posts'>";
// vypis prispevku
$sposts = DB::query("SELECT id,text,author,guest,time,ip FROM `" . _mysql_prefix . "-posts` WHERE home=" . $id . " AND type=4 ORDER BY id DESC");
if (DB::size($sposts) != 0) {
while ($spost = DB::row($sposts)) {
// nacteni autora
if ($spost['author'] != -1) {
$author = _linkUser($spost['author'], "post-author' title='" . _formatTime($spost['time']), false, false, 16, ":");
} else {
$author = "<span class='post-author-guest' title='" . _formatTime($spost['time']) . ", ip=" . _showIP($spost['ip']) . "'>" . $spost['guest'] . ":</span>";
}
// odkaz na spravu
if (_postAccess($spost)) {
$alink = " <a href='index.php?m=editpost&id=" . $spost['id'] . "'><img src='" . _templateImage("icons/edit.png") . "' alt='edit' class='icon' /></a>";
} else {
$alink = "";
}
// kod polozky
$result .= "<div class='sbox-item'>" . $author . $alink . " " . _parsePost($spost['text'], true, false, false) . "</div>\n";
}
} else {
$result .= "\n<div class='sbox-item'>" . $GLOBALS['_lang']['posts.noposts'] . "</div>\n";
}
$result .= "\n </div>\n </div>\n </div>\n ";
}
return $result;
}
function _HCM_smileys($text = "")
{
return _parsePost($text, true, false, false);
}