37 |
$arts = array(); |
$arts = array(); |
38 |
if (!$offset) $offset = 0; |
if (!$offset) $offset = 0; |
39 |
if (!$spec && $isMed) $spec = 0; |
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)"); |
$conds = array(); |
41 |
if ($id > 0) $sql .= " AND (news.news_id = $id)"; |
if (!$isEdit) array_push($conds, "(prikazi)"); |
42 |
if ($ct) $sql .= " AND ((category = '$ct') OR ((cat_news.cat_id = '$ct') AND (cat_news.news_id = news.news_id)))"; |
if (!$id || $id < 0) array_push($conds, $isMed ? "(plivamed)" : "(NOT plivamed)"); |
43 |
if (isset($spec)) $sql .= " AND (spec_news.news_id = news.news_id) AND (spec_news.spec_id = $spec)"; |
if ($id > 0) array_push($conds, "(news.news_id = $id)"); |
44 |
if ($limit && $isEdit) $sql .= ""; |
if ($ct) array_push($conds, "((category = '$ct') OR ((cat_news.cat_id = '$ct') AND (cat_news.news_id = news.news_id)))"); |
45 |
$sql .= " ORDER BY d_orig DESC"; |
if (isset($spec) && (!$id || $id < 0)) array_push($conds, "((spec_news.news_id = news.news_id) AND (spec_news.spec_id = $spec))"); |
46 |
|
# if ($limit && $isEdit) array_push($conds, ""); |
47 |
|
$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, exclusive FROM news".(isset($ct)?", cat_news":"").((isset($spec)&&(!$id||$id<0))?", spec_news":""); |
48 |
|
$conds = implode(" AND ", $conds); |
49 |
|
if ($conds) $sql .= " WHERE ".$conds; |
50 |
|
$sql .= " ORDER BY d_orig DESC, title"; |
51 |
if ($limit && !$isEdit) $sql .= " LIMIT $limit"; |
if ($limit && !$isEdit) $sql .= " LIMIT $limit"; |
52 |
if ($offset) $sql .= " OFFSET $offset"; |
if ($offset) $sql .= " OFFSET $offset"; |
53 |
$sth = $dbh->prepare($sql); |
$sth = $dbh->prepare($sql); |
59 |
$art["pic_alt"], $art["pic_pos"], $art["more"], |
$art["pic_alt"], $art["pic_pos"], $art["more"], |
60 |
$art["more_title"], $art["date"], $art["au_pic"], |
$art["more_title"], $art["date"], $art["au_pic"], |
61 |
$art["au_alt"], $art["au_info"], $art["au_name"], |
$art["au_alt"], $art["au_info"], $art["au_name"], |
62 |
$art["au_cv"], $ord, $art["show"]) = $row; |
$art["au_cv"], $ord, $art["show"], $art["ex"]) = $row; |
63 |
$art["show"] = ($art["show"][0] == "f" || $art["show"][0] == "F") ? false : true; |
$art["show"] = ($art["show"][0] == "f" || $art["show"][0] == "F") ? false : true; |
64 |
|
$art["ex"] = ($art["ex"][0] == "f" || $art["ex"][0] == "F") ? false : true; |
65 |
list($art["pic_w"], $art["pic_h"]) = PicSize($art["pic_url"]); |
list($art["pic_w"], $art["pic_h"]) = PicSize($art["pic_url"]); |
66 |
$art["more_new"] = strstr($art["more"], "://") ? true : false; |
$art["more_new"] = strstr($art["more"], "://") ? true : false; |
67 |
global $sysaupicdir; |
global $sysaupicdir; |
71 |
$art["text"] = array(); |
$art["text"] = array(); |
72 |
if ($art["id"]) get_sections($art["id"], $art["text"]); |
if ($art["id"]) get_sections($art["id"], $art["text"]); |
73 |
$art["order"] = $ord; |
$art["order"] = $ord; |
74 |
$art["read"] = (count($art["text"]) > $npar || $art["more"]) ? GetRead($art["id"], $ct) : ""; |
$sql = "SELECT rel_id FROM related WHERE (news_id = ".$art["id"].")"; |
75 |
|
$sth2 = $dbh->prepare($sql); |
76 |
|
if (!$sth2) error("Cannot prepare query: \"$sql\""); |
77 |
|
if (!$sth2->execute()) error("Cannot execute query: \"$sql\""); |
78 |
|
$row = $sth2->fetchrow_array(); |
79 |
|
$sth2->finish(); |
80 |
|
$art["related"] = $row ? true : false; |
81 |
|
$art["read"] = (count($art["text"]) > $npar || $art["more"] || $art["related"]) ? GetRead($art["id"], $ct) : ""; |
82 |
$art["category"] = $ct; |
$art["category"] = $ct; |
83 |
$art["limit"] = $limit; |
$art["limit"] = $limit; |
84 |
$art["offset"] = $offset; |
$art["offset"] = $offset; |
106 |
} |
} |
107 |
|
|
108 |
function newsShow($art) { |
function newsShow($art) { |
109 |
global $fname, $tpl, $acat, $acat2; |
global $fname, $tpl, $acat, $acat2, $dbh; |
110 |
$fname = "show.tpl"; |
$fname = "show.tpl"; |
111 |
$tpl->assign("title", MyEscape(convert_html($art["title"]))); |
$tpl->assign("title", MyEscape(convert_html($art["title"]))); |
112 |
$tpl->assign("lead", ParseNewline(MyEscape(convert_html($art["lead"]), false), false)); |
$tpl->assign("lead", ParseNewline(MyEscape(convert_html($art["lead"]), false), false)); |
119 |
$tpl->assign("titlepic_width", $art["pic_w"]); |
$tpl->assign("titlepic_width", $art["pic_w"]); |
120 |
$tpl->assign("titlepic_height", $art["pic_h"]); |
$tpl->assign("titlepic_height", $art["pic_h"]); |
121 |
$tpl->assign("date", $art["date"] ? strftime("%d.%m.%Y.", strtotime($art["date"])) : ""); |
$tpl->assign("date", $art["date"] ? strftime("%d.%m.%Y.", strtotime($art["date"])) : ""); |
122 |
$tpl->assign("AUTHOR", GetAuthor($art["au_pic"], |
$tpl->assign("AUTHOR", GetAuthor($art["au_pic"], $art["au_alt"], |
123 |
$art["au_alt"], $art["au_info"], |
$art["au_info"], $art["au_w"], $art["au_h"], $art["au_cv"])); |
124 |
$art["au_w"], $art["au_h"])); |
$tpl->assign("exclusive", $art["ex"]); |
125 |
|
$some_title = false; |
126 |
for ($i = 0; $i < count($art["text"]); $i++) { |
for ($i = 0; $i < count($art["text"]); $i++) { |
127 |
$art["text"][$i]["text"] = ParseNewline(MyEscape( |
if ($art["text"][$i]["title"]) $some_title = true; |
128 |
convert_html($art["text"][$i]["text"]), false), true); |
if ($art["text"][$i]["text"]) { |
129 |
$art["text"][$i]["hl"] = ParseNewline(MyEscape( |
$art["text"][$i]["text"] = ParseNewline(MyEscape( |
130 |
convert_html($art["text"][$i]["hl"]), false), true); |
convert_html($art["text"][$i]["text"]), false), true); |
131 |
$art["text"][$i]["exp"] = ParseNewline(MyEscape( |
} |
132 |
convert_html($art["text"][$i]["exp"]), false), true); |
if ($art["text"][$i]["exp"]) { |
133 |
if ($art["text"][$i]["hl"]) $art["text"][$i]["hl"] = GetHighlight($art["text"][$i]["hl"]); |
$art["text"][$i]["exp"] = ParseNewline(MyEscape( |
134 |
|
convert_html($art["text"][$i]["exp"]), false), true); |
135 |
|
} |
136 |
|
if ($art["text"][$i]["hl"]) { |
137 |
|
$art["text"][$i]["hl"] = GetHighlight(ParseNewline( |
138 |
|
MyEscape($art["text"][$i]["hl"], false), false)); |
139 |
|
} |
140 |
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; |
141 |
} |
} |
142 |
|
$tpl->assign("id", $art["id"]); |
143 |
$tpl->assign("text", $art["text"]); |
$tpl->assign("text", $art["text"]); |
144 |
$tpl->assign("cat", $art["category"]); |
$tpl->assign("cat", $art["category"]); |
145 |
$tpl->assign("acat", $acat); |
$tpl->assign("acat", $acat); |
146 |
$tpl->assign("acat2", $acat2); |
$tpl->assign("acat2", $acat2); |
147 |
$tpl->assign("pgfs", count($art["text"])); |
$tpl->assign("pgfs", count($art["text"])); |
148 |
|
$tpl->assign("some_title", $some_title); |
149 |
|
if ($art["id"]) { |
150 |
|
$sql = "SELECT news.news_id, news.category, news.title, news.lead, news.title_pic, news.title_alt FROM news, related WHERE (news.news_id = related.rel_id) AND (related.news_id = ".$art["id"].") AND (prikazi) ORDER BY d_orig DESC"; |
151 |
|
$sth = $dbh->prepare($sql); |
152 |
|
if (!$sth) error("Cannot prepare query: \"$sql\""); |
153 |
|
if (!$sth->execute()) error("Cannot execute query: \"$sql\""); |
154 |
|
$related = array(); |
155 |
|
while ($row = $sth->fetchrow_array()) { |
156 |
|
list($id, $cat, $title, $lead, $pic, $alt) = $row; |
157 |
|
if ($pic) list($w, $h) = PicSize($pic); |
158 |
|
array_push($related, array( |
159 |
|
"id" => $id, |
160 |
|
"title" => MyEscape($title), |
161 |
|
"lead" => ParseNewline(MyEscape($lead), false), |
162 |
|
"pic" => MyEscape($pic), "w" => $w, "h" => $h, |
163 |
|
"alt" => MyEscape($alt), |
164 |
|
"read" => GetRead($id, $cat) |
165 |
|
)); |
166 |
|
} |
167 |
|
$sth->finish(); |
168 |
|
$tpl->assign("related", $related); |
169 |
|
} |
170 |
global $PATH; |
global $PATH; |
171 |
if (is_array($PATH)) array_push($PATH, |
if (is_array($PATH)) array_push($PATH, |
172 |
MyUpper(MyEscape(convert_html($art["title"])))); |
MyUpper(MyEscape(convert_html($art["title"])))); |