" . $lang["title"] . "
";
$for_logged_only = ($user['level'] == 0) ? " and " . $config['sql_prefix'] . "kategorie.for_logged<>1":"";
$zaznam = selectDatabase("select
n.id as idecko,
n.datum_pridania,
n.last_update,
n.diskusia_id,
n.nadpis,
n.hlavicka,
n.text_spravy,
n.pouzivatel_id,
n.ukazat_formular,
n.je_otvorena,
n.show_diskusia,
n.for_logged as locked_article,
n.related_articles,
n.related_as_header,
n.show_hlavicka_after_open,
n.show_title_icons,
n.picture_path,
n.hits,
n.enable_rating,
n.friendly_url,
p.id,
p.level as userLevel,
p.prihl_meno as nick,
p.email,
k.nazov as katnazov,
k.id as katid,
k.idx,
k.for_logged as locked
from
" . $config['sql_prefix'] . "pouzivatel as p,
" . $config['sql_prefix'] . "news as n
LEFT JOIN " . $config['sql_prefix'] . "newsCats as nk
ON nk.news_id = n.id
LEFT JOIN " . $config['sql_prefix'] . "kategorie as k
ON nk.category = k.id
where
p.id = n.pouzivatel_id
and
authorized = 'y'
and
n.datum_pridania <= CURDATE()
and
n.id = " . intval($_GET['id']));
$cesta = showCategoryPath($zaznam['katid']);
if($zaznam['locked'] == '1' && $user['level'] == 0)
{
echo "" . $lang['lockedArticle'] . "
";
}
else
{
renderFullArticle($zaznam);// newsFunctions.php
}
$friendly_url = (!empty($zaznam['friendly_url'])) ? $zaznam['friendly_url'] : convertUrlRewriteAddress($zaznam['nadpis']);
$currQuery = $lang['webAddress'] . $zaznam['idx'] . "/c-" . $zaznam['idecko'] . "/" . $friendly_url . "/";
echo "
URL: " . $currQuery . "
";
}
else
{//sluzi na tlac vyplneneho userForm (dotaznika) po jeho uspesnom odoslani
$formUser = (isset($_GET['formUserId'])) ? (int)$_GET['formUserId'] : 0;
if($formUser)
{
$dotaznik = selectSafeDatabase("select id, dotaznik_id, meno, email, telefon, poznamka from " . $config['sql_prefix'] . "dotaznik_uzivatel where id = " . $formUser);
if(!empty($dotaznik))
{
echo "";
echo "
" . $lang["formPrintHeaderText"] . "
";
echo "
";
echo "
" . $lang["formPrintTopTextLeft"] . "
";
echo "
" . $lang["formPrintTopTextRight"] . "
";
echo "
";
$qa = selectAllSafeDatabase("SELECT
uzivatel_odpovede.dotaznik_uzivatel_id,
uzivatel_odpovede.otazka_id,
uzivatel_odpovede.odpoved_id,
uzivatel_odpovede.volna_odpoved,
uzivatel.dotaznik_id,
uzivatel.meno,
uzivatel.telefon,
uzivatel.email,
otazky.otazka,
otazky.typ_odpovede,
otazky.podnadpis,
odpovede.dotaznik_otazky_id,
odpovede.odpoved
FROM " . $config['sql_prefix'] . "dotaznik_uzivatel as uzivatel
LEFT JOIN " . $config['sql_prefix'] . "dotaznik_uzivatel_odpovede as uzivatel_odpovede ON uzivatel.id = uzivatel_odpovede.dotaznik_uzivatel_id
LEFT JOIN " . $config['sql_prefix'] . "dotaznik_otazky as otazky ON otazky.id = uzivatel_odpovede.otazka_id
LEFT JOIN " . $config['sql_prefix'] . "dotaznik_odpovede as odpovede ON uzivatel_odpovede.odpoved_id = odpovede.id
WHERE uzivatel.id = " . $formUser . "
ORDER BY uzivatel_odpovede.otazka_id");
echo "
";
echo "
";
echo "| " . $lang["userNameText"] . ": " . $qa[0]['meno'] . " |
";
echo "| " . $lang["contactText"] . ": " . $qa[0]['telefon'] . " |
";
echo "" . $lang["emailText"] . ": " . $qa[0]['email'] . "
|
";
foreach($qa as $index => $value)
{
echo "| " . $value['otazka'] . ": " . ((!empty($value['volna_odpoved'])) ? $value['volna_odpoved'] : $value['odpoved']) . " |
";
}
echo "
";
echo "
";
echo "
";
echo "
" . ((empty($lang["formPrintBottomTextLeft"])) ? date("j.n.Y H:i") : $lang["formPrintBottomTextLeft"]) . "
";
echo "
" . $lang["formPrintBottomTextRight"] . "
";
echo "