3 |
global $dbh; |
global $dbh; |
4 |
if (!isset($nid)) return array(); |
if (!isset($nid)) return array(); |
5 |
if (!$par) $par = "NULL"; |
if (!$par) $par = "NULL"; |
6 |
$sql = "SELECT paragraph_id, text, title, level, class, pic, alt, pos, hl, pic_title FROM paragraphs, par_levels WHERE (news_id = $nid) AND (level = level_id) AND (parent = $par)"; |
$sql = "SELECT paragraph_id, text, title, level, class, pic, alt, pos, hl, pic_title, full_pic FROM paragraphs, par_levels WHERE (news_id = $nid) AND (level = level_id) AND (parent = $par)"; |
7 |
$sth = $dbh->prepare($sql); |
$sth = $dbh->prepare($sql); |
8 |
if (!$sth) error("Cannot prepare query: \"$sql\""); |
if (!$sth) error("Cannot prepare query: \"$sql\""); |
9 |
if (!$sth->execute()) error("Cannot execute query: \"$sql\""); |
if (!$sth->execute()) error("Cannot execute query: \"$sql\""); |
10 |
while ($row = $sth->fetchrow_array()) { |
while ($row = $sth->fetchrow_array()) { |
11 |
$subs = get_sections($nid, $text, $row[0]); |
$subs = get_sections($nid, $text, $row[0]); |
12 |
list($w, $h) = PicSize($row[5]); |
list($w, $h) = PicSize($row[5]); |
13 |
|
list($w2, $h2) = PicSize($row[10]); |
14 |
array_push($text, array( |
array_push($text, array( |
15 |
"id" => $row[0], |
"id" => $row[0], |
16 |
"text" => $row[1], |
"text" => $row[1], |
22 |
"pos" => $row[7], |
"pos" => $row[7], |
23 |
"hl" => $row[8], |
"hl" => $row[8], |
24 |
"exp" => $row[9], |
"exp" => $row[9], |
25 |
|
"full" => $row[10], |
26 |
|
"fw" => $w2, |
27 |
|
"fh" => $h2, |
28 |
"subs" => $subs, |
"subs" => $subs, |
29 |
"w" => $w, |
"w" => $w, |
30 |
"h" => $h |
"h" => $h |
33 |
$sth->finish(); |
$sth->finish(); |
34 |
} |
} |
35 |
function newsLoad($id, $ct = "", $limit = 0, $offset = 0, $npar = 1) { |
function newsLoad($id, $ct = "", $limit = 0, $offset = 0, $npar = 1) { |
36 |
global $dbh, $spec, $isMed; |
global $dbh, $spec, $isMed, $isEdit; |
37 |
$arts = array(); |
$arts = array(); |
38 |
if (!$offset) $offset = 0; |
if (!$offset) $offset = 0; |
39 |
$sql = "SELECT DISTINCT news.news_id, title, lead, title_pic, title_alt, title_pos, url, url_title, d_orig, author_pic, author_alt, author_info, author_name, ord FROM news".(isset($ct)?", cat_news":"").($spec?", spec_news":"")." WHERE (".($isMed?"":"NOT ")."plivamed)"; |
if (!$spec && $isMed) $spec = 0; |
40 |
|
$sql = "SELECT DISTINCT news.news_id, title, lead, title_pic, title_alt, title_pos, url, url_title, d_orig, author_pic, author_alt, author_info, author_name, autor_cv, ord, prikazi FROM news".(isset($ct)?", cat_news":"").(isset($spec)?", spec_news":"")." WHERE (".($isMed?"":"NOT ")."plivamed)".($isEdit?"":" AND (prikazi)"); |
41 |
if ($id > 0) $sql .= " AND (news.news_id = $id)"; |
if ($id > 0) $sql .= " AND (news.news_id = $id)"; |
42 |
if ($ct) $sql .= " AND ((category = '$ct') OR ((cat_news.cat_id = '$ct') AND (cat_news.news_id = news.news_id)))"; |
if ($ct) $sql .= " AND ((category = '$ct') OR ((cat_news.cat_id = '$ct') AND (cat_news.news_id = news.news_id)))"; |
43 |
if ($spec) $sql .= " AND (spec_news.news_id = news.news_id) AND (spec_news.spec_id = $spec)"; |
if (isset($spec)) $sql .= " AND (spec_news.news_id = news.news_id) AND (spec_news.spec_id = $spec)"; |
44 |
|
if ($limit && $isEdit) $sql .= ""; |
45 |
$sql .= " ORDER BY d_orig DESC"; |
$sql .= " ORDER BY d_orig DESC"; |
46 |
if ($limit) $sql .= " LIMIT $limit OFFSET $offset"; |
if ($limit && !$isEdit) $sql .= " LIMIT $limit"; |
47 |
|
if ($offset) $sql .= " OFFSET $offset"; |
48 |
$sth = $dbh->prepare($sql); |
$sth = $dbh->prepare($sql); |
49 |
if (!$sth) error("Cannot prepare query: \"$sql\""); |
if (!$sth) error("Cannot prepare query: \"$sql\""); |
50 |
if (!$sth->execute()) error("Cannot execute query: \"$sql\""); |
if (!$sth->execute()) error("Cannot execute query: \"$sql\""); |
54 |
$art["pic_alt"], $art["pic_pos"], $art["more"], |
$art["pic_alt"], $art["pic_pos"], $art["more"], |
55 |
$art["more_title"], $art["date"], $art["au_pic"], |
$art["more_title"], $art["date"], $art["au_pic"], |
56 |
$art["au_alt"], $art["au_info"], $art["au_name"], |
$art["au_alt"], $art["au_info"], $art["au_name"], |
57 |
$ord) = $row; |
$art["au_cv"], $ord, $art["show"]) = $row; |
58 |
|
$art["show"] = ($art["show"][0] == "f" || $art["show"][0] == "F") ? false : true; |
59 |
list($art["pic_w"], $art["pic_h"]) = PicSize($art["pic_url"]); |
list($art["pic_w"], $art["pic_h"]) = PicSize($art["pic_url"]); |
60 |
$art["more_new"] = strstr($art["more"], "://") ? true : false; |
$art["more_new"] = strstr($art["more"], "://") ? true : false; |
61 |
global $sysaupicdir; |
global $sysaupicdir; |
65 |
$art["text"] = array(); |
$art["text"] = array(); |
66 |
if ($art["id"]) get_sections($art["id"], $art["text"]); |
if ($art["id"]) get_sections($art["id"], $art["text"]); |
67 |
$art["order"] = $ord; |
$art["order"] = $ord; |
68 |
$art["read"] = (count($art["text"]) > $npar) ? GetRead($art["id"], $ct) : ""; |
$art["read"] = (count($art["text"]) > $npar || $art["more"]) ? GetRead($art["id"], $ct) : ""; |
69 |
$art["category"] = $ct; |
$art["category"] = $ct; |
70 |
$art["limit"] = $limit; |
$art["limit"] = $limit; |
71 |
$art["offset"] = $offset; |
$art["offset"] = $offset; |
96 |
global $fname, $tpl, $acat, $acat2; |
global $fname, $tpl, $acat, $acat2; |
97 |
$fname = "show.tpl"; |
$fname = "show.tpl"; |
98 |
$tpl->assign("title", MyEscape(convert_html($art["title"]))); |
$tpl->assign("title", MyEscape(convert_html($art["title"]))); |
99 |
$tpl->assign("lead", MyEscape(convert_html($art["lead"]), false)); |
$tpl->assign("lead", ParseNewline(MyEscape(convert_html($art["lead"]), false), false)); |
100 |
$tpl->assign("titlepic_url", MyEscape(convert_html($art["pic_url"]))); |
$tpl->assign("titlepic_url", MyEscape(convert_html($art["pic_url"]))); |
101 |
$tpl->assign("titlepic_alt", MyEscape(convert_html($art["pic_alt"]))); |
$tpl->assign("titlepic_alt", MyEscape(convert_html($art["pic_alt"]))); |
102 |
$tpl->assign("titlepic_type", $art["pic_pos"]); |
$tpl->assign("titlepic_type", $art["pic_pos"]); |
106 |
$tpl->assign("titlepic_width", $art["pic_w"]); |
$tpl->assign("titlepic_width", $art["pic_w"]); |
107 |
$tpl->assign("titlepic_height", $art["pic_h"]); |
$tpl->assign("titlepic_height", $art["pic_h"]); |
108 |
$tpl->assign("date", $art["date"] ? strftime("%d.%m.%Y.", strtotime($art["date"])) : ""); |
$tpl->assign("date", $art["date"] ? strftime("%d.%m.%Y.", strtotime($art["date"])) : ""); |
|
include_once("author.php"); |
|
109 |
$tpl->assign("AUTHOR", GetAuthor($art["au_pic"], |
$tpl->assign("AUTHOR", GetAuthor($art["au_pic"], |
110 |
$art["au_alt"], $art["au_info"], |
$art["au_alt"], $art["au_info"], |
111 |
$art["au_w"], $art["au_h"])); |
$art["au_w"], $art["au_h"])); |
112 |
for ($i = 0; $i < count($art["text"]); $i++) { |
for ($i = 0; $i < count($art["text"]); $i++) { |
113 |
$art["text"][$i]["text"] = ParseNewline(convert_html( |
$art["text"][$i]["text"] = ParseNewline(MyEscape( |
114 |
MyEscape($art["text"][$i]["text"]), false), true); |
convert_html($art["text"][$i]["text"]), false), true); |
115 |
$art["text"][$i]["hl"] = ParseNewline(convert_html( |
$art["text"][$i]["hl"] = ParseNewline(MyEscape( |
116 |
MyEscape($art["text"][$i]["hl"]), false), true); |
convert_html($art["text"][$i]["hl"]), false), true); |
117 |
$art["text"][$i]["exp"] = ParseNewline(convert_html( |
$art["text"][$i]["exp"] = ParseNewline(MyEscape( |
118 |
MyEscape($art["text"][$i]["exp"]), false), true); |
convert_html($art["text"][$i]["exp"]), false), true); |
119 |
if ($art["text"][$i]["hl"]) $art["text"][$i]["hl"] = GetHighlight($art["text"][$i]["hl"]); |
if ($art["text"][$i]["hl"]) $art["text"][$i]["hl"] = GetHighlight($art["text"][$i]["hl"]); |
120 |
if ($art["text"][$i]["level"]) $art["text"][$i]["level2"] = (($art["text"][$i]["level"] - 1) * 15) + 2; |
if ($art["text"][$i]["level"]) $art["text"][$i]["level2"] = (($art["text"][$i]["level"] - 1) * 15) + 2; |
121 |
} |
} |
123 |
$tpl->assign("cat", $art["category"]); |
$tpl->assign("cat", $art["category"]); |
124 |
$tpl->assign("acat", $acat); |
$tpl->assign("acat", $acat); |
125 |
$tpl->assign("acat2", $acat2); |
$tpl->assign("acat2", $acat2); |
126 |
|
$tpl->assign("pgfs", count($art["text"])); |
127 |
global $PATH; |
global $PATH; |
128 |
if (is_array($PATH)) array_push($PATH, |
if (is_array($PATH)) array_push($PATH, |
129 |
MyUpper(MyEscape(convert_html($art["title"])))); |
MyUpper(MyEscape(convert_html($art["title"])))); |